Howdy, Stranger!

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


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.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


  • 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

  • Justin BibJustin Bib USAMember Posts: 0

    ______ // // free video tutorials and ebooks about || R Go C# JavaScript MATLAB Visual Basic Python Objective-C Assembly Visual Basic .NET Ruby PHP PL/SQL C++ Scratch Swift Perl Delphi C Java Julia Crystal Bash Apex Fortran COBOL ML Logo Transact-SQL Hack Rust Erlang Alice Awk FoxPro LabVIEW Ada Prolog Scheme SAS Dart F# ABAP Scala Lisp Kotlin Lua Clojure D VBScript || ______

Sign In or Register to comment.