Array problem

Matt_26z

Here's what needs to be done.

Pull content from one DB field, and write it to a new text file PHP makes right there. There'll be three sets of content lines per text file.

So.....

Read three DB fields
Write them to a new text file
Save text file
Repeat 1-3 with new text files until end of DB is reached.

This isn't a problem doing it for the first 3. LIMIT 0,3 can be used for that. But how do I keep it going until the end?

If I use.....

mysql_fetch_array(mysql_query("SELECT * FROM $table WHERE $info != "" LIMIT 0,3", connection stuff here)) {

read db and file making stuff here

}

The LIMIT numbers are then out of the array and can't be added to.

So how is this done?

xblue

Not sure if I get you right...
Do you want all fields from the first 3 rows?
Or the first 3 fields from all rows?
Either way it should be enough to execute the query only once and then fetch each record in a while loop.

If 1, you query should be fine (an additional ORDER BY might not hurt). In case you don't know how many fields there are, you could use mysql_fetch_row() and loop to the array like this:

$result=mysql_query("SELECT * FROM $table WHERE $info != "" LIMIT 0,3";

while ($row=mysql_fetch_row($result)){
    for ($i=0; $i<count($row); $i++){
        echo $row[$i]." "; // just an example, do whatever you want here
    }
    echo "<BR>";
}

If 2, you would ommit the LIMIT clause as this limits rows, not columns, and (preferably) specify the names of the first 3 field, or retrieve all fields with * but ignore the rest of them.

If it is something else, could you explain in more detail?

Matt_26z

After I search for the rows needed, here's basically the end result I'm looking for.....

.txt file #1:
row1 field1
row2 field1
row3 field1

.txt file #2:
row4 field1
row5 field1
row6 field1

etc... etc...

Just 3 rows per txt file. But again, this is after I search for the needed rows. So I can't just call up the table rows in sets of three.... unless it was possibly the returned search result rows in sets of three?

xblue

You could execute a series of select queries, each time increasing the start position by 3, but trust me, this is not a good way to do it. Far more efficient: use an internal counter to determine when you have read 3 rows. Example:

// execute sql statement without limit clause
$result=mysql_query("SELECT * FROM $table WHERE $info !=''");

while ($row=mysql_fetch_array($result)){

// increase internal counter
$counter++;

// append data to a string that will be written to file
$filetext.=$row[0]."\n";

// if 3 rows have been read, write to file and reset $filetext
if ($counter%3==0) {
      // openfile, write and close file here
      $filetext='';
}
}

Keep in mind that you might need to deal with the last few rows in case the number of rows is not evenly devided by 3. Also, you may be able to use $counter/3 if you want to create files with filenames like data1.txt, data2.txt, data3.txt on the fly.

Hope I got you right this time,
xblue