MAC IE 5 issue with Flash5/PHP/MySQL

[timshaya]

hi there,

building a basic flash / php / mysql component that displays concert listings, 20 at a time.
it has 'last 20' and 'previous 20' buttons that  cycle through the database based on the value of a var that's passed via as/php and tells the db which record to start printing back from.

the SQL statemtent looks like this:
SELECT * FROM tableName ORDER BY showsID DESC LIMIT startDisplay, 20

everything works fine on PC in IE 5, IE 5.5, NS 4.7, Mozilla 0.9 and on MAC in NS 4.7.

The problem is with MAC IE 5. All's good, until you get to the end of the db table.

When the end of db is reached (less than 20 get returned from db) Php sends flash a message saying 'There's no more SHOWS.' At this point, if you click on 'last 20,'
the problem occurs - NO DATA is sent back to flash*. If you hit it again, the correct data is sent back to flash from the db and if you keep hitting 'last 20' at this point, all is good and correct.

The 'last 20'   button works fine when there are 20 or more records to display next (ie, we're not at the end of the db yet).

Does this explanation make sense ?

has anyone got any idea why this may be  happening on MAC IE 5 only?

here's an online example:

http://www.theexitrock.com/qa/flash_nextbtn.html


* it seems that no data is being sent back to flash because the
onClipEvent(data) { this.gotoAndPlay("show");} never triggers in that case.

tim

[flashswami]

I won't pretend I know exactly what the problem is, but from what you've said, i think the problem is with the Mac swf player. What OS are you using? There's a whole raft of issues with OS9 for example.

Check out this link and do a search http://www.macromedia.com/support/flash

[timshaya]

yep, i'm on OS 9.1. thanks for the link, flashswami.

my IE 5 has Flash 5.0 r41, according to the browser plugin tester on this page:
http://www.cyscape.com/showbrow.asp



tim