mysql_fetch_row() function show me warning [duplicate]

Question

I get mysql_fetch_row(): supplied argument is not a valid MySQL result here is my code

$query="select DISTINCT categories_memories.memory_id from categories_memories INNER JOIN categories ON categories.id=categories_memories.category_id";

$res=mysql_query($query);

while($row=mysql_fetch_row($res))
{

}

please guide me

ThiefMaster · Accepted Answer · 2012-04-05 08:30:08Z

0

Your query failed so mysql_query() returned false which is not a valid MySQL result.

You need to have a look at the SQL error to fix it, here's a simple (but horrible) way to get the error in case one happens:

$res = mysql_query($query) or die(mysql_error());

answered Apr 5, 2012 at 8:30

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hardeep Pandya · Accepted Answer · 2012-04-05 09:52:27Z

-1

SQL query supplies empty result set so mysql_fetch_row generate warning to avoid try below code

if($res){
   while($row=mysql_fetch_row($res))
   {
      do something
   }
}

answered Apr 5, 2012 at 9:52

Hardeep Pandya

9151 gold badge8 silver badges27 bronze badges

1 Comment

Barmar Dec 7 at 23:52

Empty result set doesn't cause an error like this. Only an error does.

Collectives™ on Stack Overflow

mysql_fetch_row() function show me warning [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related