Resource id #18

[Leovenous]

I don't know how much php is involved. This may belong in the SQL area.

Anyway, this frusterates me. Its not unusual for me to encounter resource id issues and hours of searching has yielded very little result. Maybe I have a wrong approach or something, I would like to learn.

So this query:

[code]$query = "SELECT frc_id FROM frc_users WHERE frc_id = '$userid' ";
$result = mysql_query ($query) or die(mysql_error());
echo $query;    
echo $result;[/code]

I get the right query:

[code]SELECT frc_id FROM frc_users WHERE frc_id='2'[/code]

But the result is the resource id #18. What gives?

[Orio]

Try:
[code]print_r($result);[/code]

Orio.

[wildteen88]

You cant echo $result in its raw state. You have to use a function like mysql_fetch_array in order to get the results. $result justs stores the result resource which is loaded into memory.

So if you do this:
[code]$rows = mysql_fetch_array($result);

echo print_r($rows);[/code]

You'll now see your results.

[Leovenous]

That makes sense. I wondered if it had to do with an array. Thanks

[hackerkts]

[code]$rows = mysql_fetch_array($result);[/code]
Is for calling one/zero row, if you want to call more more rows, you need to use while loop.

There's a FAQ which is sticky, try reading there. It has examples.