searching query

[abels28]

i ran a query and have rowset from mysql. using mysql_fetch_row($queryname) will fetch the next row in the query. is there a way to fetch a specific row number. these rows DO NOT have a column that is Auto-Incremented with there row number. is there a function similiar to the fetch_row that will allow me to specify a row number.

[k9sar72]

Use mysql_fetch_array() instead.

that will return your results in an associative array, allowing you to access the values by their table column names

$row=mysql_fetch_array($result)

echo $row['COLUMN_NAME']

etc.

actually I think I misread your question.....

try something along the lines of

$row=mysql_fetch_array($result);
$row_count = count($row);
$num_range = range(0, $row_count);
for ($i = 0; $i < $row_count; $i++) {
if (SOME_CONDITION) {
break;
}
else {
do something else with $row[$i];
}

where break will advance to the next row if your condition is true.