MySQL doesnt get right results :S

[Trundle]

Heya,

for some reason mysql isnt getting the right results, it keeps getting all results instead of just a special one!!

for example:

  $resulth = mysql_query("SELECT * FROM gc_rounds WHERE TrnyID = $tid AND Round = $rowI[Round]");
while ($rowu = mysql_fetch_array($resulth)) { 

Well for some reason it keeps showing results of all TrnyID's and not just from this only one. (and yes, $tid works fine)

Same goes to if(), it also shows everything then.. its really annoying. Anyone know how to fix that? Thanks!

[steadyguy]

Have you tried putting $tid and $rowI[Round] in quotes? It's probably generating a MySQL error - try

if (mysql_error()) 
    print mysql _error(); 

to get more info on which error you're getting.

Might want to use extract() on $rowI, too - then you can just use the variable name $Round, instead of $rowI[Round].