issue running custom query

[DrByte]

Got it working except for i'm now trying to grab/match the product Id for those products whose image has a large version. Of course, the large images directory contains many images for which there directly are no products (as some prods have multiple images and the naming convention for those will not match up - and some images may exist where a product has been deleted or not yet created ...but that's okay) I only need to find the prod id for those images that have a valid matching database entry.

You'll probably have to work your logic backwards. Prepare an array of images and product IDs. Then do your matching from the other angle.

Either that or you'll have to find a way to do a progressively-less-restrictive lookup, since the "LIKE" clause can't match on less than what you give it ... and as you know, the additional-image files are longer than the original product image base filename, and are of varying lengths.

[stride-r]

Okay, thanks. I think I get what you're saying. I also realize that making a new db query for each pass through the loop wasn't the most sane way to accomplish this either.

However, i'm still having an issue getting the right query results.

I've taken a step backwards and am now trying to get just an array of prod ids. Sounds simple enough ...but it's not working for me. Here's what I have:

  $prodIds_query = "SELECT p.products_id FROM " . TABLE_PRODUCTS . " p WHERE p.products_status = '1'";
  
  $myProdIds = $db->Execute($prodIds_query);
  
  echo "Array count: " . count($myProdIds) . "<br /><br />";

  foreach ($myProdIds as $idsValues){
     echo "Array values: " . $idsValues . "<br />";
  } 

The result of running the above is this seemingly (to me anyway ) odd reply:
Array count: 1

Array values:
Array values: Resource id #303
Array values: 0
Array values:
Array values: Array


Its retrieving a recordset of 1 ....yet I can view the 13 products currently loaded into my localhost demo/test Zen Cart store. Furthermore, if I copy/paste this same query into MySQL Query Browser, it displays the correct 13 records.

Any thoughts on what I'm doing wrong in trying to get at it from within Zen Cart itself???

[stride-r]

Also, I ran a print_r($myProdIds) on the above mentioned array and it spits out this:

queryFactoryResult Object ( [is_cached] => [resource] => Resource id #303 [cursor] => 0 [EOF] => [fields] => Array ( [products_id] => 1 ) )

Still not sure what it means.

[yellow1912]

$myProdIds is an object, not an array

you have to do this

while(!$myProdIds->EOF){

//do whatever
echo $myProdIds->fields['products_id'];
$myProdIds->MoveNext();
}

[stride-r]

Ah, okay ... thanks for enlightening he who was in the dark! ...if only i'd examined the code in one of the zen cart files!!!

Anyway, now it works like a charm! Thanks again for everyones help.