Jump to content

News Feed Design


derekshull

Recommended Posts

You do still need to limit that query to your follows.

 

In phpmyadmin or mysql command line run SELECT * FROM follow WHERE username = 'Put your username here'; - what do you get?

Link to post
Share on other sites

Also in the longrun you'll want to switch the order of your JOIN and probably just use INNER.

 

SELECT description, needsusername, datesubmitted 
FROM needs
INNER JOIN follow
ON follow.followname = needs.needsusername
AND follow.username = 'Your username here';

 

Is what I think you'll need based on your posts.

Link to post
Share on other sites
  • 1 year later...

Two years later and I really enjoyed reading this, super entertaining.  Anyways "Jessica" your code snippet really helped and I can't stand it when the person doesn't even try and help themselves and expects you to do everything and then gets rude when you don't solve all their issues.

Link to post
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.