YourPadre Posted June 14, 2009 Report Share Posted June 14, 2009 (edited) Sveiki, Teiksim man ir jauztaisa atskaite no - līdz datumiem, kā tas izskatītos MySQL? Teiksim ir funkcija mysql_query ("SELECT * FROM work_orders WHERE status='completed' ??? No-līdz datumam ??? ") Kā to var izdarīt? Danke :) Edited June 14, 2009 by YourPadre Quote Link to comment Share on other sites More sharing options...
werd Posted June 14, 2009 Report Share Posted June 14, 2009 (edited) SELECT * FROM work_orders WHERE status = 'completed' AND date_from <= '".$date."' AND date_to <= '".$date."' Starpcitu līdzīgs piemērs jau bija šeit. Edited June 14, 2009 by phpjanis Quote Link to comment Share on other sites More sharing options...
marcis Posted June 14, 2009 Report Share Posted June 14, 2009 SELECT * FROM `work_orders` WHERE status='completed' AND date_from<='".$date."' AND date_to>='".$date."' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.