Re: link with database
| From: | Shawn McKenzie | Date: | Tue, 11 Mar 2008 20:11:52 +0000 |
| Subject: | Re: link with database | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-271314@lists.php.net to get a copy of this message | ||
Shawn McKenzie wrote:
> Sofia Jacob (CA) wrote:
>> Hi,
>>
>> I want to create a link that get the name and the link from the database.
>>
>> The problem is that I get the bullets created with <li> but not the link, here is my
>> code and the result:
>>
>>
>>
>> <?php
>> function do_html_URL($url, $name)
>> {
>> // output URL as link and br
>> ?>
>> <a href="<?=$url?>"><?=$name?></a><br>
>> <?php
>> }
>>
>> ?>
>>
>> function display_categories($cat_array)
>> {
>> if (!is_array($cat_array))
>> {
>> echo "No hay categorías actualmente disponibles<br>";
>> return;
>> }
>> echo "<ul>";
>> foreach ($cat_array as $row)
>> {
>> $url = "show_cat.php?Categorie_ID=".($row["Categorie_ID"]);
>> $title = $row["Catname"];
>> echo "<li>";
>> do_html_URL($url, $title);
>> }
>> echo "</ul>";
>> echo "<hr>";
>> }
>>
>> function get_categories()
>> {
>> // Petición a la base de datos de una lista de categorías
>> $conn = db_connect();
>> $query = "SELECT Categorie_ID, Catname
>> FROM categories";
>> $result = @mysql_query($query);
>> if (!$result)
>> return false;
>> $num_cats = @mysql_num_rows($result);
>> if ($num_cats ==0)
>> return false;
>> $result = db_result_to_array($result); //db_fns.php
>> return $result;
>> }
>>
>>
>> $cat_array = get_categories();
>> display_categories($cat_array);
>>
>>
>>
>>
> Shorts tags are not enabled maybe?
>
> use <?php and ?> not <?=.
>
> -Shawn
Also, you need to close your <li> with </li> after. That should be
fixed, but you can confirm by looking at your page source. If you see:
<li><a href=""></a><br>
Then short tags are not enabled.
-Shawn