Any database that supports nested queries (unfortunatly this excludes
MySQL) ... you can do
select pic_id from pictures where pic_id not in (select pic_id from
album_pictures)
Otherwise you might have a harder time with MySQL ... something like set
difference if it supports it (I'm not
Have you considered using the console-tool, mysqldump?
You could write a quick script ... say
mysqldump -u adminuser -p adminpass --all-databases backup.sql
tar -zcvf backup.tar.gz backup.sql
mv backup.sql /somepath/backup.sql
if you're on Winders, a batch file:
mysqldump -u adminuser -p
Norma,
I have found the best strategy is to setup an ODBC link to an
alternative to the database. As an example, I had a mysql database
intranet, and I created an ODBC link to, with the MySQL ODBC drivers
(from the mysql.com site), and then opened up Microsoft Access.Went
file = get
I'll bite.First of all, if Netscape / Opera browsers are running,
you can be guarenteed that it is a problem with IE, especially since you
just SP'd it. The URL for the fix you described is located at:
Anybody have code that WORKS (hehe) for executing a MS-SQL stored
proceedure through PHP?
exec viewFacilities()
Thanks in advance!
~Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
= mysql_query($SQL);
may have to prefix with exec like you mentioned...
change sp_runthis to your procedure name... probably still works the
same..
On Wed, 16 Jul 2003, Stephen March wrote:
Anybody have code that WORKS (hehe) for executing a MS-SQL stored
proceedure through PHP?
exec viewFacilities
What I would recommend is using PEAR's HTML_TreeMenu package for this.
http://pear.php.net/package-info.php?package=HTML_TreeMenu
I use it quite a bit in applications .. .download the souce (make sure you
have PEAR configured), and it even comes with an example.
Cheers,
~Steve
quote
Does the ip address of where you are trying to access the mysql database
from (client), change?If you have a dynamic ip address
your ISP should have a grant something to the effect of:
grant all on database.* to [EMAIL PROTECTED] identified by 'password';
This would allow your client to be
If all else fails, split on the .
$url = split(, $_SERVER[REQUEST_URI]);
$args = $url[0];
Cheers,
~Steve
Steve B. wrote:
I have an online tutorial build into a web page.
It has button next step.
If you are on page index.php?abc=123 for instance
the code is smart enough to make it
