SEARCH:
Previous: SQL_OneValue Next: SQL_AllRows

SQL_OneRow

string SQL_Query
array Row


Accepts a SQL query and returns the first row only of the result. If the query returns zero rows the routine returns boolean false.

Note that the query itself should return only 1 or a few rows, using this routine is not a substitute for planning an efficient query. If you hand this routine a query that generates 1 million rows, the server will still generate the entire result, even though it only gives back the first one.

Previous: SQL_OneValue Next: SQL_AllRows