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



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[Opserty]

If your doing it via a plugin or custom vB page you can use:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Otherwise I think its something like this:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[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!