calling one row in a column

[error_22]

Hi,

I was wonerding, is there a way to call one row in a column? Lets say I have table called "test" with 3 columns (id, title, content). Lets also say that there are 10 rows. What if I want to call row number 5 in the id column and at the same time row number 8 in the title column. I was hoping for something like this:


$sql = "SELECT * FROM `test`";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
echo $row['1']['id'];
echo $row['2']['id'];
}
Using that query, I could call every row. They would also be separated. My problem is, the above code doesnt work ahaha. Is there a way to achieve this?

Thanks in advance
Niklas

[Adrian Schneider]

mysql_fetch_assoc() returns an associative array, so it would actually be: echo $row['id'];
echo $row['title'];
echo $row['content'];

[error_22]

well i never said i used the right fetch method....i have no idea what to use actually. in your example, all rows would be called. my question is: is there a way to separate the rows? I want to be able to call row number 4 and then row number 6, not the other ones? is there a way to achieve this?

Thanks for helping....again ahaha

[Adrian Schneider]

just 4 and 6? or 2, 4, 6, 8, etc?

Anyway, something like this could work for your query SELECT *
FROM `test`
WHERE `id` IN (2,4)Note this is id 2 and 4, not necessarily rows 2 and 4.

You can narrow the results in MySQL or PHP... here is a PHP example to show every second row...$counter = 0;
while ($row = mysql_fetch_assoc($result))
{
if (++$counter %2 == 1)
{
continue;
}
// echo your stuff here
}