$linkID = mysql_connect($host,$user,$pass) or die ("Could not connect to host.");
mysql_select_db($database,$linkID) or die ("Could not find database.");
$query = "SELECT * from songlist WHERE genre='Emo' ORDER BY ID ASC limit 25";
$resultID = mysql_query($query,$linkID) or die ("Data not found");
// and this
songlist.htmlText += "<b>"+artistA[i]+"</b> " + titleA[i]+IDA[i]+"<br>";
Or is there something i should know about ID (which is the Primary Key) that cannot be displayed in Flash this way? Please advise someone, I'm stumped!
and here's what i want to do next with _global.myid = [], since each song has a unique ID, i want to assign a request button where when users click the button it will retrieve the unique ID for that song to be sent to PHP, im not sure if this is how it's gonna be done.. but here's what i have in mind..
Chris, is there anyway i could prevent the browser from popping up when users click the request button as my application is supposed to be standalone and it'd kinda kill the function if suddenly a browser pops up. hehehe.
im really new at this, and im just combining stuffs i found. i know there are easier ways of doing it.
Thats what I was explaining....lol. Give me a bit....I'll make something here to test with and repost the code. Mind you it will be setup completely different. On the upside, you will be able to pack in a bunch of actions in a section of the way I do it that will make more sense and allow you more options.
I'm having a "finished my deck" party so bear with me...the wife is fuming everytime I sneak way to code I'll post back.
Hey Chris, glad to have someone helping me out coz Im super stumped on this. I'm actually trying to integrate this with a request/dedication system belonging to SAM Broadcasting tool. so the idea now is to retrieve the uniqe ID of each song to be sent to the PHP to do its other magic of sending the song to the broadcasting tool and database.
here's a ZIP file containing what i'm trying to do and what it needed to communicate with once the ID reaches the PHP..
Hey Chris, awesome file you've got there but right now im too whacked to apply that to what i've done. but anyhoo, im not sure if you've seen my latest dev file and i think you should coz its nearly finished but im lost. i cant seem to pass the vars from Flash to PHP... ive tried from a HTML form, is vars are pssed to that PHP..bam the request & dedication would work for my application.. but right now it isnt Can you please take a look at my SendAndLoad.zip, here;'s the link if youve lost it
Ah, thing is i have just too many people helping me out and im stumped with which to follow. Anyway, Chris, the problem I have now is with the dangg dedication part, (the green headphone with a white dialog box icon), if you click that, it will go to a frame where your name and message is required. once Submit is pressed, its suppose to SendAndLoad variables into flash_post.php, but somehow it isnt.. im not sure whether its my Flash, or his PHP is faulty.. Because from a HTML form, his PHP seem to be working! hehe