AW: [PHP] Query Help Needed

take a look at your table definiton. maybe some of your fields have a diferent definition as the value you want to insert. e.g. fax_number in your query-string is defined as string and in your table as integer or something like this regards martin -----Ursprüngliche Nachricht----- Von: Payzillee [mailto:imm@arts.gla.ac.uk] Gesendet: Donnerstag, 29. November 2001 12:37 An: php-general@lists.php.net Betreff: [PHP] Query Help Needed Hi, could anyone tell me what is wrong with this Insert query? I get an 'Invalid query' error but I can't see the problem at all. All the fields match exactly what is in my database, it's all in lowercase too. Cheers. mysql_query ("INSERT INTO listserve (title, surname, forename, job_title, org_name, address1, address2, address3, address4, city, region, postal_code, country, email, mob_phone, tel_number, fax_number, org_web_address, personal_web_address, special_interests, date, time) VALUES ('$title', '$surname', '$forename', '$job_title', '$org_name', '$address1', '$address2', '$address3', '$address4', '$city', '$region', '$postal_code', '$country', '$email', '$mob_phone', '$tel_number', '$fax_number', '$org_web_address', '$personal_web_address', '$special_interests', '$date','$time')") -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net