[RESOLVED] Nested do while

dcjones

Hi all,

I have two tables, table 1 holds flight data and table 2 holds telephone number.

I need to be able to read all the records in table 1 and send them using SMS messaging to all the record in table 2

Example: Table1
BA1234
LH9989
AA76

Table 2
555 555 5551
555 555 5552

Output
BA1234 555 555 5551
BA1234 555 555 5552
LH9989 555 555 5551
LH9989 555 555 5552
AA76 555 555 5551
AA76 555 555 5552

This is the code I am working with:

do { 		

do {

$SMSBody =  $row_FlightSMSSend['FlightNo'] . " " . $row_FlightXAlertUsers['FlightxUserTeleNo'];
// send SMS

} while ($row_FlightXAlertUsers = mysql_fetch_assoc($FlightXAlertUsers));

} while ($row_FlightSMSSend = mysql_fetch_assoc($FlightSMSSend));

bradgrafelman

So... what's your question?

dcjones

Hi Brad,

Good point, I forgot that part.

When I run the code if reads the records from table 1, first "do while" then reads the records from table2, second "do while".

Then reads the next record from table 1 but does not read the records from table 2.

The cycle completes until all the records in table 1 have been read.

I do hope I have made this clear.

Thanks.

bradgrafelman

dcjones;11013579 wrote:
Then reads the next record from table 1 but does not read the records from table 2.

Do you ever reset the internal position pointer for the 'table 2' result set back to the beginning (e.g. via [man]mysql_data_seek/man)?

dcjones

Hi Brad,

I have spent the last hour reading up on "mysql_data_seek()" I just lost the will to live. There does not seem to be any relatively simple tutorials on this subject unless you know of any.

Many thanks for your help once again.

bradgrafelman

Er... I don't think it can get much simpler than what the PHP manual says about the function. You simply pass the function a resource you get from a successful call to mysql_query() as well as the position you want PHP to reset the internal pointer to. As the manual states, the first position in the result set is identified as row number zero.

dcjones

Hi Brad,

You were right to "Er", when I took a fresh look at your last post it became very simple.

I thank you.