My queries do not execute. It just redirects to blank page. Please help.

[backups2007]

Here'es my code. I double checked it and I can't seem to find any reason why it won't work. Or maybe I just missed something. Please help. Thanks. If you have any suggestion on how I can improve this code, please post your them.

 
//inserting so
if($cust_id!="")
{
    $query_dealer = mysql_query("INSERT INTO service_order (so_no, cust_id, prod_id, qty, purchase_date, invoice_no, date_arrived, time_arrived, date_started, time_started, date_finished, time_finished, remarks, estimate, labor, spare_parts, materials, transportation, storage_fee, total_charges, so_date, prepared_by, service_tech, costing_approved)"."
    VALUES ('$so_no', '$cust_id', '$prod_id', '$qty','$dop','$invoice_no','$date_arrived','$time  _arrived','$date_started','$time_started','$date_f  inished','$time_finished','$remarks','$estimate','  $labor', '$spare_parts', '$materials', '$transportation', '$storage_fee', '$total_charges', '$so_date', '$prepared_by', '$service_tech', '$costing_approved')");  
}
if($walkin_id!=="")
{
    $query_walkin = mysql_query("INSERT INTO service_order (so_no, walkin_id, prod_id, qty, purchase_date, invoice_no, date_arrived, time_arrived, date_started, time_started, date_finished, time_finished, remarks, estimate, labor, spare_parts, materials, transportation, storage_fee, total_charges, so_date, prepared_by, service_tech, costing_approved)"."
    VALUES ('$so_no', '$walkin_id', '$prod_id', '$qty','$dop','$invoice_no','$date_arrived','$time  _arrived','$date_started','$time_started','$date_f  inished','$time_finished','$remarks','$estimate','  $labor', '$spare_parts', '$materials', '$transportation', '$storage_fee', '$total_charges', '$so_date', '$prepared_by', '$service_tech', '$costing_approved')");
 
if($query_walkin)
{
header("Location: form_service_order.php");
}
}
else
{
echo "Error! Cannot process request.";
}
 
if($part_no1!="")
{
    $query1 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no1','$pquantity1','$so_no')");
    if($query1 && $part_no2!="")
    {
        $query2 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no2','$pquantity2','$so_no')");
        if($query2 && $part_no3!="")
        {
            $query3 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no3','$pquantity3','$so_no')");
            if($query3 && $part_no4!="")
            {
                $query4 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no4','$pquantity4','$so_no')");
                if($query4 && $part_no5!="")
                {
                    $query5 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no5','$pquantity5','$so_no')");
                    if($query5 && $part_no6!="")
                    {
                        $query6 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no6','$pquantity6','$so_no')");
                        if($query6 && $part_no7!="")
                        {
                            $query7 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no7','$pquantity7','$so_no')");
                            if($query7 && $part_no8!="")
                            {
                                $query8 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no8','$pquantity8','$so_no')");
                                if($query8 && $part_no9!="")
                                {
                                    $query9 = mysql_query("INSERT INTO so_parts (part_id, qty, so_no) VALUES ('$part_no9','$pquantity9','$so_no')");
                                    if($query9)
                                    {
                                        header("Location: form_service_order.php");
                                    }
                                    else
                                    {
                                        echo "Error! Cannot process request.";
                                    }
                                }
                                else
                                {
                                    header("Location: form_service_order.php");
                                }
                            }
                            else
                            {
                                header("Location: form_service_order.php");
                            }
                        }
                        else
                        {
                            header("Location: form_service_order.php");
                        }
                    }
                    else
                    {
                        header("Location: form_service_order.php");
                    }
                }
                else
                {
                header("Location: form_service_order.php");
                }
            }
        }
        else
        {
            header("Location: form_service_order.php");
        }
    }
    else
    {
        header("Location: form_service_order.php");
    }
}
else
{
    if($mid1!="")
    {
        $query1 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid1','$mq1','$so_no')");
        if($query1 && $mid2!="")
        {
            $query2 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid2','$mq2','$so_no')");
            if($query2 && $mid3!="")
            {
                $query3 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid3','$mq3','$so_no')");
                if($query3 && $mid4!="")
                {
                    $query4 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid4','$mq4','$so_no')");
                    if($query4 && $mid5!="")
                    {
                        $query5 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid5','$mq5','$so_no')");
                        if($query5 && $mid6!="")
                        {
                            $query6 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid6','$mq6','$so_no')");
                            if($query6 && $mid7!="")
                            {
                                $query7 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid7','$mq7','$so_no')");
                                if($query7 && $mid8!="")
                                {
                                    $query8 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid8','$mq8','$so_no')");
                                    if($query8 && $mid9!="")
                                    {
                                        $query9 = mysql_query("INSERT INTO so_materials (mat_id, qty, so_no) VALUES ('$mid9','$mq9','$so_no')");
                                        if($query9)
                                        {
                                            header("Location: form_service_order.php");
                                        }
                                        else
                                        {
                                        echo "Error! Cannot process request.";
                                        }
                                    }
                                    else
                                    {
                                    header("Location: form_service_order.php");
                                    }
                                }
                                else
                                {
                                    header("Location: form_service_order.php");
                                }
                            }
                            else
                            {
                                header("Location: form_service_order.php");
                            }
                        }
                        else
                        {
                            header("Location: form_service_order.php");
                        }
                    }
                    else
                    {
                    header("Location: form_service_order.php");
                    }
                }
            }
            else
            {
            header("Location: form_service_order.php");
            }
        }
        else
        {
            header("Location: form_service_order.php");
        }
    }
}
?>

[Atli]

Hi.

Try adding the die() function after your mysql_query() calls. Like so:

mysql_query("SELECT * FROM tbl") or die("Query failed: ". mysql_error());
 

This will print any SQL error.

You could also get rid of those if statements by using arrays. Somewhat like this:

$fieldValues = array("value1", "", "value3", "");
 
foreach($fieldValues as $value) {
  if(!empty($value)) {
    mysql_query("INSERT INTO tbl(fieldName) VALUES('$value')");
  }
}
 

[backups2007]

Hi.

Try adding the die() function after your mysql_query() calls. Like so:

mysql_query("SELECT * FROM tbl") or die("Query failed: ". mysql_error());
 

This will print any SQL error.

You could also get rid of those if statements by using arrays. Somewhat like this:

$fieldValues = array("value1", "", "value3", "");
 
foreach($fieldValues as $value) {
  if(!empty($value)) {
    mysql_query("INSERT INTO tbl(fieldName) VALUES('$value')");
  }
}
 

Your first suggestion did not work. For some reason, it still redirected to blank page.

As for your second suggestion, I can't use it. Because I placed a condition that validates the fields. If it is empty, the row of data will be skipped.

[Markus]

Your first suggestion did not work. For some reason, it still redirected to blank page.

As for your second suggestion, I can't use it. Because I placed a condition that validates the fields. If it is empty, the row of data will be skipped.

What Atli wanted was some more information. Information, that if we're going to help, we need.

So do what he said, add the

 
or die (mysql_error());
 
 

After your mysql queries.

And then it should return errors.

AND then we can help :)

Also, it's possible that this code isn't the problem - show the code for form_service_order.php

Thanks.