[SOLVED] Notice: A non well formed numeric value encountered

[paragkalra]

I have a MySQL database and a table containing many cool quotes. I have written small php code that fetches the data from the database and displays a random quotation on the web-browser.

 

Everything is working but I am getting a strange error along with a random quotation:

Notice: A non well formed numeric value encountered

 

My code is:

<?php

 

 

include "dbconnect.php";

$query1="SELECT `srno` FROM `quotes` ORDER BY `srno` DESC LIMIT 1" ;

$min=1;

$maxdata=mysql_query($query1);

while($maxlimit=mysql_fetch_row($maxdata))

{

$max=`echo "$maxlimit[0]<br=>"`;

 

}

$quoteno=rand($min, $max);

$query2 = "SELECT `quote`,`author` FROM `quotes` where `srno`=$quoteno";

$selectdata = mysql_query($query2);

while($col=mysql_fetch_row($selectdata))

{

 

echo "$col[0]<br>";

echo "- $col[1]<br>";

 

}

?>

 

The exact output that being displayed with a random quote is:

 

Notice: A non well formed numeric value encountered in /var/www/test/rquotes.php on line 13

 

When everything's coming your way, you're in the wrong lane.

- Maxx Power

[Maq]

Well what is this?

 

$max=`echo "$maxlimit[0]
"`;

 

Have you echoed $max and $min?

[paragkalra]

$max=`echo "$maxlimit[0]<br=>"`;

 

Through above line I am storing the the maximum value contained in "maxlimit" into a variable called "max".

 

That piece of code is working. Problem lies in:

$quoteno=rand($min, $max);

[Maq]

Try this:

 

$maxdata=mysql_query($query1) or die(mysql_error());
$maxlimit=mysql_fetch_assoc($maxdata);
$max=$maxlimit['srno'];
$quoteno=rand($min, $max);

[paragkalra]

"Maq"..U r a Genious...ur code worked like a breeze.......thanks mate......

[Maq]

"Maq"..U r a Genious...

 

Far from it....

 

thanks mate......

 

You're welcome! 

[DarkWater]

Well what is this?

 

$max=`echo "$maxlimit[0]<br=>"`;

 

Have you echoed $max and $min?

 

Did anyone else notice the fact that he was using backticks?

[Maq]

Well what is this?

 

$max=`echo "$maxlimit[0]
"`;

 

Yes ---^ 

[paragkalra]

I am a newbie and it was perhaps my first php code ... 

[Maq]

I am a newbie and it was perhaps my first php code ... 

 

Hehe, we all start somewhere.  I was just asking because I've never seen that before.  I though it may be something that I wasn't aware of...