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. Did you stop the process through Xamp? When you shut down your computer it should stop.
  2. 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. 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. So you do have several other users you're following. Try the other query I gave you in place of yours.
  5. 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. 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. You don't need the table alias when you print the row. Print_r($postrow)
  8. 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. 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. It has nothing to do with that.
  11. 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. You have a syntax error in your query. Read the link in my signature on debugging SQL.
  13. 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. 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.
×
×
  • 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.