In other tutorials we've shown you how to display data from your database, typically in an 'all the data' mode. But there are times when you only want some of the data displayed - and a 'latest news' system doesn't look good when you display 'news' from years ago. Neither does a 'coming events' system look very professional when it displays events whose date has passed.

In keeping with the Llamasery tutorials objectives - to teach by useful example - this tutorial will provide a couple of small but practical code examples that deal with news and events, where the database is displayed in a limited fashion that makes sense for the application.

Our example News system will use the LIMIT statement in the database query; our example Events system will use the WHERE statement in the database query (for date comparison). And since these are pretty simple, this tutorial is going to be very short.

And if you haven't worked out how News and Events work with the tips above, read on …

  next  »