[Decypher]

Hey all, my problem is when i go to update the data any data that i send over which is from a drop down box (form), it for some reason does not update it. However if i update data that is inputted it updates fine.

I've checked to see if the data is actually sent to the next page also and that it does so I'm usure why it does not work. I've checked to make sure all the rows are the same but still can't find anything

first page:

<select name="rankname">
		 
		 <?
		 $rankq = 'SELECT * FROM rank ORDER BY rankid ASC';
		 $rankquery = mysql_query($rankq);
		 while($rows = mysql_fetch_array($rankquery)){
			 
			 $rankid = $rows['rankid'];
			 $rankchoice = $rows['rank'];
			 
				echo'<option value='.$rankchoice.'>'.$rankchoice.'</option>';
				}?>
				</select>	

second page:

require ("connection.php");
require ("session.php");


$updaterank = 'UPDATE user set rank = '.$_POST['rankname'].' WHERE userid = '.$_SESSION['userid'].'';
$rankres = mysql_query($updaterank);

Database look:

rank varchar(20) latin1_general_ci No

This post has been edited by Decypher: 14 January 2010 - 06:00 PM

[nick1200]

Decypher, on 14 Jan, 2010 - 12:07 PM, said:

Hey all, my problem is when i go to update the data any data that i send over which is from a drop down box (form), it for some reason does not update it. However if i update data that is inputted it updates fine.

I've checked to see if the data is actually sent to the next page also and that it does so I'm usure why it does not work. I've checked to make sure all the rows are the same but still can't find anything

first page:

<select name="rank">
		 
		 <?
		 $rankq = 'SELECT * FROM rank ORDER BY rankid ASC';
		 $rankquery = mysql_query($rankq);
		 while($rows = mysql_fetch_array($rankquery)){
			 
			 $rankid = $rows['rankid'];
			 $rankchoice = $rows['rank'];
			 
				echo'<option value='.$rankchoice.'>'.$rankchoice.'</option>';
				}?>
				</select>	

second page:

$rank = $_POST['rank'];

echo $rank;

$updaterank = 'UPDATE user set rank = '.$rank.' WHERE userid = '.$_SESSION['userid'].'';
$rankres = mysql_query($updaterank);

i take it your staring the session on top of both pages ?

There is no connect be for the mysql

mysql_connect("localhost", "username", "pass") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());

This post has been edited by nick1200: 14 January 2010 - 01:33 PM

[Decypher]

there is a session and a connection as like i've said if the data is inputted it will update, it's only if the data comes from a drop down box like above

[Decypher]

ok added the structure of the database too incase that will help but I'm still confused on why it won't update the data either though the data is being sent across to the next page...

I guess I'm right in sayin it has something to do with the update statement?

But if that is the case why does the same statement work for other pieces of data?

[thinspirit]

Try adding this to your update query and see what it says:

$rankres = mysql_query($updaterank) or die(mysql_error());

If it presents an error, it should help to lead you to a solution.

[Decypher]

yeah it comes up with that error

so i take it it's something wrong with the previous line?

[thinspirit]

what does the error say?

[Decypher]

Unknown column 'Hitman' in 'field list'

that's the error I gain but shouldn't the data be inputted for that column and not the column name changed?

'UPDATE user set rank = '.$_POST['rankname'].' WHERE userid = '.$_SESSION['userid'].'';

which is what i don't get...user is the table, rank is the field that is being changed and rankname(Hitman) is the variable that is ment to change it :S

This post has been edited by Decypher: 16 January 2010 - 08:48 AM

[Decypher]

any ideas?

[JackOfAllTrades]

How about enclosing the rank in quotes within the update? If it's a string column, you need to do that.

[xerxes333]

Have you tried (as JOAT suggested)

$updaterank = "UPDATE user set rank = '".$_POST['rankname']."' WHERE userid = '".$_SESSION['userid']."'";

[Decypher]

yeah that works

Thanks alot jack and xerxes.

Just a quick question...How come for input boxes you can get away with singular quotations but when I've used select boxes it won't work?