Searche Engine

[doudousan]

Hey Guys
Can you tell what the prob with this script is:
MySQL says error at line 34 where "while" statement....

Thanks

<?php
$titre = $GET['titre'];
$anMin = $GET['anMax'];
$anMax = $GET['anMin'];
$comb = $GET['comb'];

echo "<B>Titre= $titre anMin = $anMin anMax= $anMax";

if ($comb == 'ET')
$requete = "SELECT * FROM FilmSimple"
. "WHERE titre LIKE '$titre' "
. "AND annee BETWEEN $anMin and $anMax";

else

$requete = "SELECT * FROM FilmSimple"
. "WHERE titre LIKE '$titre' "
. "OR (annee BETWEEN $anMin and $anMax)";

$connexion = mysql_pconnect (localhost, eq36253, ad52bghj);
mysql_select_db (eq36253, $connexion);

// Exécution et affichage de la requete
$resultat = mysql_query ($requete, $connexion);

while ($film = mysql_fetch_object ($resultat))
{
echo "$film->titre, paru en $film->annee, realise "
. "par $film->prenomMES $film->nomMES.<BR>";
}

?>

[TheDefender]

MySQL says error at line 34 where "while" statement....

What is the exact error you are receiving? It is hard to know how and where to begin to help you with truncated information.

[eli03]

Your giving away your username and password. The username is equal to the database name, is that right?

$connexion = mysql_pconnect (localhost, eq36253, ad52bghj);
mysql_select_db (eq36253, $connexion);

[TheDefender]

Sorry, I missed some of the code since it was not enclosed in the php tags using that little php button...

Going along with eli03, you do need to make sure you enclose literal values in your $connexion variable in quotes.

$connexion = mysql_pconnect ("localhost", "eq36253", "ad52bghj"); 
mysql_select_db ("eq36253", $connexion);