Jessica

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

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.

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.

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

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.

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?

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

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.

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.

It has nothing to do with that.

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.

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

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.

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.

... Google "mysql join"

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

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.

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.

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?

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.

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

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.

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.)

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.

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