NicePHP77

Awesome!!! I changed code as you mentioned above AND deleted all thumbs in the kissmt directory so it would regen them and it works great now! Thanks!!!!

yes, the shop by brand. i think it reloads each time you refresh, you just caught a page where the images were all showing. but it doesn't always work, some show and some don't even tho there are images for the manufactures of one's that don't show.

i tried to change the code above with the suggesitons, but the images missing still show. you can see the site at discounters paradise dot com. i am complete noob to php advanced so I am not sure about defining...

I still couldn't get it to work, any suggestions?

Have a feature on our cart that allows a scrolling banner, but since upgrade to php5, the images aren't showing. Here is scrollinghead file which is followed by main php file, any suggestions would greatly help! <script type="text/javascript" src="includes/carousel/jquery.js"></script> <script type="text/javascript" src="includes/carousel/jquery.carouFredSel.js"></script> <script type="text/javascript" language="javascript"> $(document).ready(function(){ $("#image_carousel2").carouFredSel({ circular: true, infinite: true, auto : true, height : <?echo ($brands_image_size);?>, items: { width : <?echo ($brands_image_size+4);?>, height : <?echo ($brands_image_size);?>, }, scroll: { items: <?echo ceil( (1/($brands_image_size+4))*1000);?>, fx: "<?echo $brands_box_effect;?>", duration: 750, pauseOnHover: 3000 }, }); }); </script> <STYLE> .image_carousel2 { padding: 15px 0 15px 40px; position: relative; } .image_carousel2 img { border: 1px solid #ccc; background-color: white; padding: 9px; margin: 7px; display: block; float: left; } .clearfix { float: none; clear: both; } </STYLE> ------------------------- BELOW IS OTHER MAIN FILE <? $brands_image_size= 80; $brands_box_bkcolor = "#EEEEEE"; $brands_box_effect = "scroll"; require(DIR_WS_INCLUDES . 'scrollingbrandshead.php'); $num_brands_query = "select `manufacturers_id` from `manufacturers`;"; $num_brands_result = mysql_query($num_brands_query); $num_brands = mysql_num_rows($num_brands_result); $display_brands_query = "select manufacturers_id,manufacturers_name,manufacturers_image from manufacturers where manufacturers_image != '' ORDER BY RAND() Limit 18;"; $display_brands_result = mysql_query($display_brands_query); $num_brands_with_images = mysql_num_rows($display_brands_result); ?> <?php if($num_brands_with_images >3){ ?> <div class="ui-widget-content ui-corner-all infoBoxContents"> <table cellspacing=4 cellpadding=4 height=<?echo ($brands_image_size+4);?> width=100% align=center style="background-color:<?echo $brands_box_bkcolor;?>"> <tr> <td> <a href=allmanufacturers.php?<?echo tep_session_name().'='. tep_session_id();?>><span style="color:<? echo MENU_ITEM_COLOR;?>; font-size:17px; font-weight:bold;">Shop by<br />Brand</span></a> </td> <td align=center> <div class="image_carousel"> <div id="image_carousel2" style="background-color:#<?echo $brands_box_bkcolor;?>"> <? while($display_brands_row = mysql_fetch_array($display_brands_result)){ if(file_exists(DIR_WS_IMAGES . $display_brands_row['manufacturers_image']) && $display_brands_row['manufacturers_image'] != ""){ echo "<span style='background-color:#FFFFFF; border:1px solid #BBBBBB; ;height:".($brands_image_size-2)."px; width:".($brands_image_size+2)."px; float: left; display:inline-block; vertical-align:middle;'>"; //div content echo "<a HREF=index.php?manufacturers_id=" . $display_brands_row['manufacturers_id'] . "><table valign=center align=center width=100% height=100%><tr><Td align=center>"; echo tep_image(DIR_WS_IMAGES . $display_brands_row['manufacturers_image'], $display_brands_row['manufacturers_name'], ($brands_image_size-4),($brands_image_size- ,'style=" float:left; display:inline-block vertical-align:middle"' ); echo "</td></tr></table></a>"; echo "</span>"; } } ?> </div> <div class="clearfix"></div> </div> </td> </tr> </table> </div> <? }?>

Thanks, i did those changes and noticed a database error - strange. In looking further this files calls several other php files, it seems the guy that coded this didn't keep it up with strict standards and its hosed...need to hire it out to correct, its a pretty complicated datafeed pull, push, etc.

Thanks. Hard-coded it to this: $limit=50000; $q = "select * from table_name"; // $q = "select * from " . $src; $r = mysql_query($q); while(($ar = mysql_fetch_array($r, MYSQL_ASSOC)) && $limit > 0 ){ <---------------------------------------------------------- LINE 43 //start $newsql = "REPLACE into " . $dbtable ." "; $newsql .= "(v_products_model,v_products_name_1,v_products_description_1,v_products_image,v_product_upc,v_products_price,v_products_quantity,v_products_weight,v_categories_name_1_1,v_categories_name_2_1,v_categories_name_3_1,v_categories_name_4_1,v_categories_name_5_1,v_categories_name_6_1,v_categories_name_7_1,v_manufacturers_name,v_status,v_products_tax_class_id,EOREOR)"; $newsql .= " VALUES ("; //Model $newsql .= "'" . $ar['SKURcrd'] . "', "; ERROR: mysql_fetch_array() expects parameter 1 to be resource, boolean given in ... on line 43 (indicated above) Looking for any side work?

Thank you!! I am a complete noob when it comes to rewriting code. This was written for us and worked well until a php5 upgrade seems a bit stricter. Any suggestions how to fix this code so it works? thanks for any help you can give!!

Not sure how to correct this error, searched the forums, but couldn't find solution: $conn=mysql_connect ($dbhost, $dbuser, $dbpass) or die ("I cannot connect to the database because: " . mysql_error()); mysql_select_db($dbname) or die("Unable to select database because: " . mysql_error()); mysql_query("DROP TABLE `grn_gemcart_data`"); $sql = "CREATE TABLE IF NOT EXISTS " . $dbtable . " ("; $sql .= "v_products_model varchar(24), "; $sql .= "PRIMARY KEY(v_products_model), "; $sql .= "v_products_name_1 varchar(64), "; $sql .= "v_products_description_1 TEXT, "; $sql .= "v_products_image varchar(30), "; $sql .= "v_product_upc INT, "; $sql .= "v_products_price varchar(10), "; $sql .= "v_products_quantity INT, "; $sql .= "v_products_weight varchar(10), "; $sql .= "v_categories_name_1_1 varchar(255), "; $sql .= "v_categories_name_2_1 varchar(255), "; $sql .= "v_categories_name_3_1 varchar(255), "; $sql .= "v_categories_name_4_1 varchar(255), "; $sql .= "v_categories_name_5_1 varchar(255), "; $sql .= "v_categories_name_6_1 varchar(255), "; $sql .= "v_categories_name_7_1 varchar(255), "; $sql .= "v_manufacturers_name varchar(50), "; $sql .= "v_manufacturers_image varchar(50), "; $sql .= "v_status TINYINT, "; $sql .= "v_products_tax_class_id TINYINT, "; $sql .= "EOREOR varchar(10)"; $sql .= ");"; mysql_query($sql); $limit=50000; $q = "select * from " . $src; $r = mysql_query($q); while(($ar = mysql_fetch_array($r, MYSQL_ASSOC)) && $limit > 0 ){ //start $newsql = "REPLACE into " . $dbtable ." "; $newsql .= "(v_products_model,v_products_name_1,v_products_description_1,v_products_image,v_product_upc,v_products_price,v_products_quantity,v_products_weight,v_categories_name_1_1,v_categories_name_2_1,v_categories_name_3_1,v_categories_name_4_1,v_categories_name_5_1,v_categories_name_6_1,v_categories_name_7_1,v_manufacturers_name,v_status,v_products_tax_class_id,EOREOR)"; $newsql .= " VALUES (";