query

mysql_query("SELECT * FROM shop_items ORDER BY
                                id WHERE zichtbaar ==1");

Error

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in

Wie weet wat er fout is?

De Dus:

mysql_query("SELECT * FROM shop_items ORDER BY
                                id WHERE zichtbaar == 1");

== vervangen door = in je query

dankjullie bijde. weet iemand wat hier fout is

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] =<[/COLOR] [COLOR= #0000BB]500[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]straatrat[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]501[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] =<[/COLOR] [COLOR= #0000BB]1500[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]kruimeldief[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]1501[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] =<[/COLOR] [COLOR= #0000BB]3100[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]3101[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] =<[/COLOR] [COLOR= #0000BB]1500[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]huurmoordenaar[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]3101[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] =<[/COLOR] [COLOR= #0000BB]4500[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700];
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]Maffia[/COLOR][COLOR= #007700];
}[/COLOR]
?>

Doe is elseif ipv if ??

Verander =< in <=

Erik schreef:

Verander =< in <=

nu is bij alles de uitkomst maffia

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] <=[/COLOR] [COLOR= #0000BB]500[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]straatrat[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]501[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] <=[/COLOR] [COLOR= #0000BB]1500[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]kruimeldief[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]1501[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] <=[/COLOR] [COLOR= #0000BB]3100[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]3101[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] <=[/COLOR] [COLOR= #0000BB]1500[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]huurmoordenaar[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]]   >=[/COLOR] [COLOR= #0000BB]3101[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$user_row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ervaring[/COLOR][COLOR= #007700]] <=[/COLOR] [COLOR= #0000BB]4500[/COLOR][COLOR= #007700])){[/COLOR] 
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700];
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$rang[/COLOR] [COLOR= #007700]=[/COLOR][COLOR= #DD0000]Maffia[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$rang[/COLOR][COLOR= #007700];[/COLOR]
?>

Opgelost

Bartv schreef:

Opgelost

Ja dankjewel!