Need help...

[SCS_Rocket-Devi]

I want to select the post count from userid 1 i have tried to use this and its not working :(

SELECT * FROM `user` FROM `posts` WHERE `userid` = 1 LIMIT 1

What am i doing wrong?

Thanks Dan

[Dilmah]

SELECT posts FROM `user`WHERE `userid`=1 LIMIT 1

[SCS_Rocket-Devi]

Thanks, its getting somewhere but when u put it in as PHP code it shows the value as 0 when it should be 88

$querya="SELECT posts FROM `user`WHERE `userid`=1 LIMIT 1";

[Opserty]

If your doing it via a plugin or custom vB page you can use:
$userid = 2;
$userinfo = fetch_userinfo($userid);
$postcount = $userinfo['posts'];


Otherwise I think its something like this:

$query = mysql_query("SELECT `posts` FROM `user`WHERE `userid`=1 LIMIT 1");
$array = mysql_fetch_assoc($query);
$postcount = $array['posts'];

[SCS_Rocket-Devi]

im doing it from 3rd party script

[Opserty]

Use the second block of code I posted then, that should work.

[SCS_Rocket-Devi]

yey! thanks it works!