Page 1 of 1

Need code - Tried but failed badly

Posted: Wed Jun 16, 2004 9:11 am
by orochi
Okay, i have been trying to quit awhile now to get this to work... and it hasent worked at all, i have posted at phpnet forums, but they admit to being to lazy to help....

so here is what i need

Can someone make an admin panel for this SQL tables?

Insert into:
Artists
Contests

List for: (with a delete option)
Artists
Contests
Entries
Comments

Here is the SQL file

Code: Select all

Database glebe_ca_-_test running on localhost 
# phpMyAdmin SQL Dump 
# version 2.5.3 
# http://www.phpmyadmin.net 
# 
# Host: localhost 
# Generation Time: Jun 11, 2004 at 10:03 AM 
# Server version: 3.23.58 
# PHP Version: 4.3.4 
# 
# Database : `glebe_ca_-_test` 
# 

# -------------------------------------------------------- 

# 
# Table structure for table `artists` 
# 

CREATE TABLE `artists` ( 
  `artist` text NOT NULL, 
  `password` text NOT NULL, 
  `email` text NOT NULL, 
  `website` text NOT NULL, 
  `title` text NOT NULL, 
  `banner` text NOT NULL, 
  `message` text NOT NULL, 
  `popular` smallint(5) unsigned NOT NULL default '0', 
  `art` smallint(5) unsigned NOT NULL default '0', 
  `concept` smallint(5) unsigned NOT NULL default '0', 
  `suggestion` smallint(5) unsigned NOT NULL default '0', 
  `winner` smallint(5) unsigned NOT NULL default '0', 
  `entry` smallint(5) unsigned NOT NULL default '0' 
) TYPE=MyISAM; 

# 
# Dumping data for table `artists` 
# 


# -------------------------------------------------------- 

# 
# Table structure for table `comments` 
# 

CREATE TABLE `comments` ( 
  `contest` smallint(5) unsigned NOT NULL default '0', 
  `entry` smallint(5) unsigned NOT NULL default '0', 
  `stamp` datetime NOT NULL default '0000-00-00 00:00:00', 
  `name` text NOT NULL, 
  `suggestion` text NOT NULL, 
  `ip` text NOT NULL 
) TYPE=MyISAM; 

# 
# Dumping data for table `comments` 
# 


# -------------------------------------------------------- 

# 
# Table structure for table `contests` 
# 

CREATE TABLE `contests` ( 
  `contest` smallint(5) unsigned NOT NULL default '0', 
  `theme` text NOT NULL, 
  `date` date NOT NULL default '0000-00-00', 
  `date2` date NOT NULL default '0000-00-00', 
  `date3` date NOT NULL default '0000-00-00', 
  `date4` date NOT NULL default '0000-00-00', 
  `popular` smallint(5) unsigned NOT NULL default '0', 
  `art` smallint(5) unsigned NOT NULL default '0', 
  `concept` smallint(5) unsigned NOT NULL default '0', 
  `suggestion` smallint(5) unsigned NOT NULL default '0', 
  `entry` smallint(5) unsigned NOT NULL default '0', 
  `description` text NOT NULL 
) TYPE=MyISAM COMMENT='list of weekly drawing contests'; 

# 
# Dumping data for table `contests` 
# 


# -------------------------------------------------------- 

# 
# Table structure for table `entries` 
# 

CREATE TABLE `entries` ( 
  `contest` smallint(5) unsigned NOT NULL default '0', 
  `entry` smallint(5) unsigned NOT NULL default '0', 
  `artist` text NOT NULL, 
  `artist2` text NOT NULL, 
  `image` text NOT NULL, 
  `popular` smallint(5) unsigned NOT NULL default '0', 
  `art` smallint(5) unsigned NOT NULL default '0', 
  `concept` smallint(5) unsigned NOT NULL default '0', 
  `suggestion` smallint(5) unsigned NOT NULL default '0', 
  `winner` set('popular','art','concept') NOT NULL default '', 
  FULLTEXT KEY `image` (`image`), 
  FULLTEXT KEY `image_2` (`image`) 
) TYPE=MyISAM COMMENT='Drawing Contest Entry'; 

# 
# Dumping data for table `entries` 
# 


# -------------------------------------------------------- 

# 
# Table structure for table `votes` 
# 

CREATE TABLE `votes` ( 
  `contest` smallint(5) unsigned NOT NULL default '0', 
  `ip` text NOT NULL, 
  `popular` text NOT NULL, 
  `art` text NOT NULL, 
  `concept` text NOT NULL, 
  `stamp` datetime NOT NULL default '0000-00-00 00:00:00', 
  `proxy` text 
) TYPE=MyISAM; 

# 
# Dumping data for table `votes` 
#