3 Replies - 589 Views - Last Post: 18 June 2009 - 05:22 PM Rate Topic: -----

#1 konk353535  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 165
  • Joined: 04-December 08

SQl UPDATE not working

Posted 18 June 2009 - 03:56 PM

can anyone tell me wats wrong with me code plz all the strings are fine and its a real table im linkign it to and ive connected to it and everything it just this code that isnt working plz help thanks :)

code :
$sql8="UPDATE college SET currentcourse='$course',current='$current2',daystogo='$daystogo',increase='$increase',stat='$stat' year='$year', day='$day', hour='$hour', minute='$minute', second='$second' WHERE username='$name'";
$result8=mysql_query($sql8);


Thanks

Is This A Good Question/Topic? 0
  • +

Replies To: SQl UPDATE not working

#2 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1638
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: SQl UPDATE not working

Posted 18 June 2009 - 04:22 PM

Your concatenation is wrong. Try this

$sql8="UPDATE college SET  currentcourse='".$course."',current='".$current2."',daystogo='".$daystogo."',increase='".$increase."',stat='".$stat."' year='".$year."', day='".$day."', hour='".$hour."', minute='".$minute."', second='".$second."' WHERE username='".$name."'";
$result8=mysql_query($sql8);


Was This Post Helpful? 0
  • +
  • -

#3 konk353535  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 165
  • Joined: 04-December 08

Re: SQl UPDATE not working

Posted 18 June 2009 - 04:55 PM

View PostPsychoCoder, on 18 Jun, 2009 - 03:22 PM, said:

Your concatenation is wrong. Try this

$sql8="UPDATE college SET  currentcourse='".$course."',current='".$current2."',daystogo='".$daystogo."',increase='".$increase."',stat='".$stat."' year='".$year."', day='".$day."', hour='".$hour."', minute='".$minute."', second='".$second."' WHERE username='".$name."'";
$result8=mysql_query($sql8);


still not working zzz thanks btw
Was This Post Helpful? 0
  • +
  • -

#4 konk353535  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 165
  • Joined: 04-December 08

Re: SQl UPDATE not working

Posted 18 June 2009 - 05:22 PM

View Postkonk353535, on 18 Jun, 2009 - 03:55 PM, said:

View PostPsychoCoder, on 18 Jun, 2009 - 03:22 PM, said:

Your concatenation is wrong. Try this

$sql8="UPDATE college SET  currentcourse='".$course."',current='".$current2."',daystogo='".$daystogo."',increase='".$increase."',stat='".$stat."' year='".$year."', day='".$day."', hour='".$hour."', minute='".$minute."', second='".$second."' WHERE username='".$name."'";
$result8=mysql_query($sql8);


still not working zzz thanks btw

i got it i dunno how but its working now :)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1