Need help with this query

The following querry gives me this error

Warning: 0 is not a MySQL result index in /usr/local/lib/apache/htdocs/CourtDates/allopen.php on line 42

here is the code

(Line 41)
$result = mysql_query("SELECT,collections.UNIX_TIMESTAMP(courtdate),collections.courtdesc,collections.operatorid,collections.UNIX_TIMESTAMP(dateadded),collections.note,, FROM collections,clients WHERE clientid = $cid ORDER BY courtdate ASC");

(Line 42)
while(list($id,$courtdate,$courtdescription,$operator,$dateadded,$notes,$clid,$a) = mysql_fetch_array($result))

any help would be appreciated.

Thanks in advance


  • [b][red]This message was edited by Souldrinker at 2002-10-22 8:37:12[/red][/b][hr]
    your result has not bringing any results to the intepretor, thats all - this means no match in database ;)

    best regards,

    sebastian mohrenstecher
    executive secretary

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion