hey guys,
i am trying to display a list of distributors in this code, but i keep getting this error;
Warning: mysql_fetch_assoc(): 5 is not a valid MySQL result resource in c:\web\htdocs\chroma\testing\distributors.php on line 70
here is the code;
<?php require_once('Connections/Chroma.php'); ?>
<?php
$maxRows_Chroma = 10;
$pageNum_Chroma = 0;
if (isset($_GET['pageNum_Chroma'])) {
$pageNum_Chroma = $_GET['pageNum_Chroma'];
}
$startRow_Chroma = $pageNum_Chroma * $maxRows_Chroma;
mysql_select_db($database_Chroma, $Chroma);
$query_Chroma = "SELECT * FROM distributors";
$chromadate = mysql_query("SELECT date FROM distributors");
$date = mysql_fetch_array($chromadate);
$thedate = date("F d, Y t:i:A");
$query_limit_Chroma = sprintf("%s LIMIT %d, %d", $query_Chroma, $startRow_Chroma, $maxRows_Chroma);
$Chroma = mysql_query($query_limit_Chroma, $Chroma) or die(mysql_error());
$row_Chroma = mysql_fetch_assoc($Chroma);
if (isset($_GET['totalRows_Chroma'])) {
$totalRows_Chroma = $_GET['totalRows_Chroma'];
} else {
$all_Chroma = mysql_query($query_Chroma);
$totalRows_Chroma = mysql_num_rows($all_Chroma);
}
$totalPages_Chroma = ceil($totalRows_Chroma/$maxRows_Chroma)-1;
mysql_free_result($Chroma);
do { ?>
<img src="<?php echo $row_Chroma['logo']; ?>" border="0"> <br />
Company Name : <?php echo $row_Chroma['coname']; ?> <br />
Street Address: <?php echo $row_Chroma['streetaddress']; ?> <br />
Post/Zip code: <?php echo $row_Chroma['postcode']; ?> <br />
Country: <?php echo $row_Chroma['country']; ?> <br />
Phone: <?php echo $row_Chroma['phone']; ?> <br />
Fax: <?php echo $row_Chroma['fax']; ?> <br />
Date Submitted: <?php echo $thedate; ?> <br />
Web Site: <a href="<?php echo $row_Chroma['site']; ?>" target="_blank"><?php echo $row_Chroma['site']; ?></a> <br />
email address: <a href="mailto:<?php echo $row_Chroma['email']; ?>"><?php echo $row_Chroma['email']; ?></a> <br />
Chroma Products Supplied: <br />
<?php
if ($row_Chroma['a2'] == ("Y")){
echo ("A2 <br />"); }
else if ($row_Chroma['a2'] == ("N")){
echo ; }
if ($row_Chroma['atelier'] == ("Y")){
echo ("Atelier <br />"); }
else if ($row_Chroma['atelier'] == ("N")){
echo ; }
if ($row_Chroma['archival'] == ("Y")){
echo ("Archival <br />");}
else if ($row_Chroma['archival'] == ("N")){
echo ; }
if ($row_Chroma['chromaart'] == ("Y")){
echo ("Chroma Art <br />");}
else if ($row_Chroma['chromaart'] == ("N")){
echo ; }
if ($row_Chroma['chromacryl'] == ("Y")){
echo ("Chromacryl <br />");}
else if ($row_Chroma['chromacryl'] == ("N")){
echo ; }
if ($row_Chroma['cromakidz'] == ("Y")){
echo ("Chroma Kidz <br />");}
else if ($row_Chroma['cromakidz'] == ("N")){
echo ; }
if ($row_Chroma['josonjas'] == ("Y")){
echo ("Jo Sonjas <br />");}
else if ($row_Chroma['josonjas'] == ("N")){
echo ; }
?>
<?php } while ($row_Chroma = mysql_fetch_assoc($Chroma)); ?>
Can anybody help me out a bit?
Thanks in advance!
Christian
