Re: Cannot select specific record from a list
Peter,
I really appreciate you helping. Should I add that to the existing query and where?
here is what it looks like now:
<?php
mysql_select_db($database_connSummer, $connSummer);
$query_displayDetail = "SELECT camp.camp_id, camp.title, camp.descrip, camp.camp_date, camp.`time`, camp.grade_pk, camp.grade_k, camp.grade_1, camp.grade_2, camp.grade_3, camp.grade_4, camp.grade_5, camp.grade_6, camp.grade_7, camp.grade_8, camp.grade_9, camp.grade_10, camp.grade_11, camp.grade_12, camp.cost, camp.loc_id, camp.inst_id, instructors.inst_fn, instructors.inst_ln, instructors.inst_bio, locations.loc_name FROM camp, instructors, locations WHERE camp.loc_id = locations.loc_id AND camp.inst_id = instructors.inst_id";
$displayDetail = mysql_query($query_displayDetail, $connSummer) or die(mysql_error());
$row_displayDetail = mysql_fetch_assoc($displayDetail);
$totalRows_displayDetail = mysql_num_rows($displayDetail);
?>
Thanks again