Thanks for your concern.
the error for the addfriends.php says "[B][COLOR="Red"]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1",[/COLOR][/B]
while error for the request.php says [COLOR="Green"][B]"Unknown column 'userID' in 'where clause'"[/B][/COLOR].
I am kinda confused cus I have spent time trying to fix it but error still occur. can u offer me some help looking at my code plz.
Thankz

Hello Guys, Im having a problem with my request code. I need to send a request to a friend and it should appear on the friends page when the friend log in. then if the freind accept it, it should get updated in the freinds table , ut I seem to be having some errors with the code. I've sat all night trying to fixed it but I seem to be putting more error that than never. I have attached my login and request codes along with the users and friends table to help u understand what im talking about.
Pls I need help.
Thanks guys.
I've created two tables, one for users and one for friends

// users table

CREATE TABLE `kclove`.`users` (
`userID` INT( 11 ) NOT NULL AUTO_INCREMENT COMMENT 'auto_increment',
`name` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`username` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`password` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`interest` VARCHAR( 255 ) NULL DEFAULT NULL ,
PRIMARY KEY ( `userid` )
) ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci

//Friends2
CREATE TABLE `kclove`.`friends2` (
`friends2ID` INT( 11 ) NOT NULL AUTO_INCREMENT COMMENT 'auto_increment',
`person1` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`person2` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`status` INT( 11 ) NULL DEFAULT '0',
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM ...

Hello Folks., Im new to this forum and just trying to learn Java.
I have a program Im trying to write in Java. [B]its about managing flights and booking flights for customers and also Alter flight should customer wish to change their mind not travelling.[/B] Im kinda confused on how to start. Please can any one please help kick start me.
I'll appreciate that as it will help me learn as well.
Thanks.