Category Archives: Web Apps

Update Across Joined Tables in MySQL

I had to do a MySQL update on records that were retrieved from a two-table join today. I shouldn’t have been surprised to find that I needed a different syntax than I know from MS SQL, where I would write, … Continue reading

Posted in MS SQL, mysql, Transact SQL | Tagged , , , , | Leave a comment

Tracing MySql Transactions

Anyone who has had to troubleshoot or support systems built on a SQL Server database knows and loves the Profiler Tool, which allows you to see all of the queries submitted to a database. Web page database interaction tends to … Continue reading

Posted in Linix/Apache, mysql, php, Web Apps | Tagged , , , , , , , , | Leave a comment

Simultaneous MySQL DB Connections in PHP

I recently added a copy function to one of the web applications that I’ve developed. In addition to letting the user copy records to a new set of records in the same system, I decided to also allow them to … Continue reading

Posted in mysql, php, Web Apps | Tagged , , | Leave a comment

Output Buffers Are too Cool

All php developers have been there. You’ve got the page working just like it should. And with one exception, it looks good too. That exception: All of your status and debut messages. You hate to get rid of it. It’s … Continue reading

Posted in php, Web Apps | Tagged , , , , | Leave a comment

PHP Shortcut to Set Two Values at Once

I’ve been coding in php for seven years, and doing it professionally for four. Until today, I never knew you could use a syntax like this to set the value of more than one variable.

I’m not sure why … Continue reading

Posted in php, Web Apps | Tagged , | Leave a comment

Find Nth Level of URL from Current Page

I ran into an interesting need when updating some code for MyQuizWiz, an online quiz and survey system that I developed. There’s a need to display content generated by the system in users’ Facebook fan pages.. Specifically, there is a … Continue reading

Posted in php, Web Apps | Tagged , , | Leave a comment