[quote="Mazarini"]A première vue, il manque une parenthèse )[/quote]

Effectivement je ne l'avais pas vu !
[Raaaaaaaah quand on est apprentie et que l'on aime pas le PHP c'est horrible :oops: ]

Merci beaucoup :P

A première vue, il manque une parenthèse )

$connect=mysql_connect("...","...","...") or die("Impossible de se connecter");
mysql_select_db("production", $connect) or die("Impossible de se connecter");

$resultat = mysql_query("SELECT user.company, login, site.street1, site.street2, site.postal_code, site.city, site.latitude, site.longitude FROM user, site WHERE (site.street1 = user.street1) && (site.latitude<='4,1'|| site.latitude>='51,3' || site.longitude<='-5' || site.longitude>='8,1' || site.latitude IS NULL && site.longitude IS NULL ORDER BY user.company ASC LIMIT 45") or die (mysql_error());

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY user.company ASC LIMIT 45' at line 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Bonjour,
Voilà j'ai un problème en soumettant une requête SQL (qui marchait il y a 2 semaines :x )
Voici le début de mon code :
[php]$connect=mysql_connect("...","...","...") or die("Impossible de se connecter");
mysql_select_db("production", $connect) or die("Impossible de se connecter");

$resultat = mysql_query("SELECT user.company, login, site.street1, site.street2, site.postal_code, site.city, site.latitude, site.longitude FROM user, site WHERE (site.street1 = user.street1) && (site.latitude<='4,1'|| site.latitude>='51,3' || site.longitude<='-5' || site.longitude>='8,1' || site.latitude IS NULL && site.longitude IS NULL ORDER BY user.company ASC LIMIT 45") or die (mysql_error());[/php]

Mais quand je lance il m'affiche cette erreur :
[php]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY user.company ASC LIMIT 45' at line 1[/php]

J'ai essayé de supprimer ORDER BY et LIMIT mais cela me remet :
[php]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1[/php]

Auriez-vous une idée ? :oops: