Export Into

Manat

Hello All

If I have entries in a Table and I want to export everything into a text file in PHPmyADmin, but with a where clause associated to it, can I do it?

Also, if I can't, can someone give me an SQL statement where I create a new Table and insert data into from a where clause targeting another table.

Like this, select * From Table
Where salutation='hello'

And then create a Table, and putting results of the above into the create table statement. I don't know if i'm explaining myself well.

Can someone show me how to do this?

Thanks

leatherback

Hi,

I am not sure what you why you want to do what you want to do. One way (If it is for a once-only backup or something?)
You could of course create a simple PhP page:

$query = "select * from database where colum = $criterium";
$Results =@ mysql_query($query);
while ($rows =@ mysql_fetch_array($Results))
{
echo $row[1];
echo ' ';
echo $row[2]
echo '.....'
};

Then you can just select everything and save it.
There is for sure a nice way, I have not tried it, but writing to a file directly:

fopen http://www.phpbuilder.com/manual/function.fopen.php
fwrite http://www.phpbuilder.com/manual/function.fwrite.php

So above would be something like:

$query = "select from database where colum = $criterium";
$Results =@ mysql_query($query);
$fp = fopen("file.txt", "w")
while ($rows =@ mysql_fetch_array($Results))
{
fwrite ($fp, $row[*])
};

// you'd have to look at the output format: I am not sure wether the wildcard '*' is accepted by PhP. Maybe you'd have to call each value in the table individually. But the idea is there, I'd say.

Hope it helps?!