create a website product comparision query using php mysql
Posted: Mon Mar 03, 2014 12:40 am
Hi
I am trying to create a simple web comparision page using php-mysql.
The web pages contains products. I would like to provide viewers with the option to compare products. Atmost 4 products should be compared at same time.
Therefore i propose to place a small checkbox next to each product to see if 4 products are selected. Once 4 products are checked and compare button is clicked the results should display in pop-up window.
How do i write the query taking into consideration the products selected ???
how do i display the results from database onto website in a pop-up page ???
my products table is as follows:
product-id
product-name
price
quantity
stock
is there a better option to do it???
im a newbie to php and also mysql.I understand SQL having worked with ORACLE databases.
Can someone please help me. Give me some ideas to work around with.
Thanks in advance.
I am trying to create a simple web comparision page using php-mysql.
The web pages contains products. I would like to provide viewers with the option to compare products. Atmost 4 products should be compared at same time.
Therefore i propose to place a small checkbox next to each product to see if 4 products are selected. Once 4 products are checked and compare button is clicked the results should display in pop-up window.
How do i write the query taking into consideration the products selected ???
how do i display the results from database onto website in a pop-up page ???
my products table is as follows:
product-id
product-name
price
quantity
stock
is there a better option to do it???
im a newbie to php and also mysql.I understand SQL having worked with ORACLE databases.
Can someone please help me. Give me some ideas to work around with.
Thanks in advance.