Re: Passing mysql table names to php functions?
- From: kennthompson@xxxxxxxxx
- Date: 27 Feb 2007 07:02:52 -0800
The name passes -- the echo test works; it just won't work as a mysql
table. The variable is getting there, but mysql for some reason does
not recognize it. I've read something about prepare and execute in
mysql, but not sure this is the answer to my problem.
On Feb 27, 8:36 am, "Jose da Silva" <josedasi...@xxxxxxxxx> wrote:
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.- Hide quoted text -
- Show quoted text -
.
- Follow-Ups:
- Re: Passing mysql table names to php functions?
- From: J.O. Aho
- Re: Passing mysql table names to php functions?
- References:
- Passing mysql table names to php functions?
- From: kennthompson
- Re: Passing mysql table names to php functions?
- From: Jose da Silva
- Passing mysql table names to php functions?
- Prev by Date: Re: Passing mysql table names to php functions?
- Next by Date: Re: saving content from another site
- Previous by thread: Re: Passing mysql table names to php functions?
- Next by thread: Re: Passing mysql table names to php functions?
- Index(es):
Relevant Pages
|
