Location: PHPKode > scripts > Jack's MySQL class > jacks-mysql-class/functions.txt
sql class method(date 13.05.2007):
	- setFetchMethod($method)													:	set default fetch method
	- connect($dbhost, $dbuser, $dbpass, $dbname)								:	connect to databse
	- disconnect()																:	disconnect
	- query($query, $index=0)													:	prefrom query and save info for it on $index
	- query1($qry, $index=0, $method=false)										:	preform query, return result from it, and clear it
	- getrow($index=0, $rown=false, $method=false)								:	get rows, if no rows available clear info about the query
	- getnumrows($index=0) 														:	number of selected rows
	- getnumflds($index=0) 														:	number of selected fields
	- getnumaff($index=0) 														:	number of affected rows
	- getlastid() 																:	last added id
	- free_result($index=0) 													:	free sql result
	- nextindex()																:	return next avalable(free) index
	- escape($str)																:	simple escape
	- escape_full($str)															:	more advanced escape
	- quote()																	:	quote
	- where($cond)																:	return where conditions
	- insert($table, $values, $avalues=0)										:	insert query
	- update($table, $values, $cond=0)											:	update query
	- set($table, $values, $key=0, $kval=0)										:	if record exists update it, if no add new
	- delete($table, $cond=0)													:	delete query
	- select($table, $fields='*', $cond=false, $limit=false, $index=0)			:	select query
	- table_info($table=0, $prefix=0, $suffix=0, $type='MyISAM')				:	table info
	- table_content($table=0, $prefix=0, $suffix=0, $skip=array())				:	table content
Return current item: Jack's MySQL class