Menu
Community /Pin to ProfileBookmark
@NogDogOct 29.2015 — #I suspect the problem is that you are not using braces to delineate the code associated with each if(), and in PHP it will only associate the next line with it if you do not use braces. So, your code as written is equivalent to:
Which I suspect is not what you want. ?
This is why many (most?) PHP devs used braces around if/else code blocks even if it's just for one line, in case they ever want to add lines to them.
How do i get the "SELECT" string correct? And wrong
haha my subject….too bad i cant change it
Im trying to make it possible to search people after age so this is what ive done. problem is, the string looks like this and obv that doesnt work.
[code=html]
SELECT * FROM users WHERE country=’asd’ AND state=’zxc”’ > ”” < 1970-01-01
i have been trying to get it to work but i cant. This is the code.
[code=php]
$query = “SELECT * FROM users WHERE country=’$country’ AND state=’$state'”;
$age= $row[‘age’];
if(!is_null($mindate))
$query .= ” AND age='”;
$query .= “‘$age’ > ‘$mindate'”;
if(!is_null($maxdate))
if(!is_null($mindate))
$query .= ” AND “;
$query .= “‘$age’ < $maxdate”;
Sign in
to post a comment8 Comments(s) ↴
0
@NogDogOct 29.2015 — #I suspect the problem is that you are not using braces to delineate the code associated with each if(), and in PHP it will only associate the next line with it if you do not use braces. So, your code as written is equivalent to:[code=php]
$query = "SELECT * FROM users WHERE country='$country' AND state='$state'";
$age= $row['age'];
if(!is_null($mindate))
{
$query .= " AND age='";
}
$query .= "'$age' > '$mindate'";
if(!is_null($maxdate))
{
if(!is_null($mindate))
{
$query .= " AND ";
}
}
$query .= "'$age' < $maxdate";
[/code]Which I suspect is not what you want. ?
This is why many (most?) PHP devs used braces around if/else code blocks even if it's just for one line, in case they ever want to add lines to them.