msql query

[peter_act]

Hello everyone,

I'm setting up my site called internetcruisingclub dot com from a basic Dolphin social network template.
Because it was basically a dating site, on the "join" page it had a field "Looking for"' which I didn't want, so changed it to "Name of boat"
I thought I knew more about phpmyadmin than I actually did, so now I've mucked up the "join" page, and I get the message:

Database query error
Query:
INSERT INTO `Profiles` SET `NickName` = 'peteract', `Password` = 'sunshine', `Email` = 'peteract@gmail.com', `DateReg` = '2009-07-21 05:05:54', `DateLastEdit` = '0000-00-00', `Status` = 'Active', `DateLastLogin` = '0000-00-00', `Featured` = 0, `Sex` = 'male', `LookingFor` = '', `DescriptionMe` = 'I want to load articles', `DateOfBirth` = '', `Headline` = '', `Country` = 'AU', `City` = 'Macgregor', `Couple` = 0, `Tags` = '', `zip` = '2615', `Name_of_boat` = 'Lettuce Spray'
Mysql error:
Unknown column 'LookingFor' in 'field list'

I also get:

Found error in file /home/cruising/public_html/inc/classes/BxDolProfilesController.php
at line 111. Called db_res function with erroneous argument #0

Where can I find "field list" in phpmyadmin, so I can fix the problem?
(and learn a bit more sql stuff)

Many thanks in advance,

Peter

[Raju Gautam]

Click in the Profile table in the left hand side of phpmyadmin then you will see the fields in the right hand side. And it says that the field 'LookingFor' does not exist in the table.

[peter_act]

Thanks Rajug,

I put the field back in, and the "join" page on the site worked perfectly.
I just had to put "Disregard this field" on the joining form - go to the site and see what I mean.

Not a very elegant solution, as I just wanted to get rid of the field altogether, but at least it works.

Will try and learn how to insert and delete fields in a table

Cheers,

Peter

[r937]

I just had to put "Disregard this field" on the joining form

LOL @ "Name of your boat (if any)"

[peter_act]

Yes, this site will be for dreamers too, if I ever learn how to set things up.
I don't mind paying someone to do it, but then I will never learn to do it myself

Cheers from Australia,

Peter