SpellsBook

 +PHP
+ Adobe Flash 2 0 (0)
+ Arrays (4)
+ COM for Windows (2)
+ Image (2)
+ LDAP (3)
+ MySQL (11)
+ Basic MySQL Example
+ Database Information
+ Error Checking
+ Fetch Associative Array
+ Last Insert ID
+ Mysql PROD function
+ Number of Rows
+ SQL Dump to Database
+ Select Examples
+ Table and Field Information
+ Various Information
+ Regular Expressions (2)
+ String Manipulation (12)
+ Time and Date (6)
 +Library Options
+   View Other Library
Adobe_Flash_3_0
C_Plus_Plus
Debian_Install
Del_me_Soon
HTML_and_CSS
JavaScript
Linux_Commands
PHP
 +General Options
+   Library Home
+   PHP-CSL Credits
+   PHP-CSL License
+   Resource Links
+   Log in
Snippet available for: MySQL


category Basic MySQL Example
Connect, execute a query, print resulting rows and disconnect from a MySQL database...
category Error Checking
Check for errors using mysql_errno() and mysql_error()...
category Last Insert ID
Get the ID generated from the previous INSERT operation...
category Database Information
List information on databases available on a MySQL server, tables, fields and processes...
category Mysql PROD function
SUM and PROD functions Sql has SUM(n) AVG(n) etc but no PROD(n) (this is bad) Sneaky trick i...
category SQL Dump to Database
If you wish to execute many queries stored in a .sql file (usually created with a MySQL Dump) - this...
category Number of Rows
Get the number of rows in a result set...
category Table and Field Information
Print out table and field information...
category Select Examples
Selecting data with mysql_fetch_array...
category Fetch Associative Array
Fetch data from a MySQL database as an associative array...
category Various Information
Various SQL Information outside of queries...
 
 
Powered by: PHP-CSL V0.9