Using date variable from form in WHERE statement

[im8kers]

Hello,

 

I have been searching everywhere to figure this out but haven't found anything.  So either it's stupid simple or I'm going about it the wrong way.  Here is my sql code:

 

SELECT p.*, c.bagsrecd, c.recddate, c.locationid

FROM ninlf_received AS c INNER JOIN ninlf_recipient AS p

ON c.recipientid = p.recipientid

WHERE c.recddate >= '$_POST["start"]' AND c.recddate <= '$_POST["end"]'

 

I need to filter the data by the variables from a previous page post.  I am using MySQL 5.0 and will create this as a view.

 

Thanks.

[Illusion]

make sure that c.recddate ,$_POST["start"] and $_POST["end"] all are having the same format.

[im8kers]

All formats are the same.  I did a query and hard coded dates in their place and it ran great.  I just can't seem to get the dates to be from the variables!?!

 

Any other ideas?

[Illusion]

the ntry

WHERE c.recddate >= '$_POST[start]' AND c.recddate <= '$_POST[end]'

 

or

 

WHERE c.recddate >= '{$_POST['start']}' AND c.recddate <= '{$_POST['end']}'

 

[im8kers]

Niether one worked.  The first one nothing showed in the result and the second gave me an #1064 error.

[Illusion]

then try something like this

 

$query="SELECT p.*, c.bagsrecd, c.recddate, c.locationid

FROM ninlf_received AS c INNER JOIN ninlf_recipient AS p

ON c.recipientid = p.recipientid

WHERE c.recddate >= ".$_POST['start']."AND c.recddate <= ".$_POST['end'];

 

before running the query first echo ur query like

echo $query;

and then execute if ur varibles are interpreted.

 

 

 

[im8kers]

After a couple tweeks the query echoed the variables correctly in the page.   I created a view and the it still won't grab the variable from the page into the view. ???

[fenway]

I don't see the view code anywhere.

[im8kers]

Here is the code again.  Again I'm attempting to have this code run from the mysql database and not from the php page.

 

 

SELECT p.*, c.bagsrecd, c.recddate, c.locationid
FROM ninlf_received AS c INNER JOIN ninlf_recipient AS p
ON c.recipientid = p.recipientid
WHERE c.recddate >= '$_POST["start"]' AND c.recddate <= '$_POST["end"]'

[fenway]

How do you intend to use $POST from the mysql database?

[im8kers]

I guess that is my question.  It all works from the page source in the php query, but that's not where I need it.

 

Do you have any recommendations how I can make the mysql source "look or refer" to the $POST variable?

[fenway]

I guess that is my question.  It all works from the page source in the php query, but that's not where I need it.

 

Do you have any recommendations how I can make the mysql source "look or refer" to the $POST variable?

I don't really know what this means.