[RESOLVED] mysql_result(): Unable to jump to row 0 on MySQL result index 3

[shersaha]

I have some typical problem.. when I am retriving date from mysql database like follows :-

select * from emp where date between '2006-10-01' and '2006-10-10'; query executed and result is shown.

But when the same query is executed from another page (html form and php variable) it shows the error :mysql_result(): Unable to jump to row 0 on MySQL result index 3"..

My code is like this :.. $sql = 'SELECT * FROM duty_roster WHERE week_date BETWEEN "$From_date" AND "$To_date"';

Here $From_date and $To_date is supplied by user through html form.

please help me ..

thanks .

[Piranha]

Have you tried to show the sql string by echoing it? If you did then you would notice that the variable you wanted is not in it. These two examples illustrate what I mean:

$a = "test";
echo "this is a '$a'";
// output will be      this is a 'test'

$c = 'test';
echo 'this is a "$c"';
// output will be      this is a "$c"

When using strings with the ' character the variables are not parsed. To make your query work you could do either of these alternatives:

$sql = 'SELECT * FROM duty_roster WHERE week_date BETWEEN "' . $From_date . '" AND "' . $To_date. '"';
$sql = "SELECT * FROM duty_roster WHERE week_date BETWEEN '$From_date' AND '$To_date'";

[shersaha]

Thanks for quick reply and its working for me. again thanks..