Unidentified error occurs when testing a recordset in php dreamweaver mx 2004
hi
my name is Eman . iam a beginner in php language.
iam trying to buid my own web site. i use php and dreamweaver mx2004 .
I build my database using phpmyadmin and i connect my database with dreamweaver , but when i generate a recordset "Unidentified error occurs when testing a recordset in php dreamweaver mx 2004" . Can somebody help me?
First off all i use macromedia dreamweaver mx2004 and appserv 2.6.0
this is acode for a simple page in my site. i build the database using phpmyadmin . Every thing is ok ,but when i generate a recordset . dreamweaver says unidentified error has occurs . please try to help me
with my regarrds
PHP Code:<?php require_once('Connections/nationalex3.php'); ?>
<?php
mysql_select_db($database_nationalex3, $nationalex3);
$query_rsproduct = "SELECT prodName, prodPrice, prodInventory FROM products ORDER BY prodName ASC";
$rsproduct = mysql_query($query_rsproduct, $nationalex3) or die(mysql_error());
$row_rsproduct = mysql_fetch_assoc($rsproduct);
$totalRows_rsproduct = mysql_num_rows($rsproduct);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>National Exasperator Store</title>
<script language="JavaScript" type="text/javascript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<link href="global.css" rel="stylesheet" type="text/css" />
</head>
<body onload="MM_preloadImages('images_global/nav_headline_f2.gif','images_global/nav_horoscope_f2.gif','images_global/nav_quiz_f2.gif','images_global/nav_archive_f2.gif','images_global/nav_home_f2.gif')">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images_global/logo_top.gif" width="247" height="19" /></td>
<td align="right" class="bgGrayGreen"><img src="images_global/cosmo_pub.gif" width="170" height="19" /></td>
</tr>
<tr>
<td><img src="images_global/logo_national1.gif" width="247" height="44" /></td>
<td class="logoCell"><img src="images_global/logo_national2.gif" width="152" height="44" /></td>
</tr>
<tr>
<td width="1" valign="top"><table width="232" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images_global/spacer.gif" width="164" height="1" />
<p class="date">
<script language="JavaScript" type="text/javascript">
document.write(doClock("M0","%20","D0",",%20","Y0"));
</script>
</p></td>
<td><img src="images_global/logo_btm.gif" width="83" height="34" /></td>
</tr>
</table></td>
<td width="100%" class="bgGrayGreen"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('headline','','images_global/nav_headline_f2.gif',1)"><img src="images_global/nav_headline.gif" alt="Headlines" name="headline" width="87" height="34" border="0" id="headline" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('horoscope','','images_global/nav_horoscope_f2.gif',1)"><img src="images_global/nav_horoscope.gif" alt="Horoscopes" name="horoscope" width="108" height="34" border="0" id="horoscope" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('quiz','','images_global/nav_quiz_f2.gif',1)"><img src="images_global/nav_quiz.gif" alt="Quiz" name="quiz" width="54" height="34" border="0" id="quiz" /></a><a href="index.php"><img src="images_global/nav_store_f3.gif" width="64" height="34" border="0" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('archives','','images_global/nav_archive_f2.gif',1)"><img src="images_global/nav_archive.gif" alt="Archives" name="archives" width="82" height="34" border="0" id="archives" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('home','','images_global/nav_home_f2.gif',1)"><img src="images_global/nav_home.gif" alt="Home" name="home" width="58" height="34" border="0" id="home" /></a></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" class="mainSidebar"><h1>Categories</h1>
<h2> </h2>
<p><img src="images/alien_ad.gif" width="155" height="200" /> </p>
<p> </p></td>
<td valign="top"> </td>
<td valign="top" class="mainContent"><h1>National Exasperator Online Store</h1>
<table width="100%" border="0" class="productTable">
<tr>
<th width="48%">Item for Sale </th>
<th width="22%">Price</th>
<th width="30%">Availability</th>
</tr>
<tr>
<td><a></a></td>
<td> </td>
<td></td>
</tr>
</table>
<p> </p></td>
</tr>
<tr>
<td width="1" class="mainSidebar"><img src="images_global/spacer.gif" width="165" height="1" /></td>
<td><img src="images_global/spacer.gif" width="15" height="8" /></td>
<td width="100%"><p> </p>
<p class="copyright">Copyright 2003, Sawyer McFarland Media, Inc. </p></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsproduct);
?>
CSS Codes
Reply With Quote
Bookmarks