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?

Expand|Select|Wrap|Line Numbers

 
<?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

Expand|Select|Wrap|Line Numbers

 
<?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:

Expand|Select|Wrap|Line Numbers

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

beepdev

Or you can get the absolute value:

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

Return value of 1 instead of -1

re: Return value of 1 instead of -1

re: Return value of 1 instead of -1

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about