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
