only insert record if there is data in field

ejwf

Hello

I have a data entry page on a website that shows a number of options in columns (size / colour / quantity) for a list of items (rows)
As it turns out the user will not fill in all of the information in one go, they will come to the site on 2 or 3 occassions to fill in different bit of information but in each case they will complete at least one row.
At the moment the code I have enters the data onto the mysql database for all the rows whether the user has entered data or not so I am getting a lot of blank records in the database which is screwing up the data I am getting out ........
so what I want to do it put some sort of if $POST['quantity'] <1 don't add the record but I don't know the best way to do this or where to put it in the code - the code I have at the moment is

if (isset($_POST['Quantity']))
{ 
$arr_size = count($_POST['Quantity']); 
for ($i=0;$i< $arr_size;$i++) 
{ 
    $Quantity = strip_tags(trim($_POST['Quantity'][$i])); 
    $Colour = strip_tags(trim($_POST['Colour'][$i])); 
    $Id = ($_POST['Id'][$i]); 


$query = "INSERT INTO tblResults (Ref,MRef,SRef,ClRef,Quantity,Colour,LoadedBy)
		VALUES ('$Ref','$MId','$SRef','$CRef','$Quantity','$Colour','$UserId')";
$result = mysql_query($query)
or die(mysql_error());
} //close for
} //close if

can anyone suggest how I can improve this code so that it only inserts records when a user has put the data in the row on the website - thanks

remnant

well, you could say:

if (!empty($_POST['Quantity']))

However, it sounds like cookies or some user tracking might be a more logical way to handle this.

ejwf

thanks but this doesn't achieve what I was looking for
example
the website table looks like this
---------id colour quantity

Item#1 101 ------ ------
Item#2 102 ------ ------
Item#3 103 ------ ------
Item#4 104 ------ ------
Item#5 105 ------ ------

the id comes from a previous query to the database
the user fills in the blanks
but if they only fill in the colour / quantity for item #3 I only want that record added to the database

using this code adds all 5 records with 0 in the fields where the user hasn't put any information in

if (isset($_POST['Quantity'])) 
// or if I use if (!empty($_POST['Quantity'])) it still doesn't work

{  

$arr_size = count($_POST['Quantity']);  

for ($i=0;$i< $arr_size;$i++)  

{  

    $Quantity = strip_tags(trim($_POST['Quantity'][$i]));  

    $Colour = strip_tags(trim($_POST['Colour'][$i]));  

    $Id = ($_POST['Id'][$i]);  


$query = "INSERT INTO tblResults (Ref,MRef,SRef,ClRef,Quantity,Colour,LoadedBy) 
        VALUES  ('$Ref','$MId','$SRef','$CRef','$Quantity','$Colou
r','$UserId')"; 
$result = mysql_query($query) 
or die(mysql_error()); 
} //close for 
} //close if

any ideas anyone?

remnant

This is a design issue, not really a php coding problem.

If a user is going to enter all the information about item #3 (size / color / quantity) why are you passing the information as arrays which contain those attributes for other items?

Why not just have each item under a seperate form tag?

ejwf

This is because the user entry table is created by a query.
Item#1 / Item#2 etc. is the content of an array created by this query and then for every item within the array I show the Id and then a blank box for the user to enter Colour and then Quantity