Problem Displaying 10 rows of Different Categories

**ameshkin** · Mar 27 '06, 06:45 PM

Re: Problem Displaying 10 rows of Different Categories

I meant 3 or 4 rows! Same Table, different value in `cat` field

**Jerry Stuckle** · Mar 29 '06, 02:45 AM

Re: Problem Displaying 10 rows of Different Categories

ameshkin wrote:[color=blue]
> I'm having all kinds of visual problems using dreamweaver's built in
> query builder. I have 4 different categories. Right.
>
> I want to show ten records from each category of items in a mysql
> database. All on the same page. Could someone tell me what is wrong
> with my code?
>
> The page is here
> http://www.picmonkey.com/MoreGraphics.php
>
> $currentPage = $_SERVER["PHP_SELF"];
>
>
> $maxRows_ForBoy s = 10;
> $pageNum_ForBoy s = 0;
> if (isset($_GET['pageNum_ForBoy s'])) {
> $pageNum_ForBoy s = $_GET['pageNum_ForBoy s'];
> }
> $startRow_ForBo ys = $pageNum_ForBoy s * $maxRows_ForBoy s;
>
> mysql_select_db ($database_pigg ybank, $piggybank);
> $query_ForBoys = "SELECT graphics.owner, graphics.Upload Date,
> graphics.cat, graphics.locati on, graphics.auto FROM graphics
> where `cat` = 'For Guys'";
> $ForBoys = mysql_query($qu ery_ForBoys, $piggybank) or
> die(mysql_error ());
> $row_ForBoys = mysql_fetch_ass oc($ForBoys);
> $totalRows_ForB oys = mysql_num_rows( $ForBoys);
>
> if (isset($_GET['totalRows_ForB oys'])) {
> $totalRows_ForB oys = $_GET['totalRows_ForB oys'];
> } else {
> $all_ForBoys = mysql_query($qu ery_ForBoys);
> $totalRows_ForB oys = mysql_num_rows( $all_ForBoys);
> }
> $totalPages_For Boys = ceil($totalRows _ForBoys/$maxRows_ForBoy s)-1;
>
> //2
>
> $maxRows_ForGir ls = 10;
> $pageNum_ForGir ls = 0;
> if (isset($_GET['pageNum_ForGir ls'])) {
> $pageNum_ForGir ls = $_GET['pageNum_ForGir ls'];
> }
> $startRow_ForGi rls = $pageNum_ForGir ls * $maxRows_ForGir ls;
>
> mysql_select_db ($database_pigg ybank, $piggybank);
> $query_ForGirls = "SELECT graphics.owner, graphics.Upload Date,
> graphics.cat, graphics.locati on, graphics.auto FROM graphics where
> `cat` = 'For Girls'";
> $query_limit_Fo rGirls = sprintf("%s LIMIT %d, %d", $query_ForGirls ,
> $startRow_ForGi rls, $maxRows_ForGir ls);
> $ForGirls = mysql_query($qu ery_limit_ForGi rls, $piggybank) or
> die(mysql_error ());
> $row_ForGirls = mysql_fetch_ass oc($ForGirls);
>
> if (isset($_GET['totalRows_ForG irls'])) {
> $totalRows_ForG irls = $_GET['totalRows_ForG irls'];
> } else {
> $all_ForGirls = mysql_query($qu ery_ForGirls);
> $totalRows_ForG irls = mysql_num_rows( $all_ForGirls);
> }
> $totalPages_For Girls = ceil($totalRows _ForGirls/$maxRows_ForGir ls)-1;
>
> mysql_select_db ($database_pigg ybank, $piggybank);
> $query_Animals = "SELECT graphics.owner, graphics.Upload Date,
> graphics.cat, graphics.locati on, graphics.auto FROM graphics WHERE
> `cat` = 'Animals'";
> $Animals = mysql_query($qu ery_Animals, $piggybank) or
> die(mysql_error ());
> $row_Animals = mysql_fetch_ass oc($Animals);
> $totalRows_Anim als = mysql_num_rows( $Animals);
>
> mysql_select_db ($database_pigg ybank, $piggybank);
> $query_Cartoons = "SELECT graphics.owner, graphics.Upload Date,
> graphics.cat, graphics.locati on, graphics.auto FROM graphics WHERE
> `cat` = 'Cartoons'";
> $Cartoons = mysql_query($qu ery_Cartoons, $piggybank) or
> die(mysql_error ());
> $row_Cartoons = mysql_fetch_ass oc($Cartoons);
> $totalRows_Cart oons = mysql_num_rows( $Cartoons);
>
> $queryString_Fo rGirls = "";
> if (!empty($_SERVE R['QUERY_STRING'])) {
> $params = explode("&", $_SERVER['QUERY_STRING']);
> $newParams = array();
> foreach ($params as $param) {
> if (stristr($param , "pageNum_ForGir ls") == false &&
> stristr($param, "totalRows_ForG irls") == false) {
> array_push($new Params, $param);
> }
> }
> if (count($newPara ms) != 0) {
> $queryString_Fo rGirls = "&" . htmlentities(im plode("&",
> $newParams));
> }
> }
> $queryString_Fo rGirls = sprintf("&total Rows_ForGirls=% d%s",
> $totalRows_ForG irls, $queryString_Fo rGirls);
>
> //column 3
>
> $maxRows_Glitte r = 10;
> $pageNum_Glitte r = 0;
> if (isset($_GET['pageNum_Glitte r'])) {
> $pageNum_Glitte r = $_GET['pageNum_Glitte r'];
> }
> $startRow_Glitt er = $pageNum_Glitte r * $maxRows_Glitte r;
>
> mysql_select_db ($database_pigg ybank, $piggybank);
> $query_Glitter = "SELECT graphics.owner, graphics.Upload Date,
> graphics.cat, graphics.locati on, graphics.auto FROM graphics
> where `cat` = 'Glitter'";
> $Glitter = mysql_query($qu ery_Glitter, $piggybank) or
> die(mysql_error ());
> $row_Glitter = mysql_fetch_ass oc($Glitter);
> $totalRows_Glit ter = mysql_num_rows( $Glitter);
>
> if (isset($_GET['totalRows_Glit ter'])) {
> $totalRows_Glit ter = $_GET['totalRows_Glit ter'];
> } else {
> $all_Glitter = mysql_query($qu ery_Glitter);
> $totalRows_Glit ter = mysql_num_rows( $all_Glitter);
> }
> $totalPages_Gli tter = ceil($totalRows _Glitter/$maxRows_Glitte r)-1;
> ?>
>
> <?php
>
>
> $maxRows_Animal s = 10;
> $pageNum_Animal s = 0;
> if (isset($_GET['pageNum_Animal s'])) {
> $pageNum_Animal s = $_GET['pageNum_Animal s'];
> }
> $startRow_Anima ls = $pageNum_Animal s * $maxRows_Animal s;
>
> mysql_select_db ($database_pigg ybank, $piggybank);
> $query_Animals = "SELECT graphics.owner, graphics.Upload Date,
> graphics.cat, graphics.locati on, graphics.auto FROM graphics where
> `cat` = 'For Girls'";
> $query_limit_An imals = sprintf("%s LIMIT %d, %d", $query_Animals,
> $startRow_Anima ls, $maxRows_Animal s);
> $Animals = mysql_query($qu ery_limit_Anima ls, $piggybank) or
> die(mysql_error ());
> $row_Animals = mysql_fetch_ass oc($Animals);
>
> if (isset($_GET['totalRows_Anim als'])) {
> $totalRows_Anim als = $_GET['totalRows_Anim als'];
> } else {
> $all_Animals = mysql_query($qu ery_Animals);
> $totalRows_Anim als = mysql_num_rows( $all_Animals);
> }
> $totalPages_Ani mals = ceil($totalRows _Animals/$maxRows_Animal s)-1;
>
> mysql_select_db ($database_pigg ybank, $piggybank);
> $query_Glitter = "SELECT graphics.owner, graphics.Upload Date,
> graphics.cat, graphics.locati on, graphics.auto FROM graphics WHERE
> `cat` = 'Glitter'";
> $Glitter = mysql_query($qu ery_Glitter, $piggybank) or
> die(mysql_error ());
> $row_Glitter = mysql_fetch_ass oc($Glitter);
> $totalRows_Glit ter = mysql_num_rows( $Glitter);
> ?>
> <?php include('header .php'); ?>
> <td colspan="3"><h1 ><a href="index.php ">Index</a> - Browse
> Graphics</h1></td></table>
>
> <div class="dotted" id="Layer1" style="position :absolute; width:383px;
> height:153px; z-index:1; left: 470px; top: 112px; background-color:
> #e4e9eb; layer-background-color: #e4e9eb;">
>
> <script language="JavaS cript" type="text/javascript">
> 
> </script>
> <script language="JavaS cript"
> src="http://ypn-js.overture.com/partner/js/ypn.js">
> </script>
> <br>
> <a href="http://www.mytuneslive .com"
> target="_blank" >MyTunesLive.co m<br>
> </a><br>
> Play your MP3 Library from anywhere! You can create a profile, and put
> a flash player in your myspace, friendster or other social site!
> </div>
>
> <?php do { ?><?php do { ?><?php do { ?><?php do { ?>
>
> <table width="950" border="0" align="center">
> <tr>
> <td width="100"><di v align="center"> <a
> href="http://www.picmonkey.c om/MyCode.php?mine =<?php echo
> $row_ForGirls['auto']; ?>"><img src="<?php echo
> $row_ForGirls['location']; ?>" width="100" align="middle"
> border="0"></a></div> </td>
> <td width="100"><di v align="center"> <a
> href="http://www.picmonkey.c om/MyCode.php?mine =<?php echo
> $row_ForBoys['auto']; ?>"><img src="<?php echo
> $row_ForBoys['location']; ?>" width="100" align="middle"
> border="0"></div></td>
> <td width="100"><di v align="center"> <a
> href="http://www.picmonkey.c om/MyCode.php?mine =<?php echo
> $row_Animals['auto']; ?>"><img src="<?php echo
> $row_Animals['location']; ?>" width="100" align="middle"
> border="0"></div></td>
> <td width="387"></td>
> <td colspan="2"><di v align="center"> <a
> href="http://www.picmonkey.c om/MyCode.php?mine =<?php echo
> $row_Glitter['auto']; ?>"><img src="<?php echo
> $row_Glitter['location']; ?>" width="150" align="middle"
> border="0"></div></td>
> </tr>
> <tr>
> <td></td>
> <td></td>
> <td> </td>
> <td> </td>
> <td width="1">&nbsp ;</td>
> <td width="236">&nb sp;</td>
> </tr>
> </table>
> <?php } while ($row_ForGirls = mysql_fetch_ass oc($ForGirls)); ?>
> <?php } while ($row_ForBoys = mysql_fetch_ass oc($ForBoys)); ?>
> <?php } while ($row_Animals = mysql_fetch_ass oc($Animals)); ?>
> <?php } while ($row_Glitter = mysql_fetch_ass oc($Glitter)); ?>
> <table width="950" border="0" align="center">
> <tr>
> <td width="100"><di v align="right">< a href="<?php
> printf("%s?page Num_ForGirls=%d %s", $currentPage,
> min($totalPages _ForGirls, $pageNum_ForGir ls + 1),
> $queryString_Fo rGirls); ?>">View More </a></div></td>
> <td width="100"><di v align="right">< a href="<?php
> printf("%s?page Num_ForBoys=%d% s", $currentPage,
> min($totalPages _ForBoys, $pageNum_ForBoy s + 1), $queryString_Fo rBoys);
> ?>">View More</a></div></td>
> <td width="185">&nb sp;</td>
> <td width="133">&nb sp;</td>
> <td width="240"><di v align="right">< a href="<?php
> printf("%s?page Num_Glitter=%d% s", $currentPage,
> min($totalPages _Glitter, $pageNum_Glitte r + 1), $queryString_Gl itter);
> ?>">View More</a></div></td>
> </tr>
> <tr>
> <td width="100">&nb sp;</td>
> <td width="100">&nb sp;</td>
> <td width="185">&nb sp;</td>
> <td width="133">&nb sp;</td>
> <td width="240">&nb sp;</td>
> </tr>
> </table>
>[/color]

Without going through all of your code, what are you actually getting? And what
do you expect to get that's different?

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

Problem Displaying 10 rows of Different Categories

Problem Displaying 10 rows of Different Categories

Comment

Comment