double insert

[Anon]

Hi PHPers,

i'm having trouble with an insert call.
when the insert call is inside an else {insert .....}, the insert into the database occurs twice. when the insert call is not inside the else {}, the insert only occurs once.
whats going on here?

thanks

[Anon]

I imagine there is more to it than you're saying. Post the relevent code including several lines before and several lines after your if ...else construct.

[Anon]

if (!isset($dbid)) {

$query = "SELECT user FROM user_table WHERE user = '$w_user' and password = '$w_password'";
mysql_pconnect("localhost","rootuser","rootpassword")
               or die("Unable to connect to SQL server");
mysql_select_db("seqin") or die("Unable to select database");
$results = mysql_query($query) or die("Select Failed!AAAA"); 

if (  !(mysql_num_rows($results) == 1) ){
require("login3.html");
echo "stuck in second  <br>  ";
}
else {
echo "login okay";
	$query = "INSERT into login_table (username , status, dbid) values('$w_user', '1', '$id' )";
mysql_pconnect("localhost","rootuser","rootpassword")
               or die("Unable to connect to SQL server");
mysql_select_db("seqin") or die("Unable to select database");
mysql_query($query) or die("Insert Failed!bbbbbb");
echo result5555;

}
echo result3333344444;
$dbid = -1;

}