On Sat, 2010-07-03 at 09:20 +0200, Hans Åhlin wrote:
> You have forgotten the ending ; in the sql query....
> try this
> mysql_query("INSERT INTO employes (name,lastname, salary, id, afp,
> isss, nit) VALUES ('".$field[0]."',
> '".$field[1]."','".$field[2]."','".$field[3]."','".$field[4]."','".$field[5]."','".$field[6]."');");
>
> **********************************************
> Hans Åhlin
> Tel: +46761488019
> icq: 275232967
> http://www.kronan-net.com/
> irc://irc.freenode.net:6667 - TheCoin
> **********************************************
>
>
>
> 2010/7/3 Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx>:
> > On Fri, 2010-07-02 at 23:19 +0000, Carlos Sura wrote:
> >
> >> Hello Ash,
> >>
> >> No, I don't get an error message, the thing is, my post form, isn't working... I can't post those fields in database when I fill them up in the form... But, I really don't know why... Do you want my form code? all the entire class.php code??
> >>
> >> Thank you for helping me.
> >>
> >> Carlos Sura.
> >>
> >>
> >>
> >>
> >>
> >>
> >> Subject: Re: What's wrong in this function? Does not work for me.
> >> From: ash@xxxxxxxxxxxxxxxxxxxx
> >> To: carlos_sura@xxxxxxxxxxx
> >> CC: php-general@xxxxxxxxxxxxx
> >> Date: Sat, 3 Jul 2010 00:08:05 +0100
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> On Fri, 2010-07-02 at 22:05 +0000, Carlos Sura wrote:
> >>
> >>
> >> Hello, this function does not work for me... And I really don't know what am I doing wrong... Any help??
> >>
> >> This function is in a class, and I call it in a form, to create a new user..
> >>
> >>
> >>
> >> $objEmploye=new Employe;
> >> if ( $objEmploye->insert(array($name,$lastname,$salary,$dui,$afp,$isss,$nit)) == true){
> >> echo 'Saved';
> >> }else{
> >> echo 'Error, try again';
> >> }
> >> }else{
> >>
> >>
> >> function insert($field){
> >> if($this->con->connect()==true){
> >> return mysql_query("INSERT INTO employes (name,lastname, salary, id, afp, isss, nit) VALUES ('".$field[0]."', '".$field[1]."','".$field[2]."','".$field[3]."','".$field[4]."','".$field[5]."','".$field[6]."')");
> >> }
> >> }
> >>
> >>
> >>
> >>
> >> Thanks.
> >>
> >> _________________________________________________________________
> >> http://clk.atdmt.com/UKM/go/197222280/direct/01/
> >> Do you have a story that started on Hotmail? Tell us now
> >>
> >>
> >>
> >>
> >> I can't see anything wrong with that code excerpt. Are you getting a specific error, and if so, what is the code on and around the line number indicated in that error?
> >>
> >>
> >>
> >>
> >>
> >>
> >> Thanks,
> >>
> >> Ash
> >>
> >> http://www.ashleysheridan.co.uk
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> _________________________________________________________________
> >> http://clk.atdmt.com/UKM/go/197222280/direct/01/
> >> We want to hear all your funny, exciting and crazy Hotmail stories. Tell us now
> >
> >
> > Break the code down into very simple parts with echo statements. First,
> > I'd echo out the $_POST or $_GET data that you're using to see if the
> > values you think are being sent are being sent. Then, move onto the next
> > part of code, stepping through with echo statements to output variable
> > values to ensure that your data is following the right path. This is one
> > of the easiest ways to find a problem I've found, short of using an IDE
> > to step through the code.
> >
> > Also, you could put the code up on something like pastebin and post a
> > link to it, which will let people see what the code looks like and
> > hopefully figure out where the problem is.
> >
> > Thanks,
> > Ash
> > http://www.ashleysheridan.co.uk
> >
> >
> >
Semicolons at the end of SQL statements are not required unless you are
issuing multiple SQL statements in one string.
Thanks,
Ash
http://www.ashleysheridan.co.uk
