modernmafiia Posted November 18, 2011 Share Posted November 18, 2011 okay basically i made this little status thing you post it and it shows but say like i posted something it will show for everyone on there profile how do i make it so it shows what each person has posted not someone else's post on everyone's profile echo" <form action='status.php?action=update' method='post'> <input type='text' name='upTITLE' size='54' class='textbox' value='Whats On Your Mind?'> <input class='submit' name='Update Status' type='submit' value='Update Status' /> "; $anpdata=$db->query("SELECT * FROM updates"); $q=$db->query("SELECT user_level FROM users WHERE userid=$userid"); $r=$db->fetch_row($q); while($updata=$db->fetch_row($anpdata)) { $us=$db->query("SELECT username FROM users WHERE userid={$updata['upADDER']}"); $us=$db->fetch_single($us); $time=date('F j',$updata['upTIME']); print" {$updata['upTITLE']} <br /> "; print " <div align='right'> Updated On: {$time} {$year}</b>"; if($r['user_level'] != 1) { print " | <a href=status.php?action=upID&upID={$updata['upID']}><b>Remove Status</b></a></div> <img src='images/sep.png' width='490px'>"; } } Quote Link to comment Share on other sites More sharing options...
Newbie123 Posted November 18, 2011 Share Posted November 18, 2011 $anpdata=$db->query("SELECT * FROM updates"); You're selecting *all* the statuses and not giving the query a WHERE clause to select specific data. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.