Pagina 1 van 1
te drukken sql?
Geplaatst: 14 mar 2006, 22:49
door supperbas
Code: Selecteer alles
$query = mysql_query ( "SELECT * FROM sb_portal WHERE portal = 'stick' AND year = '".$year."' AND banned != 'yes' AND week1 = '".$week."' OR week2 = '".$week."'OR week3 = '".$week."'OR week4 = '".$week."' ORDER BY rating DESC LIMIT 0,25" );
$i = 1;
while ( $portal = mysql_fetch_array($query) )
{
De query is te druik lijkt mij want hij doed niet alles wat ik denk op geven te hebben (dus met and and or or etc)
hoe krijg ik dit goed?
BVD,
-supperbas :thumb:
Geplaatst: 14 mar 2006, 22:51
door Paul
Code: Selecteer alles
$query = mysql_query ( "SELECT * FROM sb_portal WHERE portal = 'stick' AND year = '".$year."' AND banned != 'yes' AND (week1 = '".$week."' OR week2 = '".$week."'OR week3 = '".$week."'OR week4 = '".$week."') ORDER BY rating DESC LIMIT 0,25" );
Moet werken denk ik.
Geplaatst: 15 mar 2006, 07:48
door supperbas
ty