PDA

View Full Version : Help with an SQL statement



digires
01-29-2004, 06:37 PM
Hi, this may seem like a rather basic question, but I am trying to figure out an sql statement that will allow me to pull values out of the "listingDBElements" table for a specific property, and assign a variable to each of them.

So, in other words, for property 353 find field_name=deductible and assign field_value to the variable $deductible.

This is easy for one item, but I want to know if there is a way to get several values out of that table without a separate query for each one? (i.e. using SELECT field_value FROM listingDBElements WHERE ID=353 AND field_name=deductible; for each of them seems excessive)

Any ideas?
Thanks for any input.

John