HELP!!!!!!!!!!! code bug

Anon

Why in the world doesn't this WORK?? $id is from a form on another page. Yes, it is passed fine, I can echo $page_id just fine. This generates nothing. No errors, but no output either. Help!

$temp = explode ("-", $id);
$page_id = $temp[0];

$result = mysql_query("SELECT name FROM soccer_pics WHERE page_id LIKE '$page_id'") or die("Mysql Error");

$i = 1;

if ($result != "")
{
while($row = mysql_fetch_row($result))
{
$name = $row[0];
echo '<div id="Layer'.$i.'" style="position:absolute; z-index:'.$i.'; visibility: hidden; width:640; height:480"><img src="http://www.zikes.com/soccer/pics/'.$name.'" height="480" width="640"></div>';

$name_array[] = $name;
$i++;
}
}
else
{
die("Error.");
}

Anon

hmm. instead of

if ($result != '')

try

if (mysql_affected_rows() || die("No results returned")){
while ($row = mysql_fetch_row($result)){
//prcess row here

           //use this just to see if your getting actual values returned
          //then remove it and process the rows if you are getting actual values
           foreach($row as $key => $value){
                       echo "$key = $value<BR>";
           }

}

I am guessing that you are not getting data returned in the result, or are getting a nul value returned.

You can get a valid $result returned, without actually retrieveing any data.

If this is the case, mysql_affected_rows() will return false and the die() statement will execute.

Anon

Yeah, I'm not getting any data. The die statement was executed.

But I don't understand why not. It all very simple code, nothing complex or anything and I've done it many times before.

If anyone has any ideas, I'd like to hear em.

Also, I have run the query succesfully by replacing $page_id with 1 or 2 and it works fine. Just when I put it in as a variable does it screw up.

Anon

Then your variables are not holding the values you expect them to hold.

Use the die statement in strategic places to print out the variables just before you do the query. If they do not hold the right values, most likely they hold no values, then start moving the die() statement backwards towards the origin of the variables. Once you know where the values are getting screwed up you know where to fix it at.

Debugging is an art form of it's own. It can be a real bi--h sometimes, but you learn more through debugging than you ever could through a book or on-line course.

You'l find the problem, just keep at it.

Best of luck! :o)