April 3rd, 2000, 06:07 PM
i'm trying to build a database for the local music scene. music listings are put in the database with musicians name, date (yyyy-mm-dd format), where to, etc.
question 1: is there a way to grab entries sorted by thier first letter? for example, having links a,b,c,...,z, and by clicking on the "a" link you get only the musician's whose names start with a.
question 2: is there a way to get future dates? for example $today = date("Y-m-d");
will get you todays date, is there a way to get tomorrows date. day after tomorrow, and the day after that, etc.? this is so i can show who's playing where on future dates.
thanks, in advance.
April 4th, 2000, 05:17 AM
q1. select * from <table> order by <column name>;
q2. probably isnt the easiest way but hey it works
$today = date("Y-m-d");
April 4th, 2000, 09:55 PM