Help customizing a datafeed for Zen Cart

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="