tabel fra Mysql
Hvordan får jeg lavet denne tabel. Der kommer en fejl:Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/web34/html/index3.php on line 24Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/web34/html/index3.php on line 29
Script:<?php
$host = "localhost";
$user = "web34";
$pw = "****";
$database = "usr_web34_1";
mysql_connect($host, $user, $pw) or die("Couldn't connect to mysqldatabase");
mysql_select_db($database) or die("Couldn't connect to database");
$query = @mysql_query("SELECT * FROM Aktiespil") or die(mysql_error());
$resultat=mysql_query($query);
$number=mysql_num_rows($resultat);
echo "<TABLE WIDTH=\"146\" BORDER=\"0\">";
while($row=mysql_fetch_array($resultat))
{
echo "<TR VALIGN='top'>
<TD BGCOLOR='#ECECEC'>
<div CLASS='hvid'>$row[Fri1]<BR>
$row[Fri2]
</div>
</TD>
<TD></TD>
</TR>
<TR VALIGN='top'>
<TD ><div><B>$row[Fri3]</B></DIV></TD>
</TR>
<TR VALIGN='top'>
<TD></TD>
</TR>";
}
echo "</TABLE>";
?>
