query problem

[FURQAN]

hi there furqi here

i have a problem of mysql  in my code following is the code any help will b highly appreciated thanxxx

<?php
mysql_connect('localhost','root','') or die("cannot run");
mysql_select_db('normalisation') or die("cannot run");
$sql="SELECT a.id,t.correct
  FROM answertable a,table t
  WHERE a.rollnumber=t.rollno";
$result=mysql_query($sql) or die("cannot run");
?>

 

this code gives output "cannot run" i.e., die

[fenway]

How about dumping mysql_error()?

[ignace]

$result=mysql_query($sql) or die("cannot run " . mysql_error());

[FURQAN]

it is saying the following 

 

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 'table t WHERE a.rollnumber=t.rollno' at line 2

 

thanxxx

[fenway]

You called your table "table"? Bad idea -- don't use a reserved keyword.