Re: Passing mysql table names to php functions?
- From: kennthompson@xxxxxxxxx
- Date: 27 Feb 2007 10:18:27 -0800
On Feb 27, 10:56 am, "J.O. Aho" <u...@xxxxxxxxxxx> wrote:
kennthomp...@xxxxxxxxx wrote:
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.
If your tables has other characters than a-z,A-Z,0-9 and - and _ then
you should put `` around the variable
$result = mysql_query("select * from `{$tableName}`");
I think you should use a while-loop instead of the for-loop you are using
while($row=mysql_fetch_array($result)) {
/* do something */
}
--
//Aho
No. That won't work either. I need to add one more thing. To make the
stable version work I had to identify the old table name as global. I
think this looks simpler than it really is. I thought a simple
variable name could be passed as a table name, but there must be some
mysql code that allows it.
.
- 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
- Re: Passing mysql table names to php functions?
- From: kennthompson
- Re: Passing mysql table names to php functions?
- From: J.O. Aho
- Passing mysql table names to php functions?
- Prev by Date: Re: Form input data
- Next by Date: Re: testing php on my home computer
- 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
|
