This is a bug in PHP, right?

[Aquawave]

In my SQL table, column number4 equals '18' and column set0 equals '1'

PHP Code:

<?php
    $query = "SELECT * FROM tablea WHERE id = (SELECT MAX(id) FROM tablea)";
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);
    echo $row['number4'];
    echo $row['set0'];
?>

$row['number4'] echo's fine, but $row['set0'] does not echo at all. Is this a bug in PHP?

[DrDOS]

I haven't even started on mysql yet, but I suspect it isn't a bug. You just have to call each one separately, maybe by looping over the calls. Try swapping the two in the code and see which one gets echoed.

[Aquawave]

Thanks for your reply man.

Unfortunately, your suggestions didn't work. :\

[Keleth]

No, it can't be a bug in PHP, your setup is correct, your data is probably wrong somewhere. Presumably, if you throw your query info phpMyAdmin or some other command line, it works fine?

If you do print_r($row);, show us what you get? or var_dump($row['set0'])

[bcarl314]

Try changing this:

PHP Code:

$result = mysql_query($query); 


to this

PHP Code:

$result = mysql_query($query) or die(mysql_error()); 


you might also want your query to be:

PHP Code:

$query = "SELECT * FROM tablea ORDER BY id DESC limit 1"; 


if you're trying to get the last record in the tablea table.

[Aquawave]

Originally Posted by Keleth

Presumably, if you throw your query info phpMyAdmin or some other command line, it works fine?

If you do print_r($row);, show us what you get? or var_dump($row['set0'])

Yes it works fine, but I need the value of $row['set0'].

I did a print_r() and everything came out fine, except, $row['set0'] was empty, yet its not because I can see it in my table via my SQL's console.

[Keleth]

var_dump didn't give any useful info? I can't think of ANY reason why some of your columns would show up correctly but not others.

[Fou-Lu]

Issue a var_dump and post that.
The data is your problem, not the code. Make sure your error reporting is enabled as well:

PHP Code:

ini_set('display_errors', 1);
error_reporting(E_ALL); 


It would also be helpful to issue a SHOW CREATE TABLE tablea and show that as well.