[PHP-DB] Re: [PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
m.AUCCIIM_ID = my.member_id where now() < DATE_ADD(DATE_SUB(concat(member_year + 1,'-07-01'), INTERVAL 1 DAY), INTERVAL 30 DAY) AND m.Preferred_First_Name LIKE 'Don%' group by m.AUCCIIM_ID order by m.preferred_last_name Don

[PHP-DB] Re: [PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
On Nov 27, 2010, at 10:08 AM, Daniel P. Brown wrote: one primary question: are you using the mysql_* family, mysqli_* family, or another method of interfacing with MySQL? mysql_ $results = mysql_query($query) or die(mysql_error()); Don -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] RE: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

2010-03-07 Thread Venkat Raman Don
y get impacted. So this means that this is not a problem with Windows OS or for that reason any other OS. Hope this explain things. Thanks, Don. -Original Message- From: Gunawan Wibisono [mailto:[email protected]] Sent: Sunday, March 07, 2010 7:37 AM To: [email protected]; p

Re: [PHP-DB] Changing part of a query before displaying it

2009-07-15 Thread Don Collier
' ' . $row['fourth_column'] . ' ' . $row['fifth_column'] . ' ' . $row['sixth_column'] . ' '; } Thanks patrick On Wed, Jul 15, 2009 at 1:10 PM, Don Collier <mailto:d...@colliercl

[PHP-DB] Changing part of a query before displaying it

2009-07-15 Thread Don Collier
olumn that I want to change is the 3rd one. How do I go about doing this? Don Collier -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Database join on varchar(32) Vs. bigint

2003-10-20 Thread Don Myers
s there a noticable difference between using BIGINT Vs. varchar(32) in doing all of those joins? Or because of the index it's not really a big difference (or no difference at all?) Don Myers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Need help with a OpenLink ODBC driver error again

2003-10-06 Thread Don Myers
conn) or die("".odbc_errormsg()); odbc_result_all($results) or die("pulling result error"); echo "closing connection $conn"; odbc_close($conn); odbc_close_all(); ?> Don Myers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Getting ODBC openlink 37000 in odbc_do($conn,"$sql") but odbc_tables($conn) works? Help!

2003-10-02 Thread Don Myers
I am using iodbc from openlink on OS X and everything seems fine and I can get the database tables with $results = odbc_tables($conn) or die("".odbc_errormsg()); And print them to the screen with odbc_result_all($results) or die("printing result error"); But when I try $sql="select * form tblJ

[PHP-DB] Recordsets and associative arrays

2003-02-17 Thread Don Briggs
x27;t be putting all of the record fields into the table. So we can't just make an array of the associative arrays returned by mysql_fetcharray($result). Hope you can help me out. Don! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] HELP!! Warning: mysql_pconnect:

2002-12-12 Thread Don Briggs
I would greatly appreciate any help that anyone could offer. I just can't figure out why we sometimes have trouble connecting, especially with the load on two large servers being so tiny. Don! Briggs [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] ODBC connection problem

2001-09-10 Thread Don Jackson
there a work around for this or a fix? I need to give internet access for this older internal database at the same time local users are accessing it. thanks in advance don -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mai

[PHP-DB] problem with dbase connections using ODBC

2001-09-07 Thread Don Jackson
d to give internet access for this older internal database at the same time local users are accessing it. I've tried using ASP and PWS and it works but I really want to use PHP ;> thanks in advance don -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Don Read
nsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTE

[PHP-DB] RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Don Read
t; table is read only" and it stops... > can you drop or create tables ? If not then your sql daemon permissions are messed up. stop the daemon, chown -R mysql.mysql /path/to/mysql/data, restart the daemon. Regards, -- Don Read [EMAIL PROTECTED] --

[PHP-DB] MySQL execution order...

2001-02-22 Thread Don Johnson
00:00:00') ------ Any ideas why the rows are getting the DownloadedDateTime field updated before they get SELECTed? Thanks, Don Johnson [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] PHP security

2001-02-20 Thread Don
I am writing aome PHP scripts to connect to a MySQL database. In order to connect, I have found the following documented code: $dbLink = mysql_connect("localhost", "my_user", "my_password") Here, the password is plain text. This does not seem very secure to me. What is to prevent someone usin

[PHP-DB] Best Way

2001-02-17 Thread Don Smith
first name, or just the first and last, or just the company or just the last name and the company.. and, oh well, you get the idea. Am I stuck with an awful lot of IF statements or is there a smarter way of handling this? The site is CameraCrews.com. Select "-by Name" to see the input p