Posts in: MySQL / Databases
- My S Q L
CONCAT()function - I’m building the back-end for JAWS.org, which will ?¢‚Ǩ‚Äù among other things ?¢‚Ǩ‚Äù allow members to search for other members by name. I wanted users to be able to search whole names (such as “Tiffany Brown”). But I couldn’t figure out how. Here’s a query similar to the original: SELECT * FROM membership WHERE firstName OR lastName LIKE [...] [6 Oct 2003]
- Forms, arrays PHP and databases
- For the last two days, I have been pulling my hair out (not literally) about this problem: How to store array data in a database. I solved the problem and learned something to boot. Read what I learned. [7 Sep 2003]
- S Q L Training on a budget
- Want to get your feet wet with SQL? Try SQLCourse.com. [25 Aug 2003]
- An article to live by
- It’s an oldie, but a goodie: SQL Injection Attacks: Are You Safe? from DevArticles.com. If you develop with databases, you should definitely read this article. It focuses on ASP and Microsoft SQL Server 2000, but the concepts are similar across other databases, including MySQL and Oracle 9i. Quick PHP tip: If you use numbers in your query [...] [24 Aug 2003]
- If you can’t fix one problem…
- …fix another instead. Namely, the date issue. The old ‘posted on:’ format was a raw, unformatted MySQL date. It did the job, but it was a little bit awkard because of its ‘YYYY-MM-DD’ format. What I wanted instead was a pretty, text date: ‘day, month date, year.’ But whenever I tried to convert the numeric date to [...] [11 Aug 2003]
