We need someone to create a website from a database of almost 300,000 restauraunts that we have. The site needs to have a design, and MUST have mod_rewrite so the url will be like [login to view URL] instead of [login to view URL]
Also, the title tags must relate to the restaraunt.
This is a EASY Job. The design should be nice, but doesnt have to be really fancy.
A copy of the structure is below.
#
# Table structure for table `tblcrosscategories`
#
CREATE TABLE tblcrosscategories (
RestaurantLocationID int(11) default NULL,
CategoryID int(11) default NULL
) TYPE=MyISAM
# --------------------------------------------------------
#
# Table structure for table `tblrestaurantcategories`
#
CREATE TABLE tblrestaurantcategories (
RestaurantCategoryID int(11) default NULL,
Category varchar(35) default NULL,
category_id int(11) default NULL
) TYPE=MyISAM
# --------------------------------------------------------
#
# Table structure for table `tblrestaurants`
#
CREATE TABLE tblrestaurants (
RestaurantID int(11) default NULL,
RestaurantLocationID int(11) default NULL,
Name varchar(75) default NULL,
Address1 varchar(30) default NULL,
Address2 varchar(20) default NULL,
City varchar(30) default NULL,
State char(2) default NULL,
Zip varchar(5) default NULL,
PhoneMain varchar(10) default NULL,
PhoneToll varchar(10) default NULL,
Phone varchar(10) default NULL,
Fax varchar(10) default NULL,
Fax2 varchar(10) default NULL,
URL varchar(60) default NULL,
Email varchar(40) default NULL
) TYPE=MyISAM