Help with php

[kwnocree 1]

Hi i created a php code but it is maybe wrong....

The Subcategory name it is displaying 2 times..

Php Code:

$catssql = "SELECT * FROM cats1";
$result2 = mysql_query($catssql);

echo '<table width="800" class="productstable" align="center">';
while($cats1row = mysql_fetch_assoc($result2))
{
echo '<tr><td><b>'. $cats1row['cat_nm'].'</b></td></tr>';
$ctid = $cats1row['id'];
$catsoncat = "SELECT * FROM categories,cats1 WHERE categories.catid = $ctid";
$result3 = mysql_query($catsoncat);
while($catsoncatrow = mysql_fetch_assoc($result3))
{
echo '<tr><td>'.$catsoncatrow['cat_name'].'</td></tr>';
}
}
echo '</table>';

If anyone knows how to fix it help please

[dethdeks 2]

check your sql to make sure that its reading properly the only thing that i can see is maybe put a } before the second while statement. HTH

[kwnocree 1]

No...i have it because if i close this tag before the second while it will not display categories and subcategories at the same box

[dethdeks 2]

only thing i can think is possibly check your mysql DB and see if it had inserted twice

[kwnocree 1]

No ...i checked :/

[tariq1 1]

Dear You code is nice, Please check again, or can use a Counter as follows to protect duplication

 

$catssql = "SELECT * FROM cats1";

$result2 = mysql_query($catssql);

$i= 0;

echo '<table width="800" class="productstable" align="center">';

while($cats1row = mysql_fetch_assoc($result2))

{

echo '<tr><td><b>'. $cats1row['cat_nm'].'</b></td></tr>';

$ctid = $cats1row['id'];

$catsoncat = "SELECT * FROM categories,cats1 WHERE categories.catid = $ctid";

$result3 = mysql_query($catsoncat);

while($catsoncatrow = mysql_fetch_assoc($result3))

{

echo '<tr><td>'.$catsoncatrow['cat_name'].'</td></tr>';

}

$i++;

}

 

echo '</table>';

 

or see the post to know more

http://www.blog.pennybackshop.com/fetching-mysql-data-in-proper-way.html

 

 

 CP Moderator Message: Link Coded - Tech425

[CyberAbc 290]

u may use phpmyadmin in gui mode to track ur error ......

[kwnocree 1]

Thnx solved

[7soon 0]

check ur 1st sql

$catssql = "SELECT * FROM cats1";

 

u have to add where clause to fetch the main cats only =)