anotha mysql query problem

[fuzic]

I have a query, and when I call a result using mysql_result, it says the suplied argument is an invalid resource, so something in the following query isn't working. Any ideas?

$resultg = mysql_query("SELECT `user`,`icon`,`caption`,`site`,`aim`,`yahoo`,`icq`,`post_count`,`status` FROM `users` WHERE `user_id` = '".$uid."' LIMIT 0, 30");

[JoeBrewer]

Hi mate

I'm only a beginner at this kinda thing, but I think that this may work:

$query = "SELECT user,icon,caption,site,aim,yahoo,icq
,post_count,status FROM users WHERE user_id = '".$uid."' LIMIT 0, 30";

$resultg = mysql_query($query);

Joe

[TTT]

you don't have to use ex. 'user','icon' ...

just use

$resultg = mysql_query("SELECT user,icon,caption,site FROM users WHERE user_id = $uid LIMIT 0, 30");