[RESOLVED] SQL column value img src breaking continue; statement

bemore

I've got some values in my columns that I use as img src:

<div id="comp"><center><img src="<?php echo $path.$rows['comp'];?>.gif" align="center"></center></div>

I want to put a lot of data into the table, in a different column, but

while($rows = mysqli_fetch_array($result, MYSQLI_BOTH)){

it causes the images to appear broken rather then not showing the image at all, breaking the website in google chrome and I'm sure other browsers.

I use

if(!$rows['gamename']){continue;}else{}

in an attempt to only loop rows that contain a gamename, but it works only for firefox.

Is there a work around for this? Otherwise, there are 9000+ rows displaying when they should not be in my particular situation.

Weedpacket

The choice of browser shouldn't make a difference.

If you want to skip rows, why not put a condition in the database query to filter them out?

bemore

I have tried that. The browser in this instance definitely matters, and you can see an example here

http://oplinfo.usr.sh/gclist.php

In firefox, Aaaaa is shown along with two images that have sources on the disc.
In chrome, Aaaaa is shown along with 4 images, 2 of which are broken images to X.png and X.gif (because X is a value inside of the database)

Weedpacket

bemore wrote:
The browser in this instance definitely matters, and you can see an example here

Purely cosmetic: the HTML in both browsers is the same, and includes an [font=monospace]<img>[/font] element that references a url named [font=monospace]/files/images/.gif[/font]. The only difference is that Chrome (and IE) renders a broken image and Firefox doesn't. Either way, the HTML is still broken.

bemore

Okay, so from what you're saying, the browser matters...? Lol.. But, clearly the browser matters. In one it is broken, and the other is not. No one cares what happens behind the scenes, only the developers care about this. Not users.

HTML is broken? Or.. do you mean the source is missing, either way? Please elaborate. I'm looking to solve this issue, rather then discuss the discrepancies between the browsers.

How can I work around this issue?

Weedpacket

bemore wrote:
No one cares what happens behind the scenes, only the developers care about this. Not users.

I agree; developers are nobodies. And developers are not users. Users are not developers. And users are just happy they get something served to them.

Or.. do you mean the source is missing, either way? Please elaborate

Your page contains URLs to resources that don't exist (have a look at the HTML for yourself). You'll probably find a bunch of 404 responses in your sever logs.

Please elaborate. I'm looking to solve this issue, rather then discuss the discrepancies between the browsers.

You brought it up.

How can I work around this issue?

You haven't given us enough to provide you with an answer. Ine tiny line that you've already said didn't fix the problem, without saying where or how you tried to use it, and you haven't explained what you've already tried (what did you try in the query?) and what the results were.

bemore

That page is producing data from an empty table for testing purpose. Your assumptions are welcome, though. You know what they say, and I happen to be an ass man.

I think I have provided all the required and relative information.
The line is tiny, because the line is tiny... you move the last } and put it at the end of some information.. and then the if statement allows the script to continue if the column "gamename" is populated with anything. Is this what you need to know in order to provide some productive feedback?
If I am posting here, and given 2 (not 1 as you claim) methods in which I attempted to advert this issue without success, then clearly I am looking for some guidance or relative information.

Thanks!

edit: I tried queries using WHERE blah,blah etc and also SELECT blah, blah, blah FROM $tbl_name.
Results are exactly the same as as using if rows=OK then continue.

Weedpacket

bemore wrote:
That page is producing data from an empty table for testing purpose.

Who ever claimed it was otherwise?

I tried queries using WHERE blah,blah etc and also SELECT blah, blah, blah FROM $tbl_name.

And you're assuming I can divine what you wrote for "blah, blah etc"?

All I can say is that on the offending line [font=monospace]$rows['comp'][/font] contains something that - if it isn't one to begin with - is converted to an empty string. If you avoided outputting the image tag when [font=monospace]$rows['comp'][/font] contains something that - if it isn't one to begin with - is converted to an empty string (instead of simply assuming that it's valid when (apparently) it might not be), then your problem would go away.

bemore

Yes, removing the image tags would make it go away. The issue is that I need the data to be available on the page where it is valid, without displaying where it is not valid. Just like any other column of data that is not being used as am img src does.

Weedpacket

So ... you want me to just repeat the symptoms back to you? Check that the value is valid. If it is, use it. If it's not, don't. I can't give you any more because you haven't supplied any more.