Passing mysql table names to php functions?
- From: kennthompson@xxxxxxxxx
- Date: 27 Feb 2007 06:25:28 -0800
Trouble passing mysql table name in php. If I use an existing table
name already defined everything works fine as the following script
illustrates.
<?php
function fms_get_info()
{
$result = mysql_query("select * from $tableInfo") ;
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
/* do something */
}
}
/* Main */
fms_get_info();
But it won't work if I pass a variable table name to the function.
<?php
function fms_get_info($tableName)
{
$result = mysql_query("select * from $tableName") ;
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
/* do something */
}
}
/* Main */
fms_get_info($tableInfo);
I need to use the same function to gather information from multiple
tables at will without creating a different function for each possible
mysql database table by name. I thought this would be easy, but I
have failed at several tries.
.
- Follow-Ups:
- Re: Passing mysql table names to php functions?
- From: Jose da Silva
- Re: Passing mysql table names to php functions?
- Prev by Date: Re: Sessions in different versions of PHP
- Next by Date: Re: Passing mysql table names to php functions?
- Previous by thread: testing php on my home computer
- Next by thread: Re: Passing mysql table names to php functions?
- Index(es):
Relevant Pages
|