php - MySQL Syntax Error Error -

-

when calling function mysql syntax error appears, ideas?

you have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 1

function getcomments1() {     $query = mysql_query("select * comments") or die(mysql_error());     while($post = mysql_fetch_assoc($query)) {         echo $post['author'];      } }  function addcomment($cname, $ccontent) {     $query = mysql_query("insert comments values(null,'$cname','$ccontent'") or die(mysql_error()); } 
<?php include('includes/functions.php'); mysql_set_charset ( "utf8" );  if(isset($_post['submit'])) {     if(isset($_post['commentname'])) {         if(isset($_post['commentcontent'])) {             addcomment($_post['commentname'],$_post['commentcontent']);             header("location: derger.php");         } else { "text missing";          }      } else {         echo "name missing";         include('herger.php');      }  } else {     header("location: werger.php"); } ?> 

("insert comments values(null,'$cname','$ccontent'")

you didn't close values. should be:

("insert comments values(null,'$cname','$ccontent')")

also, here remind you, mysql_ functions deprecated. should using pdo or mysqli. simple google search on either give plenty of resources transition into.


Comments

Post a Comment

Popular posts from this blog

Admob integration with pygame in android -

-
hello curious know solution integrating admob app written in pygame subset android. have tried below things did' t work me :( still nothing working me may there no way :( try 1: followed google https://developers.google.com/mobile-ads-sdk/docs/admob/fundamentals#android solution has no code change build.xml modification didt works me :( try 2: tried below solutio also. http://www.michenux.net/android-admob-tutorial-461.html did't work me :( try 3: tried hack pythonactivity.java. getting below related errors. have googleadmobadssdk-6.4.1.jar in \pgs4a-0.9.4\libs path still below kind of error. below code: protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); //vrbilgi setcontentview(r_layout_main); // setcontentview(r.layout.main); // create adview // adview = new adview(this, adsize.banner, my_ad_unit_id); adview = new adview(this, adsize.banner,"a15...
Read more

mod rewrite - Using "?" when rewriting the URL -

-
i have been researching weeks looking how rewritting file/directory complementary "?" or "question mark" what need: http://mydomain.com/demo01.php to like: http://mydomain.com/?theme=jerus theme > simple directory need use websites products(in case themes) jerus > name of theme extra info: i plan on rewritting every url individually refrain wildcard varibles.** wouldn't easy instead of doing url rewriting put php in directory called theme , name index.php? http://mydomain.com/theme/?t=jerus but if you're re-writing urls make rule acutally make route this: http://mydomain.com/theme/jerus/ which waaaay prettier see question: using clean urls in restful api
Read more

installer - what is Hex representation of MSIUSEREALADMINDETECTION? -

-
i need run installer admin , not system needs connect sql server database using windows authentication. based on research, need set msiuserealadmindetection property "1" i figure these installer properties have hex representation shown in blog @ http://blogs.msdn.com/b/astebner/archive/2007/05/28/2958062.aspx var msidbcustomactiontypeinscript = 0x00000400; var msidbcustomactiontypenoimpersonate = 0x00000800 the script set value available here , not give hex representation of msiuserealadmindetection. know hex representation of msiuserealadmindetection? or has better solution editing installer post build? you can find definitions of these kind of identifiers on machine in windows sdk directory. didn't mention vs version, start looking in c:\program files (x86)\microsoft sdks\windows\x.x\include. if have vs2012+ start looking windows kits. msidefs.h file of interest. contains: // properties related uac #define ipropname_msi_uac_deployment_compliant...
Read more