Jump to content


Photo

Simple update question... please help


  • Please log in to reply
1 reply to this topic

#1 Scottyy

Scottyy
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 03 September 2006 - 07:22 PM

Hello everyone   :)

I’m a php/mysql newbie who’s stuck in a simple problem:

I have a mysql database with several tables:
bloggers
languages
etc..

bloggers table has fields like blogTitle, blogURL, language, etc…
language table has fiels like langID (which maps to language in the bloggers table), langCount, etc..

The user fills in a form and selects the language of his blog. I want to increment the value of langCount by 1 for the language that the user selected.

Here is part of code I use. For some reason it doesn't increment the value of langCount as expected:


if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "submityourblog")) { 
  $insertSQL = sprintf("INSERT INTO bloggers (name, email, province, city, country, bloggingSince, blogTitle, blogDescription, blogUrl, blogFeed, blogCategory, blogawards, `language`, imagefile) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", 
                       GetSQLValueString($_POST['name'], "text"), 
                       GetSQLValueString($_POST['email'], "text"), 
                       GetSQLValueString($_POST['province'], "text"), 
                       GetSQLValueString($_POST['city'], "int"), 
                       GetSQLValueString($_POST['country'], "text"), 
                       GetSQLValueString($_POST['bloggingSince'], "date"), 
                       GetSQLValueString($_POST['blogTitle'], "text"), 
                       GetSQLValueString($_POST['blogDescription'], "text"), 
                       GetSQLValueString($_POST['blogUrl'], "text"), 
                       GetSQLValueString($_POST['blogFeed'], "text"), 
                       GetSQLValueString($_POST['blogCategory'], "text"), 
                       GetSQLValueString($_POST['blogawards'], "text"), 
                       GetSQLValueString($_POST['language'], "text"), 
                       GetSQLValueString($_POST['imagefile'], "text")); 
                       
  mysql_select_db($database_obc, $obc); 
  $Result1 = mysql_query($insertSQL, $obc) or die(mysql_error()); 
   
// UPDATE langCount Starts here   

mysql_select_db($database_obc, $obc); 
$query_rsLang = sprintf("SELECT langID, langCount FROM languages WHERE langID = %s", GetSQLValueString($_POST['language'], "text")); 
$rsLang = mysql_query($query_rsLang, $obc) or die(mysql_error()); 

$row_rsLang = mysql_fetch_assoc($rsLang); 
$totalRows_rsLang = mysql_num_rows($rsLang); 

$varLangCounter = ($row_rsLang['langCount'] + 1); 

$updateSQL = sprintf("UPDATE languages SET langCount=%s WHERE langID=%s", 
                       GetSQLValueString($varLangCounter, "text"), 
                       GetSQLValueString($_POST['language'], "text")); 
     
     
  mysql_select_db($database_obc, $obc); 
  $Result2 = mysql_query($updateSQL, $obc) or die(mysql_error()); 
   
// Update langCount ends here 


  $insertGoTo = "thankyou.php"; 
  if (isset($_SERVER['QUERY_STRING'])) { 
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; 
    $insertGoTo .= $_SERVER['QUERY_STRING']; 
  } 
  header(sprintf("Location: %s", $insertGoTo)); 
} 


Hope someone can help. Thanks

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 September 2006 - 10:07 PM

Not sure... what string does that sprintf() call return?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users