[SOLVED] Resource Id #4

[wrathican]

what does this mean, i cant find anything of use on google. my query is:

$qallid = "SELECT all_id FROM kb3_alliances WHERE all_name='" . $alliancen . "'";
$rallid = mysql_query($qallid);
$all_id = $rallid;

echo $all_id;

 

and it just brings up: Resource Id #4

[trq]

mysql_query returns a resource. Take a look at mysql_fetch_assoc.

[kenrbnsn]

After doing a mysql_query(), you need to actually fetch the records retreived:

<?php
$qallid = "SELECT all_id FROM kb3_alliances WHERE all_name='" . $alliancen . "'";
$rallid = mysql_query($qallid);
$rw = mysql_fetch_assoc($rallid);
$all_id = $rw['all_id'];
echo $all_id;
?>

 

Ken

[wrathican]

ahh i see.

you see because the query only returned one value i assumed that i wouldnt need that, as it would be pretty straight forward as to what the value was..

thanks alot