MySQL INSERT Query - No longer works

I am having an issue with an INSERT query that used to work but, as the title suggests, it's stopped working.

Here is the offending (or not so offending) code:

$qryd = "INSERT INTO 
         trans_deposits (login, walletadd, depamount, tickamount, recadd) 
         VALUES
         ('$login', '$walletadd', '$thefee', '$ticketamount', '$recaddress')";
$resultd = @mysql_query($qryd);
session_write_close();

... but more importantly... I accidentally deleted the original table (trans_deposits) so I created another table with the same table and column names etc. After which, the query no longer worked. - I don't see how, but could this have caused an issue?

I've tried the mysql_error() "trick" but no luck. Any ideas?

Answers


$qryd = "INSERT INTO trans_deposits(login, walletadd, depamount, tickamount, recadd) VALUES('$login', '$walletadd', '$thefee', '$ticketamount', '$recaddress')";
$resultd = mysql_query($qryd); //remove @
//For INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error. 
if (!$resultd) {
    echo "Error! ", mysql_error(); //Read the text of the error message
}

Need Your Help

Does converting Oracle .rdf files to .rep do anything different than changing the extension?

oracle plsql oracle11g oraclereports

I'm using Oracle forms and reports 11g. When I was told how to compile the reports (the .rdf files) I was told to just convert them to .rep files. I didn't think to check in report builder for a

How to load a javascript file containing ajax call asynchronously?

javascript asp.net jquery

I have a JavaScript file named JScript.js this file contain a function below i.e a ajax call to a dot-net page