Moved to a new server, on old server all php files worked fine, now I am getting errors on simple mysql_connect issue.

http://www.focal-point.org/view.php?id_num=1

This is the code he sent me he said he is using....
mysql_connect("localhost", "UNAME", "PASS") or die("Failed"); mysql_select_db("focalp_main"); $query = "SELECT * FROM users WHERE id = $id_num"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($result);

thats line 1.
am I missing something? MySQL is version 5, and php is version 5

IT might be fussy..

SELECT * FROM `users` WHERE `id` = '$id_num'

nope, still does it

'$id_num' as opposed to $id_num.

Unknown column '' in 'where clause'

its not carrying the $id_num into the page when I put two `'s in

For the variable it's got to be 's, not `s.

still nothing.

So long as $id_num is numeric, this should work.