forms and validation

coalduststar

i'm currently doing a registration form that writes to myPHP database.
It updates grand but it makes an empty entry in the database as well-= this is starting to fry my head so if anyone could help it'd be pretty good

<?php

//update database

mysql_connect ('online.ulst.ac.uk', 'ltsn','ics' );
mysql_select_db (ltsn);
mysql_query ("INSERT INTO italics (title, name, sname, pos, dept, inst, address, city, country, postcode, phone, fax, email, url, teach_area, review_paper, mail_list, comp_sci, ILS, edu_dev) VALUES ('$title', '$name', '$sname', '$pos', '$dept', '$inst', '$address', '$city', '$country', '$postcode', '$phone', '$fax', '$email', '$url', '$teach_area', '$review_paper', '$mail_list', '$comp_sci', '$ILS', '$edu_dev') ");

?>

Richardtagger

coalduststar

cheers man, thank you very much- just curious tho, is there an obvious problem with the way i'm doing things? the form posts to itself:

Just don't want to poach your code- thanks again

Richardtagger

coalduststar

thanks!

coalduststar

back again- i'm grasping the concept but i don't have enough knowledge of the functions and process to know how it works!

I'm now getting this
Fatal error: Cannot redeclare is_valid_email() (previously declared in /web2/ltsn-ics/pub/italics/register.php:54) in /web2/ltsn-ics/pub/italics/register.php on line 54)

I've tried to do as much of this myself as possible but i'm confused as to what way I should be doing this. Right now I have an HTML form posting to a PHP file which is supposed to update the database, return an error (with the form and variables attached) or send up a thanks screen.

Right now if it's not entering blank entries into the database it's just not working at all. I'm not quite sure what the include line in the example i was given does especially when my form is in an HTML file.

sending out an SOS 😕
If i could even get some pointers that would be great! I've attached the PHP file if anyone's looking for a laugh!!

coalduststar

sorry here's the attachment