how to insert data into mysql base from a web page

pollux1er

I wrote a code to insert data from a web page. Not a formula. But an error occured. this is the code:

<?php
// Connecxion a la base
$base = mysql_connect('imysql03', 'i4143424', '5h173e2mu5nkooqp');
mysql_select_db('i4143424', $base);
?>

<html>
<head>
<title>Insertion dans la base</title>
</head>
<body>
<?php
// lancement de la requete
$sql = "INSERT INTO inscription_newsletter VALUES('', 'MAX', 'BOSSADI', 'max_bossadi@yahoo.fr')";

mysql_query($sql) or die ('Erreur SQL!'.$sql.'<br>'.mysql_error());

mysql_close();
?>
Max vient d'etre insere dans la base.
</body>
</html>

please hel me to know where is the mistake.
The eror reurned is this:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING

Philip

ussualy that because theere is not close tag ;

try to replace this one first for testing Smile

it must be work ok Smile

$base = mysql_connect('imysql03', 'i4143424', '5h173e2mu5nkooqp');
$db=mysql_select_db('i4143424', $base);
$sql="select * from table";
mysql_query($sql) with mysql_query($sql,$db);
close($db);

pollux1er

it still doesn't work! the error is now at this line

mysql_query($sql) with mysql_query($sql,$db);

hexkid

pollux1er

ok i'll try it and tehen i'll tell you the result!

insert data to mySQL database problem
cannot add data to mysql from PHP form
Data Mining From tables and then insert into MySQL
A very good PHP MySQL Tutorial
importing data from phpbb to smf

get data from mySQL
How to Make A PHP Portal.
Simple Question
how to simplify these codes?
learning MySQL

[PHP] phpbb registration - add to other db
phpBB errors when people sign up
php-mysql source code
A variable number of inputs for PHP to insert MYSQL
Build an online dictionary by PHP/MySQL