Re: [PHP-DB] finding ID's

2002-02-18 Thread DL Neil
Ok Jonathan, [I've put the answer back on the list - there are others who can help, and may well get back to you faster than I] Ok I get the auto_increment stuff... Just one more question. Let's say I want to show 25 rows per page. I want the script to generate links to the next page, and so

RE: [PHP-DB] finding ID's

2002-02-17 Thread Howard Picken
Hi Jon 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

Re: [PHP-DB] finding ID's

2002-02-17 Thread DL Neil
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