while row > delete it? obviously not...

[darthmahon]

Hey,

I have a list of information in a database such as names and addresses. I want people to be able to download a file of these, but I only want these names and addresses to be given to one person.

So I wrote the following:

<?php

mysql_connect(localhost, user, pass);
mysql_select_db(dbname);

$result = mysql_query("SELECT id, firstname, lastname, email FROM userstest WHERE registered=1 LIMIT 10");

$file = fopen("registered.csv", "w");

while($row = mysql_fetch_row($result))

{
    $line = implode(",", $row) ."\n";
    fwrite($file, $line);
    mysql_query ("DELETE FROM userstest WHERE id='$id'");

}

fclose($file);

echo "<font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">File has been completed, click <a href='registered.csv'>here</a> to download the file.</font>";

?>

Now this selects the 10 people as required, but it doesn't delete their record from the database. Any ideas how I need to go about doing this, while it has the row selected?

Cheers,
Chris

[bastien]

mysql_query ("DELETE FROM userstest WHERE id=' ".$row['id']." ' ");

the $row['id'] value should be the row id from the db

[darthmahon]

Hi,

I've tried what you have suggested and so far, it doens't work. This is what I have done since:

Your suggestion is outputting none of the id numbers. So it's not selecting them properly or something.

Here is the code in full as it stands:

<?php

mysql_connect(localhost, user, pass);
mysql_select_db(dbname);

$download_me = $_GET['download_me']; 
if($download_me) { 

   // make browser output downloadable 
   //header("Content-type: application/octet-stream");  

   //header("Content-Disposition: attachment; filename=registered.csv");  

   //header("Content-Transfer-Encoding: binary"); 

   $result = mysql_query("SELECT id, firstname, lastname, email FROM userstest WHERE registered=1 LIMIT 400"); 
   $query = "DELETE FROM userstest WHERE id=' ".$row['id']." ' ";

   while($row = mysql_fetch_row($result)) { 
       print $query;
	   //$line = implode(",", $row) ."\n"; 
       //print $line;
   } 
   // this stuff is being downloaded; stop here before default stuff is printed 
   die; 
} 

printf("<div>Click here to <a href=\"%s\">download</a> registered users</div>", 
        $_SERVER['PHP_SELF'] . "?download_me=true" 
        ); 
?>

I added print command to show the ID select query and I end with lots of the following:

DELETE FROM userstest WHERE id=' '

Over and over...

So I'm not sure what it is, but the row id isn't getting selected properly.

[bastien]

try using mysql_fetch_array instead of fetch_row

[darthmahon]

doesn't make any difference, I tried fetch_object also.

Am I doing the query and then telling it to delete it while selected right?

[darthmahon]

ahh, got it working I think.

while($row = mysql_fetch_object($result)) { 
       $query = "DELETE FROM userstest WHERE id=' ".$row->id." ' ";
	   print $query;
	   //$line = implode(",", $row) ."\n"; 
       //print $line;

Moved the $query into the while loop. 🙂

[darthmahon]

Now I get a problem:

Warning: Bad arguments to implode() in /home/downloadtest.php on line 22

hmmm, it doesn't like the fetch_object function...I'm obviously not telling it to do the right thing when imploding...