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