MySQL Query not Working? Seems odd..

Anon

Hi there,

The following code takes formdata (and one cookie, in the case of $totalcost) and shoves it into a MySQL database. The problem is it's not working, and I have no idea why.

Every time I run the script, I get the "die" message from the mysql_query statement, which only tells me things aren't working. I simply have NO idea what's wrong with this statement. From everything I can tell, the script has no problem connecting to the database, so that's not it... just this damned insert statement.

If someone could tell me what's causing the problem, I'd really, really appreciate it.

$sql = "INSERT INTO orders (theorder, firstname, lastname, date, address1, address2, city, state, country, zip, phone, fax, email, cardnum, cardexp, howhear, howfind, totalcost) VALUES ('$theorder','$firstname','$lastname','$date','$address1','$address2','$city','$state','$country','$zip','$phone','$fax','$email','$cardnum','$cardexp','$howhear','$howfind','$totalcost')";

$result = mysql_query($sql)
	or die("Error processing order. Sorry... $result");

PRINT("<center>Order processed!<br><br>$theorder</center>")

big_e

I don't see a problem with your code so all I can say is check you spelling. I had this problem before and it was just a simple spelling mistake. Other than that, I don't know what to tell you!

~ Eric
123 Make Me! ( http://123-makeme.com )

dgrinberg

You also need to ensure that the variable types are correct.

if you run the SQL statement on its own, (in a DB client) does it work. Copy the SQL from the output and try and run it. You may get a better error message which will help you debug

Anon

The SQL code is fine; I tried using verbatim from the commandline, with success.

Well, I had the die message throw the mysql_error() instead of simply stating that an error had occured, and got this:

Warning: 0 is not a MySQL link index in /usr/local/etc/httpd/vhosts/thudbuster.com/htdocs/store/robot.php

I'm not sure what this means. My mysql link ($db) is correct... or I see no reason why it wouldn't be. Here's the code where it's opened:

if (!($db = mysql_connect("localhost", "rjworldw", "******")))
{
	PRINT("Could not connect to database server. We're in trouble.");
	exit();
}
mysql_select_db("thudbusterstore",$db);

I figure it MUST be working, as it's not yet printed the error message... any ideas?