Re: Probleme with MySQL queries

> In fact the first return 0 results So the problem is in your select, and if your select works when you manually insert the value for id (iow, without using $var), the problem has something to do with $var. Is the data type of the ID column INT? Try the following and let us know the output: $var=107; $query = mysql_query("SELECT * FROM table WHERE id={$var};") or die(mysql_error()); // make sure to use double quotes var_dump(mysql_error(), mysql_num_rows()); $var=mysql_real_escape_string("107"); $query = mysql_query("SELECT * FROM table WHERE id={$var};") or die(mysql_error()); // make sure to use double quotes var_dump(mysql_error(), mysql_num_rows()); $query = mysql_query("SELECT * FROM table WHERE id=107;") or die(mysql_error()); // make sure to use double quotes var_dump(mysql_error(), mysql_num_rows());