[checking for duplicates]

Do you mean looking for a value and telling the user if it already exists?

 

$result = mysql_query("SELECT column_name FROM tbl_name WHERE column_name='$value'");

if (!mysql_num_rows($result > 0) {
// code here
}

[Do you use Microsoft Frontpage]

I use it for tedious things, to get the bulk of the html out of the way and then fix it all up later to work with my stylesheets etc..

[Do you use Microsoft Frontpage]

I've never even used it.

 

I use Editplus for syntax highlighting and ease of use for php.

 

Then for tedious html coding I use DreamWeaver then tweak it myself

[Dynamic LIMIT for recordsets]

Myself I always use a mysql statement as much as I can to filter the data. It's a lot more efficient than selecting a whole table and filtering it yourself with php.

 

just incorporate the values as variables into your query

 

$query = "SELECT * FROM my_table WHERE this=that LIMIT $row_offset, $rows";

OR you can only select certain fields as well

$query = "SELECT column1, column2, column4 FROM my_table WHERE this=that LIMIT $row_offset, $rows";

AND you may also skip the offset if you just want the first x rows

 

moving on...

 

then store the result

$result = mysql_query($query);

 

then do whatever with the result set

 

Hopefully thats what you were talking about