The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have a query that is pulling data from multiple tables like this:
SELECT * FROM product, product_description, product_special WHERE product.product_id > 0 && product.product_id = product_description.product_id OR product.product_id = product_special.product_id ORDER BY date_added DESC LIMIT 0,100
Here's the table structure:
Here's how I want the data displayed in a web browser: (note: if special_price exists, then display it. If there is no special_price, show all other data.)
product_id, name, price, quantity, description, special_price
If there is no product_id entry in the product_special table, then the item will not show.
If there is an entry in the product_special table, show it and the rest of the item data.
If there is no entry in the product_special table, show the rest of the data.
Sign in or Register to see more