odisey

Thanks guys. This is an excellent forum! I have the array() lesson. You guys should LOCK that upTop. Odisey

mbeals I got it! with this: if ($result) { $i=1; while ($row = mysql_fetch_array ($result, MYSQL_NUM)) { $varname = "vars$i"; //will create a variable name: var1, var2, var3.... $i++; $$varname = $row[0]; } //echo "$vars1 $vars2 $vars3"; } echo '<p>'. $vars1 . '</p>'; echo '<p>'. $vars2 . '</p>'; echo '<p>'. $vars3 . '</p>'; I am interested in what Crayon Violet thinks about passing these variables to flash as file names for swf movies to load. Does this make sense -- will it work? TY for your help guys, I am getting there. Odisey

In response to Crayon violet: This is excellent. It is just over my head at this time. Trying to learn here. I had had a LIMIT 3 in an earlier version. And decided it was not needed until I had defined the unique variables. Here is what I want to do with the data. You said you are not sure why I want unique variables when they contain the same information. This is one of my disconnects with learning Php. It seems if you can create an array with many variables, you should be able to deconstruct it as well and then use each. I am missing this...I just can't wrap the brain around it. I want to stay within a mental framework that is comprehensible to me.... Otherwise I might get something that works, I won't know why it works though. I want to send three randomly chosen variables to flash. Of course these are derived of the images column in the db. There are eight images total. These will be swf file names once I get this code figured out. As you can imagine I want to load those randomly choosen file (swfs) in Flash once they are passed. I am much better on Php that AS. Arrays make me crazy. How to make them, use them for drop downs, etc... np. I just want to access the array in Php and create unique varialbes ($vars1, $vars2, $vars3...etc...)...so I can see it with my own two eyeballs. This way the how why what where may finally enter my brainstem and take up residence. If I can do this GREAT! I am reading the AS Bible and I have a Joey Lott course I am taking. More complicated AS will come soon. TY I will save this code. Is it possable to create these unique variables in Php? What concepts about arrays am I completely missing here? TY Odisey OK: Let me try to rework mbeals version TY. I though the double $$ was a typo. Almost there.

No I cannot get it. More help needed. What have I right and wrong here?

I am getting closer, I can feel it. Here is what I am testing, and it is not working. Once I see the syntax in proper fashion, I will understand the logic. BE RIGHT BACK <?php #Color instrument vars # ODC August 4, 2008 require_once ('????.php'); //Connect to database RESET TO SAFE PATH ONCE IT FUNCTIONS // Define variables $var1 = "Hello"; // Make selection $query = "SELECT images FROM movie_images ORDER BY RAND()"; $result = mysql_query($query) or die(mysql_error()); // Table if ($result) { $i=1; while ($row = mysql_fetch_array ($result, MYSQL_NUM)) { $varname = "vars$i"; //will create a variable name: var1, var2, var3.....varn $i++; $varname = $row[0]; ####### ##or use an array if you can $vars[] = $row[0]; } echo '<p>'. $var1 . '</p>'; //echo '<p>'. $result . '</p>'; //echo '<p>'. $s3 . '</p>'; echo '<p>'. $vars2 . '</p>'; } else { echo 'There was a problem...'; } mysql_close(); // Close database connection ?>

Yeah, this is what has eluded me. I think this is the answer. I will try this out and get back in a few minutes. TY! Odisey

I read your post, and I really am not sure what the problem is by what you have said. You do not what something selected duplicated? Can you be more specific? I will try. Odisey

Hello freaks! I am trying to do something that seems so simple, yet a day later I resort to your expertise. I am selecting all rows in a column in a MySQL db. There are 8 records. I want to sort them ramdomly and pluck the top three. I don't just want to loop and print the results, I want to redefine each as a unique variable to pass to Flash. The code I have here will print the results. How do I reassign the results to unique variables? Thank you for your help. Odisey <?php #Color instrument vars # ODC August 4, 2008 require_once ('???????????.php'); //Connect to database RESET TO SAFE PATH ONCE IT FUNCTIONS // Define variables $var1 = "Hello"; // Make selection $query = "SELECT images FROM movie_images ORDER BY RAND()"; $result = mysql_query($query) or die(mysql_error()); // Table if ($result) { while ($row = mysql_fetch_array ($result, MYSQL_NUM)) { $s1 = $row[0]; // $s2 = $row[1]; // $s3 = $row[2]; echo '<p>'. $s1 . '</p>'; //echo '<p>'. $result . '</p>'; //echo '<p>'. $s3 . '</p>'; echo '<p>'. $var1 . '</p>'; } } else { echo 'There was a problem...'; } mysql_close(); // Close database connection ?>