Jump to content

Jessica

Staff Alumni
  • Content Count

    8,968
  • Joined

  • Last visited

  • Days Won

    41

Everything posted by Jessica

  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"
  16. Jessica

    News Feed Design

    Never do queries in loops. Join the two tables, and use an ORDER BY clause.
  17. Jessica

    Read/unread Messages

    Not a separate table - the php script that displays the messages should have options. You would select a folder, and the script would show you the messages in that folder. Common default folders would be Inbox and Sent. Also Trash sometimes. The script then uses simple logic to determine which messages to display from your single table.
  18. Jessica

    Read/unread Messages

    Why would the message be IN the sender's INBOX? It should be in a SENT folder. If you're showing an "all messages" view (again, like gmail), you still don't show sent messages. When you're showing the sent messages, you wouldn't bold messages they sent unless you WANT to be able to show them it hasn't been read by the reader. If you for some odd reason want to show sent messages in an inbox, you would use logic in PHP to determine the bolding - if they are the one that sent it, you don't want it bold (based on your last post), so use that logic - not the read/unread field.
  19. Jessica

    Read/unread Messages

    That's what I'm confused about too - of course the sender read it, they wrote it. It should change from read to unread when the recipient reads it. I wonder if she's talking about a message thread like in Gmail?
  20. Jessica

    Read/unread Messages

    It's just logic. You want to store if a message has been read or not. What would you add to your table? You want to store ONE THING that is a boolean. Is it really THAT HARD to figure out what you change in your table? You need to start thinking a little instead of assuming you'll find it on the internet. We are here to help but you are not doing any of this work on your own.
  21. Jessica

    Read/unread Messages

    So you've explained your specifications now. Messages are either read or unread. When someone looks at a message, you would change it to read. Where are you stuck??? What have you done? You're acting like it's some kind of magic system - you need to write the code. To write the code you need to be able to say what the code should do. It sounds like you have said what the code should do - now do it...
  22. Jessica

    Read/unread Messages

    You need to explain what you think you mean by "read/unread system". As I explained when you originally posted about the inbox system, you need to be clear about what you're trying to do, rather than assuming we can read your mind. What exactly do you want to accomplish? If you can explain it in plain english, you can probably figure out how to do it in PHP/MySQL.
  23. Jessica

    What Does Your Workspace Look Like?

    We have an hour for lunch. Leave work, 60 minutes. Get to the restaurant, now you have 50 minutes. Get seated, order, now you have 35 minutes. Get your food/drinks, now you have 25 minutes. 15 minutes to eat, pay, and leave. There's no way someone can have a drink and be okay to drive, in the amount of time we have for lunch. (When we do group lunches we tend to take 1.5 hours but still.)
  24. Jessica

    What Does Your Workspace Look Like?

    I like them fine (most of them ) but I'm not going to drink alcohol with them. I also don't think it's appropriate to have a drink then go work. Drinking is for relaxing/celebrating, and if you are able to do your work properly after a drink, what was the point of the drink? Just have a soda. Not to mention the drinking & driving issue.
  25. Jessica

    What Does Your Workspace Look Like?

    I don't get the drinking at lunch, let alone drinking with coworkers.
×

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.