Query Was Empty?

[TonyRosen]

whenever I use:

------------------------------

$query = mysql_query("INSERT INTO my_register (`credit`, `date_stamp`, `number`, `payee`, `amount`, `description`, `signatory`, `balance`) VALUES ('$credit', '$date', '$number', '$payee', '$amount', '$description', '$signatory', '$new_balance')");

------------------------------

I get "Query Was Empty" ... what causes that?

 

[Olavxxx]

try this:
echo "INSERT INTO my_register (`credit`, `date_stamp`, `number`, `payee`, `amount`, `description`, `signatory`, `balance`) VALUES ('$credit', '$date', '$number', '$payee', '$amount', '$description', '$signatory', '$new_balance')";

check what it outputs..

I'm too tired to read all quotes now

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[Chacalinc]

are you using ` or ' ? they are different characters...

 

[DRJ478]

Have you inspected the mysql_error() after the query fails? You could add the 'or die()' clause to catch what the server has to say:

$query = mysql_query("INSERT INTO my_register (`credit`, `date_stamp`, `number`, `payee`, `amount`, `description`, `signatory`, `balance`) VALUES ('$credit', '$date', '$number', '$payee', '$amount', '$description', '$signatory', '$new_balance')") OR die("Query failed: ".mysql_error());

 

[danomac]

Also, are all the fields text fields? A numeric field should not require quotes (') around the values, in your VALUES statement.

 

[TonyRosen]

Just an FYI ...

I've gone about this a whole different way now ... I still don't know why I was receiving this ... everything looked good.