Last leg of race!

ratpH1nk

Ok. I am almost there. My last chore is some kind of if statement

variables:
$var1= $POST[date1];
$var2= $POST[date2];
$var3 = $_POST[name1];

I have 3 search fields:
name correlates to name column in table X
date1 and date2 correlates to the first part of a date range specified in a sql_query:
$sql="select * from mytable where date between '%$var1%' and '%$var2%' group by name";

This has to be the query if NO name is specified in name field this has to be the query IF a name is specified:
"select * from table where name='%var3%' group by ID";

I have very little experience setting up IF statements, and this is an IF statement if I have ever seen one

Any help again is greatly appreciated!

pH1nk

theeper

if (isset($_POST[name1])) {
$sql="select * from mytable where date between '%$var1%' and '%$var2%' group by name"; 
} else {
$sql="select * from table where name='%var3%' group by ID"; 
}

(edited for syntax error)

ratpH1nk

Thanks for the information

if (isset($_POST[name1])) {

could you explain how that works, if would be so kind...

edited:

as it stands now, it looks like it is disregarding the name field, well. All entries are returned regardless if there is a name entry or noy

pH1nk

theeper

if (isset($_POST["name1"]))

Checks that the posted variable has a value set. You should use quotes around the variable name though. Sorry I didn't do it earlier.

ratpH1nk

Ok. After doing some more tests with "echo" the second half of that if statement is definitely not being evaluated.

I would guess it is something I am doing wrong......hmmm.

pH1nk

theeper

Actually, there is only one part to that statement.

$POST["name1"] is the name of the variable, or I should say, the method of retrieving the value from your form input when you do the HTTP post. For every input element you have in a form that submits a value, there will be a $POST["variable_name"] variable set for it.

So, the if (isset($_POST["name1"])) statement says, "if there is a value set for the posted 'name1' variable, the do something".

If there is any value set on the posted variable 'name1', that statement evaluates to true, otherwise, it is false.

There is a couple reasons I can think of for why it isn't working for you.

you are not doing a proper HTTP post
you are using a version of PHP that doesn't support $_POST["variable"] syntax
there is some code between where you assign the $var variable ($var3 = $_POST[name1]😉 and where your SQL happens that messes with the $var3 variable.

One last thing, be careful of allowing users to type in stuff that get's put into an SQL query, people can do bad things to your system if you don't check what they type in.

ratpH1nk

Thanks for the info! I think part of the problem is that I am posting from xxx.html and the target is xxx.php
When I relload the page, I see that it must clear out the post information, otherwose it was retaining the previous information (i assume) when I click submit. Your code was behaving perfectly, I think my construction is at fault.

Thanks for the heads up about sql entries, I will make sure that those who have access to the site (it is a intranet site) know the dangers.

Again, thanks immensely, we look to be up and running quite nicely. '

pH1nk