[RESOLVED] mysql_result wont work , but fetch array will

[Sayian]

A very strange thing is happening to me when trying to program a simple script

in this query

$sql = " SELECT `user_id` FROM `shocc_gallery_info` WHERE `id` = '$gid' ";
$query = mysql_query($sql) or die(mysql_error());
$result = mysql_result($query);
echo $result;

$result does not return a result

but if i do it this way

$sql = " SELECT * from `shocc_gallery_info` WHERE 'id' = '$gid' ";
$query = mysql_query($sql) or die(mysql_error());
$result = mysql_fetch_array($query);

echo $result['user_id'];

Now that will print the user ID

i dont understand why just a simple mysql_result wont work ...... Why should i have to call an entire array?

[kburger]

Looks like you might need to go back and read the manual for MySQL functions.

string mysql_result ( resource result, int row [, mixed field] )

Your usage:

Warning: Wrong parameter count for mysql_result()

[Sayian]

Thanks , ive done that , and i still dont understand what im doing wrong.

[Sayian]

The correct syntax needed was

$result = mysql_query("SELECT user_id FROM shocc_gallery_info WHERE id = '$gid'");
$result = mysql_result($result, 0, user_id);

thanks.

[kburger]

I edited my original post, probably while you were replying. Check my post again. The answer is there.

[kburger]

No, it's actually

$result = mysql_result($query, 0);

I think your variable naming scheme is what's throwing you off.