Need to match product with letters before the dash "-"

Expand Post »

In the product list online i have the same products uner different names due to restrictions on oscommerce.

Example:
VDE004-DE
VDE004-DE1
VDE004-DE2
NLD6400-TO
NLD6400-TO1
etc.....

In the inventory list it will just have -
VDE004
NLD6400

When a product is purchased is decrements one off the stock_level column.

I need the code to say decrement 1 off the stock_level where the letters before a dash match the name in the inventory list.

So WHERE "VDE004"-DE = VDE004;

Can anyone help?

BillyMako

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

16 posts
since Jan 2008

Permalink

Nov 6th, 2008

Re: Need to match product with letters before the dash "-"

php Syntax (Toggle Plain Text)
$fullProductId = explode("-", $value)
$productId = $fullProductId[0]
$fullProductId = explode("-", $value)
$productId = $fullProductId[0]

Should work

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: converting array from mysql database into a different mysql table

Next Thread in PHP Forum Timeline: Need to read the most recently created XML file!

DaniWeb Message

Cancel Changes

User Name
Password