Hi all ,
I'm back with another Q.
First going to explain my problem a bit.
I am making a website for a company , nothing fancy , the company just wanted a frameset , standard html page's and some buttons . No problem until they came up wirh another page that needs an update every week
So I was thinking to do it by PHP and a mysql server.
I do this with a standard form that parses the data to a PHP script and that puts the data in Mysql .
Everything seem to run fine , I am NOT getting an error but .... When I enter data into the form and submit it to the PHP script it says to me
"data insert OK , next please
" so everything is fine , I think !?!
When I do a look-up into the database no data seems to be inserted , however , there is a new record added to the table ??? I think the data is not getting parsed out of the form into the PHP , so the PHP can't submit the data into the database .
Here is the code from the FORM and from the script .
<HEAD><TITLE>INSERT Data via PHP</TITLE></HEAD><BODY>
<FORM action="insert.php" method="get">
<input type="text" size="20" name="promo">
<input type="text" name="datum">
<input type="submit" value="Submit to insert.php">
<TITLE>INSERT Data via PHP</TITLE>
('Kan geen verbinding maken met de database server');
$db = mysql_select_db('bac', $connection)
("Kan database niet vinden.");
#MYSQL INSERT STATEMENT
$sql = "INSERT INTO
$sql_result = mysql_query($sql,$connection)
('Kan data niet inbrengen in de server , contacteer de beheerder');
#PUBLISH OK MESSAGE
echo('Data insert OK , next please
If someone can help me with this problem I would really appreciate that ...
distro RH 8.0
And sorry about the typo's