Hi,
I think there where 2 possibilities.
1. Add to the customers_basket table the categories_id
SELECT
cat.*
FROM
customers_basket AS cb,
categories AS cat
WHERE
products_id=7
AND
cb.categories_id=cat.categories_id
2. Make a relation table
CREATE TABLE relation_product_category (
Hi,
You have to insert a new blob field where you can store binary data. But
it is not recommanded to store images in a database. I recommande you to
store images on a server filesystem and only the reference to the
images in a database.
Armand
Digital Directory USA wrote:
I am new to php an
Hello,
Sone or later your get tired with this table construct. I recommande you
to split this table into 4 tables:
Tables:
- country
ex.: id_country country_name
- company
ex.: id_company company_name
- activity
ex.: id_activity activity_name
- relation-country-compan
Hi,
May the following sql statement is more efficient.
SELECT * FROM bc_posts WHERE
post_citysoundex IN('A265','A415',.)
Armand
motorpsychkill wrote:
I need to have a user input a city and have MySQL pull up any records with
that city OR nearby cities (within 10 mi). Which of the following
