[RESOLVED] Resource id #4

[campsoup1988]

When I run the following script in PHP:

$temp="select max(id) as num from `$album_id`";
$max_id=mysql_query($temp) or die("error");

I get the following when I echo $max_id:

Resource id #4

any idea how to get just a number not resource id #4?

Thanks
Campsoup1988

[tsinka]

Hi,

you need to fetch the record:

 $temp="select max(id) as num from `$album_id`";
$res=mysql_query($temp) or die("error"); 
$row = mysql_fetch_assoc($res);
$max_id=$row['num'];

Does $album_id contain a table name ? The variable name looks suspicious ...

Thomas

[campsoup1988]

ok, $album_id contains the table number, in this case -1, which is stored in $album_id, and to access a table that is a number, you must have a on either side of the number, so in this case$album_idwould result in-1` which is the correct access to the table

what do you mean fetch?

Do I need to teach one of my dogs php? LoL

oh, I see what you mean!

ah thanks! it worked!

THANK YOU!
campsoup1988