This is weird:
I know my connection works. and I have an insert statement working.
using MYSQL 5.1.35
$query ="SELECT id FROM sequences WHERE name = 'uc_order_products_order_product_id' ";
$results = fm_sql_select($query);
error: 8309 ERROR: FQL0002/(1:15): The table named "sequences" does not exist.
this error was produced by: $error = fm_get_last_error();
this statement works in phpmyadmin.