Return value of 1 instead of -1

[mstng07]

How can i get a return value of 1 if the user exists in the table instead of it returning a -1?

<?php
require("config.php");
if($_GET['action'] == 'post')
{
   if(empty($_POST['Employee_ID']) || empty($_POST['Date']) || empty($_POST['Activity']) || empty($_POST['Miles']))
    {
      //if everything is not filled in than prints out error message
      error("blank");
      exit;
      }
      if(!empty($_POST['Employee_ID']))
      {
       $query="SELECT Employee_ID FROM analyzer_query WHERE Employee_ID = '{$_POST['Employee_ID']}'";
       $rs = $conn->execute($query);
       $num_columns = $rs->RecordCount();
       echo $num_columns . "<br>";
                    if($num_columns <= 0)
                        {
                          echo error ("user");
                          exit;
                        }
                        else
                        {
                        $conn->execute("INSERT INTO Activity_Log (`Employee_ID`, `Date`, `Activity`, `Miles`) VALUES ('{$_POST['Employee_ID']}', '{$_POST['Date']}', '{$_POST['Activity']}', '{$_POST['Miles']}')");
                        header("Location: success.php?action=success");
                        }
 }
}
function error($error)
{
   //if error is equal to blank
   if($error == 'blank')
      {
      echo "Please fill in all the required fields before submitting";
      }
 //if error is equal to blank
   if($error == 'user')
      {
      echo "Please fill in the correct Employee ID";
      }
}
?>

here is my config.php file

<?php  $conn = new COM ("ADODB.Connection") or die("Cannot start ADO");
$connStr = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=F:\Wellness Program\Copy of HR Employee Wellness Program.mdb;";
$conn->open($connStr); //Open the connection to the database
?>
 

[Atli]

Hi. Welcome to TSDN!

I assume this has something to do with the $rs->RecordCount() method?
Please explain a little better what you are talking about.

You could of course always simply change the value:

if($value == -1) $value = 1;
 

[beepdev]

Or you can get the absolute value:

[PHP]$value = abs($value);[/PHP]