Re: Cannot select specific record from a list
I tried it Peter and this is what I got back:
Parse error: syntax error, unexpected T_VARIABLE in E:\htdocs\Annie Wright School\summer_prog\camps\detail_results.php on line 8
here's the code after i added your suggestion:
<?php require_once('../../Connections/connSummer.php'); ?>
<?php
mysql_select_db($database_connSummer, $connSummer);
$camp_id = $_GET['camp_id']
$query_full_camp_info = "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
INNER JOIN instructors USING (inst_id)
INNER JOIN locations USING (loc_id)
WHERE camp.camp_id = $camp_id;";
$full_camp_info = mysql_query($query_full_camp_info, $connSummer) or die(mysql_error());
$row_full_camp_info = mysql_fetch_assoc($full_camp_info);
$totalRows_full_camp_info = mysql_num_rows($full_camp_info);
?>