Welcome to WebmasterWorld Guest from 54.198.134.127
I've come across a new problem which is really annoying me!
Anyway what I have is a SQL query which gets the latest sites submitted over a certain period. Now I get all the data I need into a WHILE loop, and for each site listed it displays the site details and the category of where it belongs.
This is where I get the problem which is something similar in my previous post.
What it is displaying now is the following...
Name of Site
Description
Home > Computers > Programming > Delphi and BCB > VCL Components >
Name of Site
Description
Home > Computers > Programming > Delphi and BCB > VCL Components >
Home > Arts > Animation > Web Rings >
Name of Site
Description
Home > Computers > Programming > Delphi and BCB > VCL Components >
Home > Arts > Animation > Web Rings >
Home > Arts > Animation > Web Rings >
You see where I am getting at? Frustrating.
Now I am having that same problem with the function.
Here's the code:
function nav ($id,$x='')
{
$result=mysql_query("select cat_name,parentid
from db_categories
where catid=$id");
list($DBcat_name,$DBparentid1)=mysql_fetch_row($result);
mysql_free_result($result);
$cat_name=str_replace(" ","-",$DBcat_name);
$x="$cat_name-$id/".$x;
#echo $id .'<br>';
if($id>0)
$x=nav($DBparentid1,$x);
#echo $x;
return $x;
}
$result=mysql_query("select lid,parentid,cat_name,title,url,description,link_date
from db_links,db_categories
where to_days(now()) - to_days(link_date) between 0 and 30
and db_links.catid=db_categories.catid
and approved=1
order by link_date desc
limit 3");
while (list($DBlid,$DBparentid,$DBcat_name,$DBtitle,$DBurl,$DBdescription,$DBlink_date)=mysql_fetch_row($result))
{
echo "<a href=\"$DBurl\" class=\"list4\"><strong>$DBtitle</strong></a>";
echo "<div id=\"desc_con\">$DBdescription<br /><br />";
// Category
$sql_result=mysql_query("select catid
from db_links
where lid=$DBlid");
list($DBcatid)=mysql_fetch_row($sql_result);
$url[]=nav($DBcatid);
foreach ($url as $u)
{
$u = substr($u,37);
$t=$u;
$t=str_replace("-"," ",$t);
$t=str_replace("/"," > ",$t);
$t=ereg_replace("[0-9]"," ",$t);
$location=$base_url.'/'.$u;
echo "<a href=\"$base_url/$u\" class=\"list4\">Home > $t</a><br>";
}
echo "</div>";
}
Any help is much appreciated..
If I don't get this to work then I might have to store the URL of the category in a table, and do it that way!
Any help always appreciated
Woldie.