RE: Don't know why query works this way

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>>>there are many ways to approach this.
one is, select the db before any of this activity with mysql_select_db
("dbname") then you can run as many queries against this database as you
want. Until you call that function again with another db name, mysql
with _always_ run against that database.

hth
jd


Since Jeff was telling him there were many ways to accomplish what he
wanted I figured I'd expand on what Jeff was saying and actually
ILLUSTRATE with working code/examples of what the 'many way's are.

Sorry if you found this to be Offtopic.

Aaron

-----Original Message-----
From: Adam Alkins [mailto:php@rasadam.com] 
Sent: August 6, 2003 8:16 AM
To: Aaron Wolski
Cc: php-db@lists.php.net
Subject: RE:  Don't know why query works this way

Quoting Aaron Wolski <aaronjw@martekbiz.com>:

> Here's some functions I use in my development which save on connect
and
> query calls for me.
> 
> //General Purpose Utilities.
> //db_connect connects to the database server and selects the proper
> database.
> //Arguments: None
> //Returns: Nothing
> 
> 
> function db_connect() {
> 
> 	mysql_pconnect("localhost","username","password");
> 	mysql_select_db("Database");
> 	
> }
> 
> 
> //db_query queries the database server and returns the results.
> //Arguments: SQL query string
> //Returns: Query results
> 
> function db_query($query) {
> 
> 	return mysql_query($query);
> 	
> }
> 
> 
> //db_fetch returns the next set of results from a db_query.
> //Arguments: db_query results variable
> //Returns: Next set of query results as an array or 0 if no further
> results are present
> 
> 
> function db_fetch($results) {
> 
> 	return mysql_fetch_array($results);
> 	
> }
> 
> 
> //db_numrows returns the number of rows selected from a query.
> //Arguments: query result
> //Returns: number of rows in the query result
> 
> function db_numrows($result) {
> 
> 	return mysql_num_rows($result);
> 	
> }
> 
> 
> //Always connect to the database!
> 
> db_connect();
> 
> 
> Keep these in an include file. The db_connect(); goes at the bottom
and
> keep the connection open during the routines.
> 
> 
> To call db_query you would use it like:
> 
> $someQuery = db_query("SELECT * from someTable ....");
>  
> 
> to get the results out of the query you would call db_fetch and use it
> like:
> 
> 
> $someResult = db_fetch($someQuery);
> 
> If you needed to return an array you would use it with a while or for
> statement like:
> 
> While ($someResult = db_fetch($someQuery)) {
> 
> }
> 
> If you needed to get the number of rows from the query you'd use like:
> 
> numRows = db_numrows($someQuery);
> 
> or
> 
> if (db_numrows($someQuery) > ...)
> 
> 
> These are just some thing I use to make my life easier.
> 
> Hope it helps
> 

Not to be rude... but what does that have to do with his question?

-- 
Adam Alkins
http://www.rasadam.com



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux