Need to access particular field in table

  col1  col2  col3

row1 2 - -
row2 5 - -
row3 6 - -
row4 8 - -

What would the code be for a script/function that would insert a new row with the following values?

row5 9 - -

Any help would be GREATLY appreciated.

Have a look at

it makes it very easy to make mysql queries.

An example program might look like

<?
include("database.inc");

$thisdb=new mysql_dbase("data");
$thisdb->connect();

$query="insert into tablename values (\"row5\", \"9\", \"-\", \"-\")";
$thisdb->do_query($query);

$thisdn->close_db();
?>

Mark.

I was looking for something that would insert a new row where col1 is the previous col1 incremented + 1.

So if instead of it being 8, it could be 123, and the next one inserted would be 124.