PHP/Database help!

[lalnfl]

When I do this:

 

$matches++;

$sql_update_matches = mysql_query("UPDATE Live_Event SET matches='$matches' WHERE id='$show_id' AND promo_id='$promotion_id'");

 

But when it should update the database from 0 to 1, it update it to U. What is the problem?

[tastro]

define your variables please.

[PFMaBiSmAd]

Where are you setting or getting $matches from? You are likely setting it to 'T' or 'TRUE', probably by a comparison that is actually an assignment statement (i.e. one = sign instead of two.)

 

Also, you don't need to SELECT a value in order to UPDATE it, just increment the value IN the UPDATE query.

 

 

[lalnfl]

$sql_show_name = mysql_query("SELECT * FROM Live_Event WHERE id='$show_id' AND promo_id='$promotion_id'");
$show_name = mysql_fetch_array($sql_show_name);

$show_name = $show_name['name'];
$matches = $show_name['matches'];

[lalnfl]

Does anyone know what the T and U mean in the database? I shouldn't be getting them, but yet I am.

[PFMaBiSmAd]

They mean nothing. It is your data and your code.

 

You are either setting them to those values (an 'T' + 1 is a 'U') or you are treating the number as an ascii character and it has been incremented to the value of a U/T.

[lalnfl]

So how would I get my value to go back to numbers? Because its doing the (an 'T' + 1 is a 'U') thing? How do I get it back to incrementing numbers?

[PFMaBiSmAd]

You have posted a grand total of 6 lines of code out of your whole program. How would anyone here know how your code created the problem or what to fix in it to prevent it.

[lalnfl]

You have posted a grand total of 6 lines of code out of your whole program. How would anyone here know how your code created the problem or what to fix in it to prevent it.

 

Don't get worked up about this, it was just a question. Anyways, I solved the problem.