|
sybase_result
Get result data
(PHP 4, PHP 5)
Returns the contents of the cell at the row and offset in the specified Sybase result set. When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these functions return the contents of multiple cells in one function call, they're MUCH quicker than sybase_result(). Also, note that specifying a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argument. Recommended high-performance alternatives: sybase_fetch_row(), sybase_fetch_array() and sybase_fetch_object(). Code Examples / Notes » sybase_resultsamthorogood
This could be an even quicker way (using the code above as a base): $db = sybase_connect("sybtest", "sa", "users"); $id = sybase_result(sybase_query("EXEC usp_get_id @username='$username'", $db)); echo $id; Even simpler. :) chad
If a stored procedure is doing all the work for you and you just need to retrieve a single cell... $db = sybase_connect("sybtest", "sa", "users"); $query = sybase_query("EXEC usp_get_id @username='$username'", $db); $id = sybase_result($query,0,0); echo $id; Simple. |
Change Languagesybase_affected_rows sybase_close sybase_connect sybase_data_seek sybase_deadlock_retry_count sybase_fetch_array sybase_fetch_assoc sybase_fetch_field sybase_fetch_object sybase_fetch_row sybase_field_seek sybase_free_result sybase_get_last_message sybase_min_client_severity sybase_min_error_severity sybase_min_message_severity sybase_min_server_severity sybase_num_fields sybase_num_rows sybase_pconnect sybase_query sybase_result sybase_select_db sybase_set_message_handler sybase_unbuffered_query |