Jessica

There's two docs, he needs to alias the columns.

What the?

You're doing it wrong. The way you are approaching the problem is completely wrong. Use a template system or just use PHP. You're already using PHP and you have the variables. Just echo them.

You should use straight PHP or a templating system, rather than trying to read the contents of a file into a string, parse it, and then re-write the file.

I'm designing a system that will have events, both one-time and recurring. Trying to decide on my table structure - at this point I'm thinking two separate tables for the event details (with one parent table holding the basic similar data). I'm having trouble with finalizing how I want to store everything for the recurring table. The types of appointments would be things like: Every day at noon from START_DATE to END_DATE 3 times per day every day from START_DATE to END_DATE (maybe store these as three seperate events?) - it's very likely a recurring event would often be 2-3 times per day. mon, wed, fri every week, no end a set day every month a set day every year So the fields I'm thinking so far are: start_date DATE (optional) end_date DATE (optional) start_time TIME (required) (all events require a time, but if it's a recurring event without an end date it won't have dates) end_time TIME (required) repeats_on (optional varchar, possible values like MM-DD) repeats_every (optional varchar: possible values like "mon,wed,fri" or "daily" or "weekly") Any input? I'm off to do some searching for more ideas. OR: Do I use PHP to generate the events for each of the ones with start and end dates, and store them in the regular table (and somehow link them together), and then also generate them for up to a certain amount of time for the others?

See, I'm just lazy Barand Of course, OP is going to need the PHP code too.

'$id' is the literal string of '$id'. Not the value contained within $id. Of course, the same is true of your original set code, so it should still work. Just not how you think it will.

What is the content of that file? It can't have anything output that is NOT pdf.

You can write it yourself, pay someone to do it, or whine for a while and some chump might do it. I explained the steps you need to take. Where are you stuck?

You've posted this in the wrong forum, I'm moving it for you. Typically you'd store the timestamp each time the user loads a page. Then if the last page load was within X minutes, they're considered "online".

Use BETWEEN. Moving this to the MySQL forum.

Either learn to read documentation, use classes and do basic debugging, or stick with your version 5.3.whatevs copypasta that is working.

Count what?

Really? The big bright red box telling you it's deprecated and with the option of two new extensions to use, with specific links to their pages in the manual...you don't see that big ole box? :-P

str_replace

Yes. It's actually in the manual.

You should have error reporting on in your dev environment, and only log in your prod one.

And some data.

What does htmlentities do?

I'm going to guess you'll need to join the table to itself. If you show us the actual table structure you're working with, we might actually be able to help

I can write it for you, but it'll cost you. *shrug*

https://www.google.com/search?q=define+pseudo+code Try.

Put your query in a string and execute it. mysqli_query

Yeah that would be it.

That is fine, it will submit to the page it's already on. The problem is the OP didn't actually state a problem.