[RESOLVED] Associated a number with Query

[duny]

I have though about how to say this but can not think of a way with out speaking gibberish. What I have is a mysql query as such:

$query = "select * from images WHERE drive = '$i[drive]'";
$result = MySQL_query($query); 
$row = MySQL_fetch_row($result);

and what i want is to count where a give id falls with in that search.

Say my page is on http://thissite.com/index.php?getID=98237592

and then pulls that info from the DB. Say i have about 10 other id's in that query and say 98237592 is 7th id in the db that is returned with the query. how can I echo that it is the 7th is in the DB with out having to recunstruct my DB.

[cgraz]

not sure I quite follow but I'll give it a try anyways...

$count = 0;
$id = 98237592;
while( $row = mysql_fetch_object( $query ) )
{
	++$count;

if( $row->fieldName == $id )
{
	print 'Record Number: ' . $count;
}

// Other code here
}

[duny]

Cool that give me the complete count in the query. Is there a way to associate the id with what record number.

Like id

98237592 = 7

or

54643563 = 8

[dmacman1962]

I did not test this, but give it a try.

$count = 0;
$id = 98237592;
$record = array();
while( $row = mysql_fetch_object( $query ) )
{
    ++$count;

if( $row->fieldName == $id )
{
    $record[$count] = $row['fieldname'];
    print 'Record Number: ' . $count;
}

// Other code here
} 

Again, I did not test it, but just adapt it to your scenario.

And to see the array contents, just do...

echo '<pre>';
print_r($record);
echo '</pre>';

Good luck,
Don