php getting row from database using users id

[jamieduk]

im getting a issue where $ variables are getting ignored and do not know why here is the error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

here is the code

<center>
<title>J~Net Balance Accounts</title>
<?php
// Connects to your Database
mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("messages") or die(mysql_error());
$data = mysql_query("SELECT * FROM users where id = $id")
or die(mysql_error());
Print "<table border cellpadding=3>";
while($info = mysql_fetch_array( $data ))
{
Print "<tr>";
Print "<th>User:</th> <td>".$info['user_name'] . "</td> ";
Print "<th>Balance:</th> <td>".$info['balance'] . " </td></tr>";
}
Print "</table>";
?> 

any ideas please anyone as it might be something silly

[Rabbit]

I don't see where $id is defined or initialized anywhere.

[NeoPa]

Please check When Posting (VBA or SQL) Code. This applies to you as you're asking about SQL but only posting your PHP code.

Nevertheless, your problem is in line #7, as you'd see easily if you'd posted the SQL itself.