Re: Can't store info on a mysql database...

$sql="INSERT INTO users (login,passwd) VALUES ('$logintxt', 'password($passwdtxt)')" ; mysql_db_query("mysite",$sql); ----- Original Message ----- From: "Mr. BuNgL3" <mrbungle@netcabo.pt> To: <php-general@lists.php.net> Sent: Saturday, November 02, 2002 10:32 AM Subject: [PHP] Can't store info on a mysql database... > Hi... > My problem is that i can't store info in a mysql database... ex: > > I want to store this info in my database: login/passwd and i have the php > code... > > <? > $logintxt = $HTTP_POST_VARS['logintxt']; > $passwdtxt= $HTTP_POST_VARS['passwdtxt']; > > if (!$logintxt || !$passwdtxt) > { > include('registo.htm'); > } > else > { > $ligacao=mysql_connect("localhost","",""); > if (!$ligacao) > { > print("Problemas na ligação á base de dados!"); > } > else > { > //Procurar se user já existente > > //$sql="INSERT into users SET login='$logintxt', > passwd=MD5('$passwdtxt')"; > > $sql="INSERT INTO users (login,passwd) VALUES ('$logintxt', > 'passwd=MD5($passwdtxt))'"; > mysql_db_query("mysite",$sql); > } > mysql_close(); > } > ?> > > what i'm doing wrong? : | > > thanks... > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >