Query not occuring

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
FluxNYC
Forum Newbie
Posts: 6
Joined: Sun Mar 25, 2007 6:43 pm

Query not occuring

Post by FluxNYC »

Solved. Thanks for help.
Last edited by FluxNYC on Wed Mar 28, 2007 3:28 pm, edited 1 time in total.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Re: Query not occuring

Post by volka »

FluxNYC wrote:No errors come up whatso ever the page loads as if the insertion occured. Any ideas?
Sounds like the script works fine ...unless it doesn't?

try

Code: Select all

<?php
error_reporting(E_ALL);
ini_set('display_errors', true);

if ( !isset($_POST['cname']) ) {
  die('cname not set');
}
else {
  $link = mysql_connect($hostname,$username, $password) or die(mysql_error());
  mysql_select_db($dbname, $link) or die(mysql_error());

  $query = "INSERT into $campaigns_table (campaign_name) VALUES ('".mysql_real_escape_string($_POST['cname'])."')";
  echo '<div Debug: ', htmlentities($query), "</div>\n";               
  mysql_query($query, $link) or die(mysql_error());
  echo 'affected rows: ', mysql_affected_rows($link), "<br />\n";
}
Post Reply