i have a query below
Code: Select all
$newClassID = $_SESSION["newClassID"];
$newRegisterID = $_SESSION['newRegisterID'];
mysql_select_db($database_sdma, $sdma);
$query_rsAtt = "SELECT * FROM sd_attendance, sd_customers, sd_classes, sd_discipline, sd_new_register WHERE (sd_new_register.newRegID = '$newRegisterID' AND sd_attendance.attendance_discipline = sd_discipline.disciplineID AND sd_new_register.newClassID = sd_classes.classID AND sd_attendance.attendance_cust_id = sd_customers.custID AND sd_discipline.disciplineID = sd_classes.disciplineID AND sd_classes.classID = '$newClassID' AND sd_new_register.newClassID = '$newClassID') AND (sd_customers.lesson_per_week1 = '$newClassID' OR sd_customers.lesson_per_week2 = '$newClassID' OR sd_customers.lesson_per_week3 = '$newClassID' OR sd_customers.lesson_per_week4 = '$newClassID' OR sd_customers.lesson_per_week5 = '$newClassID' OR sd_customers.lesson_per_week6 = '$newClassID' OR sd_customers.lesson_per_week7 = '$newClassID') ";
$rsAtt = mysql_query($query_rsAtt, $sdma) or die(mysql_error());
$row_rsAtt = mysql_fetch_assoc($rsAtt);
$totalRows_rsAtt = mysql_num_rows($rsAtt);Code: Select all
(sd_new_register.newRegID = '$newRegisterID' AND sd_attendance.attendance_discipline = sd_discipline.disciplineID AND sd_new_register.newClassID = sd_classes.classID AND sd_attendance.attendance_cust_id = sd_customers.custID AND sd_discipline.disciplineID = sd_classes.disciplineID AND sd_classes.classID = '$newClassID' AND sd_new_register.newClassID = '$newClassID'Code: Select all
sd_customers.lesson_per_week1 = '$newClassID' OR sd_customers.lesson_per_week2 = '$newClassID' OR sd_customers.lesson_per_week3 = '$newClassID' OR sd_customers.lesson_per_week4 = '$newClassID' OR sd_customers.lesson_per_week5 = '$newClassID' OR sd_customers.lesson_per_week6 = '$newClassID' OR sd_customers.lesson_per_week7 = '$newClassID'have i got the brackets in the wrong place?