Hello everybody,
I've got this problem:
I've got a form to update records of a Mysql database with many tables.
There's a <select> to select the table, and a <textarea> to enter text.
I'm using the same method as always to insert data:
$db=mysql_connect($server,$login,$pass);
mysql_select_db($bbdd,$db);
$today_date=date("Y-m-d");
$sql= "INSERT INTO ".$table." VALUES (NULL,'$today_date','$new)";
mysql_query($sql);
When I finally submit my query, I only get the desired result if the table I selected was the first one of the database. I mean from the top to the bottom (looking at the mysql-front interface).
What can I do to get results by selecting any table, not just the first one??
I hope you understood me....
ThanX!!!!