hello i want ours help please i have upload my table schemiea of sms_in where this table i receive from my mobile operator all sms msg sent from mobile user to a specific short code of sms services and i have uploded how data is present
the field status mean processing / null / done
done when i fnish it / null will be first default value / processing when i do something in this row..
readflag 0 is default and we put 1 when i read it
as u know we receive daily every couple of second or minute sms to my shortcode and it will be stored in this table and what i need to process this message ?
so the solution be by running a script ASP or PHP to fetch row. each minute ..using windows task scheduler ??
and which query should be applied ??
i read some topics in internet to use SQL transc lock table ?? serizable but i don't know this stuff :D bcz i don\t know the difference and what do the locking ?
and the lock will be for table or for row ..
so my task is fetch rows in this table every min and run the script again to proccess the new in coming msg so please
can anyone helpppp me !!!!!!!!!!!!!!
kindly note find the two attachment document:)