O'Reilly logo

PHP Solutions: Dynamic Web Design Made Easy by David Powers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

14 SOLUTIONS TO COMMONPHP/MYSQL PROBLEMS

What this chapter covers:

  • Extracting the first section of a longer text item
  • Using an alias in a SQL query
  • Formatting dates with PHP and MySQL
  • Working with multiple tables in MySQL

We have some unfinished business left over from the last chapter. Figure 13-2 shows content from the journal table with just the first two sentences of each article displayed and a link to the rest of the article. However, I didn't show you how it was done. The full list of articles in journal_list.php also displays the MySQL timestamp in its raw state, which isn't very elegant, particularly if you're using MySQL 3.23 or 4.0. In addition to tidying up those two things, this chapter addresses some of the most common questions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required