mySQL and nesting

artpego

have a problem. i am calling a table in a mySQL database, then trying to call another table with a query within a query. i know that nested queries are not supported in mySQL at this point; however, i am sure there is a designer work around i am missing.
the following is the code giving the problem:

<?
mysql_select_db('whatever');
$gen1gen=mysql_query("select * from table1 order by tablestuff asc");
while($hrmm=mysql_fetch_array($gen1)){
$cn=$hrmm["country"];
$id=$hrmm["ID"];
?>

then later....
<input type=text name=namer value="
<?
mysql_select_db('whatever');
$gen=mysql_query("select * from table2 where whateverval='$val' and whateverid='$id'");
while($out=mysql_fetch_array($gen)){
$outer=$out["mn"];
echo($outer);
}
}
?>
">

HELP

mad27

Your first while loop is not closed before the ?> tag arrives. Seeing your code, you want to close that loop only in the second part of the PHP code. I don't think that's possible.
What you CAN do is to generate two connections to your database with different link id's. Then you can query multiple times. Don't ask me for the specifics, see the php-manual for that. Look in the MySQL portion and for (optional) function-arguments called "int link-identifier".

TTT

problem is with connection. first you get all records from first query and then from second query you get records which are relative against first query's last record... am i right??

if you manage to get that work, plase inform me.

artpego

I have managed to get it to work. the problem i had was with a variable being used in the second mySQL query, not with the actual structure of the queries. for some reason, a variable was not being translated inside the while loop properly when it was being sent from another form. kind of odd though, outside the while loop it worked fine.

Form 1 $phpself?
$var Submited to mySQL While Loop #1
Submit --> Nested mySQL While Loop #2

when used at any point in While Loop #1, the value of $var of came out to be 46, the correct value. no problems. HOWEVER, when used in While Loop #2, the value came out to be <! 46 >, no matter what i did, reassign to a new $, echo, yada. Until i created another query prior to both of these:

$phpself
1.mySQL While Loop #0 - queries database to find a match
for $var (var was a primary key in table 1) - got a match and

assigned the value from the query to $var_var - END While Loop

i then substituted $var_var for $var and my other query structure worked fine.

why? i have not one single clue, but it worked and i was able to query both tables, get the correct results and get back to work on that section of the site.

Thanks for ya'lls help, if i can help in any way, I will be happy to.