mysql_tablename

Get table name of field (PHP 4, PHP 5, PECL mysql:1.0)
string mysql_tablename ( resource result, int i )

Example 1464. mysql_tablename() example

copy to clipboard

<?php

mysql_connect("localhost", "mysql_user", "mysql_password");
$result = mysql_list_tables("mydb");
$num_rows = mysql_num_rows($result);

for ($i = 0; $i < $num_rows; $i++) {

    echo "Table: ", mysql_tablename($result, $i), "\n";

}

mysql_free_result($result);
?>

Related Examples ( Source code ) » mysql_tablename

Examples ( Source code ) » Listing the Databases Available in a Connection

Examples ( Source code ) » Connect to MySQL

Examples ( Source code ) » Get all tables in a database

Examples ( Source code ) » Listing Tables in a Database

Code Examples / Notes » mysql_tablename

haseldow

Another way to check if a table exists: if(mysql_num_rows(mysql_query("SHOW TABLES LIKE '".$table."'"))==1) echo "Table exists"; else echo "Table does not exist";

A simple function to check for the existance of a table: function TableExists($tablename, $db) { // Get a list of tables contained within the database. $result = mysql_list_tables($db); $rcount = mysql_num_rows($result); // Check each in list for a match. for ($i=0;$i<$rcount;$i++) { if (mysql_tablename($result, $i)==$tablename) return true; } return false; }

Change Language

mysql_affected_rows
mysql_change_user
mysql_client_encoding
mysql_close
mysql_connect
mysql_create_db
mysql_data_seek
mysql_db_name
mysql_db_query
mysql_drop_db
mysql_errno
mysql_error
mysql_escape_string
mysql_fetch_array
mysql_fetch_assoc
mysql_fetch_field
mysql_fetch_lengths
mysql_fetch_object
mysql_fetch_row
mysql_field_flags
mysql_field_len
mysql_field_name
mysql_field_seek
mysql_field_table
mysql_field_type
mysql_free_result
mysql_get_client_info
mysql_get_host_info
mysql_get_proto_info
mysql_get_server_info
mysql_info
mysql_insert_id
mysql_list_dbs
mysql_list_fields
mysql_list_processes
mysql_list_tables
mysql_num_fields
mysql_num_rows
mysql_pconnect
mysql_ping
mysql_query
mysql_real_escape_string
mysql_result
mysql_select_db
mysql_set_charset
mysql_stat
mysql_tablename
mysql_thread_id
mysql_unbuffered_query