It might be worth seeing this from the MySQL manual for types TEXT and BLOB:
If you want to use GROUP BY or ORDER BY on a BLOB or TEXT column, you must convert the column value into a fixed-length object. The standard way to do this is with the SUBSTRING function. For example:
mysql> select...
Code the HTML page as a PHP page and after the link to the page in the first page add:
?[variable1_name]=[variable1_value]&[variable2_name]=[variable2_value]
so if the new page is page2.html, code it as page2.php and make the link in page1.php as:
<a...
As I'm a bear of very little brain, I'd start by saving the output of the mysql bit into a text file - assuming 1 line per output record. Then, using you favourite scripting language (which I'll assume is Bash), open the text file as an array and use
foreach ($line @array){
/* Whatever code...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.