1 reply to this topic

[heyman]

I'm having an issue with MySql insert statement. I have a page called test.php, created to check my insert statement. Here is the code on it.

$fullname="Elliot Springer";
$dbh=mysql_connect($host,$un,$pw);
mysql_select_db($dbname, $dbh);
$sql = "INSERT INTO members (name) VALUES ('$fullname')";
mysql_query($sql);
mysql_close($dbh);

Now, when i access this page (test.php) from any other page, the insert statement doesn't insert into the database, if I refresh the page (test.php), then it executes and the insert statement works. The only other thing on the page is the connection variables which are correct, hense the execution second time around.

Does anyone know why this would not execute when coming from another page, but does on the refresh?

Please help.

Thanks

[Randy]

Since it works when you reload the page it shouldn't be anything with the coding on that specific page per se.

Are some variables being passed to the test page when you're coming from another page perhaps?