insert not working

matt82 · August 11, 2008

Hi guys i am very new to php so any help would be much apreciated

the code seems like it should work none of the built in errors are returned but when i look at my mysql db no new entries are added.

<html>

<head>

</head>

<body>

<?php

include 'library/config.php';

include 'library/opendb.php';

$dbhost = 'localhost';

$dbuser = 'root';

$dbpass = 'w33kDays!';

$dbname = 'advendeals';

$connnection = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

return $connection;

mysql_select_db($dbname);

$query = "INSERT INTO clients (ClientID, ClientCountry, ClientState) VALUES ('176', 'Australia', 'queensland')";

mysql_query($query) or die('Error, insert query1 failed');

$query = "FLUSH PRIVILEGES";

mysql_query($query) or die('Error, insert query2 failed');

include 'library/closedb.php';

?>

</body>

</html>

thanks in advance for any help.

adam84 · August 13, 2008

Why do you have 'return $connection'? Your code is stopping at the point. Remove that line and try it again.

matt82 · August 15, 2008

Thanks mate once i got past that i was able to get the code working.

i appreciate it

Recommended Posts