Page 1 of 1

using variable within a hyperlink

Posted: Wed Feb 20, 2008 2:34 pm
by billabon0202
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.

Re: using variable within a hyperlink

Posted: Wed Feb 20, 2008 2:49 pm
by Zoxive

Code: Select all

echo '<p><li><a href=" ' $row[foodtype] ' . '.html' " >' . $row['foodtype'] . '</a></p>';// Notice how it looks with highlighting
=>

Code: Select all

echo '<p><li><a href="' . $row['foodtype'] . '.html" >' . $row['foodtype'] . '</a></p>'; 
 
||

Code: Select all

echo "<p><li><a href=\"{$row['foodtype']}.html\">{$row['foodtype']}</a></p>";
 

Re: using variable within a hyperlink

Posted: Wed Feb 20, 2008 4:54 pm
by billabon0202
that doesnt work either, how do i fix the syntax

Re: using variable within a hyperlink

Posted: Wed Feb 20, 2008 5:17 pm
by John Cartwright
Those will work fine. What exactly did you try and what is the output?