View Single Post
Old 04-23-2004, 08:49 AM   #1 (permalink)
metazai
Regular Contributor
 
Join Date: Apr 2004
Location: Orange County, CA
Posts: 124
metazai is on a distinguished road
Question about getting Arrays

Very new to PHP and trying to teach myself, I have a question about mysql_fetch_array.

I'm trying to load data from a table, and I'm looking through perhaps 20 entries, where every time I need to find the one that currently meets some particular criteria and then the only the 7 entries that follow that one in, how would I go about it? I've been able to snag the row that meets the criteria using the following:

PHP Code:
$rs mysql_query($query,$conn); 
while(
$row=mysql_fetch_array($rs)){
if (
$row[time_start]==$round_time){... 
but can how can mysql_fetch_array be used to find one row and then grab only it and the successive 7 rows?

Any thoughts?

(First Post, sorry if I've done any of this wrong)

Michael
metazai is offline   Reply With Quote