Manufacturer: Poreba Ref: 30761
mysqli_result Object
(
[current_field] => 0
[field_count] => 2
[lengths] =>
[num_rows] => 1
[type] => 0
)
Code and Manufacturer: Array
(
[Code] => L3000
[Manufacturer] => Poreba
)
mysqli_result Object
(
[current_field] => 0
[field_count] => 14
[lengths] =>
[num_rows] => 1
[type] => 0
)
prestige_categories: Array
(
[Code] => L3000
[Description] => Lathes Flat Bed Manual & CNC
[link] => /lstfs/htm/L3000.htm?
[SortColumn] => Size1
[Head1] => Ref #
[Head2] => Manufacturer
[Head3] => Model
[Head4] => Year
[Head5] => Swing
[Head6] => CC
[Head7] => Control
[Head8] => HP
[Head9] => Options (Non Web)
[created] => 2024-05-10 09:39:43
)
(select m.* from prestige_machines as m, prestige_categories as c where m.code=c.code and c.code='L3000') ORDER BY CASE WHEN m.manufacturer = '' and Size1 = '78.74\" ' THEN 0 WHEN Size1 = '78.74\" ' THEN 1 WHEN Size1 > '78.74\"' THEN 2 ELSE 3 END, Size1 ASC limit 10