Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Lester Caine
Ethan Rosenberg wrote: I'm probably wrong, but in some contexts; eg, sql query, $ signs are not used. I tried and added the incorrect $ sign, and Netbeans did not complain. If anyone knows of an editor that will able to spot this kind of error, please inform the list. You do need to take a

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Karl DeSaulniers
If your on a PC I would just get Eclipse. But if you have netbeans, you can set the syntax highlighting for the different scripts you write in the preferences. PHP, java, javascript, etc... Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Lester Caine
Karl DeSaulniers wrote: If your on a PC I would just get Eclipse. But if you have netbeans, you can set the syntax highlighting for the different scripts you write in the preferences. PHP, java, javascript, etc... But the problem tha5 has been identified will never be flagged by simple

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Jim Giner
On 8/22/2013 8:08 PM, Ethan Rosenberg wrote: Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com On 08/22/2013 06:56 PM, Jim Giner wrote: On 8/22/2013 4:14 PM, Ethan Rosenberg

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Jim Giner
On 8/23/2013 4:32 AM, Lester Caine wrote: Karl DeSaulniers wrote: If your on a PC I would just get Eclipse. But if you have netbeans, you can set the syntax highlighting for the different scripts you write in the preferences. PHP, java, javascript, etc... But the problem tha5 has been

[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+

[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+

[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/22/2013 9:52 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Vinay Kannan
Jim, I know this is a stupid question to be asking this far into PHP Development, maybe was a bit lazy, or just got too used to Notepad++, which editor for PHP are you using? The feature which you mentioned for a good php editor, sounds exciting, offcourse i would be looking only at the free ones

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Toby Hart Dyke
Notepad++ will do syntax highlighting. Go to Language P PHP with a PHP file open, and see the colours change! It should be automatic - are you using something other than 'php' as a file extension? Toby On 8/22/2013 5:27 PM, Vinay Kannan wrote: Jim, I know this is a stupid question to

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Vinay Kannan
Thanks Toby, Using Notepad ++ with the language selected to PHP, the syntax coloring is on On Thu, Aug 22, 2013 at 11:00 PM, Toby Hart Dyke t...@hartdyke.com wrote: Notepad++ will do syntax highlighting. Go to Language P PHP with a PHP file open, and see the colours change! It should

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Lester Caine
Vinay Kannan wrote: Jim, I know this is a stupid question to be asking this far into PHP Development, maybe was a bit lazy, or just got too used to Notepad++, which editor for PHP are you using? The feature which you mentioned for a good php editor, sounds exciting, offcourse i would be looking

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg, PhD
On 08/22/2013 09:51 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg
On 08/22/2013 11:54 AM, Jim Giner wrote: On 8/22/2013 9:52 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg
Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com On 08/22/2013 06:56 PM, Jim Giner wrote: On 8/22/2013 4:14 PM, Ethan Rosenberg wrote: On 08/22/2013 11:54 AM, Jim Giner wrote:

Re: [PHP-DB] Re: MySQL Query on the Fly

2007-05-13 Thread Steven Cruz
You can the entire thing in Java script with Style sheets. Depends on what he wants to do. iframes could be far simpler. :) itoctopus wrote: You have to use an iframe to do what you want. Once the user select something, you referesh the iframe and you pass specific parameters to it based on

[PHP-DB] Re: MySQL Query on the Fly

2007-05-12 Thread itoctopus
You have to use an iframe to do what you want. Once the user select something, you referesh the iframe and you pass specific parameters to it based on the user's choice. -- itoctopus - http://www.itoctopus.com Todd A. Dorschner [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Good

[PHP-DB] Re: MySQL Query Help

2006-03-23 Thread João Cândido de Souza Neto
Mark Dyer wrote: Hello, I'm unsure how to write the follow query, Please can someone assist. I am writing in short hand the basis of the two queries I would like to combine. The object is to select all the products that have not meet the min sale requirements so I can send myself a

[PHP-DB] Re: MySQL query problems...

2005-03-24 Thread Frank M Flynn
The error message and when I have problems I find it's very helpful to print the actual value of the $query variable. In your case it looks like AND acct_db.key1 LIKE \%\.AllMid_Data.CPU_Hostname is adding AND acct_db.key1 LIKE %.AllMid_Data.CPU_Hostname and you can't join two strings

[PHP-DB] Re: MySQL query, using DISTINCT...

2004-07-07 Thread Rui Cunha
i don't know if someone already gave you a suggestion such as: select distinct mail from ( select mail , filename, count(*) from table having count(*) 1 group by mail,filename ); i presume that you're looking for disctinct mails of users that downloaded the same file more than once. hope

[PHP-DB] Re: MySQL query, using DISTINCT...

2004-07-06 Thread Torsten Roehr
Tristan Pretty [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] com... I have a system that tracks downloads, capturing loadsa info, but of interest here, is email and filename. Simply put, I wanna show all results where file name AND email are unique. (so if email '[EMAIL PROTECTED]'

Re: [PHP-DB] Re: MySQL query, using DISTINCT...

2004-07-06 Thread Tristan . Pretty
I have a system that tracks downloads, capturing loadsa info, but of interest here, is email and filename. Simply put, I wanna show all results where file name AND email are unique. (so if email '[EMAIL PROTECTED]' has filename 'word.doc' 5 times in a table, I want to only see it

Re: [PHP-DB] Re: MySQL query, using DISTINCT...

2004-07-06 Thread zareef ahmed
Hi, using group by can also be usefull. zareef ahmed --- Torsten Roehr [EMAIL PROTECTED] wrote: Tristan Pretty [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] com... I have a system that tracks downloads, capturing loadsa info, but of interest here, is email and filename.

Re[2]: [PHP-DB] Re: MySQL query, using DISTINCT...

2004-07-06 Thread Pablo M. Rivas
Hello Tristan, Select count(id) as howmany, file_name, email from `completed_downloads` where bu='reech' and date BETWEEN '2004-06-01' AND '2004-06-30' group by file_name, email I have a system that tracks downloads, capturing loadsa info, but of interest here, is

[PHP-DB] RE: MySQL query failing on apostrophe in data

2003-08-27 Thread Dillon, John
Seemingly: http://www.php.net/manual/en/function.mysql-escape-string.php -Original Message- From: Dillon, John Sent: 27 August 2003 17:59 To: 'PHP-DB' Subject: MySQL query failing on apostrophe in data How do I avoid the problem in the subject hereto? SELECT query uses variable in

[PHP-DB] Re: MySQL query from multiple tables

2002-07-04 Thread Matthew Crouch
it sounds like you may be serializing your SQL, in which case the following link might help. http://www.ashleyit.com/rs/jsrs/select/php/select.php Matthew Nock wrote: Hi All, I have a strange query which I need to build - I have looked at the JOIN and aliasing functions of mySQL but not

[PHP-DB] Re: MySQL query from multiple tables

2002-06-29 Thread andy
hello Matthew: if I understood your problem right, you have to join the two tables. E.g: SELECT ph.*, pf.prod_ID, pf.feat_ID, pf.feat_value FROM product_head ph, product_features pf WHERE ph.prod_cat_ID = 1 AND ph.prod_cat_ID = pf.prod_cat_ID /*join the two

[PHP-DB] Re: MySQL Query Acting Up

2002-06-20 Thread user
in your SET title=\$title\, statement you forgot the second backslash before the double quote. I would start there. Martin Clifford wrote: Howdy all, If someone call tell me why this MySQL query is not working, I'd be VERY thankful. I don't see a damn thing wrong with it, but I

[PHP-DB] Re: MySQL Query Acting Up

2002-06-20 Thread Seth Yount
in your SET title=\$title\, statement you forgot the second backslash before the double quote. I would start there. Martin Clifford wrote: Howdy all, If someone call tell me why this MySQL query is not working, I'd be VERY thankful. I don't see a damn thing wrong with it, but I

[PHP-DB] Re: MySQL Query Acting Up

2002-06-20 Thread Martin Clifford
Thanks everyone! Between all the replies I was able to locate the problem and fix it! It wasn't the missing backslash (that was a typo, which sucks). I wasn't properly passing the article_id field to the query, so MySQL had a problem with WHERE id=. Thanks again! :o) Martin -- PHP

[PHP-DB] Re: MYSQL query help

2001-12-14 Thread Fred
There are several ways to get around the lack of subselect support in mysql. For your situation you can simply use: SELECT * FROM lib_asset_tbl, lib_copy_tbl WHERE lib_asset_tbl.material_id '' AND lib_asset_tbl.asset_id = lib_copy_tbl.asset_id of course, this will return a row for every