Log in script problem, please read

That's rather confusing. Are you using Javascript at all?
If you post the code you use for your register page, it'll be easier for us to see what's going on.

It's my job to help the next generation, and set a good example for them. And for that I'll gladly lay down my life.

Make sure with mysql_connect, don't put "localhost".

You have an error on line 4. Code Should be:

<?php
session_start();
$uname = $_POST['uname'];
$password = $_POST['password'];
$email = $_POST['email']
[Mysql connect and db here]
$result = mysql_query("SELECT * FROM users WHERE username='".$_SESSION['uname']."'";
$query = mysql_fetch_array($result);
$num = mysql_num_rows($query);
if($num>0){
echo"Username is taken";
}
else{
$result = mysql_query("INSERT INTO users (username,password,email) VALUES(".$_POST['username'].",".$_POST['password'].",".$_POST['email'].")");
}
?>

Aye...Hit me up on twitter 'do lol

No no no...You want it done ONLY when the user submits the form, correct?
Use an argument to determine whether the form has been submitted or not.
if($_POST[submit]){
//your code here
}
By using that bit of code, it checks to see if there is a value of the submit button, and the only way to get the value of it is to submit it.

We've all grown up. Cheers.

Yes he right something like this
if($username ==""){
echo" Plz input users name";
}
else{

A true developer

Ah okay. All fixed?

We've all grown up. Cheers.

u can crack md5.

-- Akshay

oh 0_o?

A true developer

Then try SALT, Ultragamer.
Also try something along the lines of crypt(md5(md5($myString))).

We've all grown up. Cheers.

Oh yea I agree on that one.

Aye...Hit me up on twitter 'do lol

It might not work if you don't use the same hashing formula as the one you use for registration.

We've all grown up. Cheers.

it sound hard maybe i gave it a try

A true developer

Oooh yeeeaaa SHA1!

Aye...Hit me up on twitter 'do lol

werid SBP why so happy

A true developer

Why reset the database? Just update the passwords with sha1(). o-0

We've all grown up. Cheers.

Just loop through all of your users and use a MySQL update query and set the password=sha1(password).

We've all grown up. Cheers.

Solved. locking.

Former BBmin and Gamemin.

This can remain open for other people to give their ideas to solve this problem.

I know my apprehensions might never be allayed. And so I close, realizing that perhaps the ending has not yet been written...

2 shay

-- Akshay

Ultragamer1-
<script type="php">
while($d=mysql_fetch_array(mysql_query("SELECT * FROM users"))){
$encrypt=sha1(md5($d[password]);
mysql_query("UPDATE users SET password='$encrypt' WHERE username='$d[username]'");
}
</script>

We've all grown up. Cheers.