Re: link with database

From: 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

« previous php.general (#271314) next »