PHP/MySql assistance needed

[wtd]

And for the love of Pete, man! Indent!

[nickison99]

octopi wrote:

On your update line, why do you have single qoutes around the TABLENAME
and can you please describe the tables.
(Names, Fields/types)

you could try adding a
OR DIE
line to the end of the mysql_query
to see if it doesn't complete right, mysql_error should say why.

The table name that gets updated is "MainPlayerInfo" and the field that should be updated is "Team2005"(varchar(50) - will be char(2) later). The value that should be in there is the value from the pulldown menu named "New_Team2005". I have been tinkering with it for hours now and still cannot get it to work.

[nickison99]

wtd wrote:

And for the love of Pete, man! Indent!

Next time, If I need to post this again i will indent it. Whenever i start tinkering with code I don't care about the indentation until I get it to work.

[wtd]

nickison99 wrote:

wtd wrote:

And for the love of Pete, man! Indent!

Next time, If I need to post this again i will indent it. Whenever i start tinkering with code I don't care about the indentation until I get it to work.

You might just find you get it to work faster by making it easier to read.

[nickison99]

True - (indentation in progress...)
For future refrence is there a program that is good for php editing that includes and indent feature(like Turing)?
THanks.
Nick

[wtd]

http://zend.com/store/evaluation.php?pid=77&download=1

[octopi]

nik wrote:

$getteam = mysql_query("SELECT * FROM Teams2004 WHERE TeamID ='$play[Team2004]'");

okay, so why then are you trying to read data from the 'Teams2004' table?

[nickison99]

That chunk of code reads the persons team number (from MainPlayerInfo) and checks the teams table to see what team the team number refers to.

[octopi]

This part makes no sense, based on your other code.

WHERE Player_ID='$HTTP_GET_VARS[id]'

[nickison99]

I made one change to the code:

code:

echo "<FORM METHOD=POST ACTION=editteams3.php>";

is now:

code:

echo "<FORM METHOD=POST ACTION=editteams3.php?id=$play[Player_ID]>";

.

[octopi]

change

code:

Player_ID='$HTTP_GET_VARS[id]'

to

code:

Player_ID='$HTTP_POST_VARS[id]'

remove the

code:

.php?id=BLAH

from the action


add

code:

<input type=hidden name=id value=BLAH>

to your form.



Also read my other posts and follow the directions such as mysql_error()
tell me what those show, make sure that the update line is acctually being reached (does the

code:

if(isset($HTTP_POST_VARS['submit'])) {

acctually get reached.)

also give us a url of the hting, if you haven't already

[nickison99]

Hi, Can we continue this through PM? There is some information on the site that I cannot give out so I would like to pm you the link instead.

[nickison99]

Problem Fixed! Thanks to octopi and wtd for all their help!
Nick