title: Set PHP variable to latest value in MySQL row
body: <p>I searched old questions, but couldn't find an answer or wrap my head around anything relevant (new to PHP and MySQl so take it easy)!</p>
  
  <p>I have a MySQL table with the columns: id, subid, name; I ran this query:</p>
  
  <pre><code>CREATE TABLE mytable (id int(999999) NOT NULL auto_increment,subid varchar(99) NOT NULL,name varchar(99) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))
  </code></pre>
  
  <p>From the value in <em>subid</em> on the latest row I want to set to <em>$latestsubid</em>, this is what I've managed to throw together:</p>
  
  <pre><code>    &lt;?
      $user="me";
      $password="blah";
      $database="mydb";
      $host="localhost";
      mysql_connect($host,$user,$password);
      @mysql_select_db($database) or die( "Unable to select database");
      $query="SELECT subid FROM mytable";
      $result=mysql_query($query);
      $num=mysql_numrows($result);
      mysql_close();
      ?&gt;
  </code></pre>
  
  <p>If anyone could give me a hand it'd be great!</p>