PhpMyAdmin Confusion: How To Insert?

Hi, I'm trying to get the magnetic poetry board on the vds, and I'm trying to use PhpMyAdmin to do this. I've searched around for an answer, and I've also read through the PhpMyAdmin stuff on the site, and I found their documentation to be unhelpful to me (perhaps I'm a blockhead.)

Here's the situation:

]------------------------------------------------------------------------
create a table following this structure under any database:
CREATE TABLE poetry (
   fridge varchar(100) NOT NULL,
   data text NOT NULL,
   timestamp varchar(20) NOT NULL,
   ip_address varchar(15) NOT NULL
);

--[ 2 ]------------------------------------------------------------------------
create the following entry in that table:
INSERT INTO poetry VALUES ( 'fridge_name', '0,0:0,5:0,10:0,15:0,20:0,25:0,30:0,35:0,40:0,45:0,50:0,55:0,60:0,65:0,70:0,75:0,80:0,85:0,90:0,95:0,100:0,105:0,110:0,115:0,120:0,125:0,130:0,135:0,140:0,145:0,150:0,155:0,160:0,165:0,170:0,175:0,180:0,185:0,190:0,195:0,200:0,205:0,210:0,215:0,220:0,225:0,230:0,235:0,240:0,245:0,250:0,255:0,260:0,265:0,270:0,275:0,280:0,285:0,290:0,295:0,300:0,305:0,310:0,315:0,320:0,325:0,330:0,335:0,340:0,345:0,350:0,355:0,360:0,365:0,370:0,375:0,380:0,385:0,390:0,395:0,400:0,405:0,410:0,415:0,420:0,425:0,430:0,435:0,440:0,445:0,450:0,455:0,460:0,465:0,470:0,475:0,480:0,485:0,490:0,495:0,500:0,505:0,510:0,515:0,520:0,525:0,530:0,535:0,540:0,545:0,550:0,555:0,560:0,565:0,570:0,575:0,580:0,585:0,590:0,595:0,600:0,605:0,610:0,615:0,620:0,625:0,630:0,635:0,640:0,645:0,650:0,655:0,660:0,665:0,670:0,675:0,680:0,685:0,690:0,695:0,700:0,705:0,710:0,715:0,720:0,725:0,730:0,735:0,740:0,745:0,750:0,755:0,760:0,765:0,770:0,775:0,780:0,785:0,790:0,795:0,800:0,805:0,810:0,815:0,820:0,825:0,830:0,835:0,840:0,845:0,850:0,855:0,860:0,865:0,870:0,875:0,880:0,885:0,890:0,895:0,900:0,905:0,910:0,915:0,920:0,925:0,930:0,935:0,940:0,945:0,950:0,955:0,960:0,965:0,970:0,975:0,980:0,985:0,990:0,995:0,1000:0,1005', '02/22/01 02:04:25', '24.17.1-[ 1 18.141');

Code (markup):

I can create the table... no problem there....... I'm lost at step 2. What exactly am I inserting and where (no joke intended) In phpMyAdmin I've got 4 fields now... I don't see any "poetry Values"....can someone please advise

many thanks,
Gator Mirage

 

If I understand you right, it looks like you're trying to insert values into the 'fridge_name' field but when you created the table you named it 'fridge'.

 

Thank you Crazy Rob for the response: this is the install.txt right here:

I basically don't know much about databases, and I've been searching on-line, and I'm not finding any good solutions. Does this appear like they made an error in the install.txt file? many thanks.......

this is the install.txt right here:

--[ 1 ]------------------------------------------------------------------------
create a table following this structure under any database:
CREATE TABLE poetry (
   fridge varchar(100) NOT NULL,
   data text NOT NULL,
   timestamp varchar(20) NOT NULL,
   ip_address varchar(15) NOT NULL
);

--[ 2 ]------------------------------------------------------------------------
create the following entry in that table:
INSERT INTO poetry VALUES ( 'fridge_name', '0,0:0,5:0,10:0,15:0,20:0,25:0,30:0,35:0,40:0,45:0,50:0,55:0,60:0,65:0,70:0,75:0,80:0,85:0,90:0,95:0,100:0,105:0,110:0,115:0,120:0,125:0,130:0,135:0,140:0,145:0,150:0,155:0,160:0,165:0,170:0,175:0,180:0,185:0,190:0,195:0,200:0,205:0,210:0,215:0,220:0,225:0,230:0,235:0,240:0,245:0,250:0,255:0,260:0,265:0,270:0,275:0,280:0,285:0,290:0,295:0,300:0,305:0,310:0,315:0,320:0,325:0,330:0,335:0,340:0,345:0,350:0,355:0,360:0,365:0,370:0,375:0,380:0,385:0,390:0,395:0,400:0,405:0,410:0,415:0,420:0,425:0,430:0,435:0,440:0,445:0,450:0,455:0,460:0,465:0,470:0,475:0,480:0,485:0,490:0,495:0,500:0,505:0,510:0,515:0,520:0,525:0,530:0,535:0,540:0,545:0,550:0,555:0,560:0,565:0,570:0,575:0,580:0,585:0,590:0,595:0,600:0,605:0,610:0,615:0,620:0,625:0,630:0,635:0,640:0,645:0,650:0,655:0,660:0,665:0,670:0,675:0,680:0,685:0,690:0,695:0,700:0,705:0,710:0,715:0,720:0,725:0,730:0,735:0,740:0,745:0,750:0,755:0,760:0,765:0,770:0,775:0,780:0,785:0,790:0,795:0,800:0,805:0,810:0,815:0,820:0,825:0,830:0,835:0,840:0,845:0,850:0,855:0,860:0,865:0,870:0,875:0,880:0,885:0,890:0,895:0,900:0,905:0,910:0,915:0,920:0,925:0,930:0,935:0,940:0,945:0,950:0,955:0,960:0,965:0,970:0,975:0,980:0,985:0,990:0,995:0,1000:0,1005', '02/22/01 02:04:25', '24.17.118.141');

--[ 3 ]------------------------------------------------------------------------
modify magnetic_poetry.inc.php with you MySQL server, login, pass, and the
database/table you created.

Code (markup):

 

if you are using phpmyadmin then when running the this insert.sql that have this line
INSERT INTO poetry VALUES ( 'fridge_name', '0,0:0,5:0,10:0,15:0,20:0,25:0,30:0,35:0,40:0,45:0,50:0,55:0,60:0,65:0,70:0,75:0,80:0,85:0,90:0,95:0,100:0,105:0,110:0,115:0,120:0,125:0,130:0,135:0,140:0,145:0,150:0,155:0,160:0,165:0,170:0,175:0,180:0,185:0,190:0,195:0,200:0,205:0,210:0,215:0,220:0,225:0,230:0,235:0,240:0,245:0,250:0,255:0,260:0,265:0,270:0,275:0,280:0,285:0,290:0,295:0,300:0,305:0,310:0,315:0,320:0,325:0,330:0,335:0,340:0,345:0,350:0,355:0,360:0,365:0,370:0,375:0,380:0,385:0,390:0,395:0,400:0,405:0,410:0,415:0,420:0,425:0,430:0,435:0,440:0,445:0,450:0,455:0,460:0,465:0,470:0,475:0,480:0,485:0,490:0,495:0,500:0,505:0,510:0,515:0,520:0,525:0,530:0,535:0,540:0,545:0,550:0,555:0,560:0,565:0,570:0,575:0,580:0,585:0,590:0,595:0,600:0,605:0,610:0,615:0,620:0,625:0,630:0,635:0,640:0,645:0,650:0,655:0,660:0,665:0,670:0,675:0,680:0,685:0,690:0,695:0,700:0,705:0,710:0,715:0,720:0,725:0,730:0,735:0,740:0,745:0,750:0,755:0,760:0,765:0,770:0,775:0,780:0,785:0,790:0,795:0,800:0,805:0,810:0,815:0,820:0,825:0,830:0,835:0,840:0,845:0,850:0,855:0,860:0,865:0,870:0,875:0,880:0,885:0,890:0,895:0,900:0,905:0,910:0,915:0,920:0,925:0,930:0,935:0,940:0,945:0,950:0,955:0,960:0,965:0,970:0,975:0,980:0,985:0,990:0,995:0,1000:0,1005', '02/22/01 02:04:25', '24.17.1-[ 1 18.141');

and phpmyadmin will automatically insert the data above to the db and if you want to do it manually then
go to your poetry table in phpmyadmin and you will find an "Insert" text link near to a browse link. click the insert link
and insert in the four fields:
fridge: fridge_name
data:0,0:0,5:0,10:0,15:0,20:0,25:0,30:0,35:0,40:0,45:0,50:0,55:0,60:0,65:0,70:0,75:0,80:0,85:0,90:0,95:0,100:0,105:0,110:0,115:0,120:0,125:0,130:0,135:0,140:0,145:0,150:0,155:0,160:0,165:0,170:0,175:0,180:0,185:0,190:0,195:0,200:0,205:0,210:0,215:0,220:0,225:0,230:0,235:0,240:0,245:0,250:0,255:0,260:0,265:0,270:0,275:0,280:0,285:0,290:0,295:0,300:0,305:0,310:0,315:0,320:0,325:0,330:0,335:0,340:0,345:0,350:0,355:0,360:0,365:0,370:0,375:0,380:0,385:0,390:0,395:0,400:0,405:0,410:0,415:0,420:0,425:0,430:0,435:0,440:0,445:0,450:0,455:0,460:0,465:0,470:0,475:0,480:0,485:0,490:0,495:0,500:0,505:0,510:0,515:0,520:0,525:0,530:0,535:0,540:0,545:0,550:0,555:0,560:0,565:0,570:0,575:0,580:0,585:0,590:0,595:0,600:0,605:0,610:0,615:0,620:0,625:0,630:0,635:0,640:0,645:0,650:0,655:0,660:0,665:0,670:0,675:0,680:0,685:0,690:0,695:0,700:0,705:0,710:0,715:0,720:0,725:0,730:0,735:0,740:0,745:0,750:0,755:0,760:0,765:0,770:0,775:0,780:0,785:0,790:0,795:0,800:0,805:0,810:0,815:0,820:0,825:0,830:0,835:0,840:0,845:0,850:0,855:0,860:0,865:0,870:0,875:0,880:0,885:0,890:0,895:0,900:0,905:0,910:0,915:0,920:0,925:0,930:0,935:0,940:0,945:0,950:0,955:0,960:0,965:0,970:0,975:0,980:0,985:0,990:0,995:0,1000:0,1005
timestamp: 02/22/01 02:04:25
ip_address:24.17.1-[ 1 18.141