Transfer VAriables, BETWEEN...AND..

Anon

2 Questions:

I have a form that sends its variables to a javascript..

the form name is originally like:

<form name="doublecombo">

now I added 2 other textfields that have the names="year1" and "year2",

I wish to transfer these 2 variables to another script. so here's what I did

I changed the form to <form name="doublecombo" value="script2.php">

and a hidden field
<input type=hidden name="action" value="search">

(this I think sends the variables to the action function and under the search if statement that I have)

Would the above successfully transfer the variables? I tested it and it didn't seem to work.

Now, In my second script, I have this command line:

$result = mysql_query("SELECT * FROM $table WHERE date BETWEEN year1 AND year2, model LIKE '%$model%'order by counter);

This simply gave me an error of the result.. there're no errors if i get rid of either the BETWEEN...AND or the model LIKE 'model'..

How do I get those 2 to work together?

THANK YOU!

btw, sometimes when I do a search on phpbuilder, words such as 'search' givees me an error page that says '

There was an error executing this query. Please try later. ' ..

then I immediately search for other words and it works.. So im assuming that the search function needs to be fixed 🙂

It gets frustrating sometimes I had to do search through the archives page by page 🙁