Underligt - Mysql_fetch_array.
Hej alle.ja,nu har jeg et problem med mysql_fetch_array.
besked_fejl:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/xxxxx.dk/public_html/x.php on line 44
--------------------
$host = "xxxxx";
$use = "xxxxxx";
$pass = "xxxxx";
$db_name = "xxxxx";
$tbl_name = "nyhed";
mysql_connect("$host", "$use", "$pass")or die("ingen forbindelse");
mysql_select_db("$db_name")or die("ingen DB");
$sql = "SELECT * FROM tbl_name ORDER BY id DESC";
$result=mysql_query($sql);
?>
<body>
<table width="100%" border="1" cellspacing="0">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>
<p><?php do { ?></p>
<table width="100%" border="1" cellspacing="0">
<tr>
<td><? echo $rows['titel']; ?></td>
</tr>
<tr>
<td><? echo $rows['name']; ?></td>
</tr>
<tr>
<td><? echo $rows['text']; ?></td>
</tr>
</table>
<?php }
while($rows=mysql_fetch_array($result));
?></td>
</tr>
</table>
</body>
</html>
<?php mysql_close(); ?>
Mvh Ole
