Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Front-End Pages

View all replies to this thread

Front-End Pages

Thread began 12/25/2011 5:36 pm by Php | Last modified 1/09/2012 6:14 am by Php | 1962 views | 22 replies

1/08/2012 2:29 pmIan S

Hi,

As I suspected you have three recordsets on the page all with the same name.

The first one is correct, but it is being overridden by the next two.

Delete the last two as per the text below...

$query_rsProductDetails = "SELECT ProductID, ProductName, ProductPrice, ProductWeight, ProductLongDesc, ProductImage FROM products";
$rsProductDetails = mysql_query($query_rsProductDetails, $db395605499) or die(mysql_error());
$row_rsProductDetails = mysql_fetch_assoc($rsProductDetails);
$totalRows_rsProductDetails = mysql_num_rows($rsProductDetails);
$query_rsProductDetails = "SELECT ProductID, ProductName, ProductPrice, ProductWeight, ProductLongDesc, ProductImage FROM products";
$rsProductDetails = mysql_query($query_rsProductDetails, $db395605499) or die(mysql_error());
$row_rsProductDetails = mysql_fetch_assoc($rsProductDetails);
$totalRows_rsProductDetails = mysql_num_rows($rsProductDetails);

Thanks
Ian

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.