
Untitled
By: a guest on
Jul 17th, 2012 | syntax:
None | size: 0.71 KB | hits: 6 | expires: Never
php creating delivery time using for looping structure
0-1 or 1-2 or 2-3 or 3-4 or 4-5 or .... 19-20 working days.
0-2 1-3 2-4 3-5 4-6
. . . . .
. . . . .
. . . . .
0-20 1-20 2-20 3-20 4-20
s.no shopname , shoplinks , price , delivery time , shopping cost
1 xyz xyx.com 5858 here i should provide delivery time free
[Table working_days]
id[int],day[varchar]
1,Sundary
2,Monday
[Table working_hours]
id[int],dayID[int],hour_start(time),hour_end(time)
1,2,10:00,14:00
SELECT hour_start,hour_end from working_hours where id=(select id from working_days where day='Monday');