jerry187

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 }

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..

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

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