Jessica

Move your styles into a css file instead of doing them inline, and use a tool like Firebug to debug. I don't see anything in there about centering a button.

Plus the query is failing.

You're using "uName" in some spots and "username" in others. Pick one and stick with it.

Try using heredoc syntax, not sure if it works for constants.

One of the other two I listed. Although really, git is worth it. I was really hesitant to start using it at first, the job I was at used all 3 and after a while I would find when I switched back to a project using cvs or svn I was annoyed and just wanted to convert them all to git.

The username is typically "root". We don't know what your username and password is though. But I doubt it's blank.

Your question is...?

Version control. I like git. Other ones are cvs and svn.

Do a select * on the user id. What is returned?

He WAS asking the OP, not you. The OP is claiming that the query is returning results he feels are impossible. The question is how do you know it's returning results? The point being, the problem may be with your code that is making you think it returned something. How about you don't tell other people what to post, and let the moderators deal with it if there's an actual problem. Our rules state this. And since you're so keen on helping the OP, maybe you should re-read the post. Your query is even further from what he wants. You have not provided anything of value to this thread.

I guess I'd also have to add in how long the event lasts, rather than using an end time I think just storing the length is better.

I like it - that never occurred to me but it makes it a lot clearer. I see a similar thing suggested on stack overflow. I think that would work nicely, especially by making the events be able to have more than one entry on the date/Cron table, I can have a lot more flexibility on the rules too.

In javascript you concatenate strings with + If you have the string you want to add the code to, just do "http://"+url+""

That is what you're doing.

What debugging have you done? It's fairly obvious that either the constant is defined with a blank value, or it's not defined. The code appears fine, and it sounds like its working.

And the problem is?

Considering you're still using that approach, then clearly you didn't figure out that its wrong. You should not read the contents of a file then rewrite the file to do something that PHP is entirely designed to do - print a variable inside HTML. Did you bother to google for templating systems? Did you try anything besides the code you've posted, such as using echo? It's as simple as removing your file processing code, changing the HTML to include PHP echo statements, and including the file.

yeah, text is not PDF output.

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.