Jump to content

Jessica

Staff Alumni
  • Content Count

    8,968
  • Joined

  • Last visited

  • Days Won

    41

Jessica last won the day on June 5 2013

Jessica had the most liked content!

Community Reputation

420 Excellent

About Jessica

  • Rank
    This is not my name.
  • Birthday 06/25/1986

Contact Methods

  • Website URL
    http://thewebmason.com

Profile Information

  • Gender
    Female
  • Location
    Dallas, TX
  • Age
    26
  1. Jessica

    mysqld.exe unable to be deleted

    Did you stop the process through Xamp? When you shut down your computer it should stop.
  2. Jessica

    PHP Micro-Frameworks

    Anyone tried Tonic? The docs seem very lacking. A friend suggested I check it out for a project he needs help on, but I thought it was pretty... Lacking.
  3. Jessica

    News Feed Design

    Way to ensure you won't get my help again. This is why I don't usually write actual code for people. They act like assholes even when you give them what they want. Bite me.
  4. Jessica

    News Feed Design

    So you do have several other users you're following. Try the other query I gave you in place of yours.
  5. Jessica

    News Feed Design

    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.
  6. Jessica

    News Feed Design

    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?
  7. Jessica

    News Feed Design

    You don't need the table alias when you print the row. Print_r($postrow)
  8. Jessica

    News Feed Design

    Oh and by the way - I don't come here to "help" ungrateful whiny babies. So stop acting like a child and remember this is a FREE Help forum. (For the record, if someone paying me spoke to me in such an ungrateful manner I'd fire them, so I especially won't put up with it from someone I am donating my time to.) Grow up.
  9. Jessica

    News Feed Design

    You can't mix mysqli and mysql. You need to use the mysql version of the error function when you're using a mysql connection instead of mysqli. However, you did actually fix the syntax error, so good job. You still need to specify what column to do your join ON, but otherwise good.
  10. Jessica

    News Feed Design

    It has nothing to do with that.
  11. Jessica

    News Feed Design

    You're the fastest reader I've ever seen! OR there's no way you read the post, implemented proper error checking and got the actual error.
  12. Jessica

    News Feed Design

    You have a syntax error in your query. Read the link in my signature on debugging SQL.
  13. Jessica

    News Feed Design

    You want all the users you follow right? Right now you select all the users in your SQL, but your PHP only pulls the first row. Then you do ANOTHER query to get that users posts. You're doing the same thing you were before. Do only ONE query.
  14. Jessica

    News Feed Design

    Specify what columns you join on. If you're going to use table aliases make them make sense. a and b are meaningless. You also should be using a primary key ID instead of the username. Username should only be stored in the user table, everything else should use their user id. You are running one query to get a user, and then selecting the information for that ONE USER. You need to do just ONE query joining the two tables only limiting it to the logged in user, not BOTH users.
  15. Jessica

    News Feed Design

    ... Google "mysql join"
×

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.