I searched the messages but didn't see anything related to this.. I
could really use some help. I've been coding php and mysql for years,
but this is the first time I've messed with different databases in one
place and the solution is escaping me.
I have 2 pages, index.php and menu.php
menu.php is included via require_once in index.php, just after the
beginning of the body tag.
My select in index.php is returning Resource id #13, but no rows. If
I echo the query and then paste that into phpMyAdmin, it returns one
row (as it should).
If I remove the call to menu.php, the query returns 1 row.
Menu.php is working correctly.
When I click one of the links and reload index.php, it echos this:
SELECT * FROM pages WHERE id=2 LIMIT 1 Resource id #13 0
What am I doing wrong?!
Here's the related code from index.php:
require_once("menu.php");
if($page_id){
}else{
$db="my_db_goes_here";
$page_id=1;
} //endif
$connection=my_connect($host,$username,$password,$db);
$query="SELECT * FROM pages WHERE id=$page_id LIMIT 1";
$sql=mysql_query($query) or die("Unable to query: ".$query);
echo $query." ".$sql," ".mysql_num_rows($sql);
Here's most of menu.php, minus some superfluous html:
foreach($db_array as $db){
$connection=my_connect($host,$username,$password,$db);
$query="select * from pages order by filename";
$sql=mysql_query($query) or die("Unable to query: ".$query);
while($row=mysql_fetch_array($sql)){
$link=stripslashes($row['linkname']);
?>
<a href="index.php?db=<?=$db?>&page_id=<?=$row['id']?>">
<?=$link?>
</a>
<?php
} //endwhile
mysql_close($connection);
} //endforeach
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
