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