Need a specific Number of MySQL-Fields

[Dragonspell]

OK, here's my problem.

I've got a MySQL-table with several fields (fake1,fake2,test1,test2,test3,fake3). Now, I do only want to get the fields test1,test2,test3, but I only know by an Integer, how may there are (because the number of fields increases from time to time, so there will be test4, test5,..., test100 in near future etc).

With Non-Arrays (integer for example, $Test1, $Test2, $Test3 etc), I normaly would use something like this:

PHP Code:

for ($i=1;i<=$number_of_testfields;i++){
print ("${"test".$count}");
} 


With arrays it should look somthing like this, but I can't get this example work (PHP doesn't like the 3rd line):

PHP Code:

$data=$DB_site->query_first("SELECT * FROM Testtable");
for ($i=1;$i<=$number_of_testfields;$i++){
  print ("$data[test".$i."]");
} 


I hope you understood my problem. Thanx for your help.

[g-force2k2]

maybe because you didn't identify the variable:

PHP Code:

$number_of_testfields 


so that would just give it no effect resulting in now results? regards...

g-force2k2

[Dragonspell]

Ehm... no.

I've declared it (=5).

[Dragomancer]

The Problem is, that the code

PHP Code:

print ("$data[test".$i."]"); 


generates an "" output, but I know that there's data in $data[test1].
Here's the proof:

PHP Code:

print $data[test1]; 


I get an output with "5".

I really need to run the first one, so plzzzzz help me !

[Hoffi]

Try the following:

PHP Code:

eval ("\$output = \"\$data[test".$i."]\";");
print ($output); 


Otherwise you can read the Rownames with the SQL Describe Tablename all Rownames out of the Database and use them is this way.

[Dragomancer]

Originally posted by Hoffi
Try the following:

PHP Code:

eval ("\$output = \"\$data[test".$i."]\";");
print ($output); 


:banana::banana:IT WORKS:banana::banana:

ThankyouThankyouThankyouThankyouThankyouThankyou
ThankyouThankyouThankyouThankyouThankyouThankyou
ThankyouThankyouThankyouThankyouThankyouThankyou
ThankyouThankyouThankyouThankyouThankyouThankyou
ThankyouThankyouThankyouThankyouThankyouThankyou
ThankyouThankyouThankyouThankyouThankyouThankyou