Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
php mysql how do i jump to a specific row?
- Thread starter ksoong
- Start date
Here's an example, hopefully you know enough PHP/MySQL to fit this to your personal needs:
<HTML>
<HEAD>
<TITLE>News Page</TITLE>
</HEAD>
<BODY>
<?PHP
$getallnews=mysql("dbname","select * from newstable order by date desc"
;
for($i=0;$i<3;$i++)
{
$newstitle=mysql_result($getallnews,$i,"title"
$newsbody=mysql_result($getallnews,$i,"body"
echo "
<H3>$newstitle</H3>
<BR>$newsbody<P>
";
}
?>
</BODY>
</HTML>
If this confuses you, feel free to ask.
<HTML>
<HEAD>
<TITLE>News Page</TITLE>
</HEAD>
<BODY>
<?PHP
$getallnews=mysql("dbname","select * from newstable order by date desc"
;for($i=0;$i<3;$i++)
{
$newstitle=mysql_result($getallnews,$i,"title"
;$newsbody=mysql_result($getallnews,$i,"body"
;echo "
<H3>$newstitle</H3>
<BR>$newsbody<P>
";
}
?>
</BODY>
</HTML>
If this confuses you, feel free to ask.
- Status
