Can anybody give me any good reasons not to use a time stamp as an order number in my shopping cart. It seems to me that the number is guaranteed to be random and it saves having to make an extra time column to keep track of the order. The only small concern I have is the chance that somebody orders at the exact same time as somebody else but the chance of that has got to be incredibly small but possible. My second question is I've designed a very simple Postgres database wrapper. The methods are exactly what you would assume to see in any db wrapper a pg_query, pg_fetch_array. My question is in the db wrapper, is there an easy way to always include the table name as an index in all my pg_fetch_array returned results? The reason I ask is when designing my tables I'm delegated to prefixing my column names i.e. users_name instead of just name or forum_posts instead of just posts to make sure there's no collision. Cheers Thomas Shaw Php.coder@xxxxxxxxx
