[php+mysql] Ввывод данных с базы

[Muntik]

_www.23board.ru


Хотелось бы что бы саб-категории были тоже линками и полностью выводились. (прим. _www.1post.ru)

<?
dbc();
$bsel_an=mysql_query("SELECT count(*) FROM ". $db_prefix ."categories where parent=0 and status=1");
while($an=mysql_fetch_array($bsel_an)) {
$it=$an["count(*)"]; }
$td=($it/2);

echo "<table width=100%><tr><td width=50% valign=top>";
$sel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent=0 and status=1 limit 0,$td");
while($an=mysql_fetch_array($sel_an)) {
$id=$an["id"];
$altname=$an["altname"];
$catname=$an["catname"];
echo "<li style='line-height: 15px; color: #BF270C;'><a href=/s/$altname><b>$catname</b></a>";

echo "</li><br>";
$asel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent='$id' and status=1 limit 0,3");
while($an=mysql_fetch_array($asel_an)) {
$cid=$an["id"];
$subcataltname=$an["altname"];
$subcatname=$an["catname"];
echo "<font color=black>$subcatname, ";}
echo "...</font><br><br>";

}

echo "</td><td width=50% valign=top>";

$zsel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent=0 and status=1 limit $td,$it");
while($an=mysql_fetch_array($zsel_an)) {
$zid=$an["id"];
$zaltname=$an["altname"];
$zcatname=$an["catname"];
echo "<li style='line-height: 15px; color: #BF270C;'><a href=/s/$zaltname><b>$zcatname</b></a>";

echo "</li><br>";
$zasel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent='$zid' and status=1 limit 0,3");
while($an=mysql_fetch_array($zasel_an)) {
$zcid=$an["id"];
$zsubcataltname=$an["altname"];
$zsubcatname=$an["catname"];
echo "<font color=black>$zsubcatname, ";}
echo "...</font><br><br>";
}

 

[Jeurey]

Ну и кто полезет разбираться в вашем движке? Вам в заказ услуг, имхо :-/

 

[denover]

Попробуй это. Поменял 2 строчки в конце.

<?
dbc();
$bsel_an=mysql_query("SELECT count(*) FROM ". $db_prefix ."categories where parent=0 and status=1");
while($an=mysql_fetch_array($bsel_an)) {
$it=$an["count(*)"]; }
$td=($it/2);

echo "<table width=100%><tr><td width=50% valign=top>";
$sel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent=0 and status=1 limit 0,$td");
while($an=mysql_fetch_array($sel_an)) {
$id=$an["id"];
$altname=$an["altname"];
$catname=$an["catname"];
echo "<li style='line-height: 15px; color: #BF270C;'><a href=/s/$altname><b>$catname</b></a>";

echo "</li><br>";
$asel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent='$id' and status=1 limit 0,3");
while($an=mysql_fetch_array($asel_an)) {
$cid=$an["id"];
$subcataltname=$an["altname"];
$subcatname=$an["catname"];
echo "<font color=black>$subcatname, ";}
echo "...</font><br><br>";

}

echo "</td><td width=50% valign=top>";

$zsel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent=0 and status=1 limit $td,$it");
while($an=mysql_fetch_array($zsel_an)) {
$zid=$an["id"];
$zaltname=$an["altname"];
$zcatname=$an["catname"];
echo "<li style='line-height: 15px; color: #BF270C;'><a href=/s/$zaltname><b>$zcatname</b></a>";

echo "</li><br>";
$zasel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent='$zid' and status=1 limit 0,3");
while($an=mysql_fetch_array($zasel_an)) {
$zcid=$an["id"];
$zsubcataltname=$an["altname"];
$zsubcatname=$an["catname"];
//echo "<font color=black>$zsubcatname, ";
echo "<a href=/r/$zcid>$zsubcatname</a>, ";
}
//echo "...</font><br><br>";
echo "...<br><br>";
}

 

[Muntik]

Помогло вот только сабкатигории выводятся не все(

 

[denover]

Так будут все выводится

<?
dbc();
$bsel_an=mysql_query("SELECT count(*) FROM ". $db_prefix ."categories where parent=0 and status=1");
while($an=mysql_fetch_array($bsel_an)) {
$it=$an["count(*)"]; }
$td=($it/2);

echo "<table width=100%><tr><td width=50% valign=top>";
$sel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent=0 and status=1 limit 0,$td");
while($an=mysql_fetch_array($sel_an)) {
$id=$an["id"];
$altname=$an["altname"];
$catname=$an["catname"];
echo "<li style='line-height: 15px; color: #BF270C;'><a href=/s/$altname><b>$catname</b></a>";

echo "</li><br>";
$asel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent='$id' and status=1 limit 0,3");
while($an=mysql_fetch_array($asel_an)) {
$cid=$an["id"];
$subcataltname=$an["altname"];
$subcatname=$an["catname"];
echo "<font color=black>$subcatname, ";}
echo "...</font><br><br>";

}

echo "</td><td width=50% valign=top>";

$zsel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent=0 and status=1 limit $td,$it");
while($an=mysql_fetch_array($zsel_an)) {
$zid=$an["id"];
$zaltname=$an["altname"];
$zcatname=$an["catname"];
echo "<li style='line-height: 15px; color: #BF270C;'><a href=/s/$zaltname><b>$zcatname</b></a>";

echo "</li><br>";
//$zasel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent='$zid' and status=1 limit 0,3");
$zasel_an=mysql_query("SELECT * FROM ". $db_prefix ."categories where parent='$zid' and status=1");
while($an=mysql_fetch_array($zasel_an)) {
$zcid=$an["id"];
$zsubcataltname=$an["altname"];
$zsubcatname=$an["catname"];
//echo "<font color=black>$zsubcatname, ";
echo "<a href=/r/$zcid>$zsubcatname</a>, ";
}
//echo "...</font><br><br>";
echo "...<br><br>";
}