using variable within a hyperlink
Posted: Wed Feb 20, 2008 2:34 pm
First is this possible. I want to use a variable that i pulled from an array within my hyperlink. \
Ex. I pulled the foodtype variable from my database using:
$qry= "SELECT DISTINCT (restaurant_info.food_type) as foodtype
FROM restaurant_info
INNER JOIN restaurants
ON restaurants.rest_id= restaurant_info.rest_id
WHERE restaurants.delivery = 'yes'
ORDER BY food_type ASC";
Then i wanted to use that data to echo hyperlink created by that variable (foodtype)
$result = mysql_query($qry); //result of the query
if (!$result) {die(mysql_error()); //if result is empty then show error and stop process
}else{
echo '<ul>'; //start unordered list for links
while($row = mysql_fetch_array($result)) {
// CREATE link using $row['foodype'].html
this is where i am confused
echo '<p><li><a href=" ' $row[foodtype] ' . '.html' " >' . $row['foodtype'] . '</a></p>';
}
echo '</ul>';
}
And second, what is the syntax for doing something like that, i have tried to search for it but have been unsuccessful.
Ex. I pulled the foodtype variable from my database using:
$qry= "SELECT DISTINCT (restaurant_info.food_type) as foodtype
FROM restaurant_info
INNER JOIN restaurants
ON restaurants.rest_id= restaurant_info.rest_id
WHERE restaurants.delivery = 'yes'
ORDER BY food_type ASC";
Then i wanted to use that data to echo hyperlink created by that variable (foodtype)
$result = mysql_query($qry); //result of the query
if (!$result) {die(mysql_error()); //if result is empty then show error and stop process
}else{
echo '<ul>'; //start unordered list for links
while($row = mysql_fetch_array($result)) {
// CREATE link using $row['foodype'].html
this is where i am confused
echo '<p><li><a href=" ' $row[foodtype] ' . '.html' " >' . $row['foodtype'] . '</a></p>';
}
echo '</ul>';
}
And second, what is the syntax for doing something like that, i have tried to search for it but have been unsuccessful.