Sorry it's for mysql only...but this merely reflects the current state
of php's database support...especially regarding functions for
retrieving database metadata.
Perhaps it's about time you had another look ;)
Use ADOdb and you have access to a range of engines. Yes
there are some holes, but
In the big scheme of things, I need several functions to be performed by a
web interface / database system. In an attempt to maintain some sense of
order, I'm hoping to divide common data into a seperate MySQL database away
from the function specific data. For example, I need to do project
i asked this same question once and somehwere in the archives is a post by
John Holmes that shows an example of how mysql allows db joins. its from
last month i believe
http://marc.theaimsgroup.com/?l=php-db
but in short, mysql does support this using . db.table.field
hth
Jeff
Anyone heard of this company? I just bought a nice motherboard from these guys for 20
bucks!
http://www.tigersurplus.com
Just wanting to know if anyone else has used them before.
Thanks
BJ
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
IMHO I would be extremely reluctant to open any link sent to this list.
The last time I did so, not only did it connect me to a porno site, it
created a link in my favorites folder, causing me to have a lot of
explaining to do ( as I access this list through my place of employment ).
So,
Thanks, I found the post from John Holmes and was able to reconstruct the
query in mysql. But when I transferred that over to php and try to extract
an associative array from each record, I found that only one column came out
instead of two.
By simply changing the query from:
$query = select
Sorry, I meant referenced in another table not database
On Thu, 2003-09-18 at 16:09, Jonathan Villa wrote:
I have several tables I want to delete as well as their reference in
another database
The query produced is this:
Try putting backticks around the table name in the drop table statement.
Is xxx the database name?
-Micah
On Thu September 18 2003 2:09 pm, Jonathan Villa wrote:
I have several tables I want to delete as well as their reference in
another database
The query produced is this:
You may be able to use mysql_fetch_array() and use numerical indexes to
reference the redundant names, but isn't it easier and better to just assign
aliases like you're doing?
It makes for more readable code, that's for sure.
-Micah
On Thu September 18 2003 12:55 pm, Mike Tallroth wrote: