how do i select

[sabret00the]

how do i select ALL data from a database concerning a specific userid?

something along the lines of
SELECT * FROM * WHERE userid=XX

[Xenon]

nope, you have to use joins
SELECT *
FROM user
INNER JOIN userfield USING(userid)
INNER JOIN usertextfield USING(userid)
...
WHERE user.userid = xx

[sabret00the]

thanks :)