sql query with php problem

[sanjay123456]

Dear friends ,

How i write this query in mysql

data r following
$que=$_POST['que'];

$quiz=$_POST['quiz'];

its variable inserted in to mysql is following query correct or not

mysql_query("INSERT INTO result(que,ans)
VALUES ($que,$quiz)");

sanjay

[ronverdonk]

Yes, but when the fields have data type character, you better store the values between single quotes, like this

mysql_query("INSERT INTO result(que,ans) 
VALUES ('$que', '$quiz')");

Ronald :cool:

[sanjay123456]

Sir ,

thx ur quick reply sir
plz tell me that both que and quiz are as a interger and both r coming integer
and in mysql table i aslo declare int can i convert both in int or they r in int in php page

because in jsp everything in form of string

sanjay

[ronverdonk]

When both $que and $quiz are integers your original INSERT statement is correct. I.e.

mysql_query("INSERT INTO result(que,ans) 
VALUES ($que,$quiz)");

Ronald :cool:

[satya61229]

and you should quote the any input by user, for security reason.
check for get_magic_quotes_gpc() and mysql_real_escape_string();