UBB.Developers Forums Community Development Programming PHP and Server-side Scripting Quickie FAQ Script

<?php <br /><br />// declare variables and make the database connection <br /><br />MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database"); <br />@mysql_select_db( "$dbName") or die( "Unable to select database"); <br /><br />// query information for faq <br /><br />$result = mysql_query("SELECT * FROM cats,subcats WHERE c_autonum=s_cat"); <br />$i = 1; <br />if ($myrow = mysql_fetch_array($result)) { <br /><br />// display list if there are records to display <br /><br />  do { <br />     printf("%s. <a href=%s>%s</a><br />&nbsp;&nbsp;&nbsp;%s. %s<br />\n", <br />     $myrow["c_autonum"], <br />     $PHP_SELF, <br />     $myrow["c_title"], <br />     $i, <br />     $myrow["s_title"]); <br />$i++; <br />   } while ($myrow = mysql_fetch_array($result)); <br /> } <br /><br />else {echo "Sorry, nothing found!"; <br />     } <br />?> 

SELECT * FROM cats,subcats WHERE c_autonum=s_cat

c_autonum, c_title, s_autonum, s_cat, s_title, s_desc

<br />  $lastcat = ""; // Set it to empty the before the loop, to make the category print the first time.<br />  do { <br />     // First, print the category, but only if it has changed from the last row.<br />     if ( $lastcat != $myrow["c_title"] ) {<br />        printf( "%s. <a href=%s>%s</a><br />\n", <br />        $myrow["c_autonum"], <br />        $PHP_SELF, <br />        $myrow["c_title"]);<br />        // Set last category to the one we printed, so we won't print it again<br />        $lastcat = $myrow["c_title"];<br />     }<br /><br />     // Now we can print the questions in this category<br />     printf("&nbsp;&nbsp;&nbsp;%s. %s<br />\n", <br />     $i, <br />     $myrow["s_title"]); <br />$i++; <br />   } while ($myrow = mysql_fetch_array($result)); <br />