[SOLVED] how to getting link from database

[beboo002]

hello all

i am creating a dynamic site but i hav problem to fetch the value form database with link

<?

include_once("includes/db.php");

include_once("includes/functions.php");

$sql="select * from tbl_cat where sub_cat_id=0 order by rand() limit 2 ";

$res=mysql_query($sql,$link);$query=mysql_fetch_row($res);

while ($row=mysql_fetch_array($res))

{

//echo "<td>$row[cat_name]</td>";

 

}

?>

 

need here link like

<a href="category.php?display_cat_id=<?=$row_cat['id'];?>"><?=$row_cat['cat_name'];?></a>

but i cont able to do this although it was not giving any error also not showing any result

and <?=$query["2"];?>is work properly with out link.

 

[vbnullchar]

try this;

 

while($row=mysql_fetch_array($res)) 
{
echo "<a href='category.php?display_cat_id=$row_cat[id]'>$row_cat[cat_name]</a>";
}

[vijayfreaks]

Hi...

 

For that are you sure that whatever you have written in key of  $row_cat.. i.e.

$row_cat['id'] in this --> 'id' so exactly same column(field) in db...

 

so check for it otherwise it seems to be ok..

 

Regards,

Vijay

[Northern Flame]

while($row_cat = mysql_fetch_array($res)) 
{
echo "<a href='category.php?display_cat_id=$row_cat[id]'>$row_cat[cat_name]</a>";
}