Howdy, Stranger!

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

Categories

Need help with this query

xeric00xxeric00x Member Posts: 2
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.id,collections.UNIX_TIMESTAMP(courtdate),collections.courtdesc,collections.operatorid,collections.UNIX_TIMESTAMP(dateadded),collections.note,clients.id,clients.attorney 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

Comments

  • SouldrinkerSouldrinker Member Posts: 143
    [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
    net::allies

    www.net-allies.de
    info@net-allies.de



Sign In or Register to comment.