Hello all,
I am very new to php, in fact, this is my first attempt at a script. I have just been following a tutorial online. Currently, I have a page where the user types in a username and password, I then pass those parameters to this page. This page connects to a main db, looks up their username and password and then attempts to switch them to their own db but that doesn't seem to work. When the page loads, I get errors because of my last select. It tells me that the database users does not have a table grades which is true but I wanted it to change to the grades db. How can I fix this? Also-is there a way in php to display the results of a query into an editable grid? Thanks, Eddie <html> <head> <title>PHP Test</title> </head> <body bgcolor="white"> <?php // connect to db $dbcnx=mysql_connect("localhost","user","password"); if (!$dbcnx) {echo ("<p>Unable to connect to the database server at this time"); exit(); } // use the users db mysql_select_db("users", $dbcnx); if (! @mysql_select_db("users")) { echo ("Unable to connect to the main db at this"); exit(); } $result=@mysql_query("Select dbname from users where pword='$password' and username='$username'"); // if (!$result) { // echo("<p>Error performing query: " . mysql_error() . // "</p>"); // exit(); // } //($row=mysql_fetch_array($result)) mysql_select_db("grades",$dbcnx); $result=@mysql_query("Select subject, grade from grades"); if (!$result) { echo("<p>Error performing query: " . mysql_error() . "</p>"); exit(); } while ( $row = mysql_fetch_array($result) ) { echo("<p>" . $row["Grades"] . "</p>"); } ?> </blockquote> </body> </html> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php