You will usually need to apply some logic to the query that you apply to a table, and this is easily done with the WHERE keyword.
This will be followed by a fieldname, or list of them, and then the condition you want to be met.
Thus if you want to select only rows from a table WHERE the user is called Quentin you would do the follow:
$peeps = mysql_query("SELECT * FROM users WHERE firstname = 'Quentin'");
?>
Archive for the ‘Scripting / Coding’ CategoryHow to include a conditional in my MySQL query?How to group the results of a MySQL query?If you want to group the results by a particular field value rather than listing all results individually, then you use the GROUP BY keyword. How to find the number of rows affected by a query?With mysql it is usually just a case of learning which function to use, and this is no exception. How do I find the ID of a new row added to a table?If you are adding data to a mySQL table then you will often want to know the ID of a row you have just inserted so that you can reference it elsewhere. Often you’ll add to a table with an auto_increment ID field and then want to use this to store other information on other tables. How do I connect to MySQL from PHP?The first thing you will need to do when using PHP and mySQL is to connect to the mySQL database from PHP. And that’s all there is to it – use your username, host, password and database name and this will establish the connection. Is IonCube supported?Yes Host1Free.com supports IonCube. Usually IonCube is used for encoding PHP files. Is Zend Optimizer available?Yes Host1Free.com support Zend Optimizer. Zend Optimizer is used to run for better performance PHP applications. HTTP Error 500 – Internal server errorThe server failed to fulfill an apparently valid request. HTTP Error 403 – ForbiddenThe 4xx class of status code is intended for cases in which the client seems to have erred. Except when responding to a HEAD request, the server should include an entity containing an explanation of the error situation, and whether it is a temporary or permanent condition. These status codes are applicable to any request method. User agents should display any included entity to the user. These are typically the most common error codes encountered while online. Where can I find server PHP information?To get the detailed information about PHP modules you can visit this link located here. |
|