Exporting MYSQL data??

[jplush76]

Basically what I need to do is create record sets in a flat file.

We have orders in our MYSQL database and I need to export them to a flat file but in a record set format , so basically instead of comma's separating the fields the field lenghths would be hard coded.

like name might be a 25 length and in my flat file no matter how long the name, the length will be 25 characters, and so on?

anyone know where to get info on this?

thanks!

[Anon]

This might not be the best way to do it, but here is a way to do it in PERL. If you are looking for a PHP script to do it online, that would be easier to make.

use DBI;
$driver = "mysql";$hostname="localhost";$database="db";$port=3306;$user="root";$password="";
$dsn = "DBI:$driver:database=$database;host=$hostname;port=$port";
$dbh = DBI->connect($dsn, $user, $password) || die ("connection failed");
my $data=$dbh->prepare("DESCRIBE table");
$data->execute;

undef @TYPE_ARRAY;
while (my $ref = $data->fetchrow_arrayref())
{($junk,$TYPE_ARRAY[$i++])= ($ref->[1] =~ /(()(\d{1,3})/);}
my $data=$dbh->prepare("SELECT * FROM table");
$data->execute;
while (my $ref = $data->fetchrow_arrayref())
{
for ($i=0;$i<@TYPE_ARRAY;$i++)
{$out .= sprintf("% $TYPE_ARRAY[$i]s",$ref->[$i]);}
$out .= "\n";
}
print $out;