Menu
Hello all. I am getting error on line 6. The errors quantity is 800 (for each line of my db). For example:
Notice: Undefined offset: 1 on line 6
Notice: Undefined offset: 2 on line 6
Notice: Undefined offset: 3 on line 6
….. etc
1. $result = mysql_query(“select * from sage_data”);2. $num = mysql_num_rows($result);3. $row = mysql_fetch_array($result);4. for ($i=0; $i<$num; $i++)5. {6. $show_all_res = $_POST[‘show_all_res’][$i];7. $result1 = mysql_query(“select * from sage_data where8. Module=’$show_all_res'”);9. while ($row1 = mysql_fetch_array($result1))10. {11. echo $show_all_res;12. }
The source page is:
<form action=’show_all_res.php’ method=’post’>
<select multiple id=”show_all_res” name=’show_all_res[]’>
<?
$result = mysql_query(“select * from `sage_data
while ($row = mysql_fetch_array($result))
{
if ($row[‘Module’]!=”)
{
echo “<option value=’$row[Module]’>”.$row[‘Module’].”</option>”;
}
}
</select>
</form>
Please Please Please!!!!!! Tell me what to do?