Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XAMPP MySQL error exporting to csv

Status
Not open for further replies.

Baukep

Programmer
Sep 28, 2006
44
NL
Hello,

When I try to export a query result to a csv file I get the following:
(just a little piece af it). The last row beginning with <span class="syntax">< is very long and printed all on the same row.
On one of the last rows is this message:
#1305 - FUNCTION biljart.ROUND does not exist
</code><br />
</div><fieldset class="tblFooters"> </fieldset>

I don't use functions so the problem must be anywhere else (In XAMPP and php perhaps.

Any help would be very nice

Bauke


<!-- PMA-SQL-ERROR -->
<div class="error"><h1>Fout</h1>
<p><strong>SQL-query:</strong>
<a href=" target="mysql_doc"><img class="icon" src="./themes/original/img/b_help.png" width="11" height="11" alt="Documentatie" title="Documentatie" /></a><a href="tbl_properties.php?db=biljart&table=wedstrijden&token=f0ab4a8e1c525fc0cf9b157bb327c728&sql_query=SELECT+DATE_FORMAT+%28+w_datum+%2C+%27%25d-%25m-%25y%27+%29+AS+Datum++%2C+w_ronde+AS+Ronde++%2C+w_wnr+AS+%22Wedstr.+nr%22++%2C+w_brtn+AS+Beurten++%2C+speler+AS+Speler++%2C+l_naam+AS+Naam++%2C+temaken+AS+%22Te+maken%22++%2C+car+AS+%22Caramb.%22++%2C+perc+AS+%22Perc.%22++%2C+berpunten+AS+Punten++%2C+Afwgem+AS+%22Afw.+gem.%22++FROM+%28++SELECT+w_seizoen++%2C+w_datum++%2C+w_ronde++%2C+w_wnr++%2C+w_brtn++%2C+w_speler1+AS+speler++%2C+w_s1_temaken+AS+temaken++%2C+w_s1_car+AS+car++%2C+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+AS+perc++%2C+IF+%28+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+%3E%3D+100+AND+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+%3E%3D+100+%2C+1+%2C++IF+%28+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+%3D+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+%2C+1+%2C++IF+%28+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+%3E+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+AND+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+%3E%3D+100+%2C+3+%2C++IF+%28+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+%3E+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+AND+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+%3C+100+%2C+2+%2C+0+%29+%29+%29+%29+AS+berpunten++%2C+ROUND+%28+w_s1_car+%2F+w_brtn+%2C+4+%29+-+ROUND+%28+w_s1_temaken+%2F+25+%2C+4+%29+AS+Afwgem++FROM+wedstrijden+WHERE+w_seizoen+%3D+%222006%2F07%22++UNION+ALL++SELECT+w_seizoen++%2C+w_datum++%2C+w_ronde++%2C+w_wnr++%2C+w_brtn++%2C+w_speler2+AS+speler++%2C+w_s2_temaken+AS+temaken++%2C+w_s2_car+AS+car++%2C+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+AS+perc++%2C+IF+%28+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+%3E%3D+100+AND+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+%3E%3D+100+%2C+1+%2C++IF+%28+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+%3D+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+%2C+1+%2C++IF+%28+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+%3E+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+AND+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+%3E%3D+100+%2C+3+%2C++IF+%28+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+%3E+ROUND+%28+w_s1_car+%2F+w_s1_temaken+%2A+100+%2C+3+%29+AND+ROUND+%28+w_s2_car+%2F+w_s2_temaken+%2A+100+%2C+3+%29+%3C+100+%2C+2+%2C+0+%29+%29+%29+%29+AS+berpunten++%2C+ROUND+%28+w_s2_car+%2F+w_brtn+%2C+4+%29+-+ROUND+%28+w_s2_temaken+%2F+25+%2C+4+%29+AS+Afwgem++FROM+wedstrijden+WHERE+w_seizoen+%3D+%222006%2F07%22++%29+AS+d++INNER+JOIN+leden+ON+l_id+%3D+d+.+speler++ORDER+BY+w_wnr+DESC+%2C+punten+DESC+++LIMIT+36&show_query=1"><img class="icon" src=" ./themes/original/img/b_edit.png" width="16" height="16" alt="Wijzigen" /></a> </p>
<p>
<span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SELECT</span> <span class="syntax_alpha syntax_alpha_functi
onName">DATE_FORMAT</span><span class="syntax_punct syntax_punct_bracket_open_round">
 
That query is impossible to read. Can you please post it in readable plain text.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top