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
Category Archives: Web Apps
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
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.
[crayon-5d36b9f1c50a3938698959 inline="true" ]$variable_x = $variable_y = 0;
[/crayon] I’m not sure why … Continue reading