Message-
From: Kirk Babb [mailto:[EMAIL PROTECTED]
Sent: Monday, December 29, 2003 4:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] table structure question
Hi everyone,
I would like to set up the following two tables inside a db for a soccer
league, but wanted to run their structure by you
I would do it a little bit different:
1. I would add ID's for each of the tables.
2. I would split teams in 2 tables; the captain stuff would be in a
separate table (captain_team let's say), simply because I would have
different players as captains in different games. If you keep the
structure as
Hi everyone,
I would like to set up the following two tables inside a db for a soccer
league, but wanted to run their structure by you guys first. Here it is:
dbname: soccer_stats
tables: teams, players
teams
--
name | captain | division | paid | pmnt_notes | win | loss | tie | goals_for
|
Hi,
I would be very grateful if someone could look at my table design for me
please. The sytem will be used to
allow users to log in to a web site and book staff. Here is my design so
far.
# -- MySQL dump --
#
# Table structure for table 'WMS_Allocations'
#
CREATE TABLE WMS_Alloca
Hi Jennifer,
Okay first, in your current page, just do one SQL statement that selects the
4 fields you want all at once, then use extract() to turn the record/result
into variables, and print out your form like:
0)
{
print "";
// Get Record and Echo/Print Out Data
while(
Hello Jenniffer,
I think the you could do like this:
"; \\ The current id selected in the DB
echo "".$result['name'].""; \\ it will print the name of product
echo "Quantity ".$result['quantity'].""; \\ and the quantity
echo "Cost: ".$result['price']." SC"; \\ price as well
echo "
Hi all,
I have a table called items here is a dump:
CREATE TABLE items (
id int(10) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
item_type int(4) NOT NULL default '0',
image varchar(100) NOT NULL default '',
price int(10) NOT NULL default '0',
quantity int(5) NOT NU