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@xxxxxxxxxxxxx from the to/cc fields)
--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
jnichel@xxxxxxxxxxxxxxxxxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
