auto_increment=0

2005-02-16 Thread Philippe Rousselot
hi, I am migrating a DB having a table with a UID not_null autoincrement the original table starts at UID=0 I cannot migrate this table autmaticaly as the line for UID=0 is automatically transformed into UID=1 and therefore I get an error message for the next line (UID=1) as being already into t

query over several tables

2003-12-16 Thread Philippe Rousselot
Hi I have three linked tables : store, catalogue, and sales store : ID_store, store, date catalogue : ID_product, product sales : ID_sales, ID_store, ID_product, product, quantity I would like a view giving me ALL the products in catalogue with the quantity per store if the store has this produc

connection problem

2001-12-09 Thread Philippe Rousselot
hi, I am new to PHP/mySQL. When i connect to phpMyAdmin to work with my database I do not have any problem of connection, but when I try to connect to my mySQL DB using this script (http://www.utpala.net/query1.php), then I get the following error message, Does anyone see something wrong in