Grumps

<?php ob_start(); $host="localhost"; // Host name $username="*****"; // Mysql username $password="*******"; // Mysql password $db_name="*****"; // Database name $tbl_name="members"; // 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"); // Define $myusername and $mypassword $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" $_SESSION["myusername"] = $username; $_SESSION["mypassword"] = $mypassword; header("location:main.php"); } { echo "<script language=\"JavaScript\">\n"; echo "alert('Incorrect Username or Password');\n"; echo "window.location='index.php'"; echo "</script>"; } ob_end_flush(); ?> I have a login and I want the incorrect login alert box changed to a yes / no confirm box. If you put in an incorrect username and/or password you should get a confirm box "Do you have an account?" (yes / No). If yes, alert box "Please check your login details" else alert box "Username = cash\nPassword = cash" Any help would be great.

your error is line 3... <?php $db = mysqli_connect("localhost", "root", "3308") or die(mysqli_connect_error()); mysqli_select_db($db, "booksdb") or die(mysqli_error($db)); line 3 is $db = mysqli_connect("localhost", "root", "3308") or die(mysqli_connect_error()); I have not used mysqli howerver it will be close to mysql which I am still learning. What I would try is combining the 2 lines above to this: $db = mysqli_connect("localhost", "booksdb", "TABLEname") or die(mysqli_connect_error()); Good luck

I have no code yet that why I am posting this. I need a login script something like this: if user = xxx then $db_host = "localhost";$db_user = "1234";$db_pass = "*******";$db_name = "1234";$db_table = "xxx"; else if user = yyy then $db_host = "localhost";$db_user = "1234";$db_pass = "********";$db_name = "1234";$db_table = "yyy"; else if user = zzz then $db_host = "localhost";$db_user = "1234";$db_pass = "********";$db_name = "1234";$db_table = "zzz"; else user = '' then $db_host = "localhost";$db_user = "1234";$db_pass = "********";$db_name = "1234";$db_table = "casual"; Trouble is I need to connect to the database to get the user then disconnect and reconnect to it with the correct table. Also have not attempted to write the login script for the website as I think it might be all part of the same thing.