the mysql server guives to me this error now tk a look
ˇGracias! Hemos recibido sus datos. Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\apache group\apache\htdocs\1\2\registered.php3 on line 39 Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in c:\apache group\apache\htdocs\1\2\registered.php3 on line 42 the error is on here line 39 mysql_free_result($result); line 42 mysql_close($db); ----- Original Message ----- From: "Bryan Lipscy" <[EMAIL PROTECTED]> To: "'Luis A'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 8:25 PM Subject: RE: [PHP] mysql trouble > Create a user with appropriate privledges for the database. DO NOT use > root. > > > <?php > > $DB_HOST = "localhost"; > $DB_USER = "root"; // Do not do this. Make a different user. > $DB_PASS = ""; > $DB_DB = "mydb"; > > // connect to the database server > $db= @mysql_pconnect ( $DB_HOST , $DB_USER , $DB_PASS ); > > // use the database > @mysql_select_db ( $DB_DB ) or die ( "[ERROR] ".mysql_error() > ); > > // process form > > $sql = "INSERT INTO agenda (nombre, direccion, telefono, email) > VALUES ('".$nombre."', '".$direccion."', '".$telefono."', > '".$email."')"; > > $result = mysql_query($sql); > > echo "ˇGracias! Hemos recibido sus datos.\n"; > > /* Free resultset */ > mysql_free_result($result); > > /* Closing connection */ > mysql_close($db); > > ?> > > > You did not mention where the $nombre, $direccion, $telefono, or $email > variables are being initialized. > To capture the values from a form use $_POST['name'] where name is the > name of the field on the form. > > HTH > > -----Original Message----- > From: Luis A [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 25, 2003 4:21 PM > To: [EMAIL PROTECTED] > Subject: [PHP] to paulm Re: [PHP] mysql trouble > > > hey i think the root does not need password to connect to mysql > > or yes ???? > > on my server the root user does not have password > thats why i dont know why he does not update the database? > > ----- Original Message ----- > From: "paulm" <[EMAIL PROTECTED]> > To: "Luis A" <[EMAIL PROTECTED]> > Sent: Tuesday, February 25, 2003 6:48 PM > Subject: Re: [PHP] mysql trouble > > > > you don't have a password for root in mysql_connect > > ----- Original Message ----- > > From: "Luis A" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, February 26, 2003 1:04 AM > > Subject: [PHP] mysql trouble > > > > > > hi pasl i got a troblem here > > > > > > if some one can help me ? > > > > take a look at this > > <?php > > // process form > > $link = mysql_connect("localhost", "root"); > > mysql_select_db("mydb",$db); $sql = "INSERT INTO agenda (nombre, > > direccion, telefono, email) " + > > "VALUES ('$nombre', '$direccion', '$telefono', '$email')"; $result = > > > mysql_query($sql); echo "ˇGracias! Hemos recibido sus datos.\n"; > > > > ?> > > > > > > > > HE DOES NOT WORKING > > > > any subjest ? > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php