[RESOLVED] Select two items from same row in database table

kiwibrit

Is there a quicker way of doing this (in php5)?

It correctly picks $description_1 and $description_2, but uses two queries. I think I should be able to use one query only - but haven't figured how.

$result = mysqli_query($link, "SELECT description FROM pageref WHERE pagerefno = $reqpageref") 
or die ("Error in query_des: $query. " . mysqli_error());
$row = mysqli_fetch_row($result);
$description_1 = $row[0];
$result = mysqli_query($link, "SELECT url FROM pageref WHERE pagerefno = $reqpageref") 
or die ("Error in query_url: $query. " . mysqli_error());
$row = mysqli_fetch_row($result);
$url_1 = $row[0];

vertmonkee

This should work as your query

SELECT description, url FROM pageref WHERE pagerefno = $reqpageref

kiwibrit

Thanks, but I am struggling to get the results out of what I guess is the resultant array. For example,

$row = mysqli_fetch_row($result);
echo $row['description', 'url'];

gives no result.

$row = mysqli_fetch_row($result);
echo $row[0];

gives me description only.

What I want to be able to do is extract, and assign variables to, description and url - as I did, rather clumsily, in the opening post.

vertmonkee

Hopefully this should work I haven't tested it but seems to be what you are after

$result = mysqli_query($link, "SELECT description, url FROM pageref WHERE pagerefno = $reqpageref") or die ("Error in query_des: $query. " . mysqli_error()); 
$row = mysqli_fetch_row($result); 
$description_1 = $row[0]; 
$url_1 = $row[1];

laserlight

You should use mysqli_fetch_assoc() if you want to access the column by name rather than by position. The array returned is just that -- an array.

$row = mysqli_fetch_assoc($result);
echo $row['description'] . ' ' . $row['url'];

kiwibrit

laserlight wrote:
You should use mysqli_fetch_assoc() if you want to access the column by name rather than by position. The array returned is just that -- an array.
$row = mysqli_fetch_assoc($result);
echo $row['description'] . ' ' . $row['url'];

That did it, thank you. And thank you vertmonkee for your assistance, particularly on selection. I have some more reading to do on arrays.