Hi Jon, and Howard,
(comments interposed, below)
> Try using something like
> $getlist = mysql_query("SELECT id FROM yourdb",$dbconnectetc);
> $numrows = mysql_num_rows($getlist);
> echo "$numrows\n";
> This will give you the number of records in your db.
> If you use autoincrement for the id field your will not have to
> worry about your ++.
> If you delete any records numrows will always be correct.
=this is correct, but COUNT(*) is optimised/more efficient (RTFM: 6.3.7 Functions for
Use with GROUP BY
> First off, sorry for the newbie question... :(.
> I want to be able to query the database and find the record with the
> highest ID value. Example... each row ideally has an incremented integer
> ID (1, 2, 3, 4...) but I am running into problems when I try and delete
> a row (let's say row 2). My PHP currently selects all of the rows and
> formulates the ID off of that... This I found out is bad because when I
> delete row 2 the query says there are 3 rows so my PHP will try to make
> the ID = 4. I just need the code to find the highest ID so I can ++ it.
> Sorry again for the easy question!
=no need to apologise, we all have to start somewhere.
=It is an FAQ. By asking it you indicate that you don't (yet) understand the
philosophy of the AUTO_INCREMENT
facility. It is there to provide an ID for new rows of data, not to be a 'count' of
the rows. If you consider
that this ID may be used as a key into this table's data from another table (foreign
key), then you will realise
that changing ID values to reflect intermediate deletions is less than logical. (RTFM:
AUTO_INCREMENT, although it doesn't seem to get into this point - the annotated
comments are worth a read
though). I've just a had a quick look to see where the manual discusses the
'philosophy' and have come up
empty - perhaps someone else can steer you right, if you need more.
=It is worth reading through PHP's large collection of built-in MySQL_ functions.
There are specific functions
that will return various 'numbers of rows' to the script to suit various situations.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php