Jump to content

error ???


dollythesheep

Recommended Posts

Can anyone see what's wrong with this code?  It keeps on telling me that this line is wrong

[color=purple]while ($row = mysql_fetch_assoc($query3)){[/color]

...??

 

<?php

if (isset($_POST['submit'])){
   $choice = $_POST['choice'];
   
   echo "The user selected <b>$choice</b><p>";
}

  $query= "SELECT count(*) AS c FROM detention WHERE detentiondate='$detentiondate' AND pupilno='$pupilno'";
  $result = mysql_query($query);
  $result_array = mysql_fetch_assoc($result);


$query3 = mysql_query("SELECT detentiondate.detentiondates FROM detentiondates, detention, academicyear
WHERE detention.detentiondate != '$_SESSION[detentiondate]' AND detention.detentiondate <= academicyear.enddate
AND detention.detentiondate >= academicyear.startdate AND '$result_array[c]' = 0 ");
$result3 = mysql_query($query3);

echo '<form>';

[color=purple]while ($row = mysql_fetch_assoc($query3)){[/color]
   echo "<input type='radio' name='choice' value='{$row['detentiondate']}'><br>";
}

echo '<input type="submit" name="submit">';
echo '</form>';

?>

Link to comment
https://forums.phpfreaks.com/topic/98600-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.