i dont know whyyyyyyy he does not inser into the databse the values ??
take a look <?php $DB_HOST = "localhost"; $DB_USER = "db"; // Do not do this. Make a different user. $DB_PASS = "luisito"; $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 opina (nombre, provincia, pais, url, title, email, comentario) VALUES ('".$nombre."', '".$provincia."', '".$pais."', '".$url."', '".$title."', '".$email."', '".$comentario."')"; $result = mysql_query($sql); echo "ˇGracias! Hemos recibido sus datos.\n"; ?> aparently hje works all rigth but when i present this var <?php $link = mysql_connect("localhost", "nobody"); mysql_select_db("mydb", $link); $result = mysql_query("SELECT * FROM opina", $link); echo "Nombre: ".mysql_result($result, 0, "nombre")."<br>"; echo "Pais: ".mysql_result($result, 0, "pais")."<br>"; echo "Provincia: ".mysql_result($result, 0, "provincia")."<br>"; echo "URL :".mysql_result($result, 0, "url")."<br>"; echo "Titulo de La Web: ".mysql_result($result, 0, "title")."<br>"; echo "E-mail :".mysql_result($result, 0, "email")."<br>"; echo "Comentario :".mysql_result($result, 0, "comentario")."<br>"; ?> on the navigator he present onley that empty with no results of the database look Nombre: Pais: Provincia: URL : Titulo de La Web: E-mail : Comentario : i dont know any subjest ??? please help me im newbabe >) ----- 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