<?php
// Make sure you're already connected to the database...
function return_mysql_table($table_name, $id_column)
{
$sql = "SELECT * FROM " . $table_name . " ORDER BY " .
$id_column . " ASC";
$result = mysql_query($sql) or die("Error: Invalid SQL:
" . $sql);
$rows = array();
while($current_row = mysql_fetch_array($result))
{
$rows[] = implode("\t", $current_row);
}
$table = implode("\r\n", $rows);
return $table;
}
?>
-----Original Message-----
From: Brent Anderson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 4:21 PM
To: php-db@lists.php.net
Subject: Formatting MySQL Queries
Hello.
My team and I are looking for a way to return an entire table of MySQL
data with columns delimited by tabs and rows delimited by carriage
returns. How exactly would this work - I'm not a PHP expert and,
although I know MySQL, I don't know where to begin with formatting a
query pointer into an actual pile of text. We have an engine ready to
take tables in this format for processing, we just need to parse the
query data into a text result.
Thanks,
Brent Anderson
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jeremy Glover
Interactive Communication Developer, Trone
336.819.6934
[EMAIL PROTECTED]
Confidentiality Notice: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the designated
recipients named above. If you are not the intended recipient, you are hereby
notified that you have received this communication in error and that any
review, disclosure, dissemination, distribution or copying of it or its
contents is prohibited. If you have received this communication in error,
please notify me immediately by replying to this message and deleting it from
your computer. Thank you.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
