error while updating
Posted: Mon Jan 01, 2007 8:49 am
Why doesn't my command run ???
if I tried ,
output is more than 1 result -> output : 1818181818181818. but I only need : 18
Code: Select all
if(mysql_num_rows($result_query)>0){
$rc_student = "";
$s = $_SESSION['valid_idReser'];
//return room which will be deleted
$room_del="Select r.id_numberRoom FROM reservation r, room p WHERE r.id_reservation='$s'";
$result_room=mysql_query($room_del);
$num=mysql_numrows($result_room);
$i=0;
while ($i<$num){
$id_numberRoom=mysql_result($result_room,$i,"id_numberRoom");
$state_room = "UPDATE room SET state_room = 'volný'
WHERE id_numberRoom = '$id_numberRoom' ";
mysql_query($state_room);
$i++;
}Code: Select all
if(mysql_num_rows($result_query)>0){
$rc_student = "";
$s = $_SESSION['valid_idReser'];
//return room which will be deleted
$room_del="Select r.id_numberRoom FROM reservation r, room p WHERE r.id_reservation='$s'";
$result_room=mysql_query($room_del);
$num=mysql_numrows($result_room);
$i=0;
while ($i<$num){
$id_numberRoom=mysql_result($result_room,$i,"id_numberRoom");
echo $id_numberRoom;
$i++;
}output is more than 1 result -> output : 1818181818181818. but I only need : 18