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
    [email protected]

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