Re: [mv] dissapearing data if repeated codes are used; how can i call the data?

[Hans-Joachim Leidinger <jojo@buchonline.net>]

******    message to minivend-users from Hans-Joachim Leidinger <jojo@buchonline.net>     ******

Michael Schwartz wrote:
> 
> ******    message to minivend-users from "Michael Schwartz" <michael@panamacom.com>     ******
> 
> Hi all!
> 
> I've asked this 2 times without success, so i guess it is a stupid
> question....but i cant find the answer...so here it goes again, hoping that
> someone answers:
> 
> i have a table pretty much like this:
> 
> code                title
> x                       USA
> x                       CR
> x                       BR
> 
> It is the output of Analog, a web statistics program.   Minivend (it seems),
> doesnt like items with the same code....it doesnt show them.....If i
> eliminate the header 'code', the results appear, but not what i want to
> appear.
> If i manually change the codes so they are different, it works perfectly,
> but I want it to be an automated process....Crontabs runs analog, it creates
> the output at 12midnight, and the site using minivend should read it.
> Now, the question:
> 
> How can i access records in the database if they have the same code? is this
> possible? am i missing something here??
> 
> Thanks for your input.

Hi Michael,

the code is used as a product ID and this ID should not be exist two or
more in a database. 
If a visitor wish to buy an items "xyz" and there are two items a and b
with the code "xyz". Do you know, which items do you sell? A or b? 
Last time, i have builded a wrong products.asc with two or more same
items with the same code and MV show all of them. However, are you able
to write a script, which will rename two or more same code via crontab?
For Example "xyz", "xyz1", "xyz2" etc.? 
Regarding Analog, if i remembered right, Analog is able to collect (i
donīt know the right english word) all same code into one code. But i
donīt know the right setting of the analog.cfg from my head (i have not
analog at home).

Hope you get any suggestions!

Regads,

	Joachim

-- 
-------------Hans-Joachim Leidinger---------------------


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list