|Just another Perl shrine|
Re: checking mysql rows continuouslyby LanX (Cardinal)
|on Dec 08, 2020 at 11:49 UTC||Need Help??|
these are mostly SQL questions, not Perl.
Well ... to get you started with DBI
> then how can i run the query continuously
->fetchrow ° will give you row after row if you don't LIMIT you can run it in a loop
> skip to next row if the previous one status eq to no
I recommend you use DBI#fetchrow_hashref
Fetches the next row of data and returns it as a reference to a hash containing field name and field value pairs. ...
If there are no more rows or if an error occurs, then fetchrow_hashref returns an undef
Please see SQL tutorials
°) uhm ... DBI has no fetchrow! But ...
down-voted for showing wrong code. (Again)