Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
06-30-2013, 07:17 PM #1
- Join Date
- Jul 2010
- Thanked 0 Times in 0 Posts
Using mysql limit functon to locate first record
$SQLDISTRIBUTOR = " SELECT * FROM DISTRIBUTOR ";
$SQLDISTRIBUTOR.= " WHERE COUNTRYCOD =" . $_SESSION['COUNTRYCOD'];
$SQLDISTRIBUTOR.= " AND STATECOD =" . $_SESSION['STATECOD'];
$SQLDISTRIBUTOR.= " AND CITYCOD =" . $_SESSION['CITYCOD'];
$SQLDISTRIBUTOR.= " ORDER BY ACCOUNT_NUMBER ASCENDING LIMIT 1 ";
$FDISTRIBUTOR = mysql_query( $SQLDISTRIBUTOR, $CON );
06-30-2013, 11:23 PM #2
Is there a question in there?
And why are you still using obsolete old
mysql_query???An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.