why my code print out the last line only ?

[rocky7]

This is my coding. It can run, but the only thing is, it will print out the last line of the data in the table. Why is that happening ? Because I have more than 100 data.  

 

<?php

// set database server access variables: 

$host = "localhost"; 

$user = "root"; 

$pass = ""; 

$db = "master_inventory";

 

// open connection 

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

 

// select database 

mysql_select_db($db) or die ("Unable to select database!"); 

 

// create query 

$query = "SELECT * FROM laptop"; 

 

// execute query 

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 

 

// see if any rows were returned 

if (mysql_num_rows($result) > 0) {

 while($row = mysql_fetch_array($result)) {

  $Lap_PC_Name = $row['Lap_PC_Name'];

  $Lap_War_Expiry = $row['Lap_War_Expiry'];

 }

 

 $to       = 'abc@xyz.com';

 $subject  = 'Testing sendmail';

 $message  = 'The licensed for the following PC will expired in less than one month. PC Name : '.$Lap_PC_Name. '.Date of expired is : ' .$Lap_War_Expiry;

 $headers  = 'From: abc@xyz.com';

 

 if (mail($to, $subject, $message, $headers)) {

  echo "Email sent.";

 }

 else {

  echo "Email sending failed.";

 }

}

?>

[PravinS]

if you want to send mails to more than 100 emails ids then your mail code should be in while loop