Hey-up,
I have a list of web links in a big MySQL table and each is categorised into things like 'food', 'toys', 'books', etc...
At the moment my php table displays these links and lists them according to these categories:
$results = mysql_query("SELECT * FROM shopping ORDER by category");
What I'd like to be able to do is split the table up so it's easier to read... is there anyway of saying, "please write a header for the category type, then list all the relevant links, then have a blank row to break the table up, then repeat for the next category"?
or if anyone has an better ideas on how to do this?...
thanks very much! - dunstan
p.s. how good is this stuff, it's SO useful!
)
I have a list of web links in a big MySQL table and each is categorised into things like 'food', 'toys', 'books', etc...
At the moment my php table displays these links and lists them according to these categories:
$results = mysql_query("SELECT * FROM shopping ORDER by category");
What I'd like to be able to do is split the table up so it's easier to read... is there anyway of saying, "please write a header for the category type, then list all the relevant links, then have a blank row to break the table up, then repeat for the next category"?
or if anyone has an better ideas on how to do this?...
thanks very much! - dunstan
p.s. how good is this stuff, it's SO useful!
)