MySQL won't connect for any apparent reason. 2

[Zilch]

Okay, I've checked, re-checked, and looked over my code what feels like a few hundred times now. I know it's connecting to the Database, but it won't add information!

Anyways, here's my code:

$sql = "INSERT INTO pm (from,to,subject,message,date) VALUES ('$from','$to','$subject','$message','$date')";
$result = mysql_query($sql,$conn) or die ("Couldn't connect to send information."

I have defined all the variables, no idea why it's not working.

 

[spookie]

have u printed this query on browser? what error dose it give ?

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[Zilch]

I get the error "Couldn't connect to send information."

If you'd like the rest of the code sorrounding that bit, please tell me.

 

[spookie]

and the query looks alright ?
what if you cut and paste the query thru mysql command prompt..?does it work ?

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[Skute]

try this:

$result = mysql_query($sql,$conn) or die (&quot;Couldn't connect to send information.!<br>Reason: &quot; . mysql_error()));

That will tell you the exact problem.

Hope it helps

Skute

&quot;There are 10 types of people in this World, those that understand binary, and those that don't!&quot;

 

[DRJ478]

General observation:

Stay away from reserved words in MySQL. Don't name databases, tables, columns using reserved words. Although you can enclose them in backticks abstinence is best.

You have a column 'from'. I'd rename that to something else. Just imagine this query:
&quot;SELECT FROM myTable WHERE from =.....&quot;

 

[Zilch]

Okay, thank you everyone. The problem was the fact that I was using to and from, I changed them, and everything worked fine... just a few bugs I still need to work out though.