Re: weird!
| From: | Sebastian | Date: | Sat, 12 Apr 2003 05:33:57 +0000 |
| Subject: | Re: weird! | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-143545@lists.php.net to get a copy of this message | ||
Haha, It was because the other records had and ID of 0 so it was putting
them all, hence 1800000000 ....
wow! i thought i was going crazy until i took a peek at the columns.
cheers,
- Sebastian
----- Original Message -----
From: "Kevin Stone" <kevin@helpelf.com>
To: "Sebastian" <sebastian@dslr.net>; "php list"
<php-general@lists.php.net>
Sent: Friday, April 11, 2003 1:27 PM
Subject: Re: [PHP] weird!
|
| ----- Original Message -----
| From: "Sebastian" <sebastian@dslr.net>
| To: "php list" <php-general@lists.php.net>
| Sent: Friday, April 11, 2003 11:22 PM
| Subject: [PHP] weird!
|
|
| > very strange, the id is 18 yet it ouputs 180000000
| > why?
| >
| >
| > $result = @mysql_query("SELECT id FROM news ORDER BY time DESC LIMIT
| 0,8");
| > while($row = mysql_fetch_row($result))
| > {
| > echo $row['id'];
| > }
| >
| >
| > cheers,
| > - Sebastian
|
| LIMIT 0,8 means retrieve 8 rows starting at row 0. Do all eight rows
| contain a value?
| - Kevin
|
|
|
| --
| PHP General Mailing List (http://www.php.net/)
| To unsubscribe, visit: http://www.php.net/unsub.php
|