Query trouble. ???

[leatherback]

Hi All,

I have trying to find out why this query doesn't work, but I cannot figure it out. This is the routine (With a set of echo's to see the output):

$UserQuery = "select * from users where DisplayName = $DisplayName ";
     echo $UserQuery;
     $UserResult =@ mysql_query($UserQuery);
          while($row =@ mysql_fetch_array($UserResult))
              {
              echo '1';
              $query .= "somequery";
              echo $query;     

              }

This code will echo the correct query: When I copy & paste the query into mysql it returns 1 row of data, so that is fine.
But this code does not echo the 1, nor the $query, so doesn't enter the while loop. What am I missing?

please?

Thanks!

J.

[leatherback]

-- Problem solved --

[skirby]

come on, satisfy our curiosity. Was it the missing quotes around the $displayname in the query?