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
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
-
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