Aldus hier de script, probeer een query. zodra hij wat vind gaat het mis. bij lege queries en geen resultaten gaat het prima.
http://lynkfm.atlas2wielers.nl/?p=sc_song/search.php
alvast erg bedankt :)
<form style="padding:5px;" name="search_form" action="" method="POST">
<input type="text" name="sq" value="<?=$_POST['sq']?>">
<select name="select">
<option value="artist" <? if($select=="artist") {?> selected="selected" <? }?> >Artist</option>
<option value="title" <? if($select=="title") {?> selected="selected" <? }?>>Title</option>
</select>
<select name="limit">
<option value="">all</option>
<option value="LIMIT 50" <? if($limit=="50") {?> selected="selected" <? }?> >50</option>
<option value="LIMIT 25" <? if($limit=="25") {?> selected="selected" <? }?> >25</option>
</select>
<input type="submit" name="submit" value="search">
</form>
<? if($_SERVER['REQUEST_METHOD']=="POST"){
if(empty($sq)){echo"<div style=\"padding:5px;background-color:coral;\"><b>Your query was empty!</b></div>";}
else { ?>
<div style="padding:10px; color:#999999;">You searched for '<b><?=$sq?></b>'</div>
<? $msq = "SELECT * FROM `lynk_fm` WHERE $select LIKE '%$sq%' ORDER BY id DESC $limit";
$lol = mysql_query($msq);
if (mysql_num_rows(mysql_query($msq)) == 0) {echo "<div style=\"padding:3px;color:#999999;\"><b><i>No results found!</i></b></div>";}
else {
while($results1 = mysql_fetch_object($lol) or die(mysql_error())) { $i++ ?>
<div id="k<?=$i & 1?>" style="padding-bottom:5px;"><?=$results1->artist?> - <?=$results1->title?> </div>
<? }}}} ?>
