Simple data return from DB. Please help.

kleptik

..as in - simple for you. 🙂

Example data from "VehicleOptions" table:

ID |Interior

1 |Power Steering
2 |Power Windows
3 |Cruise

$VechOptions = "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15";
$OptionsQuery = "SELECT * FROM VehicleOptions WHERE ID IN ($VechOptions)";
$OptionsResult = $database->query($OptionsQuery);
$OptionsAll = $result->fetchRow(DB_FETCHMODE_ASSOC,$i);
$VechOptionsData = $OptionsAll['Interior'];

echo $VechOptionsData;

in tweaking this , sometimes I just get object. I'm not sure if I need to iterate or what here. Any help would be a lifesaver... Many Thanks!

bradgrafelman

kleptik wrote:
sometimes I just get object

To narrow this down, try some debugging:

$OptionsResult = $database->query($OptionsQuery);
if(!$OptionsResult) die('Error: ' . $database->error);

As for your other questions:

I would highly recommend you change the "SELECT *" to a list of column names that you'll be using - selecting all of the columns causes the DB to use more resources (CPU, memory, hard drive seek time, etc.) than it has to.
What class/library are you using? fetchRow() isn't a MySQLi function, so I'm a bit at a loss as to what class you are using to query the database.