help needed on a mysql query

[pldtm]

here is my code :

<?php

if ($prod = tep_db_query("select p.products_id, pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id='34' and p.products_id = pd.products_id "))

 $featured_prod = "Les configurations Net Micro";

 $featured_info = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $prod["products_id"], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . $prod['products_image'], $prod['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $prod['products_id'], 'NONSSL'. '">' . $prod['products_name']) . '</a>';



 $info_box_contents = array();

 $info_box_contents[] = array('align' => 'left',

                                      'text' => $featured_prod );



  new infoboxheading($info_box_contents, false, false);



 $info_box_contents = array();

 $info_box_contents[] = array('align' => 'left',

                               'text' => $featured_info );

 new infobox2($info_box_contents);

?>

[Guest]

Ok......Is it broken? What do you want the code to accomplish?

[pldtm]

ok i wan't to display an image of a specific product with the id of 34 in the main page with the link for product info page. And here the only thing that appears in the middle of my page is the mysql message.

I want to put my link in mattice contrib mainpage.php.

 

pldtm

[pldtm]

here is my error message:

 

Error!

 

Unable to determine connection method on a link!

 

Known methods: NONSSL SSL

 

 

 

 

 

 

pldtm

[jon_l]

$prod['products_id'], 'NONSSL'. '">' . $prod['products_name'])

 

Its not because there's a ' ' (space) missing after the 'NONSSL' is it?

 

I might be talking complete rubbish though, I'm not sure how fussy PHP is.

 

Jon.

[pldtm]

i don't know, i'll try tomorrow.

 

thank's

 

 

 

pldtm

[pldtm]

i found the solution but thanks a lot