access one table to get name of other

Anon

I am trying to access a group of tables from one main listing table.
this is my attempt.

<?php

$db = mysql_connect(localhost, root);
mysql_select_db(\"ngl\",$db);

$result = mysql_query(\"SELECT * FROM Tournaments ORDER BY Name\",$db);

while ($myrow = mysql_fetch_row($result))
{
$result = mysql_query(\"SELECT * FROM $myrow[0] ORDER BY Name\",$db);
while ($myrow2 = mysql_fetch_row($result))
{
print \"$myrow2[0] \";
print \"$myrow2[1] \";
print \"$myrow2[2] \";
}
}

php?>

i am really new to this so i have no idea what im doing wrong but i know its in the line.
$result = mysql_query(\"SELECT * FROM $myrow[0] ORDER BY Name\",$db);

Anon

try this one:

mysql_query("SELECT * FROM ".$myrow[0]." ORDER BY Name",$db);

single array elements are not 'translated' within double quoutes:

$the_number = 5;
"This is number: $the_number";
shows
"This is number: 5"

but
$my_numbers = array ("5","4","3");
"This is number: $my_numbers[1]";
does not show:
"This is number: 4";
however
"This is number: ".$my_numbers[1];
would.

Regards
Tom

Anon

You are confused, Tom. Variables inside double quotes ARE translated, including one dimensional arrays (multi-dimensionals are another story, which is why bracket notation was introduced in PHP4).

Variables inside single quotes are NOT translated.

Reboot, remove the slashes before the double quotes unless the double quotes are inside another set of double quotes. i.e.

print \"$myrow2[0] \";

should be:

print "$myrow2[0] ";

You would use the slash for this:

print "\"This is an example.\"";

which would cause the output:

"This is an example."

including the quotes.

This holds true for all functions including the mysql functions.

Anon

Variables inside double quotes ARE translated, including one dimensional arrays

I admit, you're right! But did in work with PHP3?? I somehow have the strong feeling, I have encountered difficulties with that some time ago..but it might have been with PHP3.

Another thing is, is saw escaped double quotes in this forum so often, that I wasn't really sure, if maybe 'addslahes' is automatically apllied on mails here.
However:

mysql_query(\"SELECT * FROM $myrow[0] ORDER BY Name\",$db);

with \" will neither work in PHP3, nor in PHP4. 😉

Tom