Problem med mysql_fetch_array
Hello der...Jeg får en fejl på linien: while($data = mysql_fetch_array($foresp)){
- hvad kan jeg gøre for at den ikke kommer?
Koden er her nedenunder...
På forhånd tak for hjælpen,
/dhunters
<?php
echo "<p class='overskrift'>$_GET[page]</p>";
?>
<?php
$db = mysql_connect("","","")or die("Der var en MySQL fejl: " . mysql_error());
mysql_select_db("",$db)or die("Der var en MySQL fejl: " . mysql_error());
$foresp = mysql_query("SELECT billede, land, dato, navn, procent, literpris, type, pris-daniel, design-daniel, farve-daniel, aroma-daniel, konsistens-daniel, smag-daniel, duft-daniel, skum-daniel, pris-casper, design-casper, farve-casper, aroma-casper, konsistens-casper, smag-casper, duft-casper, skum-casper, pris-jess, design-jess, farve-jess, aroma-jess, konsistens-jess, smag-jess, duft-jess, skum-jess, pris-kreen, design-kreen, farve-kreen, aroma-kreen, konsistens-kreen, smag-kreen, duft-kreen, skum-kreen, pris-jens, design-jens, farve-jens, aroma-jens, konsistens-jens, smag-jens, duft-jens, skum-jens FROM smagninger WHERE id=$_GET[id]");
while($data = mysql_fetch_array($foresp)){
echo "<table>";
echo "<tr>";
echo "<td align='left' valign='top'>$data[0]</td>";
echo "<td align='left' valign='top'><p><b>Smagsdato:</b> $data[2]<br><b>Land:</b> $data[1]<br><b>Navn:</b>$data[3]<br><b>Alkoholprocent:</b>$data[4]<br><b>Literpris:</b>$data[5]<br><b>Type:</b>$data[6]</p></td>";
echo "</tr>";
echo "<tr><td>";
echo "<table width='70%' border='0'>
<tr>
<td> </td>
<td><p><b>Fadbamsen [ Daniel ]</b></p></td>
<td><p><b>Stjernen [ Casper ]</b></p></td>
<td><p><b>Stella [ Jess ]</b></p></td>
<td><p><b>Corona [ Kreen ]</b></p></td>
<td><p><b>Keizer Karel [ Jens ]</b></p></td>
</tr>
<tr>
<td><p><b>Pris:</b></p></td>
<td><p>$data[7]</p></td>
<td><p>$data[15]</p></td>
<td><p>$data[23]</p></td>
<td><p>$data[31]</p></td>
<td><p>$data[39]</p></td>
</tr>
<tr>
<td><p><b>Design:</b></p></td>
<td><p>$data[8]</p></td>
<td><p>$data[16]</p></td>
<td><p>$data[24]</p></td>
<td><p>$data[32]</p></td>
<td><p>$data[40]</p></td>
</tr>
<tr>
<td><p><b>Farve:</b></p></td>
<td><p>$data[9]</p></td>
<td><p>$data[17]</p></td>
<td><p>$data[25]</p></td>
<td><p>$data[33]</p></td>
<td><p>$data[41]</p></td>
</tr>
<tr>
<td><p><b>Aroma:</b></p></td>
<td><p>$data[10]</p></td>
<td><p>$data[18]</p></td>
<td><p>$data[26]</p></td>
<td><p>$data[34]</p></td>
<td><p>$data[42]</p></td>
</tr>
<tr>
<td><p><b>Konsistens:</b></p></td>
<td><p>$data[11]</p></td>
<td><p>$data[19]</p></td>
<td><p>$data[27]</p></td>
<td><p>$data[35]</p></td>
<td><p>$data[43]</p></td>
</tr>
<tr>
<td><p><b>Smag:</b></p></td>
<td><p>$data[12]</p></td>
<td><p>$data[20]</p></td>
<td><p>$data[28]</p></td>
<td><p>$data[36]</p></td>
<td><p>$data[44]</p></td>
</tr>
<tr>
<td><p><b>Duft:</b></p></td>
<td><p>$data[13]</p></td>
<td><p>$data[21]</p></td>
<td><p>$data[29]</p></td>
<td><p>$data[37]</p></td>
<td><p>$data[45]</p></td>
</tr>
<tr>
<td><p><b>Skum:</b></p></td>
<td><p>$data[14]</p></td>
<td><p>$data[22]</p></td>
<td><p>$data[30]</p></td>
<td><p>$data[38]</p></td>
<td><p>$data[46]</p></td>
</tr>
</table>";
echo "</td></tr>";
echo "</table>";
}
?>
