link with database

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

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

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);