Hello everyone,
I need help with MySQL coding in php please if anyone can help.
I have 3 tables:
-users, where the user info is stored.
-awards: contains the list of all the awards for each user
-award_types: contains different types of award
The tables are at the bottom of the page.
What I need to do is look at these tables when a user id is being viewed and
display the awards image that the user has won.
A user can have multiple awards.
CREATE TABLE `award_types` (
`id` tinyint(3) unsigned NOT NULL auto_increment,
`award_type` varchar(255) NOT NULL default '',
`award_image` varchar(250) default NULL,
`gender` enum('m','f') NOT NULL default 'm',
`order_by` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`id`)
)
#
# Dumping data for table `award_types`
#
INSERT INTO `award_types` VALUES (1, 'November 2003', nov.gif, 'm', 0);
INSERT INTO `award_types` VALUES (2, 'December 2003', dec.gif, 'm', 1);
INSERT INTO `award_types` VALUES (3, 'January 2004', jan.gif, 'm', 2);
INSERT INTO `award_types` VALUES (4, 'February 2004', feb.gif, 'm', 3);
CREATE TABLE `awards` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL default '0',
`award_id` bigint(20) NOT NULL default '0',
`chosen` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `chosen` (`chosen`)
)
#
# Dumping data for table `awards`
#
INSERT INTO `awards` VALUES (1, 1, 1, 'enabled');
INSERT INTO `awards` VALUES (3, 1, 2, 'enabled');
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`username` varchar(16) NOT NULL default '',
`password` varchar(16) NOT NULL default '',
`hint` varchar(100) NOT NULL default '',
`realname` varchar(48) NOT NULL default '',
`description` text NOT NULL,
`age` tinyint(2) unsigned NOT NULL default '0',
`user_type` tinyint(3) unsigned NOT NULL default '0',
`state` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default 'United_States.gif',
`email` varchar(48) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`quote` varchar(255) NOT NULL default '',
`image` enum('here','there') NOT NULL default 'there',
`image_url` varchar(144) NOT NULL default '',
`image_ext` varchar(4) NOT NULL default '',
`image_status` enum('enabled','disabled','queued','approved') NOT NULL
default 'enabled',
`total_comments` int(10) unsigned NOT NULL default '0',
`subscribed` enum('yes','no') NOT NULL default 'yes',
`md5key` varchar(32) NOT NULL default '',
`signup` varchar(14) NOT NULL default '',
`timestamp` timestamp(14) NOT NULL,
`is_approved` enum('0','1') NOT NULL default '1',
`total_files` smallint(6) NOT NULL default '0',
`last_logged` datetime NOT NULL default '0000-00-00 00:00:00',
`city` varchar(32) NOT NULL default '0',
`address` varchar(64) default NULL,
`zip` varchar(32) default NULL,
`talent` varchar(32) default NULL,
`phone` varchar(32) default NULL,
`height` varchar(10) default NULL,
`weight` varchar(10) default NULL,
`education` varchar(32) default NULL,
`hobby` varchar(32) default NULL,
`topregion` enum('enabled','disabled') NOT NULL default 'disabled',
`top30` enum('enabled','disabled') NOT NULL default 'disabled',
`top10` enum('enabled','disabled') NOT NULL default 'disabled',
`top` enum('enabled','disabled') NOT NULL default 'disabled',
`total_ratings` smallint(5) unsigned default '1',
`total_points` mediumint(9) unsigned default '10',
`average_rating` decimal(6,4) default '10.0000',
`art` text,
`language` text,
`sport` text,
`skill` text,
`experience` text,
`club` text,
`lastname` varchar(250) default NULL,
`secondid` varchar(32) default NULL,
`chosens` enum('enabled','disabled') default 'disabled',
`email_status` enum('enabled','disabled','queued','approved') NOT NULL
default 'enabled',
`chosen` varchar(20) NOT NULL default 'enabled',
PRIMARY KEY (`id`),
UNIQUE KEY `md5key` (`md5key`),
UNIQUE KEY `username_2` (`username`),
UNIQUE KEY `email_2` (`email`),
KEY `sex` (`user_type`),
KEY `timestamp` (`timestamp`),
KEY `signup` (`signup`),
KEY `username` (`username`),
KEY `email` (`email`),
KEY `subscribed` (`subscribed`)
)
#
# Dumping data for table `users`
#
INSERT INTO `users` VALUES (1, 'username', 'password', 'firstname',
'lastname', '', 19, 11, 'City', 'Sweden.gif', '[EMAIL PROTECTED]',
'http://', '', 'here', '', 'jpg', 'approved', 0, 'yes',
'69f404925df883e0e5579d65b7768e7c', '20031007135005', 20031102044856, '1',
1, '2003-10-11 03:20:19', 'Stockholm', '', '', '', '', '176', '60', '2', '',
'disabled', 'disabled', 'disabled', 'disabled', 1717, 5410, '3.1508', NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'enabled', 'enabled', 'enabled');
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
