What is wrong with me?

[kbrick]

I'm embarrassed to even ask this question, but I think I'm having a MAJOR brain fart here. I'm merely trying to display two fields from a record, but I'm not getting any results. This is like the most basic thing, but I can't see what I'm missing after playing with it for a couple hours!! Anyway, I've attached a picture of the actual data record from PHPmyAdmin. The code I'm using after the database connect is:

$get_order = "SELECT id, session_id, item_total, total_tax,
order_cost, sel_ship, shprate, order_total, paytype,
ccname, ccnum, exp_date FROM order_details
ORDER BY id";
$get_order_res = mysql_query($get_order) or die(mysql_error());

$display_block = "Sel_ship: $sel_ship, Shiprate: $shprate";
echo "$display_block";
?>

...and the result I get is:

Sel_ship: , Shiprate:

Help??

😕

[sneakyimp]

your $display_block line makes no reference whatsoever to the data you just retrieved from your query.

assuming your query actually does return data (i haven't looked at your screen show) then the proper way to get data out of the results (which should be stored in $get_order_res) is to use either mysql_fetch_row() or mysql_fetch_assoc() on $get_order_res.

something like

while ($row = mysql_fetch_assoc($get_order_res)) {
echo $row['field_name1'];
echo $row['field_name 2'];
}

i have no idea what the field names are in your database...maybe 'sel_ship'? or perhaps 'shprate'?

anyways. i would encourage you to read a bit more about mysql statements at www.php.net

[kbrick]

That was it!! You are my hero....thank you!