changin PHP 5 script to PHP 4

misseyB

I am just starting to learn PHP 5 but unfortunately my ISP provider uses PHP 4 and although i've done my best to substitute PHP5 code with PHP4 i'm still getting some errors.

The latest is a 'Can't execute insert query' error returned by the query. All of the code preceeding this is working okay, including connecting to the server.

Any help would be so much appreciated. MisseyB

       $_SESSION['auth']="yes";                    
       $logname=$_POST['fusername']; 
       $_SESSION['logname'] = $logname;        
       $today = date("Y-m-d h:i:s");               
       $sql = "INSERT INTO login (loginname,logintime)
               VALUES ('$logname','$today')";
       $result = mysql_query($sql)
                 or die("Can't execute insert query.");

NogDog

Let's do some basic debugging by adding more info to your die() output to see if it points to where the problem is:

$result = mysql_query($sql)
or die("Can't execute insert query.<br />\n$sql<br />\n" . mysql_error());

This will show the query exactly as it was submitted to MySQL, along with the error message returned by it.

misseyB

Thank you, thank you, thank you, thank.

With that new code i was able to resolve all outsanding problems. You're a star!!!!

misseyB

Thank you, thank you, thank you, thank you.

With that code i was able to resolve all outsanding problems. You're a star!!!!