OK, I have a Database, and I do Queries such as this against it -
$result = mysql_query("SELECT * FROM maininventory where main_title LIKE '$alphachar%' order by main_title, alt_title, issue_num",$db);
The table is setup as follows (with some sample data to show the question.
3 Rows -
main_title , alt_title, issue_num
and then Data Like this (following example of Rows above)
Grendel Tales , Devil in Deed, 1
Grendel Tales , Devil in Deed, 2
Grendel Tales , HomeComing , 1
Grendel Tales , HomeComing , 2
How can I change the Order statement to reflect alphabetical order by main_title and alt_title AND numerical order by issue_num ?
Thanks!
Dave
$result = mysql_query("SELECT * FROM maininventory where main_title LIKE '$alphachar%' order by main_title, alt_title, issue_num",$db);
The table is setup as follows (with some sample data to show the question.
3 Rows -
main_title , alt_title, issue_num
and then Data Like this (following example of Rows above)
Grendel Tales , Devil in Deed, 1
Grendel Tales , Devil in Deed, 2
Grendel Tales , HomeComing , 1
Grendel Tales , HomeComing , 2
How can I change the Order statement to reflect alphabetical order by main_title and alt_title AND numerical order by issue_num ?
Thanks!
Dave