PHP - Mysterious Numbers Appear When Returning The Result.

hello, anybody able to help me with why this is only returning the first staff member's hours?

Code: [Select]
<?php

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

$y3=$_POST['y'];
$m3=$_POST['m'];
$d3=$_POST['d'];

$pdate=$y3."-".$m3. "-".$d3;
$pdate1 = date( 'D M j', strtotime($pdate) );
} else {


$pdate =  date('Y-m-d', strtotime("-1 day") );
$pdate1 = date( 'D M j', strtotime($pdate) );


}
echo "<table border='1' style='border-collapse: collapse' bordercolorlight='#000000' bordercolordark='#000000' width='98%' align='center'>";
echo "<tr><td width='100%' colspan='9' align='center'><b>Timesheets For $pdate1</b></td></tr>";


$result = mysql_query("SELECT * FROM staff ORDER BY name");
while($row = mysql_fetch_array($result))
{
$eid=$row['eid'];
$name=$row['name'];

  echo "<tr>";
  echo "<td align='left' colspan='9'><b>" . $name . "</b></td>";
  echo "</tr>";
 
 echo "<tr>
<th align='center'>Date</th>
<th align='center'>Job Number</th>
<th align='center' width='30%'>Service Report</th>
<th align='center'>Sign In Time</th>
<th align='center'>Sign Out Time</th>
<th align='center'>Lunch</th>
<th align='center'>Time Billed</th>
<th align='center'>Estimated</th>

</tr>";
 
 
$result3 = mysql_query("SELECT * FROM timesheet WHERE date = '$pdate' AND eid = '$eid'");
$talltime = 0;
while($row3 = mysql_fetch_array($result3))
{

  $tid=$row3['id'];
  $tdate=$row3['date'];
  $tjobnumber=$row3['jobnumber'];
  $teid=$row3['eid'];
  $tdescription=$row3['description'];
  $tsignin=$row3['start'];
  $tfinish=$row3['finish'];
  $tlunch=$row3['lunch'];
  $tkms=$row3['kms'];
  $tschednum=$row3['schednum'];

 
  
  $tdate1 = date( 'M j, Y', strtotime($tdate) );
  
    $tsignin1 = date( 'g:i a', strtotime($tsignin) );
$tfinish1 = date( 'g:i a', strtotime($tfinish) );

if( empty($tfinish) ) {
 $tfinish2="<i>In Progress";
} else {
 $tfinish2="$tfinish1";
}

$shortid=substr($tjobnumber, 5, -1); //remove the first 5 characters and minus the last character

$result = mysql_query("SELECT * FROM jobs WHERE id = '$shortid'");
while($row = mysql_fetch_array($result))
{
$jstatus=$row['status'];
 
}


$result4 = mysql_query("SELECT * FROM schedule WHERE id = '$tschednum'");
while($row4 = mysql_fetch_array($result4))
{

  $sid=$row4['id'];
  $sdate=$row4['date'];
  $seid=$row4['eid'];
  $sjobnumber=$row4['jobnumber'];
  $sstarttime=$row4['starttime'];
  $sstatus=$row4['status'];
  $setime=$row4['etime'];
  
}

$log_in_time_string = strtotime($tsignin);
$log_out_time_string = strtotime($tfinish);
$difference_in_seconds = ($log_out_time_string - $log_in_time_string);
$tbilled = ($difference_in_seconds / 3600);
  
  
  if($tbilled < 0)
{
    $tbilled1 = $tbilled + 24;
} else {
    $tbilled1=$tbilled;
}
  
  $tbilled2 = number_format(round($tbilled*4)/4,2);
  $tbilled3 = $tbilled2 - $tlunch ;
  $talltime += $tbilled3;
  
  
  echo "<tr>";
  echo "<td align='center'>" . $tdate1 . "</td>";
  echo "<td align='center'>" . $tjobnumber . "</td>";
  echo "<td align='center'>" . $tdescription . "</td>";
  echo "<td align='center'>" . $tsignin1 . "</td>";  
echo "<td align='center'>" . $tfinish2 . "</td>";
echo "<td align='center'>" . $tlunch . " hour</td>";
echo "<td align='center'>";
     if ($tbilled3 > $setime ) {
 echo "<font color='red'><b>*** " . $tbilled3 . " hours ***</b></font>";
 } else {
 echo "" . $tbilled3 . " hours";
 }
echo "</td>";
echo "<td align='center'>" . $setime . " hours</td>";


  echo "</tr>";

} 
   echo "<tr>";
 
  echo "<td colspan='6' align='right'><b>Totals :</td>";
  echo "<td align='center' colspan='2'>";
     if ($talltime > "8" ) {
 echo "<font color='red'><b>*** " . $talltime . " hours ***</b></font>";
 } elseif ($talltime < "0" ) {
 echo "<font color='red'><b>Not Signed Out</b></font>";
 } else {
 echo "" . $talltime . " hours";
 }
echo "</td>";

  echo "</tr>";

   echo "<tr>";
 echo "<td align='center' colspan='8' bgcolor='#D9FFD9'><hr></td>";
  echo "</tr>";

}
    
echo "</table>";







include 'close.php';

?>

Hello.   I'm having some issues with a select statement containing ABS(). Here's the select query:

"SELECT gadenavn, husnr, ABS(husnr - $husnr) AS husnr_range, postnr,db, shaping, dsl_node, ctr_node, db_ctr_luftlinje, bynavn FROM `TABLE 1`, Post_numre WHERE `postnr`=`postnummer` AND `gadenavn`=`$vejnavn` AND `postnr`=`$postnr` AND `husnr`>0 ORDER BY husnr_range ASC LIMIT 5"

Now lets asume my variable "$husnr" is a value of 15. In my table I have the values for coulmn "husnr":   13,12,11,10,9   What really bugs me is the outcome doing af simple "while loop"  is returning the values 12,11,10,9.   What happened to 13?!   printing the "husnr_range" values shows "3,4,5,6".   What puzzles is the row missing, as I only get 4 results, with a "LIMIT 5".   Can anyone explain why the last resulst isn't included?

Does anyone see anything wrong with the SQL?  This function keeps returning false.

Thank you for your time.

Code: [Select]
function insert_survey1($survey1_anwers) {
  // extract order_details out as variables
  extract($survey1_anwers);
 
  $username = $_SESSION['valid_user'];
  $conn = db_connect();

  // select user_id based on the entered data
  $query = "SELECT user_id FROM user WHERE
gender = '".$gender."',
birth_range = '".$birth_range."',
degree_year = '".$degree_year."'
username = '".$username."'";

  $result = $conn->query($query);

  //if the resulting user_id exists (AND has the POST data just entered, since the query must match those to return a row) ,
  if($result->num_rows>0) {
    //return the current row of the result set as an object and place it into user variable
    $user = $result->fetch_object();
//set variable for user_id to the fetched user object data representing the user_id int he db( because it was fetched from the sql select result)
    $user_id = $user->user_id;
//update the fields since the user exists already.
$query = "UPDATE user
SET gender = '".$gender."',
birth_range = '".$birth_range."',
degree_year = '".$degree_year."'
WHERE user_id = '".$user_id."'";

// $query = "UPDATE `alumni_survey`.`user`
// SET `gender` = '".$gender."',
// `birth_range` = '".$birth_range."',
// `degree_year` = '".$degree_year."'
// WHERE `user`.`user_id` = '".$user_id"'";
  } else {
//otherwise, if the user doesn't exist already insert this new data.
    $query = "INSERT INTO user (gender, birth_range, degree_year)
VALUES('".$gender."','".$birth_range."','".$degree_year."')
WHERE user_id = '".$user_id."'";
    $result = $conn->query($query);

    if (!$result) {
       return false;
    }
  }
 
  return $user_id;
}

this is only returning one record, when I know there are more, and it's an endless loop crashing my browser, can someone tell me how my brackets are wrong, or what is wrong?

Code: [Select]
if (isset($_POST['search'])){
$keyword=$_POST['keyword'];
}
$sql="SELECT id, fname, lname FROM obituaries WHERE lname LIKE '%$keyword%' OR fname LIKE '%$keyword%' ORDER BY id DESC";
$results = mysql_query($sql);
$num = mysql_num_rows ($results);

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$id = mysql_result($results,$i,"id");
$fname = mysql_result($results,$i,"fname");
$lname = mysql_result($results,$i,"lname");

 ?>
<a href="view.php?id=<?php echo ($id); ?>"><?php echo($fname); ?> <?php echo($lname); ?></a>
<?php
          }
}

?>Thanks in advance

Hello,   I am fairly new to PHP and I found some php code to print an array of numbers that create a combination - however, its slams all the numbers together without a space or a comma separator.   How can I separate the numbers in this array with the given code?  Ive attached a photo of the code.