PHP - Empty Results Check Not Working...

i am pulling the login date from the databases and i want it to check if the variable is empty and if it is echo Never Loged In and if it not empty echo the date
          <?php
          include'db.php';
  $id=$_GET['id'];
  $sql=mysql_query("SELECT * FROM admin WHERE id='$id'")or die(mysql_error());
  while($row=mysql_fetch_array($sql))
  {
  $date=$row['login_date'];
  if($date > 0)
  {
  echo"Never Loged In";
  }
  else
  {
  echo"$date";
  }
  }
  ?>

I have the form / script below that works to add multiple rows of data with one query. One thing I did not think about is what if the first set of form fields are filled and the second is not. Currently the script insert an empty row.

I'm sure how I would go about checking for an empty row and if there is an empty row ignore it and do not put it in the DB.  Can someone point me in the right direction?

Code: [Select]
<?php
// Begin the script for this page
if (isset($_POST['submit'])) {

//Assign each array to a variable
$id = $_POST['id'];
$store = $_POST['store'];
$item = $_POST['item'];
$itemprice = $_POST['itemprice'];
$itemnumber = $_POST['itemnumber'];
$couponvalue = $_POST['couponvalue'];
$couponsused = $_POST['couponsused'];
$limit = count($id);
$values = array(); // initialize an empty array to hold the values

for($i=0;$i<$limit;$i++){
$store[$i] = check_input($store[$i]);
$item[$i] = check_input($item[$i]);
$itemprice[$i] = check_input($itemprice[$i]);
$itemnumber[$i] = check_input($itemnumber[$i]);
$couponvalue[$i] = check_input($couponvalue[$i]);
$couponsused[$i] = check_input($couponsused[$i]);

$values[$i] = "( '{$id[$i]}', '{$store[$i]}', '{$item[$i]}', '{$itemprice[$i]}', '{$itemnumber[$i]}', '{$couponvalue[$i]}', '{$couponsused[$i]}')"; // build the array of values for the query string
}
$query = "INSERT INTO `item` (user_id, store, item, itemprice, itemnumber, couponvalue, couponsused) VALUES " . implode( ', ', $values ); // Form the query string and add the implod()ed values



if (!mysql_query($query,$link)){
die('Error: ' . mysql_error());
} else {
$added = "Your items have been added.";
}
}
?>


<div class="pageContent">
    <div id="main">
<div class="container">
<?php
echo $added;
if($_SESSION['id']){
echo '<form action="" method="post">';
echo '<table cellpadding= "4">';
echo '<tr>';
echo '<input type="hidden" name="id[]" id="id[]" value='.$_SESSION['id'].' />';
echo '<td><DIV CLASS="p2"><b>Store</b></div>';
echo '<input type="text" name="store[]" id="store[]" size="15" maxlength="255"/></td>';
echo '<td><DIV CLASS="p2"><b>Item</b></div>';
echo '<input type="text" name="item[]" id="item[]" size="15" maxlength="255"/></td>';
echo '<td><DIV CLASS="p2"><b>Item Price</b></div>';
echo '<input type="text" name="itemprice[]" id="itemprice[]" size="5" maxlength="255"/></td>';
echo '<td><DIV CLASS="p2"><b>Item #</b></div>';
echo '<select name="itemnumber[]" id="itemnumber[]"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option><option value="11">11</option><option value="12">12</option><option value="13">13</option><option value="14">14</option><option value="15">15</option><option value="16">16</option><option value="17">17</option><option value="18">18</option><option value="19">19</option><option value="20">20</option></select></td>';
echo '<td><DIV CLASS="p2"><b>Coupon Value</b></div>';
echo '<input type="text" name="couponvalue[]" id="couponvalue[]" size="10" maxlength="255"/></td>';
echo '<td><DIV CLASS="p2"><b># Coupons</b></div>';
echo '<select style="width: 60px;" name="couponsused[]" id="couponsused[]"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option><option value="11">11</option><option value="12">12</option><option value="13">13</option><option value="14">14</option><option value="15">15</option><option value="16">16</option><option value="17">17</option><option value="18">18</option><option value="19">19</option><option value="20">20</option></select></td>';
echo '<td><DIV CLASS="p2"><b>Doubled Coupon</b></div>';
echo '<select style="width: 75px;" name="doubledcoupon[]" id="doubledcoupon[]"><option value="1">Yes</option><option value="0">No</option></td>';
echo '</tr>';
echo '<tr>';
echo '<input type="hidden" name="id[]" id="id[]" value="'.$_SESSION['id'].'" />';
echo '<td><input type="text" name="store[]" id="store[]" size="15" maxlength="255"/></td>';
echo '<td><input type="text" name="item[]" id="item[]" size="15" maxlength="255"/></td>';
echo '<td><input type="text" name="itemprice[]" id="itemprice[]" size="5" maxlength="255"/></td>';
echo '<td><select name="itemnumber[]" id="itemnumber[]"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option><option value="11">11</option><option value="12">12</option><option value="13">13</option><option value="14">14</option><option value="15">15</option><option value="16">16</option><option value="17">17</option><option value="18">18</option><option value="19">19</option><option value="20">20</option></select></td>';
echo '<td><input type="text" name="couponvalue[]" id="couponvalue[]" size="10" maxlength="255"/></td>';
echo '<td><select style="width: 60px;" name="couponsused[]" id="couponsused[]"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option><option value="11">11</option><option value="12">12</option><option value="13">13</option><option value="14">14</option><option value="15">15</option><option value="16">16</option><option value="17">17</option><option value="18">18</option><option value="19">19</option><option value="20">20</option></select></td>';
echo '<td><select style="width: 75px;" name="doubledcoupon[]" id="doubledcoupon[]"><option value="1">Yes</option><option value="0">No</option></td>';
echo'</tr>';
echo'<tr>';
echo '<input type="submit" name="submit" value="Submit Item">';
echo'</tr>';

echo '</table>';
echo'</form>';
} else {
echo '<h1>Please, <a href="index.php">login</a> and come back later!</h1>';
}
?>
</div>
</div>
</div>

Hi, I have a form containg three text inputs and one text area.  On the php page that processes the form, I want to check first to make sure the user entered something (input field is not empty) before processing the form. I'll just provide a skeleton of form processing page below. *(I'm save space and time by omitting the form itself but he text inputs fields have the following name attributes "name", "company", "email",  and the textarea field's name attribute is  "message" )  I'll do my best to explain the code in further detail within the code comments.


Code: [Select]




<?php




//Turn on output buffering. Allows for headers to be called anywhere on script. See pg228 Ulman.
ob_start();


if (isset($_POST['submit'])) {

// Initialize a session to keep tract of error and success messages:
session_start();


//Define a session variable that keeps tract of how many times user accesses page.
$_SESSION['views'] = 1;
 

// Connect to the database.

        require('config/config.php');


//Check for errors.


//Check to make sure they entered their name.

if (!empty ( $_POST['name']))  {

        $a = TRUE;

    } else {

        $a = FALSE;

        //This variable will be echoed on the form if field is missing a value
        $_SESSION['name'] = '*Please enter a valid name.'; 


   }



//Check to make sure they entered their company name.

if (!empty ( $_POST['company'])) {

        $b = TRUE;

    } else {

        $b = FALSE;

        //This variable will be echoed on the form if field is missing a value
        $_SESSION['company'] = '*Please enter the name of an institution you are affiliated with.';  


   }



//Check to make sure email is valid.

if(eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $_POST['email'])) { 
 

         $c = TRUE; 


}else { 

         $c = FALSE;

      //This variable will be echoed on the form if field is missing a value or email format is wrong.
      $_SESSION['email'] = '*Please enter a valid email address.'; 

      } 




//Check to make sure they entered their message.

if (!empty ( $_POST['message'])) {

        $d = TRUE;

    } else {

        $d = FALSE;

       //This variable will be echoed on the form if field is missing a value
        $_SESSION['message']  = '*Please enter your message.';     


   }




 

//If no errors

if (empty($_SESSION['name'] ) && empty($_SESSION['company'] ) && empty($_SESSION['email'] ) && empty($_SESSION['message'] ) ) {


//Insert data into database.

        $query = "INSERT INTO table...     ;
       
        $result = mysql_query($query) or die("Data could not be inserted into table because: " .mysql_error());



if (mysql_affected_rows() == 1) {

    
         // Display success message

                //This variable will be echoed on the form if everything is filled out correctly.
          $_SESSION['sent'] =     "Your email has been sent.  We will get back to you shortly.";


         // Display contact page (the page containing the form)

header("Location: contact_page.php");

        exit();


}else{die(mysql_error());}
            


//Display error messages.


} else {// if errors array is not empty


         // Display page (page containing the form)

header("Location: contact_page.php"); 

exit();


        
    }//End of if there are errors.


}//End of if submit.




?>







So there it is. Everything works fine except that the part which checks if the textarea (named "message") is empty, doesn't work.   If I click the submit button without filling out any field, the appropriate error messages are printed for the text input fields but not the text area field.  If I fill out all fields correctly and leave the "message" field blank, the form gets processed correctly and values are placed in the database and the success message is printed out.  This is also the case when I enter a value for "message" textarea field.  Now I tried something.  I changed the textarea to a text field and the $_SESSION['message'] variable finally got echoed when I left this field blank.  So apparently, the problem arises from the fact that the named attribute from a textarea tag is not being processed correctly??  Who knows what's going wrong here?

Ok so i have registration page on my webs but i didn't work on empty fields so how could i check all fields?
Code: [Select]
//if no name
if(!$name){
$error = "Username missing.";
}
//if no pass
if($pass == false){
$error = "$error,Password missing";
}
//if no pass conf
if($pass_conf == false) {
$error = "$error,Pass conf missing.";
}
//if no email
if($email == false){
$error = "$error,Email missing.";
}
//pass conf
if($pass != $pass_conf){
$error = "$error,Passwords do not match.";
    }
    echo "<script>alert('$error');</script>;";
//header("Location: register.php");
 My script gives same results every time (even if i fill any of fields)...also if i un-comment header command it wont show alert..it just reloads the page

So can anyone help me with this?
Thanks..

I have two array, how I can have if else to check if both array1 and array2 are empty?

if (empty both arrays) { }
else { even if one of them are not empty }