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)!
I have a MySQL table with the columns: id, subid, name; I ran this query:
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))
From the value in subid on the latest row I want to set to $latestsubid, this is what I've managed to throw together:
<?
$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();
?>
If anyone could give me a hand it'd be great!