Query displaying same info regardless of table values

Hangin' Around Joined: Jan 25, 2008 Posts: 44

Code:

$result9 = $db->sql_query("SELECT * 


FROM " . $prefix . "_milpacs_members m


LEFT JOIN  " . $prefix . "_milpacs_members m1 


ON m.reports = m1.uniqueid");


   while ($member1row = $db->sql_fetchrow($result9)) {


      if ($member1row[reports]==0) {


         $reports = 'N/A';


      } else {


         $reports = '<a href="modules.php?name='.$module_name.'&amp;file=soldierprofile&amp;uniqueid='.$info[reports].'">'.$member1row['rank_abbr'].' '.$member1row['lastname'].'</a>';


      }


   }

I have almost no experience with mysql queries so I've just been copy & pasting til something shows. Which to my surprize it did, but its displaying the exact same rank_abbr/lastname for every reports/uniqueid number. So I'm assuming I written it wrong. Can someone show me where I went wrong with the above code?

Posted: Tue Jun 10, 2008 10:04 am

" if ($member1row[reports]==0)" { you need single quotes around reports I believe.

I don't know if you'll get an undefined constant ... assuming ... error message or not. Turn on error reporting all the way.

Posted: Tue Jun 10, 2008 10:44 am

Thanks for the reply fkelly.

You mean like this?
if ($member1row['reports']==0) {

If so then yeah, I've tried it like that. I get no errors, just the same issue of it showing a different user's info then what it should show.

Also after playing with the values in the database it appears to be calling the reports id from the last member in the table. Any clue?

Posted: Tue Jun 10, 2008 5:45 pm

Nevermind, after playing with it some more I figured out what I left out.

m.uniqueid = '$uniqueid'

Thanks anyways.