php/database - while sætning
Jeg har problemer med at få hentet noget ud af min databse, den vil ikke acceptere min while sætning, kan nogen mon hjælpe?Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/eksplicit.dk/public_html/dkdating 2/soeg_resultat.php on line 39
Her er noget af koden det drejer sig om, linie 39 er while sætningen:
--------------------------------------------------------------
$sql = "select * from users WHERE aktiv = 'ja' AND sex like '%" & $sex & "%' AND kropsbygning LIKE '%" & $kb & "%' AND haircolor LIKE '%" & $haircolor & "%' AND nationalitet LIKE '%" & $nationalitet & "%' AND civilstand LIKE '%" & $civilstand & "%' AND handicap1 LIKE '%" & $handicap & "%' AND kids LIKE '%" & $kids & "%' AND rygning LIKE '%" & $rygning & "%' AND areacode LIKE '%" & $area & "%')";
$query = mysql_query($sql,$mydb);
while ($raekke=mysql_fetch_array($query))
{
?>
<table cellspacing="0" cellpadding="0" border="1" bordercolor="#c1c1c1">
<td>
<table cellspacing="0" cellpadding="0" border="1" bordercolor="#227CC6">
<tr height="17">
<td bgcolor="white" width="90" height="17"><b> Profilnavn:</b></td>
<td bgcolor="white" width="90" height="17"><b><?php echo $raekke[brugernavn];?></b></td>
<td bgcolor="white" width="30" height="17"></td>
<td bgcolor="white" width="139" hei
