Query Was Empty- error after inseting data into database

[Gefry]

I used MySQL query to insert some fields into phpadmin database, the query was also very simple but whenever i used an launch that query it simply passed on me the error message saying that "query is empty".

I used the following query to insert field into my database.

$_SESSION['authour']="yes";
$logname = $_POST['Firstusername'];
$_SESSION['logname'] = $logname;
$today = date("Y-m-d h:m:s");

After defining the variable I passed the following parameters to insert into an database.

$sql = "INSERT INTO Member (loginName, loginTime) VALUES ('$logname', '$today')";
echo "$logname, $today";
mysql_query($sq1) or die(mysql_error());

what would be the problem where it goes wrong please help.

[Khushal]

This may happen that whenever you wanted to pointed towards some records at that time your actual pointer may directed to the different location and that location may be consider as the null pointer of empty pointer from the programming point of view. Here in your case it seems that your query would be stored in '$sql' (ESS-QUE-ELL), but mysql_query is trying to call '$sq1' (ESS-QUE-ONE).

[Mecurtis]

I will ask you to run your MySQL command for one more time, if it still gives you the same problem then switch over to postgre sql which will be the next best option to show you the error reporting and will assist in debugging the situation. or else you just need to consider it replacing your javascript functions with PHP ones since JS can sometimes interfere with MySQL result sets and PHP provide superior client side scripting anyway.