script install

[nellson]

Hi
Can anyone help me out with this

I'm trying to run this classified script on my pc, which i downloaded from hotscripts.com - when i try, i get these warnings,
Warning: mysql_fetch_row(): supplied argument is not a avlid mysql result resourse in /funcs1.php on line 22
Warning: mysql_fetch_row(): supplied argument is not a valid mysql result resourse in /funcs2.php on line 172
Warning: mysql_fetch_row(): supplied argument is not a valid mysql result recourse in /funcs2.php on line 18

Can a unix script run on windows?
should i change anything in my php.ini file

thankx

[stolzyboy]

you probably have a newer version of php on your win box that has register_globals = Off, you can either turn register_globals = On, i wouldn't, or you can open the code and change $variables to either $GET['variables'] or $POST['variables'], since this is a downloaded script and a pain to look through, it would probably be easier to turn register_globals on in your php.ini, remember to restart Apache after making changes

[nellson]

thanks Stolzyboy, for solving the other problem🙂

still have prob... with database and mysql errors,
I think it cann't convert the rows to arrays?

[Weedpacket]

Not being psychic it's difficult to debug code when the code can't be seen.

You can attach [man]mysql_error/man calls to your mysql_query() lines (examples of such can be found on the cited manual page); that will give you MySQL's interpretation of the problem.

But if you don't want to post anything more substantive, you'll pretty much be on your own fixing it.

[stolzyboy]

As weedpacket has stated, we sort of need some code to tell what is going on, and what sorts of db errors are you getting

[nellson]

Warning: mysql_fetch_row(): supplied argument is not a valid mysql result resourse in /funcs.php on line 22,

function get_ads_count()
{
global $cat_fields, $table_ads, $ct, $page, $adsonpage;

$where_string=get_where_string();
$sql_query="select count(idnum) from $table_ads where
$where_string ";
$sql_res=mysql_query("$sql_query");
$
$row=mysql_fetch_row($sql_res); // line22
$count=$row[0];
return $count;
}

---

Warning: mysql_fetch_row(): supplied argument is not a valid mysql result resourse in /funcs.php on line 175,

function get_cat_count($ct)
{
global $cat_fields, $tables_ads, $page, $adsonpage;

$sql_query="select count(idnum) from $table_ads where
catname='ct'and visible=1";

$sql_res=mysql_query("$sql_query");
$row=mysql_fetch_row($sql_res); // line 172
$count=$row[0];
return $count;
}

function get_date_update($ct)
{
global $cat_fields, $table_ads, $page, $adsonpage;

$sql_query="select time from $table_ads where
catname='$ct' and visible=1 order by time desc ";
$sql_res=mysql_query("$sql_query");
$row=mysql_fetch_row($sql_res); // line 185
$time1=$row[0];
$date_update=get_short_date($time1);
if ($time1==0) {$date_update="";}
return $date_update;
}

?>

Warning: mysql_fetch_row(): supplied argument is not a valid mysql result resourse in /funcs.php on line 185,

Thats it, unless i've missed something.

[Weedpacket]

Try replacing the lines like

$sql_res=mysql_query("$sql_query");

with

$sql_res=mysql_query($sql_query) or die("Unable to process query '$sql_query'. MySQL reports ".mysql_error());

Then you'll get a more informative error message, than you would by just assuming it worked and finding out later that it didn't.

[nellson]

Thanks very much guys,

fixed the prob... and all is running smoothly🙂