Re: Beginner's php/mysql connection probs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, April 28, 2006 10:26 am, sathyashrayan wrote:
>   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";

Put a space after the * in that query.

>     $result = mysqli_query($conn,$temp);

Add this:
or die("query failed " . mysqli_error($conn))

to the end of the line, just like you did for the mysqli_connect() above.

>     while($row=mysqli_fetch_row($result))

$result is PROBABLY 'false' (which is a boolean value) and that's
PROBABLY because having the * right next to 'from' in the query is
invalid.

But the mysqli_error() function will TELL you what is wrong, instead
of me guessing, and it will be a good habit, since it will tell you
want is wrong if you make mistakes in the future.

>     {
>       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"

You need Reply-All to hit all of us...

Well, probably.  You never know with Microsoft products...

You SHOULD be able to tell by looking at the "To: " fields after you
hit the buttons.

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux