Latest News: (loading..)

pafranklin

Member Since 04 Oct 2005
Offline Last Active Jan 26 2012, 18:18

Find content

Community Stats

Group Community Member
Active Posts 245 (0.11 per day)
Most Active In General Support (157 posts)
Profile Views 8,729
Age 49 years old
Birthday January 25, 1963
Real Name
Paul Franklin
Gender
Male
Location
Gloucestershire, UK
Interests
OSC (Obviously), general website design, cricket, cinema and theatre. Oh yes - and red wine!

Contact Information

Website URL http://www.pianocoversonline.co.uk/

0 Neutral

Friends

Latest Visitors

WallaceNetwor...
15 Jan 2012, 17:51
peterguk
03 Jan 2011, 02:14
burt
20 Jan 2010, 20:24
davidboon
07 Oct 2009, 09:37
mglew
25 May 2009, 07:03

Topics I've Started

MySQL Script

26 January 2012, 06:48

Hi there,

I am trying to write a MySQL query to update a field in the products table for products only in a certain category. However with the products_id and categories_id only linked in the products to categories table, how can I do this?

So far I have the following:

UPDATE products SET products_availability_id = '5' where products_to_categories category_id = '22'

I am trying to update the field products_availability_id in the products table but only for products in category 22..........

Any help would be appreciated!

Paul