cross quirey problem

[Simonhurst]

Hi Guys i have a table that stores some info on a user and it uses there user_id from another table and stores it into the new one

now want ive been trying to do is have a page where it pulls all the info from the 2nd db which has user_id and date

which i can do and it will display the user_id and date fine BUT what i really want it to do is instaed of displaying the user_id it will display the username from the first table that has the same user_id as the 2nd table here the code ive tried but it just gives me the top of the table and dosnt pull any thing from the DB

$Q01 = " SELECT users.username, users.user_id, ci1.date FROM
            87th_users LEFT JOIN 87th_ci1 ON username='user_id'
            WHERE ci1.user_id = 'username'
";
  // $Q01 = "SELECT  user_id, date
 //     FROM ".$prefix."_ci1 ";

  echo "<p align=center><table witdh=\"100%\" border=1 cellspacing=0 bgcolor=E4E2E2 bordercolor=204165>";
  echo"<tr><th bgcolor=\"#516783\"><font color=\"#FFFFFF\" size='3'><b>Pilots serial #'s who have been Graded CI-1</b></font></th><th>Date Graded</th></tr></p>";

  //format by row

 $R01 =         $db->sql_query($Q01)or die(mysql_error());
while ($row = $db->sql_fetchrow($R01))

{
         echo "<tr><td><b>" .$row['username'] . "</b></td><td><b>" .$row['date'] . "</b></td></tr>";
 }

i dont get any errors just no db out put any help on this is much appreciated

TIA

[nemonoman]

if this is your actual code, it is bound to produce an error.

SELECT users.username, users.user_id, ci1.date FROM
87th_users LEFT JOIN 87th_ci1 ON username='user_id'
WHERE ci1.user_id = 'username'

The table users (as in select users.username) is not referenced in your FROM clause. This will produce an error.

Second, the LEFT JOIN element will produce a bizarre result, since your statement references constants, ('user_id', 'username') instead of values on the joined table.

Typically your statement would look something like:
SELECT table1.name
FROM table1
LEFT JOIN table2 ON table1.id=table2.id
WHERE table2.status ='OK'
AND table1.date=CURRENT_DATE()

or something similar.

What I don't understand is how your query can be so confused and reconcile your statement " dont get any errors just no db out put". Your query should die(mysql_error()).