Jump to content


Photo

X-solved-Xerror editing mysql using php


  • Please log in to reply
23 replies to this topic

#21 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 30 August 2006 - 04:49 PM

$sqlqup= "UPDATE club_data SET Head='$gethead', Teacher='$getteacher', News='$getnews', Message='$getmessage', members='$getmembers' WHERE ClubID='$clubno'";

that's how it should look. as wildteen said, no quotes around the table name.  but you say it gives you a no database selected error when you do this?

edit: shouldn't

mysql_select_db($club_data, $intranet);

be

mysql_select_db($database_intranet, $intranet);



Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#22 ludjer

ludjer
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts
  • LocationSouth Africa-Pretoria

Posted 30 August 2006 - 04:54 PM

yip
it says

Failed to upadate, Reason for failing
No database selected

and if i do put quots around it then
Failed to upadate, Reason for failing
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 ''club_data' SET Head='sanan', Teacher='none', News='noneeen',
Message='noneoneo'' at line 1
:D

#23 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 30 August 2006 - 04:55 PM

shouldn't

mysql_select_db($club_data, $intranet);

be

mysql_select_db($database_intranet, $intranet);

Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#24 ludjer

ludjer
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts
  • LocationSouth Africa-Pretoria

Posted 30 August 2006 - 04:57 PM

IT works !!

;D ;D ;D ;D

thx alot every1 that helped
wildteen88
Crayon Violent

it was this

shouldn't

mysql_select_db($club_data, $intranet);

be

mysql_select_db($database_intranet, $intranet);


:D




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users