Select statement question?

[bigtime]

$pre = "forum_";



 $sql = "SELECT user_id FROM  forum_users 
 WHERE username = '$username'"; 

How do I write the above statement? The below code doesn't work where I substituted $pre for forum_:

$pre = "forum_";



 $sql = "SELECT user_id FROM  '$pre'users 
 WHERE username = '$username'"; 

Thanks in advance!

[Pig]

You need concatenate.

$sql = "SELECT user_id FROM " . $pre . "users

WHERE username = '$username'";

[bigtime]

Thanks for the quick reply. I knew it was something like that but couldn't get it quite right.

Thanks!