Deprecated: mysql_db_query()

[redgunner]

I am having difficulties in resolving this issue...

 

Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead

 

I do what it asks and then I get the following error message...

 

ERROR: INSERT INTO customers (name, age) VALUES ('', 'Joe' '40') Added Show Records

 

if ($_SERVER['REQUEST_METHOD'] == "POST") {

// Form Values
$id = "";
$name = $_POST['name'];
$age = $_POST['age'];

$SQL = " INSERT INTO customers ";
$SQL = $SQL . " (name, age) VALUES ";
$SQL = $SQL . " ('$id', '$name' '$age') ";
$result = mysql_db_query($database,"$SQL");

if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); } echo ("Added\n"); }

 

Thanks for any help in advance...

[Alex]

1. You're still using mysql_db_query() there.

2. You're naming only 2 columns and providing 3 values.

[RussellReal]

if id is an auto incrementing field you don't need to show it.. and like the other poster said you're still using mysql_db_query

[PFMaBiSmAd]

And the two values you do want to put into the query don't have a comma in between them.