php - fail to insert required fields in the database -

i wasn't clear in first post. here is.

reservation.php

<table style="border: 4px;"> <tr> <!-- start jquery pop-up --> <script src="js/jquery.js" type="text/javascript"></script> <script src="popup2.js" type="text/javascript"></script> <td style="border: 2px solid #000;"><center><img src="images/comp.jpg" height="30" width="50"><br /><b><div id="button"><a href="#" class="pcbutton">pc 05</a></div></b></center> </td> <!-- jquery pop-up code starts here including insert query --> <?php echo '<div id="popupcontact">'; echo '<a id="popupcontactclose">x</a>'; echo '<center><form method = "post" action="reserve.php">'; mysql_connect("localhost","root","") or die (mysql_error()); mysql_select_db('seat_reservation') or die (mysql_error()); $roomnumber = '400'; $chairnumber = 5; //in part, try insert in database without submitting form yet. $insert = mysql_query("insert reservation (chair_status, room_id, chair_number) values (0, '$roomnumber', '$chairnumber')"); //i'm trying retrieve inserted data , checking. $query = mysql_query("select * reservation room_id = '$roomnumber' , chair_number = '$chairnumber'"); $row = mysql_fetch_assoc($query); $_session['roomno'] = $row['room_id']; $_session['chairnum'] = $row['chair_number']; echo '<h1>information </h1>'; echo 'fullname : <input type="text" name="student_name" /><br /><br />'; echo 'student id no. : <input type="text" name="stud_id" />'; echo '<br /><br />'; echo '<input type="submit" value="submit" />'; echo '</form></center>'; echo '</div>'; echo '<div id="backgroundpopup"></div>'; ?> <!-- end jquery pop-up --> <td style="border: 2px solid #000;"><center><img src="images/comp.jpg" height="30" width="50"><br /><div id="button2"><a href="#" class="pcbutton"><b>pc 04</b></a></div></center> </td> //this table that's same code above has different pc number <?php echo '<div id="popupcontact">'; echo '<a id="popupcontactclose">x</a>'; echo '<center><form method = "post" action="reserve.php">'; mysql_connect("localhost","root","") or die (mysql_error()); mysql_select_db('seat_reservation') or die (mysql_error()); $roomnumber = '400'; $chairnumber = 4; $insert = mysql_query("insert reservation (chair_status, room_id, chair_number) values (0, '$roomnumber', '$chairnumber')"); $query = mysql_query("select * reservation room_id = '$roomnumber' , chair_number = '$chairnumber'"); $row = mysql_fetch_assoc($query); $_session['roomno'] = $row['room_id']; $_session['chairnum'] = $row['chair_number']; echo '<h1>information </h1>'; echo 'fullname : <input type="text" name="student_name" /><br /><br />'; echo 'student id no. : <input type="text" name="stud_id" />'; echo '<br /><br />'; echo '<input type="submit" value="submit" />'; echo '</form></center>'; echo '</div>'; echo '<div id="backgroundpopup"></div>'; ?> 

reserve.php

<?php session_start(); $name = $_post['student_name']; $stud_id = $_post['stud_id']; $room_id = $_session['roomno']; $chair_num = $_session['chairnum']; mysql_connect("localhost", "root", "") or die (mysql_error()); mysql_select_db('seat_reservation') or die (mysql_error()); $query = mysql_query("select * reservation room_id = '$room_id' , chair_number = '$chair_num'"); $row = mysql_fetch_assoc($query); if($row['chair_status'] == 0) { $insert = mysql_query("update reservation set chair_status = 1, student_name = '$name', stud_id = '$stud_id' room_id = '$room_id' , chair_number = '$chair_num'"); if($insert) die ("seat reserved! <br />redirecting...<meta http-equiv='refresh' content=2;reservation.php>"); else die ("try again! <br />redirecting...<meta http-equiv='refresh' content=2;reservation.php>"); } else die ("sorry, seat taken! <br />redirecting...<meta http-equiv='refresh' content=2;reservation.php>"); ?> 

here screenshot of seat reservation:

link: [note: change [dot] .] https://fbcdn-sphotos-a.akamaihd[dot]net/hphotos-ak-ash3/599637_4018881323775_858410964_n.jpg

here screenshot of pop-up upon clicking pc:

link: [note: change [dot] .] https://fbcdn-sphotos-a.akamaihd[dot]net/hphotos-ak-ash3/599637_4018881323775_858410964_n.jpg

problem : applying insert code works in 1 pc, example pc 05. in code above, applied insert code pc 05 , pc 04 testing want apply in pcs. applying in pc 05 , pc 04 doesn't make work. in database, after clicking submit button, these things inserted (note: room_id room number):

link: https://fbcdn-sphotos-a.akamaihd.net/hphotos-ak-ash3/527207_4018929644983_1759106011_n.jpg

each student should reserve seat in particular classroom. when student.a clicks on pc 05 seat, should reserved him. when student.b clicks on pc 01 seat, again, should reserved him. there multiple classrooms, used jquery tabs that. wanted have inside database (note: manual insert only) :

link: https://fbcdn-sphotos-a.akamaihd.net/hphotos-ak-ash4/376602_4018990806512_1150698954_n.jpg

your replies highly appreciated, thank in advance!

you code kind of incomplete. not use mysql_query itself. include code catch error or show output in case error occurred while inserting data.

$insert = mysql_query("insert reservation (chair_status, room_id, chair_number) values (0, 400, 5)"); // added below lines catch how many rows inserted , if not, error occured $inserted_rows = mysql_affected_rows(); if ($inserted_rows !=0) echo 'error occurred, through out error'. mysql_error();