dturnbull

So I have this Login Script, but the problem is I can only log into one of the test accounts. When i try the others the content after echo [b]'<b>Logged in Successfully</b>';[/b] doesn't appear. Please Help. [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<?php session_start(); // start session. # Login Script # WiiBuddies.com include("header.html"); require_once("mysql.php"); $username = $_GET['username']; $password = $_GET['password']; $rs = mysql_query("select count(*) as count from user where username='$username' and password='$password'"); if (mysql_num_rows($rs) == 1) { echo '<b>Logged in Successfully</b>'; $logged = "SELECT id, username, password, friend_code, location, email, about FROM user"; $result = mysql_query($logged); $query = "SELECT id, friend_code, username, email, location, about FROM user WHERE username='$username' AND password='$password'"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "<p><b>Change Username</b> <br /> <form action='change_username.php'><input name='hiddenField' type='hidden' name='id' value='{$row['id']}' /> New Username: <input type='text' name='changeusername'> <input type='submit' value='Change Username'> </form> <p><u>Current Username</u><br /> {$row['username']}<p>" . "<b>Change Friend Code</b> <br /> <form action='change_fc.php'> <input type='text' name='changefc'> <input type='submit' value='Change Friend Code'> </form> <p><u>Current Friend Code</u><br /> {$row['friend_code']}<p>" . "<b>Change Email</b> <br /> <form action='change_email.php'> <input type='text' name='changeemail'> <input type='submit' value='Change E-Mail'> </form> <p><u>Current E-Mail</u><br /> {$row['email']}<p>" . "<b>Change Location:</b><br /> <form action='change_location.php'> <input type='text' name='changelocation'> <input type='submit' value='Change Location'> </form> <p><u>Current Location</u><br />{$row['location']}<p>" . "<b>Change About:</b><br /> <form action='change_username.php'> <textarea name='changeabout' cols='60' rows='4'></textarea><br /> <input type='submit' value='Change About'> </form> <p><u>Current About Message</u><br /> {$row['about']}<p>"; } } else { echo 'password username did not match'; } ?>[/quote]

thnx for the help. worked great.

How would I check the username/password against the database? that is wat I am having troubles with.

I have a really simple database/script. Users sign up with an email, username, and password (and some other fields), and then a new page is created for them with their details. Could someone give me some help on how to make it so users can use their email/password to login then update their details?

Hi, I was wondering if it would be possible to have a script that can post a bulletin on myspace, and skip the "confirm bulletin" page.... or a script that automatically confirms the bulletin itself :) thanks in advance :)

Hi, I was wondering if it was possible for a user to complete an action, and then something automatically happens on the admin side of it. example. user buys a service. when admin is logged in to control panel the task automatically verifies this. If it is possible, can someone link me to some useful tuts? :)

Okay, I'm a pretty big PHP Noob, I only know the total basics, so i was wondering if someone could help me (or write the code for me :P ) I need a script that can be used to people type in a Title, and a Message, they click submit, they get logged into a specified myspace account, a bulletin is posted with the title/message, and then they are logged out so they can't use the other features of the account. Any help would be awesome :) edit: wrong forum sorry