3 set_global_connection();
5 function set_global_connection()
9 if (isset($_SESSION["wa_current_user"]) && $_SESSION["wa_current_user"]->company !='')
10 $db = $_SESSION["wa_current_user"]->get_db_connection();
15 $db_duplicate_error_code = 1062;
17 //DB wrapper functions to change only once for whole application
19 function db_query($sql, $err_msg=null)
21 global $db, $show_sql;
23 //echo "<br>$sql<br>";
26 echo "<font face=arial size=2 color=000099><b>SQL..</b></font>";
33 $result = mysql_query($sql, $db);
36 check_db_error($err_msg, $sql);
41 function db_fetch_row (&$result)
44 return mysql_fetch_row($result);
47 function db_fetch (&$result)
50 return mysql_fetch_array(&$result);
53 function db_seek (&$result,$record)
55 mysql_data_seek($result, $record);
58 function db_free_result ($result)
61 mysql_free_result($result);
64 function db_num_rows (&$result)
66 return mysql_num_rows($result);
69 function db_num_fields (&$result)
71 return mysql_num_fields($result);
74 function db_escape (&$result)
76 return mysql_escape_string($result);
79 function db_error_no ()
82 return mysql_errno($db);
85 function db_error_msg(&$conn)
87 return mysql_error($conn);
90 function db_insert_id()
93 return mysql_insert_id($db);
96 function db_num_affected_rows()
99 return mysql_affected_rows($db);