Re: db connect

Fred, I am more confused now that I know the script works your end. I have the sample_db setup correctly, as I can connect to it if I change the $default_dbname value to hold the sample_db. Whatever I put in the $default_dbname variable I can connect to no trouble. Passing the database as an argument is a different story though, it just won't work! I try all different variations of quotation marks on the db_connect() function, like this. function db_connect($dbname=" ") function db_connect($dbname=' ') and at other end: $link_id = db_connect("sample_db") $link_id = db_connect('sample_db') I wonder if it is the first part of include file: <?php //common_db.inc $dbhost = 'localhost'; $dbusername = 'root'; $dbuserpassword = ''; $default_dbname = 'mysql'; Did the version you used look like this? The one I originally posted was slightly different, but the one above is how mine looks. Thanks for your time. Ian. "Fred" <fred.nospam.please@querymagic.com> wrote in message news:20011130004934.37902.qmail@pb1.pair.com... > 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 <Duxbuz@bbtinternet.com> wrote in message > news:20011129220704.55551.qmail@pb1.pair.com... > > 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. > > > > > > > > > > > > > > > > > > > >