[SOLVED] Getting info from MySql DB

[bumba000]

Hi All, Thanks for reading!

 

Okay so I have a table called orders_total. In this table I have orders_total_id, orders_id, title, text, value, class, sort_order.

The "Title" column holds the names Total, SubTotal and Various Shipping titles. The "Class" column holds info like "ot_total, ot_subtotal and ot_shipping".

 

So I start with

$order_shipping = $db->Execute("select *

                            from " . TABLE_ORDERS_TOTAL . "

                            where orders_id = '" . (int)$oID . "'");

 

Then I need to echo only the "Title" for the row where the column "Class" holds the value "ot_shipping".

So my db execute may return 3 or 4 rows of data and I only want the title from the one thats class is "ot_shipping".

 

 

Thanks in advance,

                          John

 

 

[MadTechie]

unless i am missing something

wouldn't it just be

"select Title from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$oID . "' AND Class = ot_shipping"

[bumba000]

Hey Thanks for the Help.

 

This is the error I get when using that code.

 

1054 Unknown column 'ot_shipping' in 'where clause'

in:

[select title from orders_total where orders_id = '52117' AND class = ot_shipping]

 

Please advise. Hey, I'm new and I'm trying.

 

Thank you very much for your time,

              John

[MadTechie]

oopps, i assumed ot_shipping was a field,

try this, (using the value of ot_shipping)

 

"select Title from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$oID . "' AND Class = 'ot_shipping'"

[bumba000]

Got It! Thank you sooo much for your help.

 

John