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:

PHP Code:

$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:

PHP Code:

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 [sql]SELECT *
FROM `test`
WHERE `id` IN (2,4)[/sql]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...

PHP Code:

$counter = 0;
while ($row = mysql_fetch_assoc($result)) 
{
    if (++$counter %2 == 1)
    {
        continue;
    }
    // echo your stuff here
}