[SOLVED] Error with PHP /Mysql;- Wrong Syntax

[paulman888888]

Hi;

Ill get to the point.

 

This code should work but i don't no why it doesn't.

$query="INSERT INTO `requests` (`name`, `email`, `msg`, `status`)
VALUES ('$name, '$email', '$msg', `$status`)";

And in my table there is id, name, email, msg, status.

id=int

name=varchar

email=varchar

msg=blob

status=int

 

Thankyou for all help in advance

Paul

[Maq]

Don't use backticks for the value of $status.

 

Just use single quotes:

 

'$status'

 

And use an or die(msql_error()) at the end of your query call.

[Mark Baker]

And you're missing a closing quote after $name

'$name,

[MatthewJ]

If status is an int, it doesn't need quotes at all

[paulman888888]

thanks guys. It works now,

i over looked that closes quote.

 

Its always the little things, 8bit or 1 byte stopped a whole script from working.

 

Thanks again