Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-04 Thread Adam Lundrigan
Thanks. I'll try that -Adam "Marco Tabini" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Try in the current snapshot at http://snaps.php.net (also, more info on > my blog). > > Cheers, > > > Marco Tabini > http://blogs.phparch.com > > On Fri, 2003-07-04 at 13:01, Adam Lundrigan w

[PHP-DB] Re: OCI_ASSOC returns key with upper case string

2003-07-04 Thread Manuel Lemos
Hello, On 07/04/2003 08:38 PM, Reuben D. Budiardja wrote: First let me say that I am not sure if this is PHP problem or Oracle. I posted this earlier in php-general, but after looking at the available mailing lists again, I thought this forum would be more appropriate. Sorry if someone get doub

[PHP-DB] OCI_ASSOC returns key with upper case string

2003-07-04 Thread Reuben D. Budiardja
Hello, First let me say that I am not sure if this is PHP problem or Oracle. I posted this earlier in php-general, but after looking at the available mailing lists again, I thought this forum would be more appropriate. Sorry if someone get double post. I have a class that contains API for usi

Re: [PHP-DB] Re: A complex query problem

2003-07-04 Thread Micah Stevens
MySQL version 4.x has Subquery support. On Fri July 4 2003 5:54 am, Nadim Attari wrote: > From MS-SQL Server Manual: > A subquery is a SELECT query that returns a single value and is nested > inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another > subquery. A subquery can be use

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-04 Thread Marco Tabini
Try in the current snapshot at http://snaps.php.net (also, more info on my blog). Cheers, Marco Tabini http://blogs.phparch.com On Fri, 2003-07-04 at 13:01, Adam Lundrigan wrote: > that doesn't seem to workit tells me that the libmysql.dll file is not a > PHP module. Where can I track down

[PHP-DB] Re: fatal error with DB.php

2003-07-04 Thread jsWalter
"Pete Morganic" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > edit the php.ini file and change the include paths to being where your > isntallation is ; Thanks Pete for the idea, but I should give you what I had in my INI... That was the first thing I did... include_path =

Re: [PHP-DB] No MySQL Support in PHP5 - Uh oh!

2003-07-04 Thread Adam Lundrigan
that doesn't seem to workit tells me that the libmysql.dll file is not a PHP module. Where can I track down the PHP module for MySQL? Its not in my /extensions directory -Adam "Lester Caine" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Exactly how would one go about insta

[PHP-DB] SELECT question

2003-07-04 Thread Artoo
What is the syntax for running a SELECT command with multiple conditions? Example SELECT * FROM members WHERE user_id='$u_id' AND email='$email'; Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: odbc going nuts

2003-07-04 Thread Pete Morganic
I'd recmmend you use the $_POST vars as this is more secure pete George Pitcher wrote: Pete, Thanks for the tip. I do use $_REQUEST[] and then convert to variables. I moved my code to another machine and it was OK, so I've narrowed it down to a MS upgrade! Obviously tinkered with something. Geo

RE: [PHP-DB] Re: odbc going nuts

2003-07-04 Thread George Pitcher
Pete, Thanks for the tip. I do use $_REQUEST[] and then convert to variables. I moved my code to another machine and it was OK, so I've narrowed it down to a MS upgrade! Obviously tinkered with something. George > -Original Message- > From: Pete Morganic [mailto:[EMAIL PROTECTED] > Sent

[PHP-DB] Re: A complex query problem

2003-07-04 Thread Nadim Attari
>From MS-SQL Server Manual: A subquery is a SELECT query that returns a single value and is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another subquery. A subquery can be used anywhere an expression is allowed. Unfortunately you do not have Sub-queries in mySQL ... Try

[PHP-DB] Re: odbc going nuts

2003-07-04 Thread Pete Morganic
Are registed globals off, otherwise u name to change $username to $_POST['username'] > Any suggestions (apart from dropping Access in favour of another db - client choice) Oh dear.. Access is a real pain in the butt and we now NEVER deal with a client that selects Access. Never had any complai

[PHP-DB] mail()

2003-07-04 Thread Phil Dowson
Hi, Could someone let me know if it is possible to pass a resultset of a query to a single variable so it can be included as the message part of the mail function? Thanks! Phil Dowson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: fatal error with DB.php

2003-07-04 Thread Pete Morganic
edit the php.ini file and chenge the include paths to being where your isntallation is ; Jswalter wrote: I am trying to use DB.php, but I am getting htis error... Fatal error: main(): Failed opening required 'DB.php' (include_path='.;c:\php4\pear') I can't find this path defined *anywhere* I do

SV: [PHP-DB] Re: A complex query problem

2003-07-04 Thread Henrik Hornemann
Hi, You could try something like: SELECT school_name, sID FROM schools WHERE sID in (select sid from school_highlight_details where hid = 2) and sID in (select sid from school_highlight_details where hid = 4) GROUP BY sID If you a

Re: [PHP-DB] hmmm

2003-07-04 Thread Leif K-Brooks
Becoming Digital wrote: We have found the only case when banning someone from the list for foul language would be completely undesirable. Making it so he really can't unsubscribe, on the other hand, would be very desirable. Are you listening, admins? :-) -- The above message is encrypted wit

Re: [PHP-DB] hmmm

2003-07-04 Thread Becoming Digital
We have found the only case when banning someone from the list for foul language would be completely undesirable. Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU - Original Message - From: <[EMAIL

RE: [PHP-DB] Backing up entire database...

2003-07-04 Thread Ben Lake
http://www.mysql.com/doc/en/mysqldump.html www.mysql.com -> Documentation -> search = answers Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2003 4:02 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Backing up entire database... I wanna back

[PHP-DB] Backing up entire database...

2003-07-04 Thread Tristan . Pretty
I wanna back up my MySQL database in preperation for this: == http://www.securityfocus.com/news/6219 http://www.counterpane.com/alert-t20030702-001.html http://news.ists.dartmouth.edu/todaysnews.html#internal10656 SANS (http://isc.incidents.org/) says on site http://isc.sans.org/d

[PHP-DB] odbc going nuts

2003-07-04 Thread George Pitcher
Hi all, Just finishing off a site using odbc and Access and it's thrown up a problem that wasn't there yesterday. I have a simple login with a username and password. If either are blank, the user gets bumped to the login page. otherwise the user table is searched for the username and password. m

RE: [PHP-DB] Any one can help me dump XML into MySQL??

2003-07-04 Thread Boaz Yahav
This may be a start Extracting CDATA values from an XML feed / file. http://www.weberdev.com/get_example.php3?count=3692 Sincerely berber Visit http://www.weberdev.com/ Today!!! To see where PHP might take you tomorrow. -Original Message- From: Nabil [mailto:[EMAIL PROTECTED] Sent: Th