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 →
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 database, logging, mysql config, queries, query, restart, testing, trace, ubuntu
|
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 →
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 →
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.
|
$variable_x = $variable_y = 0; |
I’m not sure why … Continue reading →
Posted in php, Web Apps
|
Tagged shortcuts, syntax
|
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 →