Recent content by OsakaWebbie

I will be making multiple copies of this structure, so little decisions like this will add up. My database has 24 tables, and all but one of them might have multibyte characters entered in them, so the tables are UTF8 with either utf8_general_ci or utf8_unicode_ci collation, whichever seemed to...

If you change the LEFT JOIN to INNER JOIN (just as an experiment), do those rows disappear from the result set? If so, then for some reason it doesn't think the activity_id (17 in your first example, 5 in your png) has a match. I'm wondering if the field in the timesheet table needs to be...

That's a good idea for most of my code - only about 2-3 of my files write to the session at all (the login script and a couple others that change the GUI language and such), so it might be good for me to start a new habit of using this kind of technique to keep the session unlocked as much as...

Okay, you lost me on this sentence - in the previous post from you, I thought your last sentence meant using a standard "<link rel="stylesheet" type="text/css" href="style.css" />" in page.php, with the session technique, and then doing something in mod_rewrite to change style.css into...

Once again, great contributions by everyone. I love the Tek-Tips community! Whether at runtime or in a pre-processor to make a unique set of static CSS files for each client, it will be the same amount of complexity, and as far as I can tell it is not "unnecessary". And I don't do everything...

Spamjim: The main reason I'm using PHP to build my CSS is because of colors - this application has a single codebase but multiple "clients" with their own database and their own color schemes in some cases. CSS doesn't really have the ability to "cascade" color values as some sort of variables...

Okay, I decided to use the GET parameter - I'm gradually making all the changes now. (I'm using $_SERVER['PHP_SELF'] instead of hardcoding the name, for multiple reasons.) But if you still want to teach me for the future how I can put diagnostic code in something that is handled by the browser...

Thanks, guys. I know I can pass the page name as a GET parameter (in fact, in a few cases I am already passing other things that way), but this code appears in about 30 files right now, so I thought I'd be clever and avoid editing each one. But I'm aware that that might be the way to go. In...

I'm using PHP to construct my CSS output, like this: <link rel="stylesheet" type="text/css" href="style.php" /> Multiple files have the above line in them, and I want to serve up some specific content based on which file is calling it. My thought was to have a switch statement with cases of the...

I know - I was just chuckling about it. Thanks again, and have a great week!

Better than 1/3... that means worse than 2/3... hmm, then I should improve, because I'm actually an American living in Japan! [wink] So for me, the challenges cut the other direction, e.g. my Japanese computer with Japanese software (including the accounting software where I had the massive...

Yes, I know all of that. And I don't have a floppy drive, in case you are wondering. As of the last sentence of my previous post, I had decided to research and buy a new computer as soon as my current rush is over. (A Japanese tax accountant is coming tomorrow to review my taxes [in Japan...

Fortunately it's just internet. In fact, even POP3 doesn't seem slow (once again, gut feel only) - just HTTP. I already had the hard drive ordeal with my second hard drive (that was used for video projects and footage), which died suddenly about two months ago (I came in the room and it was...

I have Windows XP, and the GUI-style check disk tool that is run from the Properties dialog (as opposed to at boot time) does not leave any log file. I could run it again as part of booting just to get a log in Event Viewer, but the rumor is that if there were any problems found, the "I'm...

I'm even more confident that it is exactly that (having glanced at its code a bit). It looks nothing like the code at the link you referenced, though. I also had that concern, which is why I opened the file in Notepad to have a peek. It was pretty big for a PHP file, but it appeared to be pure...