$md = MD5($passwdtxt);
$sql="INSERT INTO users (login,passwd) VALUES (\"$logintxt\", \"$md\")";
mysql_query($sql) or die(mysql_error());

next time, show the error messages you got.

Also, ALWAYS USE mysql_error() when executing mysql_query()  --  see above
=====================================
"Mr. BuNgL3" <[EMAIL PROTECTED]> wrote in message
news:20021101233214.19457.qmail@;pb1.pair.com...
> 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? : |



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to