Another Unknown column 'sex' in 'field list'

[itxtme]

Hey guys,

This is driving me crazy. I am writing a loop that means the application is scalable. To do that I am making it so a loop will write the DB. I am getting an error below

PHP Code:

Unknown column 'sex' in 'field list' 


The loop that creates the query is

PHP Code:

<?php // START UPDATE FORM
//Get the fields to update via query
$all_output1=""; //set variable so it doesnt force "NOTICE" in loop
$all_output2=""; //set variable so it doesnt force "NOTICE" in loop
if (isset($_POST['submit'])) {

    $result = mysql_query("SELECT field_name FROM child_fields WHERE editible='1'") or die(mysql_error());

        while($row = mysql_fetch_array($result)){

           $safe_variable = make_safe($_POST[$row['field_name']]);
           // Check for null
           if (empty($safe_variable)) {
           $output1 = $row['field_name'].", ";
                         $output2 = "'', ";
           } else {
           $output1 = $row['field_name'].", ";
           $output2 = "'".$safe_variable."', ";
           }
           
           $all_output1 .= $output1;
           $all_output2 .= $output2;           
           

        }
        //trim last comma and space        
        $all_output1 = substr($all_output1,0,-2);
        $all_output2 = substr($all_output2,0,-2);
        
        echo $all_output1."<br>".$all_output2;

I have added the echo to view the output of each, and that looks correct

PHP Code:

first_name, last_name, dob, sex, ethnicity, school, class, medical, doctor, doctor_practice, doctors_phone, swim_ability
'', '', '', 'female', '', '', '122', 'Peanuts', '', '', '', '' 


The fields are null due to testing what will happen if the user doesnt enter information, I want the program to continue not have an sql error.

'sex' is definitely a column. The actual sql query is

  $query = "INSERT INTO caregiver ($all_output1) VALUES ($all_output2)";

I am lost as it appears from the echo that if I place that code in "()" as I have for the query it should run!? Any ideas people?? PS Have tried pasting the code into brackets straight into phpmyadmin and it works!?

[itxtme]

I am a retard -> had called the wrong table. So the error was quite correct, those columns did not exist!

[Old Pedant]

First of all, do the obvious:

echo "<hr/>DEBUG query: " . $query . "<hr/>\n";

What does that show you? Is it what you expect?

Then if it is, make sure that you are right about that field existing in the table.

Try a query such as

DESCRIBE caregiver;

either in phpmyadmin or in a mysql command line.

[Old Pedant]

LOL! Took me too long to answer you. AH, well. There is always next time.

[guelphdad]

By the way an empty string and NULL are not the same thing at all as far as databases are concerned. Just be sure you understand that as if you test for IS NULL you'd have fields that had an empty string in them returned in a database query.

[itxtme]

Thanks guys,

@ guelphdad

I learnt that the hard way! It seems to happen a lot when your new - the hard way thing I mean!