note 35926 deleted from function.mysql-tablename by didou
| From: | didou@php.net | Date: | Fri, 19 Sep 2003 12:11:51 +0000 |
| Subject: | note 35926 deleted from function.mysql-tablename by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-56758@lists.php.net to get a copy of this message | ||
Note Submitter: PHP User
----
SAMPLE OF USE:
FONCTION FOR CHECK A IF A TABLE EXIST IN SQL TABLE
$var1 = SQL PATH
$var2 = SQL USER
$var3 = SQL PASS
$var4 = SQL Name
$var5 = TABLE Name
<?php
function check_table($var1,$var2,$var3,$var4,$var5)
{
mysql_connect("$var1", "$var2", "$var3");
$result = mysql_list_tables("$var4");
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
if(mysql_tablename($result, $i)=="$var5"){$ctable="1";}
if($ctable!="1"){$ctable="0";}
}
mysql_free_result($result);
}
?>