PHP - If Row Doesnt Exist

hi, i have a select which gets todays schedule for each user.  sometimes that user doesnt have anything for todays date and it will display the info from the user above him.  how can i make it so it stays blank if there is no record?

I have an array like so


Array (14)
(
|    ['0'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['1'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['2'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['3'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['4'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['5'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['6'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['7'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['8'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['9'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['10'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['11'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['12'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
|    ['13'] => Array (5)
|    (
|    |    ['name'] = String(7) "Pikemen"
|    |    ['hp'] = Integer(1) 0
|    |    ['atk'] = Integer(1) 5
|    |    ['def'] = Integer(1) 5
|    |    ['rng'] = Integer(2) 15
|    )
)


what i want to do is add the details to a new multi dimensional array but only add one each like so

array(
    ['units'] = array(
          ['name'] => 'Pikemen',
          ['lost']    => 14
     )
)
basically where the HP is 0 in the first array i need to add them to the second if the name is unique. I have tried array unique but it didnt seem to work. Any ideas? All i get it a loop of each Pikemen

hello all,

i have a quick question.  i have a select all from toolout with toolid = $tid.  the problem is, if there isnt an entry yet in toolout, it is giving me the info from the row above.  is there any way that i can do a (if it doesnt exist, set $status to 1, rather than using the previous rows code)

my code is below.

Code: [Select]
if(isset($_POST['search']))
{

$tool=$_POST['tool'];

echo "<table border='1' style='border-collapse: collapse' bordercolorlight='#000000'

bordercolordark='#000000' width='98%' align='center'>";
echo "<tr><td width='100%' colspan='5' align='center'><b>Tool List - $tool</b></td></tr>";

echo "<tr>

<th align='center'>Tool</th>
<th>Location</th>
<th>Status</th>


</tr>";

$result = mysql_query("SELECT * FROM tools WHERE toolgroup LIKE '%$tool%' ORDER BY tool");
while($row = mysql_fetch_array($result))
{

$id=$row['id'];
$tool=$row['tool'];
$barcode=$row['barcode'];
$location=$row['location'];

$result2 = mysql_query("SELECT * FROM toolout WHERE toolid = '$id' ORDER BY id ASC");
while($row2 = mysql_fetch_array($result2))
{
$status=$row2['status'];
$who=$row2['who'];
$datechanged=$row2['datechanged'];

$datechanged1 = date( 'M j, Y', strtotime($datechanged) );


   
if("$status" == "1") {
$statusout="<font color='#0000FF' size='4'>IN</font><br /><a href='toolout.php?tool=" . $id . "' target='action'>SIGN OUT</a>";
} 

if("$status" == "2") {
$statusout="<font color='#FF0000' size='4'>OUT</font><br />$who - $datechanged1";
}

if("$status" == "3") {
$statusout="<font color='#00FF00' size='4'>PENDING OUT</font><br />$who - $datechanged1";
}

if("$status" == "4") {
$statusout="<font color='#00FF00' size='4'>PENDING IN</font><br />$who - $datechanged1";
}
 

}

  echo "<tr>";
  echo "<td align='center'>" . $tool . "</td>";
  echo "<td align='center'>" . $location . "</td>";
  echo "<td align='center'>";
  if (isset($status)) {
     echo "$statusout";
  } else {
echo "<font color='#0000FF' size='4'>IN</font><br /><a href='toolout.php?tool=" . $id . "' target='action'>SIGN OUT</a>";
  }
  echo "</td>";
   
 
 

  echo "</tr>";
  }
echo "</table>";

}
Thank you so much.

Hey,
I have this code below which seems to completely fail sending my laptop cpu fan on a frenzy. All I am wanting to do is find whether the id in the url is located inside the array below else state its not in an error saying its not a valid id (for people who change the url shown below). At the moment it doesnt like the else statement if the isset clause it not true. (I have also tried, array_key_exists)

All I can think is that it get stuck looking for an id that doesnt exist inside the array but keeps searching though I dont know much about arrays etc. Besides this when a id is inside the array the script works like I want it to.
Any ideas would be much appreciated as this is hold me back at the moment

Code: [Select]
//url: http://localhost/website/shop.php?id=10197

// Array is built from table prior to this as it will grow in size
$_SESSION['storesProducts'] = Array ( [10197] => 0 [10198] => 0 [10199] => 1 [10200] => 1 [10201] => 1 [10202] => 1 [10205] => 0 [10206] => 1 [10207] => 1 )

if(isset($_SESSION['storesProducts'][$id])){
$storesProducts = $_SESSION['storesProducts'][$id];
if($storesProducts == 0){
$list = $this->displayCategories($id);
}else{
$createProducts = new constructProducts();
$products = $createProducts->pagination($id);
}
}else{
$list = "ITS NOT HERE";
}
$output = new outputShop();
$output->display($list, $products);

i have error where my code should update existing data where id exist, it get updated ..but the others data is disappeared .only the data updated is remained 

$sql1 ="select*from semakan_dokumen where email='$stdEmail'";
$sqlsearch1 = mysqli_query($dbconfig,$sql1);
$resultcount1 = mysqli_num_rows($sqlsearch1);

if($resultcount1 > 0){
$query1=("UPDATE  semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3',sijil_sekolah= '$fileName4', sijil_dip= '$fileName5',sej_julai='$fileName6',bm_julai='$fileName7',muet='$fileName8', mid1='$fileName9',yuran= '$fileName10',umpa_bend1= '$fileName11',umpa_bend2='$fileName12',bpkp='$fileName13', penaja='$fileName14',kesihatan= '$fileName15', jhepa='$fileName16' where email= '$stdEmail' ");

}else{


//filezip
$query1 = "INSERT INTO semakan_dokumen (email,surat_tawaran,ic,sijil_lahir,sijil_spm,sijil_sekolah,sijil_dip,sej_julai,bm_julai,muet,mid1,yuran,umpa_bend1,umpa_bend2,bpkp,penaja,kesihatan,jhepa) VALUES ('$stdEmail','$fileName','$fileName1','$fileName2','$fileName3','$fileName4','$fileName5','$fileName6','$fileName7','$fileName8','$fileName9','$fileName10','$fileName11','$fileName12','$fileName13','$fileName14','$fileName15','$fileName16')";
}