Topic awaiting preservation: SELECT * FROM tableA and then shows tableB (Huh?) (Page 1 of 1)

$query_buscar = "SELECT * FROM juegos where player_1 = '" . $remote_userName . "' ";
$result_buscar = mysql_query($query_buscar) or die ("Could not query select");
if ($result_buscar) {
if ($row[0] <> ""){
echo "<table width=50% align=center><tr><td>Row 0 =".$row[0]."</td></tr></table>\n";
}
else {
echo "anything";
}

that is suppose to print the table 'juegos' right? well, it shows another table called posts!

The table 'juegos' has just two fields: player_1 and player_2 and the table posts has several fields more. (i don't think it's importat to name them, or it is?)

Anybody knows why?
I have another functions declared before, but none use the same variables than this one....

You forgot to call mysql_fetch_array() function and therefore $row variable probably contains results from some previous query that you may have above that code...

$row = mysql_fetch_array ($result_buscar)) ;

Oh!! great!!
as usual, worked!

That problem would be avoided if I make a function in a separated sheet?
like placing all the functions in the same file, and then call that file and that function, better or not?


Thanks BTW, mr.maX!!!

ahm, max, did i just see a new sig of yours?
with some foreign typografic?
the first could say Marko, but the rest?

Marko Nezic if I'm not wrong (i don't remember) is his last name...
Am I Wrong?