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)
 +Snippet Options
+   Printer Friendly
 +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
Syntax for: MySQL / Table and Field Information

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:

<?php

    mysql_connect
("localhost""mysql_username""mysql_password");
    
mysql_select_db("mysql");
    
$result mysql_query("SELECT * FROM func");
    
$fields mysql_num_fields($result);
    
$rows   mysql_num_rows($result);
    
$table mysql_field_table($result0);
    echo 
"Your '".$table."' table has ".$fields." fields and ".$rows." record(s)n";
    echo 
"The table has the following fields:n";
    for (
$i=0$i $fields$i++) {
        
$type  mysql_field_type($result$i);
        
$name  mysql_field_name($result$i);
        
$len   mysql_field_len($result$i);
        
$flags mysql_field_flags($result$i);
        echo 
$type." ".$name." ".$len." ".$flags."n";
    }
    
mysql_free_result($result);
    
mysql_close();
?>
 
Description for: MySQL / Table and Field Information
  Print out table and field information


 
Powered by: PHP-CSL V0.9