RE: newbie PHP/mySQL query

2002-04-25 Thread Phil Clandillon
eractive Design -- work: http://www.clandillon.com play: http://www.mrming.co.uk - Original Message - From: "Kim Cosgrove" <[EMAIL PROTECTED]> To: "Phil Clandillon" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2

Re: newbie PHP/mySQL query

2002-04-25 Thread denonymous
From: "Phil Clandillon" <[EMAIL PROTECTED]> > I'm using a very simple PHP script with mySQL to load a news feed (url > encoded) into flash. I've got it working but I would like the records to > come out in the opposite order, with the newest one first. At the end of your SQL query, simply add a

RE: newbie PHP/mySQL query

2002-04-25 Thread Mike Grabski
Agh... I apologize to all. Did not read the question asked correctly. As far as order is concerned, you need to add "ORDER BY <> <>" if you have a date field, this would probably be the best to use. And example might be "SELECT field1, field2, field3 FROM news ORDER BY date DESC" Again, my apo

RE: newbie PHP/mySQL query

2002-04-25 Thread Mike Grabski
You should pass the data to be imported into Flash through urlencode(). Flash needs the data to be urlencoded in order for it to be able to read it, particularly if the inputted data contains HTML, text with spaces, symbols, etc. Mike -Original Message- From: Phil Clandillon [mailto:[EMA