VinceGledhill

Thanks guys. I now have a database I have found elsewhere how to connect to the DB and have the following code. <?php // open connection to mysql server // dbc is a variable $dbc = mysql_connect ('localhost','airfield_data','mypassword'); if (!dbc){ die("not connected :" . mysql_error()); } // select the database $db_selected = mysql_select_db ("airfield_data",$dbc); if (!db_selected) { die ("cant connect :" . mysql_error()); } // test $query="UPDATE "; ?> So my question is now how to write the submission script? If someone could please give me the code to add my data to the database (only one I'll do the rest obviously)

Brilliant, thanks for that. I've started to build the DB and I've got an error message like so. Any ideas what I should do? [attachment deleted by admin]

At the moment the user puts it in via this form.http://www.microlight.co/index.php/New-Airfield I then take the information (from an e-mail that the form sends to me) and edit the card (HTML table) like in this page http://www.microlight.co/index.php/billaricay

Hi Litebearer. Thank you for your input. The new database is bare at the moment. There are no tables whatsoever in there. This is the data I get back from the current form... ***************************** start quoted form returns ************************** Your Name : trevor Airfield Name : Billericay / Napps Field Height Above Sea Level : 200 ft General Location : 2 miles North of Billericay Co-Ordinates : N 51.29.25 E 0.25.10 Prior Permission Required : Yes Alternative Airfield : Laindon Air Ground Radio : No Radio Frequency : use safety comm Runways : 08 / 26 600m Circuits : To the South of the airstrip Remarks : runway dips to the western end no faciliies and no fuel etc. Airfiled used to be known as Brocks Farm and now appears on CAA maps as Napps field Warnings : 08 departure please turn right 26 landing angled approach in to avoid houses. Operating Hours : sr to ss Airfield Operator and Contact Details : Bob Napp 01277-840287 07968-861592 Landing Fee : see bob **************************** end quoted form returns ************************** So from that I guess that my table should be "named" and the number of fields should be 16? I won't do anything with that until someone says that it's right. [attachment deleted by admin]

Hi Nomadsoul. Thank you for your offer of help. I have set up a new database and have phpMyAdmin 3.3.3 installed on my system. Please be gentle with me, I've not used it before ever.

Hello people. I am very new to PHP and have a website for microlight pilots where you can add an airfield. It is a Joomla based site and the input form can be seen here. http://microlight.co/index.php/New-Airfield I am quite prepared to re-write the whole input form again if I have to. Now here's my question. I would like the output of the form to be in an HTML table like it is on this page http://microlight.co/index.php/billaricay This is because at the moment people fill out the form, I get an e-mail with the info, and then have to put it into the airfield card manually myself. Sorry, If my explanation isn't very clear. But basically want users input into a table.