Regards,
Peter
Code: Select all
switch($mode){
case"cat":
$cat=$_GET['type'];
$query="SELECT * FROM project LEFT JOIN category USING (category_id) WHERE category_id LIKE'%$cat%' ORDER BY project_name ASC";
$result=mysql_query($query) OR DIE (mysql_error());
$r=mysql_fetch_assoc($result);
echo "<h2>".$r['category_title']."</h2>";
while ($row=mysql_fetch_assoc($result)){
echo '<a href="work.php?mode=item&id='.$row['project_id'].'">'.$row['project_name']."</a><br />";
}
break;