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



  • Justin BibJustin Bib USAMember Posts: 0

    ______ // http://forcoder.org // 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.