Re: showing warnings
| From: | Asim | Date: | Mon, 10 Sep 2007 13:22:04 +0000 |
| Subject: | Re: showing warnings | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-28463@lists.php.net to get a copy of this message | ||
Hi
script is following
if(isset($_GET['SearchTune']))
{
$tunename = substr($_GET['tune_name'],0,3);
$tunetype = $_GET['tune_type'];
$sql = "SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
'".$tunename."%' AND Tune_Type = '".$tunetype."'";
}
else
{
$sql = "SELECT Tune_Name,Tune_Type FROM Mobile_Tunes";
}
...........................................................................
function max_page($sql,$total_rows,$rows_per_page,$max_pages)
{
$all_rs = mysql_query($sql);
if(!$all_rs)
{
echo "Sorry! Try again.";
return false;
}
$total_rows = mysql_num_rows($all_rs);
mysql_free_result($all_rs);
//mysql_close($link);
$max_pages = ceil($total_rows/$rows_per_page);
return $max_pages;
}
when i use this function it shows following warning
Warning: mysql_query(): Your query requires a full tablescan (table Mobile_Tunes, 5 rows
affected). Use EXPLAIN to optimize your query. in D:\Program Files\Apache
Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
now can you tell me some solution
bye
John Mertic <jmertic@gmail.com> wrote:
Can you provide the script you are running and the exact error message
you are getting?
John
On 9/9/07, Asim wrote:
> Hi
>
>
> in my script when i scan whole table for result set to display in my page it shows warning that
> suggest me to use
>
>
> EXPLAIN statement but i donot need it as i have to show records on page
>
> how to avoid this warning?
>
> Bye
>
>
>
>
>
>
>
>
> Asim Jamil - 0092 345 4025907, Pakistan
>
> ---------------------------------
> Be a better Globetrotter. Get better travel answers from someone who knows.
> Yahoo! Answers - Check it out.
--
--
John Mertic "Explaining a joke
is like dissecting a frog: you
jmertic@gmail.com understand it better,
but the frog dies in the
process."
-Mark Twain
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
---------------------------------
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.