Re: pulling records from mysql
| From: | Richard Lynch | Date: | Fri, 26 Jul 2002 17:12:41 +0000 |
| Subject: | Re: pulling records from mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-109819@lists.php.net to get a copy of this message | ||
>I have a column in my table named firstname with twenty records in it. How
>can i use php to pull out individual records (say for ex. record 16)? Also,
select firstname from blah
where id = 16
>how could i pull out all records upto number 15? Thanks in advance.
select firstname from blah
where id < 16
or, more likely what you should be using:
select firstname from blah
limit 1, 15
--
Like Music? http://l-i-e.com/artists.htm
I'm looking for a PRO QUALITY two-input sound card supported by Linux (any
major distro). Need to record live events (mixed already) to stereo
CD-quality. Soundcard Recommendations?
Software to handle the recording? Don't need fancy mixer stuff. Zero (0)
post-production time. Just raw PCM/WAV/AIFF 16+ bit, 44.1KHz, Stereo
audio-to-disk.