Custom Computer - will pay cash

[Guest]

Hi,

 

I have been trying with minimal success to add extra categories to the Custom Computer Creator contribution.

 

I have got as far as having the products pulled from the database correctly, with the correct pricing. The only problem is that when I click on submit and go to the custom_checkout.php page I dont get the product from the extra category listed on the page properly. It just shows as "Array"

 

I am willing to pay someone via PayPal if necessary to get this fixed.

 

Can someone please help me.

 

Thanks

Criag

[blueline]

Craig-

 

On your site....do you currently have the custom computer application available to the public?

 

On went on your site to take a look, but I can't find it.

 

Thanks,

-Chris

[Guest]

Chris,

 

You can find it at http://www.cralyn.com/build.php

 

Thanks

[blueline]

I'll tell you the first problem that I see.....your categories don't provide the proper products.

 

You also have a mySQL error:

1064 - You have an error in your SQL syntax near 'AND products_price != 0 order by products_name' at line 1



select products_to_categories.products_id, categories_id, products_price, products_image, products_model, products_name, products_description from products_to_categories, products_description, products where products.products_id = products_to_categories.products_id AND products_description.products_id = products_to_categories.products_id AND categories_id = AND products_price != 0 order by products_name



[TEP STOP]

 

You can't even get to the bottom of the page due to the error. When you get this fixes, let me know and I will take another look at the site.

 

 

Hope this helps,

-Chris

[blueline]

You have to finish off the last part of that query. You have

 

AND categories_id = AND products_price != 0 order by products_name

 

Obviously, the problem is that you have written "categories_id = AND"....you must set categories equal to something.

 

HTH,

-Chris