a1 newb pars error.

[ZeroG]

Hi

i get pars error on [ echo '</select>'; ] the last line

can any one help me please ?

<? include "commun/connextion.inc.php"; ?>

<?
$sql="select * from pays";
$resultat=@mysql_db_query($dbname,$sql,$id_link);
echo '<select name="pays">';
echo '<option value="" selected></option>';

while ($rang=mysql_fetch_array($resultat)){

$code=$rang['code'];
$nom=$rang['nom'];
echo '<option value=\"$code\">$nom</option>";
}

echo $sql="select * from pays" <br>
echo $resultat=@mysql_db_query($dbname,$sql,$id_link)<br>
echo $code
echo $nom

echo '</select>';

?>

[cgraz]

You have a lot of errors. Look at this whole chunk of code

1 echo $sql="select * from pays" <br> 
2 echo $resultat=@mysql_db_query($dbname,$sql,$id_link)<br> 
3 echo $code 
4 echo $nom 

I labeled the line numbers for easy referral.

Line 1:
You're using the echo function, yet you're assigning a value to the variable $sql. Do you want to assign a value to $sql or do you want to echo that string? Also, the break at the end of that line is just floating there. Needs to be within quotes. Also no semi-colon to end the call to echo.

Line 2:
Same as above.

Line 3:
Forgot semicolon.

Line 4:
Forgot semi-colon.

Cgraz

[ZeroG]

Tanks you for the information! i have fix a few thig and now it is working even if i dont have any contry in the db yet.

there is one thing i dont understand still

this code go's in a page to register some user.
and i have this line in my code

include "../commun/connexion.inc.php";

then when the page load i have all my form waiting for information to feed the database but with some error message like these down here

Warning: Accès refusé pour l'utilisateur: 'nom_utilisateur@localhost' (mot de passe: OUI) in c:\program files\easyphp\www\commun\connexion.inc.php on line 7

Warning: MySQL Connection Failed: Accès refusé pour l'utilisateur: 'nom_utilisateur@localhost' (mot de passe: OUI) in c:\program files\easyphp\www\commun\connexion.inc.php on line 7

Now the thing is that they have not fill in their acount yet so how could they have a acount yet?

these 2 message are telling me that i dont have acces but the user is 'nom_utilisateur@localhost' and this is the information that i find in connexion.inc.php
and they refer to line 7

so i dont get it right now!

Now the line 7 in my connexion.inc.php file is down here

1 <?php
2 $dbname = 'nom_base';
3 $hostname = 'Localhost';
4 $username = 'nom_utilisateur';
5 $password = 'mot_de_passe';
6
7 $id_link = mysql_connect($hostname, $username,

$password);
8
9 ?>

do i have to change something here or this should be like that.

tanks for helping me again!

[cgraz]

It is most likely a problem with the credentials you are using (username and password). Contact your host with the information and see what they say.

Cgraz

[ZeroG]

lol yes i wich

i am the host right now and im planing on hosting my site!
i just removed the line for now but i im finish up with the user registration form pages.

i think i got mostly every thing right now

i have created a databse called utilisateur
wich is french sor user

and inside ther is de table membres

but when i go trought all my registration form nothing new apear in the databse! i guess im doing something wrong

i have use this this part of code to insert the data from the web page text field to the database!

$sql="INSERT INTO membres
(nom_usage, mot_passe, Date_inscription, question, reponse) VALUES
('$nom_usage', '$mot_passe', '$Date_inscription', '$question', '$reponse' )";

now how does mysql know wich database i whant to use
and am i correct to say that this part of code will actually send data to the database.

these code are part of a book and i have found a few mistake so far but nothing really wrong!

would you have a exemple on how i could ADD
$username to mydb.mytable.usernamefield

[jimson]

u need php manual, download one from www.php.net

to select mysql database
use mysql_select_db()

reffer : http://www.php.net/mysql_select_db