Curt, Thanks. > > #mysql_select_db($db2,$myconnection2); #not necessary > > Why isn't this necessary? if you have just opened a connection you > must select a database. Besides the fact that the second connection > isn't necessary. >
>From what I have experimented with, if I declare $db.$table in my sql, it is no >longer necessary: $sql2 = 'select participant,biography,district from '.$db.'.'.$table2.' where district=$mydata1->district'; > > while ($mydata1 = mysql_fetch_object($news)) > > { > > echo "$mydata1->district<br />$mydata1->meeting<br />$mydata1->time<br />\n"; > > > > $sql2 = 'select participant,biography,district from '.$db.'.'.$table2.' where > > district=$mydata1->district'; > My error was in the single quotes. > If you need the stylesheet to go along with this see > [EMAIL PROTECTED] :) Thanks. I Will look athtat. John > HTH. Thanks, yes. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php