![]() |
How Do I: Recycle $db->fetch_array($qry) ?
Okay... I'm drawing a blank.
I do a query... example: Code:
$qry=$db->query_read("SELECT field1,field2,field3 from vb_xyz WHERE field4='myvalue' and field8='Not_Processed'"); In the first loop, I update a given field to "Pending" status and in the second loop, I actually take action. I can't do this with one loop because I want to make sure that the Pending status is applied to the entire selected $qry before running a process, so no future spawned scripts duplicate what a previously spawned script is already attempting to complete. I know in PHP you can take an array and set the counter back to 0. But, how do I do this with the mysql query and the while clause using fetch_array? If you know of a better way to do what I want to do, Im open for suggestions. Thanks! PS - Above code is for example purposes only and not copied from my actual working code. |
In the first loop add a line to store each row in an array, then loop round that array for your second set of processing.
|
Ah Ha! Why did I not think of that. Guess when your looking in one direction, sometimes other directions are blind.
I'd still be open to reseting that counter for the $qry if anyone knows how to do that. But, in the mean time... Paul's idea would solve my issue. |
Or, better yet, you can use mysql_data_seek();
PHP Code:
|
Thank you. That worked perfectly. I think I need a vacation, I should have known that answer. ;)
|
Quote:
|
Looking thru the code, I found this function:
PHP Code:
This seems to be doing what the OP requested using the VB coding standards. |
Yes, you should use the $db->data_seek() alias for the function, as this keeps the database layer in there, which is needed when vBulletin includes different layers to cater for different database types.
|
All times are GMT. The time now is 02:13 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|