September 7th, 2003, 06:40 PM
|
|
Contributing User
|
|
Join Date: Jun 2003
Posts: 72
Time spent in forums: 11 m 36 sec
Reputation Power: 6
|
|
|
Something wrong with PHP loop code
Whats wrong...?
PHP Code:
<?
include ('forum_db.php');
$DB = mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "select * from forum_category order by category_id";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$cat_title=mysql_result($result,$i,"title");
$cat_id=mysql_result($result,$i,"category_id");
?><b><u><?=$title?></u></B><br><?
$query2 = "select section_id, title, description from forum_sections where category_id = $cat_id";
$result2=mysql_query($query2);
$num2 = mysql_numrows($result2);
$m=0;
while ($m < $num2) {
$sec_id=mysql_result($result2,$m,"section_id");
$sec_title=mysql_result($result2,$m,"title");
$sec_description=mysql_result($result2,$m,"description");
?>
<?=$sec_title?><br>
<?=$sec_description?><br>
<?
++$m;
}
?><br><?
++$i;
}
?>
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
