By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,215 Members | 1,920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,215 IT Pros & Developers. It's quick & easy.

Problem Displaying 10 rows of Different Categories

P: n/a
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_ForBoys = 10;
$pageNum_ForBoys = 0;
if (isset($_GET['pageNum_ForBoys'])) {
$pageNum_ForBoys = $_GET['pageNum_ForBoys'];
}
$startRow_ForBoys = $pageNum_ForBoys * $maxRows_ForBoys;

mysql_select_db($database_piggybank, $piggybank);
$query_ForBoys = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics
where `cat` = 'For Guys'";
$ForBoys = mysql_query($query_ForBoys, $piggybank) or
die(mysql_error());
$row_ForBoys = mysql_fetch_assoc($ForBoys);
$totalRows_ForBoys = mysql_num_rows($ForBoys);

if (isset($_GET['totalRows_ForBoys'])) {
$totalRows_ForBoys = $_GET['totalRows_ForBoys'];
} else {
$all_ForBoys = mysql_query($query_ForBoys);
$totalRows_ForBoys = mysql_num_rows($all_ForBoys);
}
$totalPages_ForBoys = ceil($totalRows_ForBoys/$maxRows_ForBoys)-1;

//2

$maxRows_ForGirls = 10;
$pageNum_ForGirls = 0;
if (isset($_GET['pageNum_ForGirls'])) {
$pageNum_ForGirls = $_GET['pageNum_ForGirls'];
}
$startRow_ForGirls = $pageNum_ForGirls * $maxRows_ForGirls;

mysql_select_db($database_piggybank, $piggybank);
$query_ForGirls = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics where
`cat` = 'For Girls'";
$query_limit_ForGirls = sprintf("%s LIMIT %d, %d", $query_ForGirls,
$startRow_ForGirls, $maxRows_ForGirls);
$ForGirls = mysql_query($query_limit_ForGirls, $piggybank) or
die(mysql_error());
$row_ForGirls = mysql_fetch_assoc($ForGirls);

if (isset($_GET['totalRows_ForGirls'])) {
$totalRows_ForGirls = $_GET['totalRows_ForGirls'];
} else {
$all_ForGirls = mysql_query($query_ForGirls);
$totalRows_ForGirls = mysql_num_rows($all_ForGirls);
}
$totalPages_ForGirls = ceil($totalRows_ForGirls/$maxRows_ForGirls)-1;

mysql_select_db($database_piggybank, $piggybank);
$query_Animals = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics WHERE
`cat` = 'Animals'";
$Animals = mysql_query($query_Animals, $piggybank) or
die(mysql_error());
$row_Animals = mysql_fetch_assoc($Animals);
$totalRows_Animals = mysql_num_rows($Animals);

mysql_select_db($database_piggybank, $piggybank);
$query_Cartoons = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics WHERE
`cat` = 'Cartoons'";
$Cartoons = mysql_query($query_Cartoons, $piggybank) or
die(mysql_error());
$row_Cartoons = mysql_fetch_assoc($Cartoons);
$totalRows_Cartoons = mysql_num_rows($Cartoons);

$queryString_ForGirls = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_ForGirls") == false &&
stristr($param, "totalRows_ForGirls") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_ForGirls = "&" . htmlentities(implode("&",
$newParams));
}
}
$queryString_ForGirls = sprintf("&totalRows_ForGirls=%d%s",
$totalRows_ForGirls, $queryString_ForGirls);

//column 3

$maxRows_Glitter = 10;
$pageNum_Glitter = 0;
if (isset($_GET['pageNum_Glitter'])) {
$pageNum_Glitter = $_GET['pageNum_Glitter'];
}
$startRow_Glitter = $pageNum_Glitter * $maxRows_Glitter;

mysql_select_db($database_piggybank, $piggybank);
$query_Glitter = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics
where `cat` = 'Glitter'";
$Glitter = mysql_query($query_Glitter, $piggybank) or
die(mysql_error());
$row_Glitter = mysql_fetch_assoc($Glitter);
$totalRows_Glitter = mysql_num_rows($Glitter);

if (isset($_GET['totalRows_Glitter'])) {
$totalRows_Glitter = $_GET['totalRows_Glitter'];
} else {
$all_Glitter = mysql_query($query_Glitter);
$totalRows_Glitter = mysql_num_rows($all_Glitter);
}
$totalPages_Glitter = ceil($totalRows_Glitter/$maxRows_Glitter)-1;
?>

<?php
$maxRows_Animals = 10;
$pageNum_Animals = 0;
if (isset($_GET['pageNum_Animals'])) {
$pageNum_Animals = $_GET['pageNum_Animals'];
}
$startRow_Animals = $pageNum_Animals * $maxRows_Animals;

mysql_select_db($database_piggybank, $piggybank);
$query_Animals = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics where
`cat` = 'For Girls'";
$query_limit_Animals = sprintf("%s LIMIT %d, %d", $query_Animals,
$startRow_Animals, $maxRows_Animals);
$Animals = mysql_query($query_limit_Animals, $piggybank) or
die(mysql_error());
$row_Animals = mysql_fetch_assoc($Animals);

if (isset($_GET['totalRows_Animals'])) {
$totalRows_Animals = $_GET['totalRows_Animals'];
} else {
$all_Animals = mysql_query($query_Animals);
$totalRows_Animals = mysql_num_rows($all_Animals);
}
$totalPages_Animals = ceil($totalRows_Animals/$maxRows_Animals)-1;

mysql_select_db($database_piggybank, $piggybank);
$query_Glitter = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics WHERE
`cat` = 'Glitter'";
$Glitter = mysql_query($query_Glitter, $piggybank) or
die(mysql_error());
$row_Glitter = mysql_fetch_assoc($Glitter);
$totalRows_Glitter = 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="JavaScript" type="text/javascript">
<!--
ctxt_ad_partner = "1066315875";
ctxt_ad_section = "29578";
ctxt_ad_bg = "";
ctxt_ad_width = 336;
ctxt_ad_height = 280;
ctxt_ad_bc = "e4e9eb";
ctxt_ad_cc = "e4e9eb";
ctxt_ad_lc = "543d25";
ctxt_ad_tc = "000000";
ctxt_ad_uc = "999999";
// -->
</script>
<script language="JavaScript"
src="http://ypn-js.overture.com/partner/js/ypn.js">
</script>
<br>
<a href="http://www.mytuneslive.com"
target="_blank">MyTunesLive.com<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"><div align="center"> <a
href="http://www.picmonkey.com/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"><div align="center"> <a
href="http://www.picmonkey.com/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"><div align="center"> <a
href="http://www.picmonkey.com/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"><div align="center"> <a
href="http://www.picmonkey.com/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>&nbsp;</td>
<td>&nbsp;</td>
<td width="1">&nbsp;</td>
<td width="236">&nbsp;</td>
</tr>
</table>
<?php } while ($row_ForGirls = mysql_fetch_assoc($ForGirls)); ?>
<?php } while ($row_ForBoys = mysql_fetch_assoc($ForBoys)); ?>
<?php } while ($row_Animals = mysql_fetch_assoc($Animals)); ?>
<?php } while ($row_Glitter = mysql_fetch_assoc($Glitter)); ?>
<table width="950" border="0" align="center">
<tr>
<td width="100"><div align="right"><a href="<?php
printf("%s?pageNum_ForGirls=%d%s", $currentPage,
min($totalPages_ForGirls, $pageNum_ForGirls + 1),
$queryString_ForGirls); ?>">View More </a></div></td>
<td width="100"><div align="right"><a href="<?php
printf("%s?pageNum_ForBoys=%d%s", $currentPage,
min($totalPages_ForBoys, $pageNum_ForBoys + 1), $queryString_ForBoys);
?>">View More</a></div></td>
<td width="185">&nbsp;</td>
<td width="133">&nbsp;</td>
<td width="240"><div align="right"><a href="<?php
printf("%s?pageNum_Glitter=%d%s", $currentPage,
min($totalPages_Glitter, $pageNum_Glitter + 1), $queryString_Glitter);
?>">View More</a></div></td>
</tr>
<tr>
<td width="100">&nbsp;</td>
<td width="100">&nbsp;</td>
<td width="185">&nbsp;</td>
<td width="133">&nbsp;</td>
<td width="240">&nbsp;</td>
</tr>
</table>

Mar 27 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I meant 3 or 4 rows! Same Table, different value in `cat` field

Mar 27 '06 #2

P: n/a
ameshkin wrote:
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_ForBoys = 10;
$pageNum_ForBoys = 0;
if (isset($_GET['pageNum_ForBoys'])) {
$pageNum_ForBoys = $_GET['pageNum_ForBoys'];
}
$startRow_ForBoys = $pageNum_ForBoys * $maxRows_ForBoys;

mysql_select_db($database_piggybank, $piggybank);
$query_ForBoys = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics
where `cat` = 'For Guys'";
$ForBoys = mysql_query($query_ForBoys, $piggybank) or
die(mysql_error());
$row_ForBoys = mysql_fetch_assoc($ForBoys);
$totalRows_ForBoys = mysql_num_rows($ForBoys);

if (isset($_GET['totalRows_ForBoys'])) {
$totalRows_ForBoys = $_GET['totalRows_ForBoys'];
} else {
$all_ForBoys = mysql_query($query_ForBoys);
$totalRows_ForBoys = mysql_num_rows($all_ForBoys);
}
$totalPages_ForBoys = ceil($totalRows_ForBoys/$maxRows_ForBoys)-1;

//2

$maxRows_ForGirls = 10;
$pageNum_ForGirls = 0;
if (isset($_GET['pageNum_ForGirls'])) {
$pageNum_ForGirls = $_GET['pageNum_ForGirls'];
}
$startRow_ForGirls = $pageNum_ForGirls * $maxRows_ForGirls;

mysql_select_db($database_piggybank, $piggybank);
$query_ForGirls = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics where
`cat` = 'For Girls'";
$query_limit_ForGirls = sprintf("%s LIMIT %d, %d", $query_ForGirls,
$startRow_ForGirls, $maxRows_ForGirls);
$ForGirls = mysql_query($query_limit_ForGirls, $piggybank) or
die(mysql_error());
$row_ForGirls = mysql_fetch_assoc($ForGirls);

if (isset($_GET['totalRows_ForGirls'])) {
$totalRows_ForGirls = $_GET['totalRows_ForGirls'];
} else {
$all_ForGirls = mysql_query($query_ForGirls);
$totalRows_ForGirls = mysql_num_rows($all_ForGirls);
}
$totalPages_ForGirls = ceil($totalRows_ForGirls/$maxRows_ForGirls)-1;

mysql_select_db($database_piggybank, $piggybank);
$query_Animals = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics WHERE
`cat` = 'Animals'";
$Animals = mysql_query($query_Animals, $piggybank) or
die(mysql_error());
$row_Animals = mysql_fetch_assoc($Animals);
$totalRows_Animals = mysql_num_rows($Animals);

mysql_select_db($database_piggybank, $piggybank);
$query_Cartoons = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics WHERE
`cat` = 'Cartoons'";
$Cartoons = mysql_query($query_Cartoons, $piggybank) or
die(mysql_error());
$row_Cartoons = mysql_fetch_assoc($Cartoons);
$totalRows_Cartoons = mysql_num_rows($Cartoons);

$queryString_ForGirls = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_ForGirls") == false &&
stristr($param, "totalRows_ForGirls") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_ForGirls = "&" . htmlentities(implode("&",
$newParams));
}
}
$queryString_ForGirls = sprintf("&totalRows_ForGirls=%d%s",
$totalRows_ForGirls, $queryString_ForGirls);

//column 3

$maxRows_Glitter = 10;
$pageNum_Glitter = 0;
if (isset($_GET['pageNum_Glitter'])) {
$pageNum_Glitter = $_GET['pageNum_Glitter'];
}
$startRow_Glitter = $pageNum_Glitter * $maxRows_Glitter;

mysql_select_db($database_piggybank, $piggybank);
$query_Glitter = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics
where `cat` = 'Glitter'";
$Glitter = mysql_query($query_Glitter, $piggybank) or
die(mysql_error());
$row_Glitter = mysql_fetch_assoc($Glitter);
$totalRows_Glitter = mysql_num_rows($Glitter);

if (isset($_GET['totalRows_Glitter'])) {
$totalRows_Glitter = $_GET['totalRows_Glitter'];
} else {
$all_Glitter = mysql_query($query_Glitter);
$totalRows_Glitter = mysql_num_rows($all_Glitter);
}
$totalPages_Glitter = ceil($totalRows_Glitter/$maxRows_Glitter)-1;
?>

<?php
$maxRows_Animals = 10;
$pageNum_Animals = 0;
if (isset($_GET['pageNum_Animals'])) {
$pageNum_Animals = $_GET['pageNum_Animals'];
}
$startRow_Animals = $pageNum_Animals * $maxRows_Animals;

mysql_select_db($database_piggybank, $piggybank);
$query_Animals = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics where
`cat` = 'For Girls'";
$query_limit_Animals = sprintf("%s LIMIT %d, %d", $query_Animals,
$startRow_Animals, $maxRows_Animals);
$Animals = mysql_query($query_limit_Animals, $piggybank) or
die(mysql_error());
$row_Animals = mysql_fetch_assoc($Animals);

if (isset($_GET['totalRows_Animals'])) {
$totalRows_Animals = $_GET['totalRows_Animals'];
} else {
$all_Animals = mysql_query($query_Animals);
$totalRows_Animals = mysql_num_rows($all_Animals);
}
$totalPages_Animals = ceil($totalRows_Animals/$maxRows_Animals)-1;

mysql_select_db($database_piggybank, $piggybank);
$query_Glitter = "SELECT graphics.owner, graphics.UploadDate,
graphics.cat, graphics.location, graphics.auto FROM graphics WHERE
`cat` = 'Glitter'";
$Glitter = mysql_query($query_Glitter, $piggybank) or
die(mysql_error());
$row_Glitter = mysql_fetch_assoc($Glitter);
$totalRows_Glitter = 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="JavaScript" type="text/javascript">
<!--
ctxt_ad_partner = "1066315875";
ctxt_ad_section = "29578";
ctxt_ad_bg = "";
ctxt_ad_width = 336;
ctxt_ad_height = 280;
ctxt_ad_bc = "e4e9eb";
ctxt_ad_cc = "e4e9eb";
ctxt_ad_lc = "543d25";
ctxt_ad_tc = "000000";
ctxt_ad_uc = "999999";
// -->
</script>
<script language="JavaScript"
src="http://ypn-js.overture.com/partner/js/ypn.js">
</script>
<br>
<a href="http://www.mytuneslive.com"
target="_blank">MyTunesLive.com<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"><div align="center"> <a
href="http://www.picmonkey.com/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"><div align="center"> <a
href="http://www.picmonkey.com/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"><div align="center"> <a
href="http://www.picmonkey.com/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"><div align="center"> <a
href="http://www.picmonkey.com/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>&nbsp;</td>
<td>&nbsp;</td>
<td width="1">&nbsp;</td>
<td width="236">&nbsp;</td>
</tr>
</table>
<?php } while ($row_ForGirls = mysql_fetch_assoc($ForGirls)); ?>
<?php } while ($row_ForBoys = mysql_fetch_assoc($ForBoys)); ?>
<?php } while ($row_Animals = mysql_fetch_assoc($Animals)); ?>
<?php } while ($row_Glitter = mysql_fetch_assoc($Glitter)); ?>
<table width="950" border="0" align="center">
<tr>
<td width="100"><div align="right"><a href="<?php
printf("%s?pageNum_ForGirls=%d%s", $currentPage,
min($totalPages_ForGirls, $pageNum_ForGirls + 1),
$queryString_ForGirls); ?>">View More </a></div></td>
<td width="100"><div align="right"><a href="<?php
printf("%s?pageNum_ForBoys=%d%s", $currentPage,
min($totalPages_ForBoys, $pageNum_ForBoys + 1), $queryString_ForBoys);
?>">View More</a></div></td>
<td width="185">&nbsp;</td>
<td width="133">&nbsp;</td>
<td width="240"><div align="right"><a href="<?php
printf("%s?pageNum_Glitter=%d%s", $currentPage,
min($totalPages_Glitter, $pageNum_Glitter + 1), $queryString_Glitter);
?>">View More</a></div></td>
</tr>
<tr>
<td width="100">&nbsp;</td>
<td width="100">&nbsp;</td>
<td width="185">&nbsp;</td>
<td width="133">&nbsp;</td>
<td width="240">&nbsp;</td>
</tr>
</table>

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.
js*******@attglobal.net
==================
Mar 29 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.