title: multiple mysql connections on one page php
body: <p>I am getting errors (not really errors, just not working properly) and I'm trying to figure out if it's related to my sql connections. I have 2 separate connections to two entirely different databases.</p>
  
  <pre><code>$dshost = "kjbkb";
  $dsdatabase = "kjhk";
  $dsusername = "hjgfytdf";
  $dspassword = "jhv";
  mysql_connect($dshost,$dsusername,$dspassword);
  mysql_select_db($dsdatabase) or die( "Unable to select database");
  
  $sql = "SELECT * FROM users WHERE `username` = '".$_POST['paydl']."'";
  $cheeseburger = mysql_query($sql);
  $res = mysql_fetch_array($cheeseburger);
  $autobus_user = $res['id'];
  
  mysql_close(); //close first connection
  
  $db_host = "khgv";
  $db_user = "trdstx";
  $db_password = "txz";
  $db_database = "gfxx";
  mysql_connect($db_host, $db_user, $db_password) or die("Unable to connect to host");
  mysql_select_db($db_database) or die( "Unable to select database");
  
  $ASDFASDF = "SELECT * FROM `autobus` WHERE `user_id` = '".$autobus_user."' LIMIT 3";
  $BobDoleDontNeedThis = mysql_query($ASDFASDF);
  $resnumbatwo = mysql_fetch_array($BobDoleDontNeedThis);
  
  mysql_close(); //close 2nd connection
  </code></pre>
  
  <p>Am I doing this right? Why is <code>$resnumbatwo</code> returning false?</p>