[PHP-DB] App. design help

2006-11-14 Thread William Stokes
Hello, I need to write a php/mysql application for managing a website for a sportsclub. At his point I need some designin tips how to implement the user and team administration. At the moment the club consists of about 30 teams. There are usually 1-2 web admins per team to update the pages. Th

Re: [PHP-DB] Simple question on auto_increment

2006-11-14 Thread Christian Flothmann
www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id (of course for your example to work all the other fields would have to be nullable) Or even the MySQL function LAST_INSERT_ID(): http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#id2725312 -- PHP Database Mail

RE: [PHP-DB] App. design help

2006-11-14 Thread Bastien Koert
create a sub table with an user id column and a team column...runs vertically instead of horizontally bastien From: "William Stokes" <[EMAIL PROTECTED]> To: [email protected] Subject: [PHP-DB] App. design help Date: Tue, 14 Nov 2006 15:18:29 +0200 Hello, I need to write a php/mysql appl