469,283 Members | 2,297 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,283 developers. It's quick & easy.

Cant Get posted value

flexsingh
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="main 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="updatebcourt_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">Insert Data Into mySQL Database </strong></td>
</tr>
<tr>
<td><font face="sans-serif, Arial" font color="white">Member 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">Court 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">Time Slot No</td>
<td><font color="white">:</td>
<td><select>

<?php
$db_name="project"; // Database name
$tbl_name="bcourt"; // 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($time, $conn); // do the query
while($queryColumn=mysql_fetch_assoc($query)){ // fetch each row in the result set
$val=$queryColumn['Time_Slot_No']; // make it simpler
echo "<option value='$val'>$val</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="project"; // Database name
$tbl_name="bcourt"; // 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=$_POST['Member_No'];
$courtno1=$_POST['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_query($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.
Mar 30 '08 #1
6 1578
ronverdonk
4,258 Expert 4TB
Your <form> is posted, [php]<td><form name="Update Network Gaming form" method="post" action="updatebcourt_ac.php">[/php]then why do you retrieve the passed value from the $_GET array?[php]$query = ("UPDATE $tbl_name SET Member_No = '$memberno1' WHERE Time_Slot_No = '".$_GET['Time_Slot_No']."' LIMIT 1");[/php]Ronald
Mar 30 '08 #2
Your <form> is posted, [php]<td><form name="Update Network Gaming form" method="post" action="updatebcourt_ac.php">[/php]then why do you retrieve the passed value from the $_GET array?[php]$query = ("UPDATE $tbl_name SET Member_No = '$memberno1' WHERE Time_Slot_No = '".$_GET['Time_Slot_No']."' LIMIT 1");[/php]Ronald

Id need to retrieve the past value so it knowns which time slot to update the member no for. That is why I'm getting the value (time_Slot_No".
Mar 30 '08 #3
ronverdonk
4,258 Expert 4TB
Guess you don''t know what I am talking about.
When you POST a value, you cannot retrieve it from the $_GET array, you must retrieve it from the $_POST array!

Ronald
Mar 30 '08 #4
Guess you don''t know what I am talking about.
When you POST a value, you cannot retrieve it from the $_GET array, you must retrieve it from the $_POST array!

Ronald
I understand now thank you, it works fine. Would you like me to post the working code up for any other users stuck to see?

Thank you very much for your help!
Mar 31 '08 #5
Markus
6,050 Expert 4TB
I understand now thank you, it works fine. Would you like me to post the working code up for any other users stuck to see?

Thank you very much for your help!
I think Ron's last post sums it up.

Regards :)
Mar 31 '08 #6
ronverdonk
4,258 Expert 4TB
I understand now thank you, it works fine. Would you like me to post the working code up for any other users stuck to see?

Thank you very much for your help!
No, I think we get the idea. But I am glad you worked it out. See you around.

Ronald
Mar 31 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Fozya | last post: by
reply views Thread by Tony Williams | last post: by
16 posts views Thread by Mike Fellows | last post: by
19 posts views Thread by bb nicole | last post: by
2 posts views Thread by moondaddy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.