Posted By

iTony on 11/20/08


Tagged

mysql function query load


Versions (?)

loading a fetch query


 / Published in: PHP
 

  1. <?php
  2.  
  3. function loadFetch( $assoc = false, $sql = null )
  4. {
  5.  
  6. unset( $query_fetch );
  7. empty( $query_fetch );
  8.  
  9. $sql = ( is_null($sql) && isset($query_result) ) ? $query_result : $sql;
  10. $fetchType = ( $assoc ) ? MYSQL_ASSOC : MYSQL_NUM;
  11.  
  12. if ( !empty($sql) )
  13. {
  14. while ( $fetch = mysql_fetch_array($sql, $fetchType) )
  15. {
  16. $query_result[] = $fetch;
  17. }
  18.  
  19. if ( !is_array($query_fetch) )
  20. {
  21. throw new Exception( "An error occured while fetching the array" . mysql_error() );
  22. } else {
  23. return $query_result;
  24. }
  25. }
  26.  
  27. }
  28.  
  29. ?>

Report this snippet  

You need to login to post a comment.