Most RDB programs come with an integrated backup solution. You might want
to look into those.
As far as why your code is not working, you are not looping through the
result set, you are only pulling one result. A database does not store data
in order, it puts it where ever there's a hole, so the 25th record could
very well hold the first spot in the file. You have more problems than not
looping, echo "$result_sql_daily[$count_daily]"; is just going to print
"array()" if I am not mistaken. To fix the problem that you asked about
though, take out the part where you fetch the first result and replace the
for statement with
while ($result_sql_daily = mysql_fetch_array($run_sql_daily)){
-----Original Message-----
From: Guru Geek [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 2:12 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Backing Up Tables Using PHP
Hello,
Trying to author my own PHP database table back up utility. A very
simple one at that...
Here's my sql statement to select everything in the table:
$sql_daily = "SELECT * FROM dailytable";
$run_sql_daily = mysql_query($sql_daily);
$result_sql_daily = mysql_fetch_array($run_sql_daily);
Here's the code for showing me whats in the result array:
for ($count_daily=0; $count_daily < count($result_sql_daily);
$count_daily++)
{
echo "<p>";
echo "$result_sql_daily[$count_daily]";
}
exit;
Does anyone out there know why it only prints one line of the table?
It's a line in the middle of the table, it's not the first line, it's
not the last line, it's in the middle of about 25 lines.
Is this not the proper way to back up tables in a database? I'd like a
back up copy of my tables on CD-ROM and I thought once this prints out
correctly I'd just have it print to a text file and then place the text
file on a cd....
Thanks,
Roger
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
