Tutorials
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsOtherTutorials

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
  #1  
Old May 6th, 2007, 10:29 AM
roelor roelor is offline
Contributing User
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 81 roelor User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 h 25 m 6 sec
Reputation Power: 2
Creating a search engine sql errors?

see i want to input this in to my retarded phpmyadmin only the ting is half of the scripts i input dont work...
PHP Code:
 CREATE TABLE 'introduction' (
  
'id' INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  
'last_name' VARCHAR50 NOT NULL ,
  
'first_name' VARCHAR50 NOT NULL
TYPE=MyISAM COMMENT='Example Table'

Nothing wrong right?
made it by hand turns out this
PHP Code:
 CREATE TABLE `introduction` (
`
idINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`
last_nameVARCHAR50 NOT NULL ,
`
first_nameVARCHAR50 NOT NULL 
ENGINE MYISAM 

i see the ' and ` are differend but why doesnt that work?
__________________
EAT THIS PIECAKE!!!
liked the old site more

Last edited by roelor : May 6th, 2007 at 10:34 AM.

Reply With Quote
  #2  
Old May 6th, 2007, 06:53 PM
lig's Avatar
lig lig is offline
"Forum Nazi"
Codewalkers Demi-God (4500 - 4999 posts)
 
Join Date: Apr 2007
Location: Jacksonville, Fl
Posts: 4,729 lig User rank is Private First Class (20 - 50 Reputation Level)lig User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 Days 1 h 32 m 7 sec
Reputation Power: 6
Code:
CREATE TABLE introduction (
  id INT AUTO_INCREMENT NOT NULL, 
  last_name VARCHAR( 50 ) NOT NULL ,
  first_name VARCHAR( 50 ) NOT NULL,
  PRIMARY KEY(id)) 
TYPE=MyISAM COMMENT='Example Table',
DEFAULT CHARACTER SET utf8,
COLLATE utf8_general_ci;  
__________________
life is a game.... Have fun
-----------------------------
http://www.phpwomen.org
strength in unity

PHPCommunity IRC
#phpc on freenode

Reply With Quote
Reply

Viewing: Codewalkers ForumsOtherTutorials > Creating a search engine sql errors?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT