Career Stages Workshops
".$category.""); $mysql="SELECT * FROM courses WHERE catid='$catid' and publish=1 order by title "; $myres=mysql_query($mysql); echo(""); while ($myrow=mysql_fetch_array($myres)) { $cid=$myrow["cid"]; $brief=tidy($myrow["brief"]); echo("".$myrow["title"]."

".$brief."

"); $myothersql="SELECT events.lid, eid, dayfrom, monthfrom, yearfrom, venue, location FROM events, venues where events.lid=venues.lid AND events.cid='$cid' ORDER BY yearfrom, monthfrom, dayfrom"; $myotherres=mysql_query($myothersql); while ($myotherrow=mysql_fetch_array($myotherres)) { $dayfrom=$myotherrow["dayfrom"]; $monthfrom=$myotherrow["monthfrom"]; $yearfrom=$myotherrow["yearfrom"]; $venue=$myotherrow["venue"]; $location=$myotherrow["location"]; /* if ($venue=='On Demand') { echo(""); } else { echo(" ".$dayfrom." ".translate_month($monthfrom)." ".$yearfrom." - ".$location."   "); } */ } //echo("

"); } echo(""); } ?>