Hey guys,
I was wondering if this code is possible. I say it is a 4GL code that I am migrating
to PHP.
Advertising
+++++++++++++++++++++++++++++++++++++++++++
$side1Query=ifx_query('select * from line, event'
.' where line.e_id=event.e_id '
.' and l_type="'.$s_lt.'" '
.' and l_status in ("O","C") '
.' and u_type="P" '
.' and betno in
(select min(betno) from line, event
where line.e_id=event.e_id
and l_type="'.$s_lt.'") ',$db) or die (ifx_error());
+++++++++++++++++++++++++++++++++++++++++++
I am asking because it would greatly help me since my current method is to select the
(min) then use the min in the query.
+++++++++++++++++++++++++++++++++++++++++++
$minS_LT = ifx_query('select min(betno) from line, event'
.' where line.e_id="'.$ecols['e_id'].'" '
.' and line.l_status in ("O","C") '
.' and line.u_type="P" '
.' and l_type="'.$s_lt.'" ',$db) or die (ifx_error());
$betcols1=ifx_fetch_row($minS_LT);
$min_betno1=min($betcols1);
+++++++++++++++++++++++++++++++++++++++++++
$side1Query=ifx_query('select * from line, event'
.' where line.e_id=event.e_id '
.' and l_type="'.$s_lt.'" '
.' and l_status in ("O","C") '
.' and u_type="P" '
.' and betno="'.$min_betno1.'"',$db) or die (ifx_error());
+++++++++++++++++++++++++++++++++++++++++++
Thanks in advance for your assistance.
Regards,
RedHat
http://redhat.opensource.bz
[EMAIL PROTECTED]
