MySQL & PHP

[CorfuVBPRogramm]

Hello all . .

I need some help plz . . .

I want to get some records from recordset return by MySQL query but not one by one.

For example.

If query return 10 records to get the 4rt and the 6th or the 2nd or the 10th directly.

How can i do that ? ? ?

Thanks a lot . . .

[cbj4074]

Why don't you just do something like this:

$query = 'SELECT * FROM your_table WHERE
your_key = 4
OR
your_key = 6
OR
your_key = 2
OR
your_key = 10';

$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {
     //do something
}

Or, if you don't know in advance which rows you will want (which would be weird), you can just increment the result set pointer manually using PHP's mysql_data_seek() function.

[iamtheironman]

// can also use  mysql_data_seek()

mysql_data_seek($myResultSet,2); 
$row = mysql_fetch_array($myResultSet);
echo $row[0];

mysql_data_seek($myResultSet,6);
$row = mysql_fetch_array($myResultSet);
echo $row[0];

mysql_data_seek($myResultSet,0);
$row = mysql_fetch_array($myResultSet);
echo $row[0];

[CorfuVBPRogramm]

Thanks iamtheironman. That was what i was search for.

Thanks a lot . . . 😃