Re: Beginner's php/mysql connection probs

sathyashrayan wrote:

Dear group, (I am a very beginner so please bear with me for a simple question) I am a self thought php beginner. I wrote my first toy code for database connection in php/mysql. The connection is successful but iam getting a warning and my rows/columns are not showing. I am getting a warning: Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in c:\webs\test\dbs\one.php on line 13 I went through the php manual for the above mentioned function where I get no clue. Pls guide me. code: <html> <head>

     <title> my first data base page </title>

</head> <body> <pre> <?php

    $conn = mysqli_connect("localhost","root","passwd","temp")
            or die("conn failed");
    $temp1 = "select *from grape_varity";     $result = mysqli_query($conn,$temp);

Your query is failing. I'm guessing that it's because you don't have a space between '*' and 'from' Better if you check to make sure the query was successful before trying to get the data.... if ( ! $result = mysqli_query ( $conn, $temp ) ) { echo ( mysqli_error ( $conn ) ); } else { while ( $row = mysqli_fetch_row ( $result ) ) { /// more code Simple error handling...you'll want to do more than that, but that will give you the gist of it

    while($row=mysqli_fetch_row($result))
    {
      for($i =0;$i < mysqli_num_fields($result);$i++)
        echo $row[i]." ";
        echo "\n";
    }
            mysqli_close($conn);

?> </pre> </body> </html> [OT] And one more thing is if I want to replay to a msg in this mail list do I have to hit replay button or replay-all button for posting in the mail list. I use "microsoft outlook 2000" [/OT]

Reply to all (and preferably remove all the addresses save php-general@lists.php.net from the to/cc fields) -- John C. Nichel IV Programmer/System Admin (ÜberGeek) Dot Com Holdings of Buffalo 716.856.9675 jnichel@dotcomholdingsofbuffalo.com