[Resolved] Problem with UPDATE

rcoursey

I am using this to update a table:
// The echos are to test variables. They are all being assigned.

echo $id. " =Rec ID. " .$outcome. " = Outcome. " . $free . " = Free. " . $gamestart . " = Game Time. ";
This query is to update the table with record changes in an html form.

$result = dbquery("UPDATE table1 SET playid='$playid', gamestart='$gamestart', team1='$team1', team1line='$team1line', team2='$team2', team2line='$team2line', pick='$pick', active='$active', outcome='$outcome', free='$free' WHERE playid='$id'");

I do not get an error when the query runs. And the $id variable is the used to check the pickid v. the pickid in the form assigned to $id.

I get no fields updated. I'm guessing it is simple and overlooked.

cgraz

Are you using mysql? is dbquery() your own function? If so, I'd use mysql_query() along with mysql_error() to see what's going on. You may also want to print the string to see what it looks like before it's executed.


$query = "UPDATE table1 SET playid='$playid', gamestart='$gamestart', team1='$team1', team1line='$team1line', team2='$team2', team2line='$team2line', pick='$pick', active='$active', outcome='$outcome', free='$free' WHERE playid='$id'";
$result = mysql_query($query) or die(mysql_error());

print "<br>" . $query;

Cgraz

rcoursey

dbquery() is my own function. It seems to work well for several other updates involved in this program.

I print out several strings being passed to the query with the echo statements. The ones I have tested do print correctly prior to the query.

I do not get any error messages upon running the query. The function has error reporting and gives a warning if the query fails for any reason.

I was hoping I missed a punctuation mark or something simple like that. But, alas, no.

I will now test all variables being passed to the query. If one does not test properly I will report back. No news means the values are valid and just not inserting for some reason.

cgraz

try the code I suggested, then copy and paste it's output to the board so I can see. Printing the query string and using mysql_error() should help you solve ANY MySQL problem you ever run across. It's done wonders for me.

Cgraz

rcoursey

the output was:

UPDATE table1 SET playid='2', gamestart='2003-05-20 20:30:00', team1=',.nm', team1line='m;ljkjg', team2='njkl;l', team2line='uil;/l;jghj', pick='lkm:Lk;lK', active='1', outcome='L', free='1' WHERE playid='6'

Even though it appeared to have all the info there was no update to the record.

I was just entering random strings.

cgraz

Well, you're changing the playid to 2 where it equals 6, so how do you know where the UPDATE is supposed to happen? TEchnically it should happen at 6, but you changed it to 2. You see what I mean?

I'd try dropping the SET playid='$playid' part and then running the update to see if it works. playid isn't your primary key, is it? If so, I wouldn't suggest changing it. If your primary key is something else, I'd use that in the WHERE clause.

Cgraz

rcoursey

Thanks,

You helped track this down!

My problem was as you thought....

I was using the wrong id in the WHERE. It should have been the pickid='$id'. This solved the issue.