[PHP-DB] newbie MySQL question

2001-05-19 Thread Matt Nigh
hi, i'm building a website right now with a shows page on it which will scroll horizontally in a window. i have each show listed in a table called shows (db is called almavale_board) with the following fields: id - bandplaying - venue - date - time - cover - description what i need to do is

Re: [PHP-DB] newbie MySQL question

2001-05-19 Thread Paul Campbell
$result = mysql_query(select * from shows); Change to $result = mysql_query(select * from shows ORDER BY date DESC); On Saturday 19 May 2001 21:45, Matt Nigh wrote: hi, i'm building a website right now with a shows page on it which will scroll horizontally in a window. i have each show

Re: [PHP-DB] newbie MySQL question

2001-05-19 Thread Matt Nigh
this would work, and does for the day, but for the month it doesn't. also, is there code to have: $result = mysql_query(select * from shows ORDER BY date DESC); (or whatever code works) and $result = mysql_query(select * from shows where id = $show order by id limit 8); combined together to