If no result display No record Found

[pquinn]

Hello,

 

First time posting here, my MYSQL version is 5.1.52 and I have a created a search function to find a user record and if the name is typed correctly the name and details are displayed on the search page, but if the name is typed incorrectly nothing is appearing. Basically I would like to be able to say if no record found and redirect back to the previous page.

 

Code:

<?php
add = $_POST['add'];
        
// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Rewards"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");

//Add query
$sql = mysql_query("UPDATE Rewards SET Rewards = (Rewards + 10) WHERE Name '%$add%'");



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");


//Update Total Points query
$sql = mysql_query("UPDATE UserList SET TotalPoints = (TotalPoints + 10) WHERE Name '%$add%'");



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");



//Search Query
$sql = mysql_query("SELECT * FROM UserList WHERE Name '%$add%'");  

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

echo '<br/><img src="images/line1.jpg" alt="" width="200" height="2" />';

echo '<br/> Username: '.$row['Username']; 

echo '<br/>';  

echo '<br/><img src="images/line2.jpg" alt="" width="200" height="2" />';

echo '<br/> Name: '.$row['Name'];   

echo '<br/> Year Group: '.$row['YearGroup'];

echo '<br/> Form Class: '.$row['FormClass'];

echo '<br/>';

echo '<br/><img src="images/line3.jpg" alt="" width="200" height="2" />';

}  


// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Rewards"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");

$sql = mysql_query("SELECT * FROM Rewards WHERE Name '%$add%'");  

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

echo '<br/> Rewards: '.$row['Rewards'];

}  



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Sanctions"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");

$sql = mysql_query("SELECT * FROM Sanctions WHERE Name '%$add%'");  

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

echo '<br/> Sanctions: '.$row['Sanctions'];

}  


// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot SELECT DB");


$sql = mysql_query("SELECT * FROM UserList WHERE Name '%$add%'");  

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

echo '<br/> Total Points: '.$row['TotalPoints'];

echo '<br/>';

echo '<br/><img src="images/line4.jpg" alt="" width="200" height="2" />';   

}  

Any help would be greatly appreciated.

 

Many Thanks

 

P Quinn

 

MOD EDIT:

 . . . 

tags added.

[Pikachu2000]

When posting code, please enclose it within the forum's

 . . . 

BBCode tags.