Problem with Query

[jeff_tet]

Here's the code:

$start = $POST['sdate'];
$end = $POST['edate'];
$tech = $_POST['techsid'];

...

$sql = 'SELECT at.* FROM at WHERE ((at.date BETWEEN \'$start\' AND \'$end\') AND (at.tid = \'$tech\'))';

I run the query

then I while loop the info ($row = mysql_fetch_array(results)) blah blah blah!

I'm pretty sure that there is something wrong with the format of my actual query.

Thanks in advance

[devinemke]

you wil want to add some sort of form validation to ensure that the passed values are valid for your query.

<?php
$start = $_POST['sdate']; 
$end = $_POST['edate']; 
$tech = $_POST['techsid']; 

// connect to db first

$result = mysql_query("SELECT * FROM at WHERE date BETWEEN '$start' AND '$end' AND tid = '$tech'") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	print_r($row);
}
?>