Database

[Anon]

I am not very experienced with PHP, but seem to be getting the hang of it. I have had a small problem which I cant get rid of. I am building a registration form which adds a record to a MySQL database. The form's action takes it to another page where the following code is:
<?
$database = "global";
$db = mysql_connect("localhost", "root");
mysql_select_db("$database",$db);
$sql = mysql_query("insert into delegate (del_title,del_fname,del_sname,del_address,del_country,del_phone,del_fax,del_email,del_company,del_industry) VALUES ('$name','$surname','$address','$country','$phone','$fax','$email','$company','$industry')",$db);
$result = mysql_query($sql);
?>
The there are no PHP or Apache server errors and the page loads correctly, but the record is not added! Please help!!

[jordan]

Though I don't have a complete solution, start by using empty() to make sure that all of your variables ($name, $surname, etc.) are set.

[writethegeek]

It looks like you left an extra ")" in your values statements just before $db.

Take it out and see if that helps.

Chris

[preetha]

hi,

I think this might help u.U have passed only 9 parameters ( i mean the inputs)to the query.U haven't passed value for (del_title). Check it out.

[Anon]

Preeda,

Thanks so much for the help!!! I tried out your recommendation and it works perfectly!!

Thanks again!

[preetha]

never mind.

preeth

[Anon]

Thanks for the help! I am being much more careful with what exactly my query is, and it seems to be working!!

Thanks again!!

Paul