Hello John,
are you sure, that the user "test" with password "test1" exist in your
Grant-Tables and has rights to
INSERT ??? [;-)]
Gruß
Christian
john zie wrote:
>
>
>
> Mysql:
>
> We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It
> works fine, however when we test a php file which just function to
> insert some data to a table in database, and display all data on the
> web page. After run this, the data have been inserted and displayed;
> however, it give us a warning message "Warning: MySQL: Unable to save
> result set in ....." . I test the same scripts in many other servers
> with MySQl 3.22.23,(BSD) , MYSQL 2.23.36(Linux), there are no errors
> or any warning messges at all. Is there a way to reconfigration
> MYSQL, or PHP to eliminate this problem. The following is a typical
> test .php:
>
> to run this sript, you just create a table call user on your test
> database.
> SQL Scripts to create the table
> "
> create table user (Uname varchar(20)
> pass varchar(8));
>
> "
>
>
> <HTML>
> <BODD>
> <TITLE> New Document </TITLE>
> </HEAD>
> <BODY>
> <?php
> $db = mysql_connect("localhost", "test", "test1") ;
> mysql_select_db("testdata");
>
>
>
> if($submit)
> {
> $query = "INSERT INTO user (user, pass) values
> ('$user', '$pass') ";
>
> $result = mysql_query($query, $db);
> echo "Your values have been inserted in
> database<BR>";
> }
>
>
> $select = "SELECT * FROM user";
> $result1 = mysql_query($select, $db);
>
> while($r = mysql_fetch_array($result1))
> {
> $user = $r["user"];
> $pass = $r["pass"];
>
> echo "This is user: $user<BR>";
> echo "This is pass: $pass<BR>";
> }
> ?>
> <form name = frm method = get>
> Username:<input type = text name = user><br>
> Password:<input type = password name = pass>
> <input type = submit name = submit>
> </form>
> </BODY>
> </HTML>
>
>
>
> Thanks,
>
>
> John
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>