Problem Displaying 10 rows of Different Categories

ameshkin

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>

Mar 27 '06 #1

Subscribe Reply

1456

ameshkin

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

Mar 27 '06 #2

Jerry Stuckle

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_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>

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*******@attgl obal.net
=============== ===

Mar 29 '06 #3

Similar topics

968

selecting information from two tables (problem)

by: Shaun | last post by:

What I am trying to do is select all the rows out of the categories table (see below) and select the sum of j_amount out of the judgment table. Right now it is only returning the categories that are in the judgment table. I want it to return those fields with the amounts out of the judgment table, but also the all the other categories from the categories table with 0 as there amount. Does anyone have a suggestion. select...

PostgreSQL Database

1724

Displaying records

by: Fronky | last post by:

Hope someone can help. I am still learning, so no laughing please. I am displaying records from a database using Response.Write(""); instead of the usual datagrid method. I am doing it this way to achieve the result I require. However. Since I have added a button to the screen, and have had to include the "object sender, System.EventArgs e", the Response.Write code has been appearing within the Documents_Table(null,null); tag on the...

C# / C Sharp

1202

Displaying subcategories

by: Manuel | last post by:

If I have 2 tables CATEGORIES and PRODUCTS. What's the most "elegant" way (in programming terms) of displaying all the Categories with it's Products on a web page? I would like to show a list or table like: -Cat1 -----Product1 -----Product2 -----Product3

ASP.NET

1350

Datagrid colum sorting problem - URGENT

by: Bill Nguyen | last post by:

I found that rows in datagrid can be sorted by clicking on the column header. However, this doesn't refresh the .currentindex DataGrid1.CurrentCell.RowNumber I need either to disable colum sorting programmatcially or somehow refresh the DataGrid1.CurrentCell.RowNumber index so that it will reflect the correct rownumber.

Visual Basic .NET

9774

MySql UPDATE problem with duplicate rows

by: Jon Maz | last post by:

Hi, I have a MySql problem I hope someone can help me with. I'm trying to run an update on a linking table, the update is running into a Primary Key constraint violation, and in my workaround I've got stuck trying to write a DELETE statement. Here's the table I'm working on: CREATE TABLE `articles_categories` (

MySQL Database

1825

problem w/ duplicates

by: Mark | last post by:

Let's say I have a table of users, and each user has a list of categories. I could store each user's categories as TEXT with delimeters like "cat1|cat2|cat3" But then I need to be able to get a full list of everyone's categories, without duplicates. Retrieving all the categories, exploding them, and then removing the duplicates is a bit slow. Is there a better method?

MySQL Database

3868

displaying categories/subcategories using modified preorder tree transversal

by: hornedw | last post by:

I have been working on a ecommerce website for myself. What I needed some assistance on was when i was trying to display the categories/subcategories for the different products. I decided to use the modified preorder tree transversal algorithm. What I wanted was on the first page is to display the catogories as follows Books (35) Electronics(23) The number inside the parenthesis being the number of products in that

PHP

3058

Problem with Multiple-step OLE DB operation generated errors

by: dhyder | last post by:

OK, like the title says my error is Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I have looked into this a lot, but have not been able to find a solution to it. <%@ Page Language="c#" runat="server" debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script runat="server"> OleDbConnection conn = new...

.NET Framework

1228