Query fail not making sense

Derokorian

Ok so I have these lines:

    $picqry = "SELECT pics_file,kids_placed,kids_name FROM {$dbkids} INNER JOIN {$dbkidpics} ON idwaiting_kids=pics_kid WHERE idwaiting_kids={$id} AND pics_profile=1";
    $picresult = mysql_query( $picqry, $conn );
    if( !$picresult ) die('Error in '.__FILE__.' on line '.__LINE__.'<br>('.mysql_errno().') '.mysql_error().'<br>Query: '.$picqry);

Using DIE because I wanted to get the error back while I'm trying to debug (I usually use trigger_error so that it writes to my log). Anyway the die is being triggered and giving me this response:

Error in /xxx/functions.php on line 46
()
Query: SELECT pics_file,kids_placed,kids_name FROM waiting_kids INNER JOIN waiting_pics ON idwaiting_kids=pics_kid WHERE idwaiting_kids=11 AND pics_profile=1

When I copy paste the query, as returned in the die, into phpMyAdmin or MySQL Workbench it works just fine, returning 1 row as expected. As you can see also mysql_errno() and mysql_error() aren't returning anything. So I have no idea why this would be returning false. Any thoughts?

bradgrafelman

Do you have multiple MySQL connections open? Regardless, try passing those two error-related functions your link identifier ($conn) as well - see if that makes them output anything more useful.

Also, do a [man]var_dump/man on $picresult - what do you get?

Derokorian

Fed the errno and error functions my $conn (its the only open connection anyway) with no change. var_dump($picresult) produces bool(false) ... I should mention its part of a function, I should also mention that the function works fine on other pages, I'm trying to create reports for the waiting kids (views, current status, misc info) for admins to get stats for all waiting kids instead of going to each kid separately.

Derokorian

Ok coming back to this today, I can't figure out why this function call is working on 3 pages and not on the one I'm making now... so for now I'm going to insert the picture without the function... yay for duplicate code =\