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
$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
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