This is an applic that I got off the internet that I am trying to install.
An example of the code follows.
if ($action=="memberlist") {
/* get the total number data and find out what the grand total is */
$sql = "select id, title, price from ad_details where member_id=" .
$_SESSION['login_id'];
$sql .=" order by $orderby $order LIMIT $limitvalue, $user_view_limit ";
$sqlcount = "select count(*) from ad_details where member_id=" .
$_SESSION['login_id'];
} else {
$sql = "select a.id, a.title, a.price from ad_details a, ad_cat_join j
where j.cat_id=$current_cat_id ";
$sql .="and a.id=j.ad_id order by $orderby $order LIMIT $limitvalue,
$user_view_limit";
$sqlcount = "select count(*) from ad_details a, ad_cat_join j where
j.cat_id=$current_cat_id ";
$sqlcount .=" and a.id=j.ad_id";
}
$sql_countresult = mysql_query($sqlcount);
list($totalrows) = mysql_fetch_row($sql_countresult);
$res = mysql_query($sql);
$num_ads = mysql_num_rows($res);
I did not code this and I'm struggling to understand the applic and PHP! So
I'm up to my armpits in alligators! LOL
Thanks.
Mike
"Robert Schipper" <froschi82@xxxxxx> wrote in message
news:20041021124845.98628.qmail@xxxxxxxxxxxxxxx
> hello mikea,
>
> looks like there is something missing in your sourcecode, which you
> should have provided. do you give any arguments to
> mysql_fetch_array() ? Do you check if it is not false?
>
> your code should look like this:
>
> $sql = "SELECT * FROM example";
> $result = mysql_query($sql,$db);
>
> if ($result) {
> $myrow=mysql_fetch_array($result);
> } else {
> echo "ERROR: SQL-query returned false!";
> }
>
> Robert
>
> Mikea wrote:
>
> > I am getting the following errors when I execute a php script.
> >
> > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result
> > resource
> > Warning: mysql_fetch_row(): supplied argument is not a valid MySQL
result
> > resource
> > Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
> > resource
> >
> > What do I need to make this work? I am new to PHP. I read something
about
> > mysql.class.php somewhere. Do I need that somewhere? Do I put an
include
> > in the main script? Where does mysql.class.php go directory-wise?
> >
> > I am sure I am not giving enough information and may not be explaining
it
> > good enough. My apologies. Again, I am new at this.
> >
> > I appreciate any help. Thank you in advance.
> >
> > Mike
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
