MySql help

[Stu]

Hey all.
At the moment i'm trying to make a script that posts news, and saves the data on a mysql db.
basically, i need to know how to use a form to submit infomation into a database. And also, a good method for creating Mysql tables without using a tool like phpMyAdmin.
Any surgestions?
- Thanks guys & gals

[Lakie]

whatever you gave the form in the name field is what you can use,

If ($_POST['postnews'])
{
$newsbody = $_POST["newsbody"]
$newstext = $_POST["newstext"];

//add to mysql manipulate the data as needed etc etc
}

In this case the form name was postnews and the fieldnames were newsbody and newstext.

As for the table a way is to just use a mysql query

mysql_query("CREATE TABLE tablename (all column details here);

[JonM]

if your confused totally on how to insert data from forms:


mysql_query("INSERT INTO db ('dbvalue','dbvalue','dbvalue') VALUES ('$form','$form','$form')");

or some times you'll get a error with that so u neeed to go

mysql_query("INSERT INTO db('$form','$form','$form')"); -- it skips picking the column or row or whatever it's called and what order the data will be inserted in , and instead just inserts the data into it 1 by 1 so if id was first the the first $form would go in it.

[Stu]

thnx guys, that helped alot
- Warm regards

[Lakie]

My Post above
If ($_POST['postnews'])
{
$newsbody = $_POST["newsbody"]
$newstext = $_POST["newstext"];

//add to mysql manipulate the data as needed etc etc
}

error in there, there should be a ; at the end of the $newsbody line.

[Stu]

Oh lol, i'm glad i didn't use exactly that, i'll show u the script as soon as it is finished