[Stormrider]

Hi everyone! I am new here as well as in php... getting the hang of it is a bit... odd but I like it really really much.. So um let's go to my first question

I have a data entry form on my webpage "manager" and what I would like to do is have a list box in it so when I set it to one value the data on the form, on Submit, gets improrted in one certain table in the MySQL DB and when I set it to the other value it gets inbserted elsewhere.

I.e. I have 2 tables in my DB called "links" and "b_links". The have the same number and type of fields. so what I would like to do is have one form that can insert data to the table to tell it to by using the list box, rather than have 2 different forms.

Thabk you in advance!
-Storm

[diamondwolf]

when you hit submit you just want two ifs really

and you check the value of $_POST['linkvalues'] or $_GET['linkvalues'] depending on which value you get from the select box

// so login details
<?php

$link = mysql_connect($server,$username,$password);
mysql_select_db($databasename);
if ($_POST['linkvalues'] == "whatever1")
{
$query = $query = "INSERT INTO links SET field ='".$titlename."',";
}

if ($_POST['linkvalues'] == "whatever2")
{
$query = $query = "INSERT INTO links2 SET field ='".$titlename."',";
}
$result = mysql_query($query);
?>

thats all there is to it

[infinitylimit]

If your listbox supplies the name of the table you could just write you sql query as so

'INSERT INTO '.$_POST['listbox'].'(value1,value2,value3,value4) VALUES ("....'

You follow? List box would be the table name.

[Stormrider]

Yeah I think I do. As I've said, I am new to php so I try to learn alot of things at once which is not so easy heh
In anycase, although I WILL try out what you guys suggested, I have worked my way around my prob by inserting everythig into one instead of two tables, BUT giving the table an extra field which helps me filter out via SQL the records that I want to present on a webpage.

Thx guys!