[SOLVED] PHP mysql BETWEEN query

[Miko]

Hello,

 

I'm making a script where a user can insert a value of 14 numbers to search a corresponding ID.

This value should be broken down in 2 (first 4 numbers and then 10 numbers).

I've done this with a substr so here no problem.

 

But now I have to query this value with a BETWEEN.

 

my code/query

 

$parcel_depot = substr($searchterm, 0, 4);
				$parcel_number = substr($searchterm, 4, 10);
				$parcel_sql = "SELECT * FROM Number WHERE depot = '$parcel_depot' AND '$parcel_number' BETWEEN 'from' AND 'to'";

 

But seems that it doesn't work.

 

What am I doing wrong here?

 

Thanks :-)

[Maq]

Well what is from and to?  Are they supposed to be variables?

[fenway]

Yes, echo $parcel_sql

[Miko]

the 'from' and 'to' are the names of the columns

[Ken2k7]

Then don't put quotes around them. If you do, they'll be literals. If you want, use backticks.

[Miko]

hmmm, did not work either  :-X.

 

I'm thinking that I'm making a mistake with 'AND' that is between my 2 variables.

Could be?

[kickstart]

Hi

 

AND looks fine.

 

As fenway says, echo out $parcel_sql and lets see what is being passed to MySQL.

 

All the best

 

Keith

[Miko]

Dit that and got this:

 

SELECT * FROM Number WHERE depot LIKE '0530' AND '7000732032' BETWEEN from AND to

[kickstart]

Hi

 

Suspect from is confusing things as it has a meaning. Use back tics around the variable names (ie `, not a ').

 

All the best

 

Keith

[Miko]

I need some sleep ... the table calls Nummer .. not Number ..

Changed the name and it's working. D'oh!

 

Thanks anywayz