Vous n'êtes pas identifié(e).
Pages : 1
Bonjour,
Apres avoir réalisé mon code de $srch :
j'ai une erreur voici le message:
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 'ORDRE BY tbl_nav.nav_id,tbl_pages.pg_link ASC' at line 3
et voici mon code :
mysql_select_db($database_connexions, $connexions);
if(isset($_GET['frmsch']) && $_GET['frmsch'] != ' ') {
$srch = $_GET['frmsch'];
$query_rsPages = "SELECT tbl_pages.pg_id,tbl_pages.pg_link,tbl_nav.nav_name FROM tbl_admins,
tbl_pages,tbl_nav WHERE tbl_pages.pg_nav = tbl_nav.nav_id AND (tbl_pages.pg_link LIKE '%srch%' OR tbl_pages.pg_cont LIKE
'%srch%' OR tbl_pages.pg_title LIKE '%srch%') ORDRE BY tbl_nav.nav_id,tbl_pages.pg_link ASC" ;
} else {
$query_rsPages = "SELECT tbl_pages.pg_id, tbl_pages.pg_link, tbl_nav.nav_name FROM tbl_admins,tbl_pages, tbl_nav WHERE tbl_pages.pg_nav = tbl_nav.nav_id ORDER BY tbl_nav.nav_id, tbl_pages.pg_link ASC";
}
$rsPages = mysql_query($query_rsPages, $connexions) or die(mysql_error());
$row_rsPages = mysql_fetch_assoc($rsPages);
$totalRows_rsPages = mysql_num_rows($rsPages);
Merci de votre aide
Pages : 1