Re: WHERE problem
| From: | Jim Lucas | Date: | Tue, 20 Feb 2007 16:27:24 +0000 |
| Subject: | Re: WHERE problem | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-249092@lists.php.net to get a copy of this message | ||
Németh Zoltán wrote:
2007. 02. 20, kedd keltezéssel 08.17-kor Jim Lucas ezt írta:-- 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. - RushMike Shanley wrote: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émethI'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???nothing is wrong with it, just confusing// 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