Stuck with UPDATE code

[FantasyLink]

Hello,

I found out it is not possible to update all 25 seeds at once using <select> HTML command so I changed that it to update each individually.

The process is to select, using <select>, one of hundred college teams from ncaa table and assign seed # to certain team.

Table: ncaa
Column name: team_name, seed, rec_win, rec_lose, id

Problem: I am not updating team properly. First UPDATE code will assign $1 to all teams. I want it to assign 1 (not $1) to selected team instead of $1 to all teams.

<?php
$updateseed ="UPDATE ncaa SET seed='$1'";
mysql_query($updateseed);
?>

<table width="300" cellpadding="0" cellspacing="0" border="0">
			   		  <tr>
					  	  <td class="text"> #1:</td>
						  <td><form action="testinsertteam.php" method="post"><select name="8">
						  <?
						  $query ="SELECT team_name FROM ncaa";
						  $result =mysql_query($query) or die(mysql_error()); 
						  while ($row =mysql_fetch_array($result)){
						  echo "<option ".$row["team_name"].">".$row["team_name"]."</option>";
						  }
						  ?>
						  </select><input type="Submit" value="Update"></td>
					 </tr>
				</table>

I also tried this code below:

<?php
$updateseed ="UPDATE ncaa SET seed='$1' WHERE team_name=$team_name";
mysql_query($updateseed);
?>

It did not update seed # or team info at all.

[rincewind456]

Well you can't have a variable $1, the Manual says:

A valid variable name starts with a letter or underscore, 
followed by any number of letters, numbers, or underscores.
 As a regular expression, it would be expressed thus:
 '[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*' 

[saidbakr]

Hi,
Your problem includes two points:-
1) Invalid variable name. You may not receive error message due to the second point.
2) Everything between sigle quote ' is printed as it is. For example:

$d = 122;
echo 'I have $d books';
//The printout is : I have $d books
//but
echo "I have $d books";
// will printout : I have 122 books

So, you may able to modify your SQL Query as follows:
$updateseed ="UPDATE ncaa SET seed=\"$one\"";
We used escape characters

[rincewind456]

saidbakr wrote:

2) Everything between sigle quote ' is printed as it is. For example:

Except if they are within Double quotes.

saidbakr wrote:

So, you may able to modify your SQL Query as follows:
$updateseed ="UPDATE ncaa SET seed=\"$one\"";
We used escape characters

That would then throw up an sql syntax error as the value to be set is going to be quoted by double quotes see this example

<?php
$_1=8;
$updateseed ="UPDATE ncaa SET seed='$_1'"; // Outputs: UPDATE ncaa SET seed='8'

$updateseed ="UPDATE ncaa SET seed=\"$_1\""; // Outputs: UPDATE ncaa SET seed="8"

?>

For further info check out the manual on Strings.

[FantasyLink]

ok, with minor change to the code as suggested, still the same result. I think the problem fall on where <select> is not communicating with UPDATE code.

I suspect that I may be missing few important information that I need to be aware for <select> to communicate with UPDATE code? Is it that I am missing hidden input value? Or is it because the value in <select> code is not corresponding with value in UPDATE?

I have been going at it for 2 days now and surfing through the net for information on using select with so little luck. My eyes feel as if it is ready to fall off. LOL!

[rincewind456]

Try checking that what you think is being sent is actually being sent. The best way is to send your form output to a page that opens phpinfo() and then check the variables that have been sent (you want to check especially for $_POST['8'], or put echoes after each variable to see if they are correct.

Also check the html source to see if the values are as they should be.