RE: mysql_connect problem

2006-06-28 Thread Ing. Edwin Cruz
http://dev.mysql.com/doc/refman/5.0/en/old-client.html Regards! Edwin. -Mensaje original- De: WSteffen [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 28 de Junio de 2006 10:29 a.m. Para: mysql@lists.mysql.com Asunto: mysql_connect problem I am using the following in a PHP script: b

RE: Baffled by error

2006-05-16 Thread Ing. Edwin Cruz
Is because in your select you have c.accound_id and in your group by clause you have a.accound_id Try this: SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins FROM account a LEFT JOIN calls c ON c.account_id = a.id WHERE c.calldate >= DATE_SUB(NOW(),INTERVAL 14 DAY) AND c.ag

RE: MySQL 5 / phpMyAdmin

2006-05-10 Thread Ing. Edwin Cruz
Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Regards! -Mensaje original- De: Amer Neely [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 10 de Mayo de 2006 12:39 p.m. Para: MySQL List Asunto: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my

RE: Table doesn't exist?

2006-03-27 Thread Ing. Edwin Cruz
Are the permissions corectly to that file??? Chown mysql:mysql /mysql/data/dbname/tablename.* -Mensaje original- De: Sara Woglom [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 27 de Marzo de 2006 01:47 p.m. Para: mysql@lists.mysql.com Asunto: Table doesn't exist? I had to shut down m

RE: OFAC SDN lists

2006-03-22 Thread Ing. Edwin Cruz
rogram a script to build a query like above. I'm using MySQL 5.0.18, php 5.0.5 -----Mensaje original- De: sheeri kritzer [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 22 de Marzo de 2006 08:31 a.m. Para: Ing. Edwin Cruz CC: Mysql Asunto: Re: OFAC SDN lists repost your question, th

RE: Error 1064: update .....select nested.

2006-03-16 Thread Ing. Edwin Cruz
update TABLE1 a, TABLE2 b set a.FIELD1=b.FIELD2 where column2='[EMAIL PROTECTED]' And column1 = '[EMAIL PROTECTED]' Or: update TABLE1 a, TABLE2 b set a.FIELD1=b.FIELD2 where b.column2=a.column1 And column1 = '[EMAIL PROTECTED]' Regards! -Mensaje original- De: Truong Tan Son [mailto:

OFAC SDN lists

2006-03-15 Thread Ing. Edwin Cruz
Hi folks! I'm asking in a web form for clients, those clients I have to search them into OFAC SDN lists( http://www.ustreas.gov/offices/enforcement/ofac/sdn/delimit/index.shtml), if they are into that list they wont be able to do transactions in my system. My problem is to perform a good search of

RE: mysql_commect or die

2006-03-11 Thread Ing. Edwin Cruz
mysql_connect("localhost","root") or die("Unable to connect to MySQL server"); $err = mysql_connect("localhost","root"); if ($err != 0) { Mysql_connect returns a link to a identifier of the conection, also returns 0 when the conection could not be estabished, When you do: $err

RE: FOREIGN KEYS

2006-03-10 Thread Ing. Edwin Cruz
I´ve found this on internet: "If you re-create a table which was dropped, it has to have a definition which conforms to the foreign key constraints referencing it. It must have the right column names and types, and it must have indexes on the referenced keys, as stated above. If these are not satis

RE: How to Log Warnings and Errors from queries

2006-03-10 Thread Ing. Edwin Cruz
There are some scripts that help us to save logs, For example: log4php You write your app and when you're testing it you define a level to save the errors into a file and display them in your app but in production the client doesn't have to see the errors, only the developers, so, in your log4php

RE: php and mysql

2006-03-09 Thread Ing. Edwin Cruz
Also be careful with this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html (after to establish a connection) Edwin. -Mensaje original- De: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 09 de Marzo de 2006 02:17 p.m. Para: Mary Adel CC: [EMAIL PROT