I'm not sure what that script is supposed to accomplish, it seems a bit
obfuscated and useless to me, nevertheless it correctly used the supplied
database rather than the default one when I tested it.  You may want to make
sure that your sample_db actually exists.

Fred

Ian <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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 <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > 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.
> > >
> > >
> >
> >
>
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to