Problem in PHP..

[infomercialscams]

I have created a form that sends data in my database sql. Thats goes well only if the fields are empty, data is transmitted in the base. I try to use the empty but it not work, My friend told me to use the trim but that also didn't work.

Here are the coding so that you can know better

<? php 
 
mysql_connect ( "localhost", "root", "") OR die ( 'Error selecting database'); 
mysql_select_db ( "camping") or die ( 'Error selecting database'); 
/ / (=> Useless 
 
$ name = $ _POST [ 'name']; 
$ first_name = $ _POST [ 'firstname']; 
$ address = $ _POST [ 'address']; 
$ PostalCode = $ _POST [ 'PostalCode']; 
$ city = $ _POST [ 'city']; 
$ telephone = $ _POST [ 'telephone']; 
$ mail = $ _POST [ 'mail']; 
$ message = $ _POST [ 'message']; 
 
if (empty ($ name) & & ($ firstname) & & empty ($ address) & & empty ($ PostalCode) & & empty ($ city) & & empty ($ telephone) & & empty ($ mail) & & empty ($ message)) 
( 
echo ( "There is an empty field"); 
) else 
( 
echo ( "fields filled"); 
 
)
 
$ req = mysql_query ( 'INSERT INTO clients (name, surname, address, Postcode, city, telephone, mail, message) VALUES ("'.$ name.' "" '. $ firstname.' "" '. $ address. ' ""'. $ PostalCode. ' ""'. $ city. ' ""'. $ telephone. ' ""'. $ mail. ' ""'. $ message. ") ') or die (mysql_error ()); 
if ($ req) 
( 
echo 'enregisttrement reussi'; 
) 
else 
( 
echo 'There was a problem <br/>. $ req; 
) 
 
 
 
mysql_close (); 
>

Can someone help me ?

Thanks
edit by admin: no commercial URLs on the forum please