|
Posted by Jerry Stuckle on 02/28/07 01:48
kennthompson@gmail.com wrote:
> On Feb 27, 10:27 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> kennthomp...@gmail.com 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.
>> This should work fine. What do you get back as an error message? How
>> are you calling the function?
>>
>> What happens if you do the following:
>>
>> function fms_get_info($tableName)
>> {
>> $sql = "select * from $tableName";
>> echo $sql . "<br>\n";
>> $result = mysql_query($sql) ;
>> for ($i = 0; $i < mysql_num_rows($result); $i++)
>> {
>> /* do something */
>> }
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
>
>
> No. That's exactly the way I was trying to do it. MySQL doesn't accept
> a table name passed into a function this way. There must be some
> hidden mysql code that I'm unaware of.
>
>
It works. Did you do as I asked? Echo the sql first, then the error
returned by mysql.
It's not PHP nor MySQL that's your problem.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
[Back to original message]
|