adamFTW
19-02-2009, 08:15 PM
<?php
include ("includes/global.php");
$n = mysql_query("SELECT uid FROM updates WHERE uid = '$oid'");
$number = mysql_num_rows($n);
$u = mysql_query("SELECT * FROM updates WHERE uid = '$oid'");
$update = mysql_fetch_array($u);
$user = mysql_query("SELECT * FROM users WHERE id = '$oid'");
$username = mysql_fetch_array($user);
if($number == "0"){
echo "You have no status updates.";
} else {
echo "{$username['username']} is {$update['message']}";
}
?>right now it only displays the most recent update, how do I make it display all the entries by that user? thx
Edit by Robbie! (Forum Moderator) - Moved to Coding Help, please post in the correct section next time, thanks.
include ("includes/global.php");
$n = mysql_query("SELECT uid FROM updates WHERE uid = '$oid'");
$number = mysql_num_rows($n);
$u = mysql_query("SELECT * FROM updates WHERE uid = '$oid'");
$update = mysql_fetch_array($u);
$user = mysql_query("SELECT * FROM users WHERE id = '$oid'");
$username = mysql_fetch_array($user);
if($number == "0"){
echo "You have no status updates.";
} else {
echo "{$username['username']} is {$update['message']}";
}
?>right now it only displays the most recent update, how do I make it display all the entries by that user? thx
Edit by Robbie! (Forum Moderator) - Moved to Coding Help, please post in the correct section next time, thanks.