madspof Posted October 7, 2007 Share Posted October 7, 2007 I have a script that i want to change a mysql database if a variable contains information, and then to go on to display the information but if the variable does not conatin any informatiion i want it to skip the changing process and just display the information from the db here is my code but i am not sure how to finish this off can come one help me out; <?php // Check if there is a cookie, if there isn't then exit! if (!isset($_COOKIE['cookie_info'])) { echo "You are not logged in."; exit; } elseif (!isset($_COOKIE['cookie_info1'])) { echo "You are not an admin."; exit; } else{ include 'connect.php'; $change = ""; $change = $_GET["Authorised"]; if(preg_match('/[A-Za-z0-9]/', $change)==TRUE){ $letter = array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z"); $numbers = array("1", "2", "3", "4", "5", "6", "7", "8", "9", "0", " "); # $user = str_replace($numbers, "", $change); $auth = str_replace($letter, "", $change); echo "$user <BR> " . "$auth <BR> "; mysql_query("UPDATE members SET Authorised = '$auth' WHERE Gamertag= '$user'") or die(mysql_error()); }else{ $activate = ""; $query = "SELECT Gamertag, Authorised FROM members"; $result = mysql_query($query); $count = 1; while($row = mysql_fetch_assoc($result)) { if($row['Authorised'] == 0){ $activate = "<a href='updateusers.php?Authorised=1$row[Gamertag]'>Deactivated </a>"; } else{ $activate = "<a href='updateusers.php?Authorised=0$row[Gamertag]'>Activated </a>"; } echo "Name :{$row['Gamertag']} <br>" . "Account status : $activate <br>"; $count++; } } } ?> Link to comment https://forums.phpfreaks.com/topic/72198-how-would-i/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.