Hi

Wasn't quite sure where to post this but I'm trying to customize a datafeed so that it works for Zen Cart.

If possible can someone help custom the code below so it will work for Zen Cart:

<?
//*** ESTABLISH CONNECTION TO MYSQL DATABASE ***
$mysql_conn=mysql_connect("localhost", "username", "password") or die("Could not connect to database!");
mysql_select_db("database_name") or die("Could not select database!");
//*** DEFINE THE NAMES OF THE TABLES IN MY DATABASE ***
$products_table="products";
$category_table="categories";
//*** DEFINE THE NAMES OF THE FIELDS IN MY DATABASE ***
$upc_field="upc";
$product_code_field="product_code"; //TIP: Set this Field to your Product's Unique PRIMARY KEY Field
$product_url_field="product_url";
$product_name_field="product_name";
$product_description_field="product_description";
$image_url_field="image_url"; //The URL of the Product Thumbnail Image
$category_id_field="category_id"; //The name of the Category_ID Field in your 'Products' Table
$cat_id_field="cat_id"; //The name of the Unique PRIMARY KEY Field in your 'Categories' Table
$category_field="category"; //The name of the Category_Name Field in your 'Categories' Table
$price_field="price";
$shipping_field="shipping";
$stock_field="stock";

//=== CREATE DATA FEED ===
$datafeed_content="";
//LOOP THROUGH PRODUCTS
$mysql_query="SELECT * FROM $products_table";
$result_data=mysql_query($mysql_query) or die("Failed to retrieve Product Data from Table '$products_table': ".mysql_error());
while($data_array=mysql_fetch_array($result_data)) {
if($upc_field!="") { $upc=strip_tags($data_array["$upc_field"]); } else { $upc=""; }
$product_code=strip_tags($data_array["$product_code_field"]);
$product_url=strip_tags($data_array["$product_url_field"]);
$product_name=strip_tags($data_array["$product_name_field"]);
$product_description=strip_tags($data_array["$product_description_field"]);
$image_url=strip_tags($data_array["$image_url_field"]);
$category_id=strip_tags($data_array["$category_id_field"]);
$price=strip_tags($data_array["$price_field"]);
if($shipping_field!="") { $shipping=strip_tags($data_array["$shipping_field"]); } else { $shipping=""; }
if($stock_field!="") { $stock=strip_tags($data_array["$stock_field"]); } else { $stock=""; }
//RETREIVE CATEGORY NAME FROM THE 'CATEGORIES' TABLE
$mysql_query2="SELECT $category_field FROM $category_table WHERE $cat_id_field='$category_id'";
$result_data2=mysql_query($mysql_query2) or die("Failed to retrieve Category Name from Table '$category_table': ".mysql_error());
$data_array2=mysql_fetch_array($result_data2);
$category_name=strip_tags($data_array2["$category_field"]);
//REMOVE UNWANTED CHARACTERS FROM FIELDS
$upc=trim(eregi_replace("[^[:alnum:]]","",$upc)); //REMOVE NON-ALPHANUMERIC CHARACTERS
$product_code=trim(eregi_replace("[^[:alnum:] -]","",$product_code)); //REMOVE NON-ALPHANUMERIC CHARACTERS WITH EXCEPTION OF 'HYPHEN'
$product_url="