Re: db connect

Fred, sample_db 'is' my database name, so this should work? Well it keeps choosing my $default_db value. Can you try my code and tell me if it works for you please? Thankyou. "Fred" <fred.nospam.please@querymagic.com> wrote in message news:20011129184157.1385.qmail@pb1.pair.com... > How are you passing the name of the database? Are you replacing 'sample_db' > in the line: > $link_id = db_connect('sample_db'); > in show_more_db.php? > > If so, then I do not see where there would be a problem. > > Fred > > Ian <Duxbuz@bbtinternet.com> wrote in message > news:20011129115833.22923.qmail@pb1.pair.com... > > Hello, > > > > Wonder if anyone can help me out. > > > > I am trying to run an example out of a book Beginning Php by wrox. > > > > One of the examples is supposed to allow me to connect to a database by > > using a function that takes a database as an argument. It has an include > > file that contains the function. > > > > Problem I get is that the argument never seems to get passed and the > > function always uses the default value. > > > > I would greatly appreciate if someone could tell me why this happens. I > > would also appreciate if no one rewrites a completely different script, as > I > > am after debugging this one. ;-) > > > > Here is the include file: > > > > <?php > > file://common_db.inc > > $dbhost = 'localhost'; > > $dbusername = 'phpuser'; > > $dbuserpassword = 'phppass'; > > $default_dbname = 'mysql'; > > > > $MYSQL_ERRNO = ''; > > $MYSQL_ERROR = ''; > > > > function db_connect($dbname=' ') { > > global $dbhost, $dbusername, $dbuserpassword, $default_dbname; > > global $MYSQL_ERRNO, $MYSQL_ERROR; > > > > $link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword); > > if(!$link_id) { > > $MYSQL_ERRNO = 0; > > $MYSQL_ERROR = "Connection failed to the host $dbhost."; > > return 0; > > } > > else if(empty($dbname) && !mysql_select_db($default_dbname)) { > > $MYSQL_ERRNO = mysql_errno(); > > $MYSQL_ERROR = mysql_error(); > > return 0; > > } > > else if(!empty($dbname) && !mysql_select_db($dbname)) { > > $MYSQL_ERRNO = mysql_errno(); > > $MYSQL_ERROR = mysql_error(); > > return 0; > > } > > else return $link_id; > > } > > > > function sql_error() { > > global $MYSQL_ERRNO, $MYSQL_ERROR; > > > > if(empty($MYSQL_ERROR)) { > > $MYSQL_ERRNO = mysql_errno(); > > $MYSQL_ERROR = mysql_error(); > > } > > return "$MYSQL_ERRNO: $MYSQL_ERROR"; > > } > > ?> > > > > And here is the php script that uses this include file: > > > > > > <?php > > file://show_more_db.php > > include "./common_db.inc"; > > > > $link_id = db_connect('sample_db'); > > $result = mysql_query("SELECT * FROM user", $link_id); > > > > while($query_data = mysql_fetch_row($result)) { > > ?> > > <?php > > echo "'",$query_data[1],"' is also php ' known as ",$query_data[3],"<P>"; > > } > > ?> > > > > > > I hope someone can help me out please. > > > > Thankyou. > > > > > >