I had imported my old oscommerce site with 15000 produts for magento! But unfortably, the thumbnails are dont defined automatically http://imgur.com/cNdXd i can do maually, but 15000 produts is a larg number and i need sped a big amout of…
I'm quite a new php programmer and cannot seem to figure out where I'm going wrong with inserting records into my MySQL database: My test script (for learning purpose) calls the eBay API and downloads the requested information into the…
I have registered a domain using some web hosting website and I logged into parallels plesk panel,I have uploaded my pages onto it but unable to connect to database does anyone know what would be three parameters would be? $con…
I am having difficulties because of the database structure on a game website similar to http://box10.com. I attempted to change table structure a bit but I made it worse, and now I must not do another mistake to keep my…
I'm about to launch a few online stores and I would like to share my thoughts so everyone can benefit and also was wondering about your opinion related to the question: open-source eCommerce vs custom built. I've been exploring some…
I am using oscommerce so you might need an understanding of it to answer this but I don't think so it is pretty general. Why would the original programmers create functions to do basic sql queries like this: function tep_db_query($query,…
I have found stripslashes function but I would rather find where I am adding more slashes than I should. My functions use mysql_real_escape_string once for each variable and I am querying database using "insert into foo(bar,bar) values($baz,$baz)" maybe this is…
I have 2 eccomerce sites that have almost identical product databases. I want to host the product tables in a separate database for the 2 eccommerce sites to share. I tried connecting to 2 separate databases at once, but couldnt…
I have 2 different servers: one running Plesk Panel (PHP 5.2.13 & MySQL 5.0.45-community-nt), and the other running Zend Server 5.5 (PHP 5.2.17 & MySQL 5.1.50-community). I have a table in mysql DB on both servers as follows: CREATE TABLE…
1st query; both tables contain all categories_ids SELECT * FROM categories c, categories_description cd WHERE c.categories_id = cd.categories_id ORDER BY sort_order, cd.categories_name 2nd query; this table maybe hold a categories_id SELECT count(*) AS total FROM products_to_categories WHERE categories_id = "'+…