ORDER BY RAND() is not very performance wise.
Try to do the rand outside of the DB and get your random record
with that number.
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow.
-Original Message-
From: Gerard Samuel [mailto:[EMAIL
Does anybody have an idea how-to use Flash and PHP to access a MySql
database. I know how to use PHP and mysql with no problem to pull info, but
with Flash I am struggling.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Might want to check out a article on devshed:
http://devshed.com/Client_Side/Flash/DataDrivenFlash/page1.html
On Wed, 2003-06-25 at 11:15, Ron Allen wrote:
Does anybody have an idea how-to use Flash and PHP to access a MySql
database. I know how to use PHP and mysql with no problem to pull
on 25/6/03 4:15 pm, Ron Allen at [EMAIL PROTECTED]
wrote:
Does anybody have an idea how-to use Flash and PHP to access a MySql
database. I know how to use PHP and mysql with no problem to pull info, but
with Flash I am struggling.
Look on flashkit.com
--
Mike Karthauser
Managing Director
Adam made a good suggestion - but using LoadVars is better, and if you are
retrieving text it's easier to bring it back as an xml file, otherwise an
ampersand stops you cold. Here's my call to the login script to
authenticate users for a news site when the login button is clicked.
The
Fairly simple if you're using Flash MX.
In the flash movie create a LoadVars object.
myObject = new LoadVars ();
create an onLoad event for it...
myObject.onLoad = function () {
trace (myObject.returnedValue);
}
drag and drop a button component and name