Can't manage to populate a db

[carlozdre]

Can someone please help me and point out what is wrong in this code?

 

I have a form.php with some fields to complete to update a MySQL database, I receive the succesful message after entering the data and but when I look in the database with phpMyAdmin I can see nothing else than 2 records I entered manual the first time when I created the db.

 

So what's wrong?

 

update.php:

 

<?php

$FName = $_POST['FName'];
$LName = $_POST['LName'];
$PHON = $_POST['PHON'];

mysql_connect ("66.79.xxx.x", "admin_chxxx", "xxx") or die ('Error: ' . mysql_error());
mysql_select_db ("admin_xxx");

mysql_query("INSERT INTO 'Clients' (ID, FName, LName, PHON) VALUES ('NULL', '$FName', '$LName', '$PHON'");

echo "Database updated with: ".$FName. " ".$LName." ".$PHON;


?>

 

 

Thanks.

[pocobueno1388]

Try to catch the error with a die statement, also try taking the quotes from around "Clients".

 

mysql_query("INSERT INTO Clients (ID, FName, LName, PHON) VALUES ('NULL', '$FName', '$LName', '$PHON'")or die(mysql_error());

[MadTechie]

<?php

$FName = $_POST['FName'];
$LName = $_POST['LName'];
$PHON = $_POST['PHON'];

mysql_connect ("66.79.xxx.x", "admin_chxxx", "xxx") or die ('Error: ' . mysql_error());
mysql_select_db ("admin_xxx");

mysql_query("INSERT INTO 'Clients' (ID, FName, LName, PHON) VALUES (NULL, '$FName', '$LName', '$PHON') ") or die(mysql_error()); 
//Missed a ), 
//no need to quote the null 
//also some debugging

echo "Database updated with: ".$FName. " ".$LName." ".$PHON;


?>

[carlozdre]

Got it, thank you again guys.

 

Btw, I had to remove the quotes too from around Clients to work, otherwise:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Clients' (ID, FName, LName, PHON) VALUES (NULL, 'AAA', 'AAA', '07786')' at line 1