to Bryan Lipscy Re: [PHP] mysql trouble

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" <x427279616e@monroe.net> To: "'Luis A'" <webmaster@iscf.esisc.colombus.cu>; <php-general@lists.php.net> 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:webmaster@iscf.esisc.colombus.cu] > Sent: Tuesday, February 25, 2003 4:21 PM > To: php-general@lists.php.net > 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" <paulm@sgi.rdscv.ro> > To: "Luis A" <webmaster@iscf.esisc.colombus.cu> > 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" <webmaster@iscf.esisc.colombus.cu> > > To: <php-general@lists.php.net> > > 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 > >