2007. 02. 20, kedd keltezéssel 11.39-kor tg-php@xxxxxxxxxxxxxxxxxxxxxx ezt írta: > Different strokes for different folks... > > Might I toss a new recommendation into the mix? > > SELECT text FROM fortunes ORDER BY RAND() LIMIT 1; > that's not new :) a couple of people recommended it earlier today/yesterday this is perfect, but only if the table is not very large. see http://www.titov.net/2005/09/21/do-not-use-order-by-rand-or-how-to-get-random-rows-from-table/ greets Zoltán Németh > > > = = = Original message = = = > > N~~meth Zolt~~n wrote: > > 2007. 02. 20, kedd keltez~~ssel 08.17-kor Jim Lucas ezt ~~rta: > >> Mike Shanley wrote: > >>> I'd like to think I understood code a little better than this, but I've > >>> got a problem with my WHERE... > >>> > >>> I know it's the WHERE because I get a good result when I leave it out. > >>> And the random function is also working... I honestly can't figure it > >>> out. Thanks in advance for help with this laughable prob. > >>> --------------------------- > >>> // How many are there? > >>> > >>> $result = mysql_query("SELECT count(*) FROM fortunes"); > >>> $max = mysql_result($result, 0); > >>> > >>> // Get randomized!... the moderated way... > >>> > >>> $randi = mt_rand(1, $max-1); > >>> $q = "SELECT text FROM fortunes WHERE index = '$randi'"; > >>> $choose = mysql_query($q); > >>> $chosen1 = mysql_fetch_array($choose); > >> ARRAY??? > > > > what's wrong with that? > > http://hu.php.net/manual/en/function.mysql-fetch-array.php > > > > and then you can of course refer to it with indexes, both numeric and > > associative > > I don't see anything problematic with that... > > > > greets > > Zolt~~n N~~meth > > > >>> // Ready to ship... > >>> > >> Referring to it via an index... could be the problem > >>> $fortune = '<span class="quotecyc">"' . $chosen1[0] . > >>> '"<br/>-Omniversalism.com</span>'; > >>> > >>> mysql_close(); > >>> > >> > >> -- > >> Enjoy, > >> > >> Jim Lucas > >> > >> Different eyes see different things. Different hearts beat on different > >> strings. But there are times for you and me when all such things agree. > >> > >> - Rush > >> > > > I would suggest using either assoc or row this way there is no > confusion. Plus it doesn't take as much resources. :) > > -- > Enjoy, > > Jim Lucas > > Different eyes see different things. Different hearts beat on different > strings. But there are times for you and me when all such things agree. > > - Rush > > > > ___________________________________________________________ > Sent by ePrompter, the premier email notification software. > Free download at http://www.ePrompter.com. > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
