Forgot Password • Register • Login

Most Popular

PHP 48 Visual Basic 15 Javascript 14 HTML 12 Adobe Photoshop 10

Graphic Design

Adobe Fireworks 1 Adobe Photoshop 10 Adobe Illustrator 0 Adobe InDesign 0 Gimp 0

Desktop Programming

C/C++ 3 Python 1 Visual Basic 15 Visual C# 1

Web Development

Adobe Dreamweaver 0 Adobe Muse 0 ASP.net 0 .htaccess 6 CSS 5 Perl 0 PHP 48 PHP - User System 2 HTML 12 Java 0 Javascript 14 Ruby on Rails 0 General Web Development 4

Operating Systems

CentOS 4 Debian 0 Ubuntu 0 Macintosh 1 Windows 7 Unraid 1

Video & Audio Editing

Adobe After Effect 0 Adobe Premiere 0 Adobe Audition 0 Final Cut 0 FruityLoops 0 iMovie 0 Windows Movie Maker 0

App Development

Apple Swift 0

Hardware

Arduino 0 Raspberry Pi 3

Miscellaneous

ChatGPT 1

Site Statistics

Total Members
525

Total Tutorials
139

Newest User
cucumber2025

Todays Guests
691

Googlebot

Long list, of nothing....

Posted on Tuesday 21st August 2007 at 04:49 PM

Diablosblizz
Diablosblizz's Avatar

Code

        while ($cat = mysql_fetch_array(mysql_query("SELECT * FROM `shop_cat`"))) {

echo "<a href='?page=view&id=$cat[id]'>$cat[name]</a>";

}

This, should display the categories names. But... it does not. It just shows a big list of nothing! What did I do wrong?

Posted on Wednesday 22nd August 2007 at 10:21 PM

Dean

PHP Code

$query = mysql_query("SELECT * FROM `shop_cat`");
while($cat = mysql_fetch_array($query)) {
echo(" <a href='?page=view&id=$cat[id]'>$cat[name]</a>");
}
?>

Posted on Thursday 23rd August 2007 at 09:12 AM

SkillMaster
SkillMaster's Avatar

The mysql_query cant be in the while loop