Ако няма id -> да селектва всичко , ако има ...

[XxLPxX]

<?php
$id=(int)$_GET['cat_id'];
if(isset($id))
{
$sql2=mysql_fetch_assoc(mysql_query("SELECT * FROM `categories` WHERE `id`='".$id."'"));
$sql=mysql_query("SELECT * FROM `templates` WHERE `type`='HTML/CSS' and `category`='".$sql2['category']."'");
}
else
{
$sql=mysql_query("SELECT * FROM `templates` WHERE `type`='HTML/CSS'");
}
echo mysql_num_rows($sql);
while($row=mysql_fetch_assoc($sql))
{
echo '<table width="100" style="float:left"><tr><td><img src="admin/files/'.$row['pic'].'" border=1 width="100" height="100" alt=""/></td></tr><tr><td align="center">Цена:'.$row['price'].'</td></tr></table>';
}
?>

Проблема ми е че когато няма id не показва нищо , когато има id , всичко е ок

 

[Karcho]

<?php
$id=(int)$_GET['cat_id'];
if(isset($id) && $id > 0)
{
$sql2=mysql_fetch_assoc(mysql_query("SELECT * FROM `categories` WHERE `id`='".$id."'"));
$sql=mysql_query("SELECT * FROM `templates` WHERE `type`='HTML/CSS' and `category`='".$sql2['category']."'");
}
else
{
$sql=mysql_query("SELECT * FROM `templates` WHERE `type`='HTML/CSS'");
}
echo mysql_num_rows($sql);
while($row=mysql_fetch_assoc($sql))
{
echo '<table width="100" style="float:left"><tr><td><img src="admin/files/'.$row['pic'].'" border=1 width="100" height="100" alt=""/></td></tr><tr><td align="center">Цена:'.$row['price'].'</td></tr></table>';
}
?>

пробвай така

 

[gLaVoReZa]

<?php
$id=(int)$_GET['cat_id'];
if($id)
{
$sql2=mysql_fetch_assoc(mysql_query("SELECT * FROM `categories` WHERE `id`='".$id."'"));
$sql=mysql_query("SELECT * FROM `templates` WHERE `type`='HTML/CSS' and `category`='".$sql2['category']."'");
}
else
{
$sql=mysql_query("SELECT * FROM `templates` WHERE `type`='HTML/CSS'");
}
echo mysql_num_rows($sql);
while($row=mysql_fetch_assoc($sql))
{
echo '<table width="100" style="float:left"><tr><td><img src="admin/files/'.$row['pic'].'" border=1 width="100" height="100" alt=""/></td></tr><tr><td align="center">Цена:'.$row['price'].'</td></tr></table>';
}
?>

Пробвай и така. :lol: