Problem in PHP form

[Sam12]

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.

Can someone help me ?

Thanks

[RobertoOrtiz]

Surely we will help you can you post your coding ? So that we will come to know your coding is correct or not.

[Sam12]

Sorry i forget to post code.

<? 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 (); 
>

[RobertoOrtiz]

function empty () "is very applicable. your problem that the instruction "INSERT" must be executed in the instruction "else" because your code following the instruction "INSERT" is executed as it is found outside the instruction "else" .