Re: Passing mysql table names to php functions?
- From: "Jose da Silva" <josedasilva@xxxxxxxxx>
- Date: 27 Feb 2007 06:36:44 -0800
Hello, have you tried some debug?
Try to
echo "My table name in function: ".$tableName;
Maybe the variable is not getting the value you expected
Regards
jose Silva
On Feb 27, 2:25 pm, kennthomp...@xxxxxxxxx wrote:
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: kennthompson
- Re: Passing mysql table names to php functions?
- References:
- Passing mysql table names to php functions?
- From: kennthompson
- Passing mysql table names to php functions?
- Prev by Date: Passing mysql table names to php functions?
- Next by Date: Re: Passing mysql table names to php functions?
- Previous by thread: Passing mysql table names to php functions?
- Next by thread: Re: Passing mysql table names to php functions?
- Index(es):
Relevant Pages
|
