17
Hello there, I have constructed a option of choosing a court only available when member no = "0". This works fine and is in the first code: -
[PHP]<html>
<head>
</head>
<body background="mai n background1.jpg " link="blue" vlink="blue">
<table width="350" border="1" align="center" cellpadding="0" cellspacing="1" >
<tr>
<td><form name="Update Network Gaming form" method="post" action="updateb court_ac.php">
<table width="100%" border="1" cellspacing="1" cellpadding="3" >
<tr>
<td colspan="3" align="center"> <strong><font face="sans-serif, Arial" font color="white">I nsert Data Into mySQL Database </strong></td>
</tr>
<tr>
<td><font face="sans-serif, Arial" font color="white">M ember No</td>
<td><font color="white">: </td>
<td><input name="Member_No " type="int" id="Member_No"> </td>
</tr>
<tr>
<td><font face="sans-serif, Arial" font color="white">C ourt No</td>
<td><font color="white">: </td>
<td><input name="Court_No" type="varchar" id="Court_No" value="Bcourt"> </td>
</tr>
<tr>
<td><font face="sans-serif, Arial" font color="white">T ime Slot No</td>
<td><font color="white">: </td>
<td><select>
<?php
$db_name="proje ct"; // Database name
$tbl_name="bcou rt"; // Table name
// Connect to server and select database.
$conn = mysql_connect($ _SESSION['host'], $_SESSION['username'], $_SESSION['password'])or die("cannot connect");
mysql_select_db ("$db_name", $conn)or die("cannot select DB");
$time=urlencode ($_GET['Time_Slot_No']);
$time = "SELECT Time_Slot_No FROM $tbl_name WHERE Member_No = '0'";
$query = mysql_query($ti me, $conn); // do the query
while($queryCol umn=mysql_fetch _assoc($query)) { // fetch each row in the result set
$val=$queryColu mn['Time_Slot_No']; // make it simpler
echo "<option value='$val'>$v al</option>"; // construct option statement
}
?>
</select></td>
</tr>
<td colspan="3" align="center"> <input type="submit" name="Submit" value="Continue "></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>[/PHP]
It then sends the data to be updated into the table replacing the member number "0" to whatever was put in.
The problem I am getting is it can't update any time slot as it cant retieve the slot I asked for. It only updates member = "0".
[PHP]<?php
// this starts the session
session_start() ;
?>
<?php
$db_name="proje ct"; // Database name
$tbl_name="bcou rt"; // Table name
// Connect to server and select database.
mysql_connect($ _SESSION['host'], $_SESSION['username'], $_SESSION['password'])or die("cannot connect");
mysql_select_db ("$db_name") or die("cannot select DB");
// Get values from form
$memberno1=$_PO ST['Member_No'];
$courtno1=$_POS T['Court_No'];
$TSN1=$_POST['Time_Slot_No'];
$time=urldecode ($_GET['Time_Slot_No']);
// Insert data into mysql
$query = ("UPDATE $tbl_name SET Member_No = '$memberno1' WHERE Time_Slot_No = '".$_GET['Time_Slot_No']."' LIMIT 1");
$result=mysql_q uery($query) or die(mysql_error ());
// if successfully insert data into database, displays message "Successful ".
if($result){
echo $query;
}
else {
echo "Cannot Update";
}
// close connection
mysql_close();
?>[/PHP]
I had asked for a echo query and it shows : -
"UPDATE bcourt SET Member_No = '3' WHERE Time_Slot_No = '' LIMIT 1"
So I know it can't find the time slot, can anyone help me please.
Thank you in advanced forany help.
