how can retrieve more than one values in text field using ajax?

im using php and ajax. Problem is that i want to search seat numbers bases of batch and semester condition on onchange event eg. if i search batch 2008 and semester first then in mysql db retrieve seat numbers 1,2,3,4 in text boxes problem in while loop why if write this so it is unsuccessful

while($row=mysql_fetch_array($result))
{

echo "<input name='seat' type='text' value=".$row['Seat_Number'].">";

}

error on this line Seat Numbers Warning: mysqlfetcharray(): supplied argument is not a valid MySQL result resource in E:\software\wamp\www\result_db\findseatno.php on line 23

but if i write this code with option menu it is successful

echo "<b> Seat Numbers</b>";
echo "<select name='seat'> 
<option>Select seat numbers</option>";

while($row=mysql_fetch_array($result))
{

echo "<option value>".$row['Seat_Number']."</option>";

}
echo "</select>";

plz solve this problem if i search in text field so what i do?

entermarks.php

<div align="left"><strong>Batch</strong> : 
      <select name="batch" onChange="getSeat(this.value,this.value,this.value);getSeat(document.fm.degree.selectedIndex,document.fm.batch.selectedIndex,document.fm.semester.selectedIndex);">
        <option value="">Select Batch</option>
        <option value="2008">2008</option>
        <option value="2009">2009</option>
</select>
      <br />
    </div>

<div align="left"><strong>Semester</strong> : 
      <select name="semester" onChange="getSeat(this.value,this.value,this.value);getSeat(document.fm.degree.selectedIndex,document.fm.batch.selectedIndex,document.fm.semester.selectedIndex);">
        <option value="">Select Semester</option>
        <option value="first">first</option>
        <option value="second">second</option>
</select>
      <br />
    </div>

<div id="seatdiv">
      <div align="left"><strong>Seat Numbers</strong> 

     <input name="seat" type="text" id="seat"/ >

      </div>
      </div>
View Answers









Related Tutorials/Questions & Answers:
Advertisements