1 Topic by mirac

  • mirac
  • Baby member
  • Offline
  • Registered: 2011-01-19
  • Posts: 6

Topic: Shoutbox reading

I have a simple shoutbox system and I can read the shouts, but my problem is I can not read the shouts of my friends?

// this is our SQL string to insert shouts into db
$sql = "INSERT INTO shouts SET post='$post', ipaddress='$ipaddress', member_id='$member_id'";

// now we retrieve the 8 latest shouts from the db
$query = "SELECT * FROM shouts WHERE member_id='" . $SESSION->conf['member_id'] . "' ORDER BY `id` DESC LIMIT 8;";

how can I read the shouts of my friends? any idea?

2 Reply by mirac

  • mirac
  • Baby member
  • Offline
  • Registered: 2011-01-19
  • Posts: 6

Re: Shoutbox reading

is that possible? I can not with database query work.
any idea?

3 Reply by radioact

  • radioact
  • Infant member
  • Offline
  • From: Semipalatinsk
  • Registered: 2007-02-06
  • Posts: 2,749

Re: Shoutbox reading

something like that

// put here query to select your friend ids
//put ids into $friend_ids array.


// this is our SQL string to insert shouts into db
$sql = "INSERT INTO shouts SET post='$post', ipaddress='$ipaddress', member_id='$member_id'";

// now we change your query to select data from friends as well
$query = "SELECT * FROM shouts WHERE (member_id='" . $SESSION->conf['member_id'] . "' OR member_id IN (" . (implode(", ", $friend_ids ) . ") ) ORDER BY `id` DESC LIMIT 8;";

Last edited by radioact (2011-07-23 23:02:48)

www.vldMagic.com - first choice customizations help desk
www.vldCrowd.com/radioact - my profile at vldCrowd

radioact's Website

4 Reply by mirac

  • mirac
  • Baby member
  • Offline
  • Registered: 2011-01-19
  • Posts: 6

Re: Shoutbox reading

Thank you for your help!

yes. how do I get friend_ids?