Question...

[phpn00bf4life]

while( $row = mysql_fetch_array( $__getPeople ) ) {
	$__id = $row['id'];
	$__getPicture = mysql_query( "SELECT * FROM pictures WHERE user_id = '$__id' LIMIT 1" );
	$_arrayPic = mysql_fetch_array( $__getPicture );
	$__getOnline = mysql_query( "SELECT * FROM online WHERE user_id = '$id' AND DATE_SUB(CURDATE(), INTERVAL 5 MINUTE) <= real_date LIMIT 1" );
    $_numOnline = mysql_num_rows( $__getOnline );
    if( $_numOnline == "0" ) {
	    $online = "Not Online";
    } else {
	    $online = "<img src=\"/images/online.gif/\" border="0" />";
    }
	if( $_arrayPic['photo_name'] == "" ) {
		$photo = "/images/nophoto.jpeg";
	} else {
		$photo = "/user_pic/" . $_arrayPic['photo_name'];
	}
	echo'<table border="0" cellpadding="4" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="170">
  <tr>
    <td width="50%" height="162" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3" bgcolor="#A39D81" height="100%">
      <tr>
        <td width="100%" valign="top" height="1"><img src="' . $photo . '" border="0" \/></td>
      </tr>
    </table>
    </td>
    <td width="50%" height="162" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber4" bgcolor="#A39D81" height="100%">
      <tr>
        <td width="100%" valign="top">' . $row['username'] . '<br />
        Online? :  ' . $online . '<br />
        City:  ' . $row['location'] . '<br />
        <a href="view_profile.php?id=' . $row['id'] . '">View Profile</a> <br />
        <a href="send_mail.php?to=' . $row['id'] . '">Send Mail!</a>
        </td>
      </tr>
    </table>
    </td>
  </tr>
</table>';
unset( $__id );
unset( $__getPicture );
unset( $_arrayPic );
unset( $__getOnline );
unset( $_arrayOnline );
}

the script will either say they are all on or all off...i need some help!

[konsu]

what kind of help and with what problem do you need?

[phpn00bf4life]

sorry, what i meant to ask was the script will either say all of them are offline or all of them are online...i need help debuggin that.

[BuzzLY]

noob,

You're gonna have to supply a little more information. How have you debugged it so far? Have you tried echoing any of the variables to the screen? Is your other data ok? What are you trying to accomplish?

Showing us your code and simply stating that it's showing "all of them are offline or all of them are online" doesn't tell us much -- which is it, and when? Is it random?

It sounds like you might not be getting the data you expect from your queries. Try running them on your SQL server to make sure they work correctly.

[phpn00bf4life]

that worked BuZZLy. Sorry i didn't provide enuff info, but that's really all the info i had at the time.. I had debugged the script fully other than that tho.