Re:Article on Storing Checkbox Data

[Anon]

Using the PHP Article on Storing Checkbox Data in a Database, I Have tried unsucessfully to accomplish the same functions using the script below:

<?php

if ($submit) {

$db = mysql_connect("", "", "");

mysql_select_db("",$db);

$sql = "INSERT INTO prospects (visitor_country,visitor_zipcode,visitor_city,visitor_address,visitor_company,visitor_state_province,visitor_telephone,visitor_fax,visitor_email,id)

VALUES ('$visitor_country','$visitor_zipcode','$visitor_city','$visitor_address','$visitor_company','$visitor_state_province','$visitor_telephone','$visitor_fax','$visitor_email','$id')";

$result = mysql_query($sql);

$sql = "INSERT INTO user (visitor_lastname,visitor_firstname,id)

VALUES ('$visitor_lastname','$visitor_firstname','$id')";

$result = mysql_query($sql);

$sql = "INSERT INTO profession (visitor_profession_specified,id)

VALUES ('$visitor_profession_specified','$id')";

$result = mysql_query($sql);

$profession = get_checkbox_labels("const_professions");

function get_checkbox_labels($table_name) {

$arr = array();

$query = "SELECT * FROM $table_name";

$qid = mysql_query($query);

while($row= mysql_fetch_object($qid)) {

		 array_push($arr, $row);
		 }

		 return $arr;
		 }

function insert_profession($uid, $profession) {

purge_lookup("lookup_professions", $uid);

$query = create_checkbox_query($profession, "lookup_professions", $uid);

mysql_query($query);

function purge_lookup($table, $uid) {

							   $q = "DELETE FROM table, WHERE uid= '$uid'";
							   mysql_query($q);
							   		 }

function create_checkbox_query($arr, $table, $uid) {

$q = "INSERT INTO $table (uid, profession_id) VALUES";

foreach ($arr as $check) {
$q .= " ( $uid , $check )" . ",";
}
return substr($q, 0, -1);
}
}
echo "Thank you $visitor_firstname for your interest!\n Your request will be processed within 1-5 business days.";

}else{

// display form
?>

              <form name="inforequest" method="POST" action="<?php echo $PHP_SELF?>">
                <p>LAST NAME:<input type="text" name="visitor_lastname" size="25">
                FIRST NAME:<input type="text" name="visitor_firstname" size="25">
                <p>COMPANY NAME:<input type="text" name="visitor_company" size="39">
                <p>ADDRESS:<input type="text" name="visitor_address" size="48">
                <p>CITY:<input type="text" name="visitor_city" size="20">
                STATE/PROVINCE:<input type="text" name="visitor_state_province" size="20">
                <p>COUNTRY:<input type="text" name="visitor_country" size="20">
                ZIP CODE:<input type="text" name="visitor_zipcode" size="23">
                <p>PHONE:<input type="text" name="visitor_telephone" size="23">
                FAX:<input type="text" name="visitor_fax" size="29">
                <p>E-MAIL:<input type="text" name="visitor_email" size="23">
                <p><font face="arial" size="2"><br>
                <b>PLEASE INDICATE THE FOLLOWING:</b></font></p>
                <p><font face="arial" size="2"><b>Profession:</b></font></p>
                <p><font face="arial" size="2"><input type="checkbox" name="profession[]">Lighting Showroom</font></p>
                <p><font face="arial" size="2"><input type="checkbox" name="profession[]">Designer</font></p>
                <p><font face="arial" size="2"><input type="checkbox" name="profession[]">Architect</font></p>
                <p><font face="arial" size="2"><input type="checkbox" name="profession[]">Electrical Supply Wholesaler</font></p>
                <p><font face="arial" size="2"><input type="checkbox" name="profession[]">Purchasing Agent</font></p>
                <p><font face="arial" size="2"><input type="checkbox" name="profession[]">Sales Representative</font></p>
                <p><font face="arial" size="2"><input type="checkbox" name="profession[]">Other</font></p>

				<b>Please Specify if Your Profession is not Listed</b>
				<p><font face="arial" size="2">PROFESSION:<input type="text" name="visitor_profession_specified" size="48">
                <p><font face="arial" color="red" size="2"><b>REQUESTS CAN
                NOT BE PROCESSED WITHOUT TOTALLY COMPLETED FORM</b></font>

                <p><input type="submit" name="submit" value="Submit" value="Reset">
          </table>



          </FORM>
		  <?php
		  }
		  ?>

Submitting a completed form results in the following fatal error:
Call to undefined function: get_checkbox_labels()

What do I have to do to further define this function?

Any assistance will be appreciated,
Debra