Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

[PHP-DB] php newbie From: Edward Peloke (epeloke <email protected>)
Date: 09/11/02

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 (!  <email protected>("users"))
      { echo ("Unable to connect to the main db at this");
       exit();
          }

  $result= <email protected>("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= <email protected>("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