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