mysql_num_rows(): supplied argument is not a valid MySQL result

[shamsuljewel]

it correctly run on php4 but I am now switch to php5 and give that error..

What was the problem?

pleaseeeeeeeee help

[pocobueno1388]

Show us your code.

 

There is most likely a problem with your query.

[shamsuljewel]

<code>$query="SELECT site_name, description, url FROM web WHERE MATCH(site_name, url, description) AGAINST ('%$keywords%')";

$result=mysql_query($query);

$j=mysql_num_rows($result);</code>

 

 

is that query wrong?

[pocobueno1388]

Change this line:

$result=mysql_query($query);

 

To:

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

 

That will tell you what the problem is.