"; echo "
"; mysql_connect("$hostname", "$user", "$password"); $result = mysql("services","SELECT * FROM organization"); echo "
| UID | Service Provider | Phone Number |
| \n"; echo mysql_result($result,$counter,uid); echo " | \n"; echo ""; echo mysql_result($result,$counter,org); echo "\n"; echo " | \n"; echo "\n"; echo mysql_result($result,$counter, phone); echo " | \n"; $counter = $counter + 1; } echo "
\n"; echo "
\n"; } Function Insert_Record () { global $state, $org, $email, $phone, $fax, $address1, $address2, $URL, $uid; mysql_connect("luna","maggot","fzr400dead"); $result = mysql("services","SELECT now()"); $now = mysql_result($result,0,"now()"); $result = mysql("services","INSERT INTO organization (org,phone, fax, email, address_1, address_2, URL) VALUES ('$org', '$phone', '$fax', '$email', '$address1', '$address2', '$URL')"); $new_uid = mysql_insert_id(); $result = mysql("services","INSERT INTO service (uid, entry_date, service) VALUES ('$new_uid', '$now', '$service')"); $state = Show_Record; }; /* Function Print_Contact (){ mysql_connect("luna","maggot","fzr400dead"); $result = mysql("services","SELECT * FROM contacts WHERE uid = $uid"); $name = mysql_result($result,1,"first_name"); $name = $name . " " . mysql_result($result,0,"last_name"); echo ""; echo ""; echo "
"; echo "
| Name | "; echo "$name |
| Phone | "; echo ""; echo mysql_result($result,0,"phone"); echo " |
| Fax | "; echo ""; echo mysql_result($result,0,"fax"); echo " |
| Email Address | "; echo "$email"; echo " |
"; echo "
"; $result = mysql("services","SELECT * FROM comment WHERE uid = $uid ORDER BY contact_date"); $total_rows = mysql_numrows($result); $counter = 0; echo "
| Date | Comment | "; while($counter < $total_rows) { echo "
| "; echo mysql_result($result,$counter,"contact_date"); echo " | "; echo mysql_result($result,$counter,"contact_comment"); echo " |
"; echo "
Add new comment below."; echo "
"; echo "
\n"; } */ /* The main loop. Call functions based on the value of $state, which gets set via a hidden INPUT TYPE. */ switch($state) { case ""; start_page(); break; case "list"; Show_Table(); break; case "create"; Empty_Form(); break; case "insert"; Insert_Record (); break; case "edit"; Show_Table(); break; case "fullrecord"; Show_Full_Record(); break; Show_in_Form($state, $uid); break; case "search"; break; } ?>