Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_POST['search'])) {
- $s_robot = $_POST['searchRobot'];
- $s_date = $_POST['searchDate'];
- $s_code = $_POST['searchErrorcode'];
- $s_position = $_POST['searchCoordinate'];
- $s_nick = $_POST['searchLoggedBy'];
- //Check witch query to select. Can be made simplier, not priority
- if(!empty($s_robot)) {
- $searchQuery = mysql_query("SELECT * FROM robot_error WHERE robot = '$s_robot' ORDER BY id DESC");
- }
- elseif(!empty($s_date)) {
- $searchQuery = mysql_query("SELECT * FROM robot_error WHERE date = '$s_date' ORDER BY id DESC");
- }
- elseif(!empty($s_code)) {
- $searchQuery = mysql_query("SELECT * FROM robot_error WHERE error_code = '$s_code' ORDER BY id DESC");
- }
- elseif(!empty($s_position)) {
- $searchQuery = mysql_query("SELECT * FROM robot_error WHERE position = '$s_position' ORDER BY id DESC");
- }
- elseif(!empty($s_nick)) {
- $searchQuery = mysql_query("SELECT * FROM robot_error WHERE logged_by = '$s_nick' ORDER BY id DESC");
- }
- if($s_robot != "") {
- $search_robot = $s_robot;
- }
- else {
- $inf = mysql_fetch_array($searchSQL);
- $search_robot = $inf['robot'];
- }
- }
- ?>
Add Comment
Please, Sign In to add comment