Re: Don't know why query works this way

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

 



In article <200308052335.52388.cortesm@fortleboeuf.net>, 
cortesm@fortleboeuf.net says...
> I have been writing my queries like this.......
> 
> $link = mysql_connect ($host, $username, $password);
> $query = "insert into $table ('joe', 15)";
> if ( mysql_db_query($dbname, $query, $link))		{	}
> 
> But then I was reading that I should use mysl_query instead of mysql_db_query.  
> But I was having a problem with where do i put the $dbname.
> 
> When I used:
> 
> mysql_query ($dbname, $query, $link)
> 
> I got an error message saying i had too many arguments.  So I changed it to:
> 
> mysql_query ($query, $link)
> 
> I then got an error message saying it didn't know what database I was 
> connected to.  I finally got around the problem by including the database 
> name in the query, like so:
> 
> $query = "insert into $dbname.$table ('joe', 15)";
> 
> I shouldn't have to say, but this is a simplified example.  I didn't want to 
> include all the fields, tables, values that the true example has.  The 
> question is, am I doing this right?  Do I have no choice but to retype the 
> $dbname all over the place if I want to use "mysql_query"?
> 
> Thank in advance for any help.

Well, no. You need to do mysql_select_db to select a database up front and 
if you happen to need to change databases, use it again. So something like

$dbname = 'whatever';
$link = mysql_connect ($host, $username, $password);
mysql_select_db($dbname);
$query = "insert into $table ('joe', 15)";
if ( mysql_db_query($dbname, $query, $link))		{	}

etc etc
-- 
Quod subigo farinam

$email =~ s/oz$/au/o;
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?

-- 
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