mysql count(*)

Senate

Even though I don't consider myself a complete newbie.. I didn't want to waste everyone's time in the other forums with such a simple question.

I'm hella sick today.. so my capabilities have been dropped to about the first day I started learning PHP 😛

I'm running a php script that inputs a series of text files, explodes them into an array, then inputs them into a database. One of the fields in the db is the name of the origin file, which I use to see if that file has been added before (therefore preventing double-entries)

My script keeps stalling at this point though..

      $result = mysql_query("SELECT count(*) AS num FROM csvfiles WHERE csv_file='$input_file'",$conn);
      $num = mysql_result($result,0,"num") or
            die("Could not check the CSV files");

  if ($num == 1) {
        # display error saying the entries been added
  } else {
        # add the entries
  }

Now i'm sure that it's something really really stupid, but i've got bad-ass migraines so am pushing aside my ego and giving in, I need help!!

If you need the rest of the script, just tell me and i'll post it.

hand

Is it my handycap that I'm not an english native speaker? What is your problem?
Your syntax is correct and it works if variable $input_file is set to a correct value:

	  $result = mysql_query("SELECT count(*) AS num FROM csvfiles WHERE csv_file='$input_file'",$conn);
      $num = mysql_result($result,0,"num") or
            die("Could not check the CSV files");

print "$num Rows found 4 input_file:$input_file<br>"; 

  if ($num == 1) {
        # display error saying the entries been added
  } else {
        # add the entries
  }

Senate

It just crashes out and says "Could not check the CSV files" every time. It's SUCH a simple thing, it's almost embarassing to ask about it.. yet it just refuses to work! The rest of the script is fine, i've taken out this piece and it all works.

Why does this always happen when you're sick etc 😛

hand

Try to display the mysql Error:

$result = mysql_query("SELECT count(*) AS num FROM csvfiles WHERE csv_file='$input_file'",$conn);
$num = mysql_result($result,0,"num") 
   or print "Could not check the CSV files &gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";	  

print "$num Rows found 4 input_file:$input_file<br>"; 

  if ($num == 1) {
        # display error saying the entries been added
  } else {
        # add the entries
  }

Did the connect to the db fail?
Does the table "csvfiles" exist?
Does the column csv_file exist?
Waht is the value of $input_file?
Please post the result of the new error message.

Senate

Got it working 🙂

Don't ask how. Played here, played there.. point is, it works.

Thanks for your quick response though.. it's appreciated 🙂