3) Same type of a deal as with the
DELETE query. So it'd look kind of like this:
php
$sql = mysql_query("SELECT * FROM thread_replies WHERE ID='{$user_post}'");
4)
LIMIT is always (AFAIK) the very last thing in any query. Think of it this way: you have a table containing, say, 250,000 users and you need to load the user info for only one user. Even though you
will be limiting the number of results returned to one via a
WHERE clause, it's best to have both the limit and where clauses, because that way once SQL reaches one match (say, 50,000 rows down) it doesn't bother checking the other 200,000 rows.
So the query using a
LIMIT might look something like this:
php
$query = "SELECT post_count FROM members WHERE id='{$id}' LIMIT 1";
5) This pertains to your original question, 1-4 were just things I noticed about your coding
What's the deal with this?
If you have any questions feel free to ask!
This post has been edited by spearfish: 12 Oct, 2008 - 07:53 PM
| 