SQL Help - Webmaster Forum - Web Design, Programming and SEO forums

03-10-2007, 12:32 AM

Dan

Status: Request a custom title
Join date: Feb 2005
Location:
Expertise:
Software:

Posts: 3,164

iTrader: 15 / 86%

Dan is an unknown quantity at this point

SQL Help

PHP Code:


			
   $sql = "select d.title, d.downloads, d.hits, d.rating, d.userid, c.category from wallpaper d, categories c where d.wallpaperid = $wallpaperid and c.categoryid = d.categoryid";

   $result = mysql_query($sql ,$db);



   if ($myrow = mysql_fetch_array($result)) {

      do {

         $pagetitle = $myrow["title"];

         $downloads = $myrow["downloads"];

         $hits = $myrow["hits"];

         $wallpaperrating = $myrow["rating"];

         $userid = $myrow["userid"];

         $category = $myrow["category"];

      } while ($myrow = mysql_fetch_array($result));



   }

Code:

Breadcrumbs: <a href="url">title</a> &raquo; <a href="domain.com/cat/<?php printf($categoryid); ?>/"><?php printf($category); ?></a> &raquo; <strong><?php printf($pagetitle); ?></strong><br />

This is how the code turns out:

Code:

Breadcrumbs: <a href="url">title</a> » <a href="domain.com/cat//">cat</a> » pagetitle

See: <a href="domain.com/cat/<?php printf($categoryid); ?>/"> does not render, I'm not sure if it's getting pulled from the database correctly, could someone take a look?

Edit: Just you so know, it's fixed. Thanks anyway.