Mombu the Php Forum

Go Back   Mombu the Php Forum > Php > If statement duplicating mysql records?
User Name
Password
REGISTER NOW! Mark Forums Read




Reply Bookmark and Share
1 29th September 08:18
parasane
External User
 
Posts: 1
Default If statement duplicating mysql records?



Sure, give Jim the credit. Now you're uninvited from the wedding! ;-P

Try rewriting your SQL query:
$sql = "SELECT * FROM tasks WHERE completed='0'";
$sql .= " AND (day_of_week BETWEEN '0' AND '".$dow."')";
$sql .= " ORDER BY id";

Looks like you even kept the variables and statements pretty much
the same. Glad to see it's working out for you out-of-the-box, for
the most part.

--
Daniel P. Brown
[office] (570-) 587-7080 Ext. 272
[mobile] (570-) 766-8107
  Reply With Quote


 


Reply


Thread Tools
Display Modes


Some other forums that might be of your interest : Php 5 forum, Apache forum, Iis forum, Functions forum, Classes forum, Librarys forum, Bugs forum, Postgres forum, Mysql forum, Paradox forum, Ms sql forum, Configurations forum, Php.ini forum, Problems forum, Scripting forum, Css forum, General forums, Off-topic talk, Links, Extra forums, Php


Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666