udskriver kun en række fra mysql
HejDen tager kun en række ud af tablen.
som i kan se på dette link http://www.kilimanjaroguide.com/guides.php
hilsen mads
koden herunder:
<?php
$resultat_id = mysql_query(\"SELECT id,text,date FROM guide_page\");
$text_id=mysql_fetch_array($resultat_id);
?>
<center><table width=\"980\">
<tr width=\"980\" height=\"173\">
<td width=\"980\" COLSPAN=\"2\" VALIGN=\"TOP\"><center><h2>Guides</h2></center></td>
</tr>
<?php INCLUDE \"menu.php\" ?>
<td width=\"820\">
<P>
<TABLE width=\"650\">
<TR class=\"text\">
<TD>
<?php Print htmlentities($text_id[text]);?>
</TD>
</TR>
</TABLE>
</p>
<table width=\"800\" border=\"1\">
<tr class=\"overskrift\">
<TD width=\"200\">
Mountain:
</TD>
<TD width=\"200\">
Name of Guide:
</TD>
<TD width=\"100\">
Age:
</TD>
<TD width=\"300\">
Small desc:
</TD>
</TR>
<?PHP
$rs = mysql_query(\"SELECT mount_name FROM mount, guides WHERE mount.id = guides.mount_id\");
$nam = mysql_fetch_array($rs);
$resultat=mysql_query(\"SELECT id,name,age,mount_id,sm_desc FROM guides\");
$new=mysql_fetch_array($resultat);
?>
<TR>
<TD width=\"200\">
<?php
print htmlentities ($nam[0]);
?>
</TD>
<TD width=\"200\">
<?php Print htmlentities($new[name]);?>
</TD>
<TD width=\"100\">
<?php Print htmlentities($new[age]);?>
</TD>
<TD width=\"300\">
<?php Print htmlentities($new[sm_desc]);?>
</TD>
</TR>
</TABLE>
</td>
</tr>
</table></center>
<br/>
<center><table>
<tr class=\"menu\">
<td>
<td>
<?php INCLUDE \"webmaster.php\" ?>
<td>
</td>
</tr>
</table></center>
</BODY>
</HTML>
