SQL Query String Syntax Question

hadoob024

I tried doing searches on this in this forum and in google and got a couple of different answers, so I thought I'd post a message here. Basically, I have a dropdown box that has values set like this:

<select name="listingtype">
<option value="1">Commercial</option>
<option value="2">Residential</option>
<option value="3">Lots</option>

So when a person selects "Commercial", I want the value "1" to get stored in the db. So my first question is, how is this "1" stored? Is its storage as a string, integer, etc. dependent on how I define the column in the db?

Then, my second question is, how do I setup a SQL query string to do a search on this? Is it like this:

$searchstring = "select * from listings where listingtype=1;";

or do I need to put quotes around the number 1 like this:

$searchstring = "select * from listings where listingtype='1';";

Thanks!

swatisonee

Hi,

I just gave you a reply to the same post you made on another forum. have a look and i hope it solves your problem

hadoob024

cool. thanks. looking at the suggestion that you made, it looks like the table name, the column name, and maybe the value as well all need to be placed within single quotes? does this seem right?

hadoob024

OK. So I know I need to put tickmarks around table and column names and put single quotes around the values, but I actually have a follow-up to this. What if I wanted to use the "between" operator? Does anyone know what the syntax for that is? Here's my SQL query string currently:

$searchstring = "select * from `listings` where `listingtype`='2' and `askingprice` between 0 and 99999;";

Do single quotes need to go around each number in the "between" operator, like between '0' and '99999';

Or maybe around the whole thing, like between '0 and 99999';