Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[Breana]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/breana/public_html/category.php on line 88
-------------------------------------------
It does this when there is no result "empty table" how can i do a quick fix to say No Results...

row 88:
[PHP]if ($myrow = mysql_fetch_array($result)) {

do {

if ($rowcolor == 1) {
$rowcolorhex = "#ffffff";
$rowcolor = 0;
} else {
$rowcolorhex = "#D6D6D6";
$rowcolor = 1;
}[/PHP]

It pops on most pages:
POSTED BY:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/breana/public_html/item.php on line 22
Admin

[Breana]

I am tring to do a fix but am having trouble..

if ($myrow = mysql_fetch_array($result)) {
  do {
    if ($rowcolor == 1) {
      $rowcolorhex = "#ffffff";
      $rowcolor = 0;
    } else {
      $rowcolorhex = "#D6D6D6";
      $rowcolor = 1;
    }
} else {
  if ($myrow = ' ' {
    printf (No results found);
  }
 

[gregerly]

I am tring to do a fix but am having trouble..

if ($myrow = mysql_fetch_array($result)) {

do {
if ($rowcolor == 1) {
$rowcolorhex = "#ffffff";
$rowcolor = 0;

} else {

$rowcolorhex = "#D6D6D6";
$rowcolor = 1;
}
} else {
if ($myrow = ' ' {
printf (No results found);
}

I do my row coloring a little different:

[PHP]$x=0;
//use a while loop instead of the if / do
while(list($field1,$field2,$field3,$field4)=@mysql _fetch_row($sql)){
$mod=$x%2;
$class=(!$mod)?"ws1style":"ws2style";

echo "<div class='$class'>$filed1</div>\n";

$x++;
}[/PHP]

The code above uses the modulus operator to determine which class the div should get.

Hope that helps. Also, to suppress your mysql_fetch_array() errors add an "@" in front of the call.

IE:

[PHP]@mysql_fetch_row($result);[/PHP]

Thanks,

Greg

[Atli]

Hi.

I've changed the title of this thread to better describe it's topic.
Using good, descriptive titles that follow the Posting Guidelines will increase your chances of getting you questions answered!

Also, please but your code inside [code] tags!

Moderator

[pbmods]

Heya, Breana.

If you're getting this error, then your MySQL query is generating an error.

You will not get an error if your query returns zero results; mysql_fetch_array() will simply return false.

Try echoing mysql_error() to see what's going on.

[Breana]

I dont understand what you mean by error i tried it noting showed up?

But this is new..

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/breana/public_html/results.php on line 79

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/breana/public_html/results.php on line 106

Here is how i placed the error.
echo mysql_error();

I'll put my code maybe you'll see the error..

[PHP]<?php

$pagenum = 0;

$searchtype = $_REQUEST['searchtype'];
$searchingred = $_REQUEST['searchingred'];

if ($_REQUEST['pagenum']) {$pagenum = $_REQUEST['pagenum'];}

$sql = "select * from " . SEARCH_TERMS . " where term = '$searchingred'";

$result = mysql_query($sql ,$db);

if (mysql_num_rows($result) > 0) {
echo mysql_error();

$row = mysql_fetch_row($result);
$count = $row[1];
$newcount = $count + 1;
$sql = "update " . SEARCH_TERMS . " set count = $newcount where term = '$searchingred'";

} else {

$sql = "insert into " . SEARCH_TERMS . " (term, count) values ('$searchingred', 1)";

}

$result = mysql_query($sql ,$db);

?>[/PHP]

[code green]

You would help yourself a lot by using simple error trapping and echoing out the values of variables.
At the moment you are blundering about blindly.
This warning

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

means that $result is empty. This is because the following query has failed
[PHP]$sql = "select * from " . SEARCH_TERMS . " where term = '$searchingred'";
$result = mysql_query($sql ,$db);
[/PHP]You cannot use mysql_functions on a non existent resultset.
If you echo out $result you expect to see something like '#1'
If you echo out $sql you will probably see why the query is wrong.

[Breana]

I don't understand what you mean?
Like this: echo mysql_error($sql);

Or other?

[code green]

[PHP]echo 'searchtype'.$searchtype;
echo 'searchingred'.$searchingred;
echo 'sql'.$sql;
//Execute the query
echo 'error'.mysql_errno();
echo 'errno'.mysql_error();

echo 'result'.$result;

//Execute the loop[/PHP]And let the dog see the rabbit!

[Breana]

Ok, lol here is what it said:

searchtypeIsearchingredsqlinsert into SEARCH_TERMS (term, count) values (''free cars, 1)error1146errnoTable 'breana_cheatz911.SEARCH_TERMS' doesn't existresult

I just looked the table is there!
[PHP]
--
-- Table structure for table `search_terms`
--

CREATE TABLE `search_terms` (
`term` varchar(255) default NULL,
`count` int(10) unsigned default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `search_terms`
--

INSERT INTO `search_terms` VALUES ('zombie', 11);
INSERT INTO `search_terms` VALUES ('Code/Game', 1);
INSERT INTO `search_terms` VALUES ('1701', 1);
INSERT INTO `search_terms` VALUES ('harvest moon', 1);
INSERT INTO `search_terms` VALUES ('alarm clock', 1);
INSERT INTO `search_terms` VALUES ('delete', 1);
INSERT INTO `search_terms` VALUES ('gta', 1);
INSERT INTO `search_terms` VALUES ('harvest', 3);[/PHP]

[Breana]

NM, i got it fixed, i looked at the error and said oops..

I had it selecting the table like this :SEARCH_TERMS
In stead of like this: search_terms

Now the error has vanished and it updates the search keys :)

Now if i can just figure out how to display the top 10 search words i am all good...

[pbmods]

Heya, Breana.

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)

I presume you are referring to this thread.