RE: [PHP-DB] Catalog

2002-12-19 Thread Cal Evans
Don't be offended:
SQL For Dummies

One of the best SQL primers I've ever read.  I STILL keep my copy handy.

Once you get through that and a few thousand queries under your belt, Joe
Celko's SQL for Smarties is a great reference. (I recommended it earlier
today to someone, dig that out and it's got a URL)

Depending on the products in your catalog, this could be a daunting. I've
got 1 catalog system that has 10 tables just to describe the products. (All
interrelated, makes for a pretty ER diagram!) But if your needs are simple
AND well defined, it could be a good starter project.

Oh, and don't forget Paul Dubois book on MySQL.  I've not yet purchased a
copy (sorry Paul) but the parts I've leafed through at the bookstore looked
very good.

Also, join the MySQL mailing list. (Paul actually hangs out over there)

=C=

*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: Hynek Semecký ME [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 4:55 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Catalog


Hi list,

I am trying to develop a product catalog using MySQL and PhP.
A long time I was looking for some tips for the database
structure.
The idea is to have a powerfull and as much as possible
universal DB application.

Does anyone have an idea of a book, e-book, site, resource please ?

Thanks
Hynek








--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Catalog

2002-12-11 Thread Hynek Semecký ME
Hi list, 

I am trying to develop a product catalog using MySQL and PhP. 
A long time I was looking for some tips for the database
structure.
The idea is to have a powerfull and as much as possible 
universal DB application. 

Does anyone have an idea of a book, e-book, site, resource please ? 

Thanks
Hynek








-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Catalog

2002-12-11 Thread Ignatius Reilly
lots of excellent resources on www.devshed.com, notably a PHPShop tutorial
and a catalogue implementation.

Ignatius

- Original Message -
From: Hynek Semecký ME [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 11:54 AM
Subject: [PHP-DB] Catalog


 Hi list,

 I am trying to develop a product catalog using MySQL and PhP.
 A long time I was looking for some tips for the database
 structure.
 The idea is to have a powerfull and as much as possible
 universal DB application.

 Does anyone have an idea of a book, e-book, site, resource please ?

 Thanks
 Hynek








 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Catalog

2002-12-11 Thread Hynek Semecký ME
Thanks.
I took a look at the catalog design here (devshed.com)
and I want to do something even more crazy.

I want to assign different pricelists over all or some products.
Product categories will have many to many relationship with products,
sub-categories the same and I will also have different product styles
with different prices. Each product will need to have
or fixed or variable price

Any idea about where I could take a look inside of SAP or something
like this ?


Thanks
Hynek



-Original Message-
From: Ignatius Reilly [mailto:[EMAIL PROTECTED]]
Sent: 11. prosince 2002 12:19
To: Hynek Semecký ME; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Catalog


lots of excellent resources on www.devshed.com, notably a PHPShop tutorial
and a catalogue implementation.

Ignatius

- Original Message -
From: Hynek Semecký ME [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 11:54 AM
Subject: [PHP-DB] Catalog


 Hi list,

 I am trying to develop a product catalog using MySQL and PhP.
 A long time I was looking for some tips for the database
 structure.
 The idea is to have a powerfull and as much as possible
 universal DB application.

 Does anyone have an idea of a book, e-book, site, resource please ?

 Thanks
 Hynek








 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Catalog

2002-12-11 Thread Snijders, Mark
jou want to make it yourself even without nowing how to code it or how to
set up a database design??? 

just by looking to other code??

think it will be to hard for a first project.. just my idea...

kind regards,

Mark



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Catalog

2002-12-11 Thread Hynek Semecký ME


I am ont interested in the code. I am interested in an idea
of a database design.

Not doing the first project neither.
But anyway, I am sure it will be difficult. Thanks

Hynek


-Original Message-
From: Snijders, Mark [mailto:[EMAIL PROTECTED]]
Sent: 11. prosince 2002 13:09
To: 'Hynek Semecký ME'; Ignatius Reilly; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Catalog


jou want to make it yourself even without nowing how to code it or how to
set up a database design???

just by looking to other code??

think it will be to hard for a first project.. just my idea...

kind regards,

Mark





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] catalog system

2002-10-21 Thread Aaron Wolski
Build you own.

Does no one want to 'work' for their projects these days? 

*shrug*

Aaron

-Original Message-
From: Sparks [mailto:alex;paychoice.com] 
Sent: Monday, October 21, 2002 9:29 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] catalog system


Greetings,

I'm looking for a cataloging system.  I've found some but they all deal
with e-commerce, which I don't want.  I'm trying to catalog items by
country, then by catagories, then by items.  I've been to all the
regular download sites but no luck :(

any help would be grateful

sparks



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] catalog system

2002-10-21 Thread Sparks
Yes, I've been trying to learn what I need.  Yes, I've surfed the
newbie/wanna be places.  I just asked if anyone knew of one, not asking to
build it for me.  Thought I'd try and learn from one and make my own.

If someone will point me to the Nubee-forum, I will gladly go.

Wannabe


Thomas Lamy [EMAIL PROTECTED] wrote in message
news:656F04F343FC25409463829A15B5FDDC08AFC4;netwake-nt.netwake.de...
 Doesn't seem so. Wannabes/Leechers never die. They haven't really
understood
 what this media ought to be.

 Most of the time it's faster (and wiser) to switch brain on for at least
ten
 minutes, rather than surfing beginner's guides for hours. Otherwise get
 yourself some training day(s).
 Really.


 [No, this was not off-topic]

 Thomas

 PS: I (and many others on the list) _like_ to help people with problems
when
 their stuck. But from time to time this list tends to be a nubee-forum.  I
 take time from my projects to read this list (and answer sometimes), just
to
 give back to the community what I got - fast help when _I_ got stuck.



 Aaron Wolski [mailto:aaronjw;martekbiz.com] wrote:
 
  Build you own.
 
  Does no one want to 'work' for their projects these days?
 
  *shrug*
 
  Aaron
 
  -Original Message-
  From: Sparks [mailto:alex;paychoice.com]
  Sent: Monday, October 21, 2002 9:29 AM
  To: [EMAIL PROTECTED]
  Subject: [PHP-DB] catalog system
 
 
  Greetings,
 
  I'm looking for a cataloging system.  I've found some but
  they all deal
  with e-commerce, which I don't want.  I'm trying to catalog items by
  country, then by catagories, then by items.  I've been to all the
  regular download sites but no luck :(
 
  any help would be grateful
 
  sparks
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] catalog system

2002-10-21 Thread Aaron Wolski
Agreed!

It sure is.

Aaron

-Original Message-
From: John W. Holmes [mailto:holmes072000;charter.net] 
Sent: Monday, October 21, 2002 12:51 PM
To: 'Sparks'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] catalog system


 If someone will point me to the Nubee-forum, I will gladly go.

http://forums.devshed.com

Newbie and advanced topics. Best forum out there, IMO.

---John Holmes...



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] catalog system

2002-10-21 Thread Thomas Lamy
Sorry, didn't want to be that offensive. It just comes through from time to
time.

Thomas

Sparks [mailto:alex;paychoice.com] wrote:
 
 Yes, I've been trying to learn what I need.  Yes, I've surfed the
 newbie/wanna be places.  I just asked if anyone knew of one, 
 not asking to
 build it for me.  Thought I'd try and learn from one and make my own.
 
 If someone will point me to the Nubee-forum, I will gladly go.
 
 Wannabe
 
 
 Thomas Lamy [EMAIL PROTECTED] wrote in message
 news:656F04F343FC25409463829A15B5FDDC08AFC4;netwake-nt.netwake.de...
  Doesn't seem so. Wannabes/Leechers never die. They haven't really
 understood
  what this media ought to be.
 
  Most of the time it's faster (and wiser) to switch brain on 
 for at least
 ten
  minutes, rather than surfing beginner's guides for hours. 
 Otherwise get
  yourself some training day(s).
  Really.
 
 
  [No, this was not off-topic]
 
  Thomas
 
  PS: I (and many others on the list) _like_ to help people 
 with problems
 when
  their stuck. But from time to time this list tends to be a 
 nubee-forum.  I
  take time from my projects to read this list (and answer 
 sometimes), just
 to
  give back to the community what I got - fast help when _I_ 
 got stuck.
 
 
 
  Aaron Wolski [mailto:aaronjw;martekbiz.com] wrote:
  
   Build you own.
  
   Does no one want to 'work' for their projects these days?
  
   *shrug*
  
   Aaron
  
   -Original Message-
   From: Sparks [mailto:alex;paychoice.com]
   Sent: Monday, October 21, 2002 9:29 AM
   To: [EMAIL PROTECTED]
   Subject: [PHP-DB] catalog system
  
  
   Greetings,
  
   I'm looking for a cataloging system.  I've found some but
   they all deal
   with e-commerce, which I don't want.  I'm trying to 
 catalog items by
   country, then by catagories, then by items.  I've been to all the
   regular download sites but no luck :(
  
   any help would be grateful
  
   sparks
  
  
  
   --
   PHP Database Mailing List (http://www.php.net/)
   To unsubscribe, visit: http://www.php.net/unsub.php
  
  
   --
   PHP Database Mailing List (http://www.php.net/)
   To unsubscribe, visit: http://www.php.net/unsub.php
  
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] catalog system

2002-10-21 Thread Ryan Jameson (USA)
I'll build you one, $70/hr US. :-)

 Ryan

-Original Message-
From: Sparks [mailto:alex;paychoice.com]
Sent: Monday, October 21, 2002 7:29 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] catalog system


Greetings,

I'm looking for a cataloging system.  I've found some but they all deal with
e-commerce, which I don't want.  I'm trying to catalog items by country,
then by catagories, then by items.  I've been to all the regular download
sites but no luck :(

any help would be grateful

sparks



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] catalog system

2002-10-21 Thread Sparks
Greetings,

I'm looking for a cataloging system.  I've found some but they all deal with
e-commerce, which I don't want.  I'm trying to catalog items by country,
then by catagories, then by items.  I've been to all the regular download
sites but no luck :(

any help would be grateful

sparks



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php