Re: [PHP-DB] Query does not work

2014-07-02 Thread Jim Giner
Once again you have provided the group with RANDOM pieces of code, completely out of context since you have already shown me that your query and db connection are being used in a function, hence your loss of $cxn. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http:/

Re: [PHP-DB] Query does not work

2014-07-02 Thread Lester Caine
On 02/07/14 04:43, Ethan Rosenberg, PhD wrote: > while ($row31 = mysqli_fetch_row($result31)) { > printf ("%s %s %s %s %s\n", $row31[0], $row31[1], $row31[2], $row31[3]); Try print_r( $row31 ); > } // no output > > How can I loose a db connection in the middle of a program? This is not sho

Re: [PHP-DB] Query does not work

2014-07-01 Thread Ethan Rosenberg, PhD
Dear List - I think I've lost the database connection. I put in the following code: $sql31= "select Lname, Fname, Phone, Cust_Num from Customers order by Lname"; echo $sql31; //echos correctly $result31 = mysqli_query($cxn,$sql31); var_dump($result31); // result n

Re: [PHP-DB] Query will not work - SOLVED

2013-02-02 Thread tamouse mailing lists
On Sat, Feb 2, 2013 at 8:08 PM, Ethan Rosenberg, PhD wrote: > I must be missing something fundamental!! Yes. > I was using the "worker@localhost", which did not have the Update privilege. > Added the privilege that, and everything worked. Please explain why you are not checking error returns f

Re: [PHP-DB] Query will not work - SOLVED

2013-02-02 Thread Karl DeSaulniers
$sql13 = "UPDATE `Customers` SET `Lname` = 'Barnet', `City` = 'Lakewood', `State` = 'NJ' WHERE `Cust_Num` = 1089"; $result13 = mysqli_query($cxn, $sql13); if(mysqli_num_rows($result13)> 0) { $row_cnt = mysqli_num_rows($result13); echo "row count result13 is $row_cnt"; } else { echo "Ouc

Re: [PHP-DB] Query Question

2011-05-23 Thread maarten
That's a very good point, but since I use postgres that's one point that doesn't affect me and as such didn't cross my mind at the time. (Postgres uses schemas where mysql uses databases, a different database on postgres usually means a different database machine. And joining tables from differe

Re: [PHP-DB] Query Question

2011-05-23 Thread maarten
I would keep the db names and/or schema names in your queries. It clarifies what you are doing with the query making it easier for someone else to debug, improve, ... Certainly for those not familiar with your db structure. I am not aware of any drawbacks that can result from this. (Ok, maybe y

RE: [PHP-DB] Query syntax error?

2011-01-13 Thread Harvey
Thanks, I got it working now, had to use the a/b/c thing a few times -Original Message- From: jose [mailto:jojap...@gmail.com] Sent: Thursday, January 13, 2011 9:52 AM Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Query syntax error? you have renamed places_data table to 'a

Re: [PHP-DB] Query syntax error?

2011-01-13 Thread jose
you have renamed places_data table to 'a' 2011/1/13 Harvey : > Hello, > > I have a query on a page that used to work fine, but is now generating an > error. > > I assume that the version of php or mysql was updated on the webhost server > or something like that? > > Here is the query: > > select c

RE: [PHP-DB] query help

2010-11-17 Thread Ashay Chaudhary
The most performant methods are to use well parameterized stored procedure or a prepared parameterized statement. : Ashay -Original Message- From: Niel Archer [mailto:n...@chance.now] Sent: Wednesday, November 17, 2010 6:30 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] query help

RE: [PHP-DB] query help

2010-11-17 Thread Constantin Brinzoi
rom: Artur Ejsmont [mailto:ejsmont.ar...@gmail.com] Sent: 17 noiembrie 2010 16:07 To: Vinay Kannan Cc: PHP DB; php mysql Subject: Re: [PHP-DB] query help well i guess you could do that. but it gets complicated after a while and there will be a lot of work and probably after a while you will get

Re: [PHP-DB] query help

2010-11-17 Thread Niel Archer
> Hello PHP Gurus, > > I need your help on an insert query. > > I wanted to know if there is way to insert an array of values into a DB. An > eg would explain this better : > > If I have 2 tables in a DB, 1) users has 3 columns 2) hobbies = 5 columns > > I was thinking of having a single functi

Re: [PHP-DB] query help

2010-11-17 Thread Max E.K
From: "Vinay Kannan" To: "PHP DB" , "php mysql" Sent: Wednesday, November 17, 2010 2:51:35 PM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: [PHP-DB] query help Hello PHP Gurus, I need your help on an insert query. I wanted to know if there is way to insert an arra

Re: [PHP-DB] query help

2010-11-17 Thread Bastien Koert
On Wed, Nov 17, 2010 at 8:51 AM, Vinay Kannan wrote: > Hello PHP Gurus, > > I need your help on an insert query. > > I wanted to know if there is way to insert an array of values into a DB. An > eg would explain this better : > > If I have 2 tables in a DB, 1) users has 3 columns 2) hobbies = 5 co

Re: [PHP-DB] query help

2010-11-17 Thread Artur Ejsmont
well i guess you could do that. but it gets complicated after a while and there will be a lot of work and probably after a while you will get into some problems. You have to handle escaping, special types etc. Then what about performance? how to query the data ... using similar approach or is

Re: [PHP-DB] Query for duplicate records

2010-10-17 Thread Chris
On 18/10/10 06:55, Ron Piggott wrote: Is there a query you could help me write a SELECT query that would search table `ministry_profiles` for where column `organization` has the same organization more than once? I am trying to delete the duplicate organization records, but I am working with

Re: [PHP-DB] Query stopping after 2 records?

2009-04-27 Thread Chris
Hawx wrote: On Mon, 27 Apr 2009 07:19:23 -0700, "Miller, Terion" wrote: I need help/advice figuring out why my query dies after 2 records. Here is the query: // Build your INSERT statement here $query = "INSERT into `warrants` (wid, name, age, warrant, bond, wnumber, cr

Re: [PHP-DB] Query stopping after 2 records?

2009-04-27 Thread Hawx
On Mon, 27 Apr 2009 07:19:23 -0700, "Miller, Terion" wrote: > I need help/advice figuring out why my query dies after 2 records. Here is > the query: > > // Build your INSERT statement here > > > $query = "INSERT into `warrants` (wid, name, age, warrant, bond, wnumber, > crime

Re: [PHP-DB] Query stopping after 2 records?

2009-04-27 Thread Bastien Koert
On Mon, Apr 27, 2009 at 10:19 AM, Miller, Terion < tmil...@springfi.gannett.com> wrote: > I need help/advice figuring out why my query dies after 2 records. Here is > the query: > > // Build your INSERT statement here > > > $query = "INSERT into `warrants` (wid, name, age, warrant, bond,

Re: [PHP-DB] query optimization

2008-09-28 Thread Chris
Yves Sucaet wrote: Hi Jack, I'm expecting less than 10 records in the resulting set. The BlockUnit table contains 337,253 records; the InteractionParts table contains 279,953 records. It takes currently 8.3 seconds to execute the query as I have it. Erh, this is embarassing but I'm going to n

Re: [PHP-DB] query optimization - DB

2008-09-26 Thread Glen Synergy
a MySQL database. > > > > - Original Message - From: "Micah Gersten" <[EMAIL PROTECTED]> > > To: "YVES SUCAET" <[EMAIL PROTECTED]> > > Cc: > > Sent: Thursday, September 25, 2008 7:55 PM > > Subject: Re: [PHP-DB] query

Re: [PHP-DB] query optimization - DB

2008-09-26 Thread Yves Sucaet
ces. Can you help out rewriting the query using EXISTS syntax? Thanks in advance, Yves - Original Message - From: "Micah Gersten" <[EMAIL PROTECTED]> To: Sent: Friday, September 26, 2008 11:47 AM Subject: Re: [PHP-DB] query optimization - DB MySQL queries use 1 in

Re: [PHP-DB] query optimization - DB

2008-09-26 Thread Micah Gersten
database. > > - Original Message - From: "Micah Gersten" <[EMAIL PROTECTED]> > To: "YVES SUCAET" <[EMAIL PROTECTED]> > Cc: > Sent: Thursday, September 25, 2008 7:55 PM > Subject: Re: [PHP-DB] query optimization > > >> Other question is, what

Re: [PHP-DB] query optimization - DB

2008-09-26 Thread Yves Sucaet
Oh, sorry I forgot to mention this. It's a MySQL database. - Original Message - From: "Micah Gersten" <[EMAIL PROTECTED]> To: "YVES SUCAET" <[EMAIL PROTECTED]> Cc: Sent: Thursday, September 25, 2008 7:55 PM Subject: Re: [PHP-DB] query optimization

Re: [PHP-DB] query optimization

2008-09-26 Thread Yves Sucaet
me help re-writing it with EXISTS... Thanks for the help so far, Yves - Original Message - From: Jack van Zanen To: Chris Cc: YVES SUCAET ; php-db@lists.php.net Sent: Thursday, September 25, 2008 7:49 PM Subject: Re: [PHP-DB] query optimization If you can answer the other

Re: [PHP-DB] query optimization

2008-09-25 Thread Micah Gersten
Other question is, what DB is this for? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com YVES SUCAET wrote: > How could I rewrite the following query so it runs faster: > > select distinct location from blockunit where blockid in ( > select bu.blockid from b

Re: [PHP-DB] query optimization

2008-09-25 Thread Jack van Zanen
If you can answer the other questions that would help as well you can try rewriting using "exist" instead of "in" But without the basic information like number of records expected and explain plan it is very hard to come up with a better solution. Brgds Jack 2008/9/26 Chris <[EMAIL PROTECTED

Re: [PHP-DB] query optimization

2008-09-25 Thread Chris
Jack van Zanen wrote: Hi If I am not mistaken, the second part of the union contains all rows that are in the first part of the union. just remove the first part. Kind of. The first part is a join, the second isn't. I was going to suggest rewriting the subquery into a single: where ip.block

Re: [PHP-DB] query optimization

2008-09-25 Thread Jack van Zanen
Hi If I am not mistaken, the second part of the union contains all rows that are in the first part of the union. just remove the first part. Also What is the table sizes of the tables? How many records are expected to come back from the union sub query? How many records are expected to come

Re: [PHP-DB] query optimization

2008-09-25 Thread Chris
Micah Gersten wrote: What indices do you have? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com YVES SUCAET wrote: How could I rewrite the following query so it runs faster: select distinct location from blockunit where blockid in ( select bu.blockid fro

Re: [PHP-DB] query optimization

2008-09-25 Thread Micah Gersten
What indices do you have? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com YVES SUCAET wrote: > How could I rewrite the following query so it runs faster: > > select distinct location from blockunit where blockid in ( > select bu.blockid from blockunit bu in

Re: [PHP-DB] Query

2008-04-30 Thread Ron Piggott
You just drew my attention my Ron Piggott wrote: > > I have an interesting question. > > > > When I run the following query through my PHP script it produces 1 > > result. I know this because I echo the value of $num to the screen from > > the following syntax: $num=mysql_numrows($result); > >

Re: [PHP-DB] Query

2008-04-30 Thread Chris
Ron Piggott wrote: > I have an interesting question. > > When I run the following query through my PHP script it produces 1 > result. I know this because I echo the value of $num to the screen from > the following syntax: $num=mysql_numrows($result); > > When I do the query in the "SQL" tab of p

Re: [PHP-DB] Query Criteria

2008-04-28 Thread YVES SUCAET
An easier way would be to use the built-in MySQL functions directly. That way, you avoid issues with date-format conversions between PHP and MySQL. Look at: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html You code then becomes: switch ($type) { case "today": $sql = "... where

Re: [PHP-DB] Query Across DBMS Boundaries (Linked Database Servers?)

2008-03-24 Thread Chris
Dee Ayy wrote: Is there something which can perform a query across different database systems? It would extend the database.table.field notation to maybe dbms.database.table.field and allow queries across MySQL and MSSQL I don't think so. Both mysql and mssql would need to know how to parse t

Re: [PHP-DB] Query table / results to an array

2008-02-29 Thread Daniel Brown
On Fri, Feb 29, 2008 at 12:22 AM, Ron Piggott <[EMAIL PROTECTED]> wrote: > $reference_number = mysql_result($search_result,$i,"reference_number"); > $description = mysql_result($search_result,$i,"description"); Just mind the line-wrapping in this message. ;-P -- Daniel P. Brown Senior

Re: [PHP-DB] Query table / results to an array

2008-02-28 Thread Chris
Ron Piggott wrote: This line of code while ($row = mysql_fetch_assoc($result)) { Gave me this error message: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource I ran select reference, description from table in mySQL and it worked --- Any idea what caused

Re: [PHP-DB] Query table / results to an array

2008-02-28 Thread Chris
Ron Piggott wrote: I need help populating an array based on the output of a mysql query. $reference_number is a value assigned by auto_increment $description is what I want the value of the array to be --- a few words in length $reference_number = mysql_result($search_result,$i,"reference_numb

RE: [PHP-DB] Query executing

2007-10-05 Thread Hutchins, Richard
The mysql_affected_rows() function will tell you how many rows were affected by the DELETE query you just fired. You can also test for TRUE or FALSE on the mysql_query() function if you just want to know if the query was successful or not. Rich -Original Message- From: ron.php [mailto:[E

Re: [PHP-DB] Query syntax

2007-09-15 Thread TG
SELECT * FROM table WHERE listing_type LIKE '%$listing_type%' AND (listing_approved = '1' OR listing_approved = '2') ORDER BY name ASC (notice the parentheses around the OR part of the clause) or you can do this... SELECT * FROM table WHERE listing_type LIKE '%$listing_type%' AND listing_approv

Re: [PHP-DB] Query syntax

2007-09-15 Thread Niel Archer
If I understood you correctly (and I'm not sure I did), this should do it $query="SELECT * FROM table WHERE listing_type LIKE '%$listing_type%' AND listing_approved IN( '1' ,'2') ORDER BY name ASC"; -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http:

Re: [PHP-DB] Query select value on MAX Date

2006-02-25 Thread Neil Smith [MVP, Digital media]
At 08:47 25/02/2006, you wrote: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_=_NextPart_001_01C63997.1A6B1B7D" Date: Sat, 25 Feb 2006 08:07:36 +0900 Message-ID: <[EMAIL PROTECTED]> From: <[EMAIL PROTECTED]> To: <'php-db@lists.php.net'> Subject: FW: [PHP-DB] Query

RE: [PHP-DB] Query select value on MAX Date

2006-02-24 Thread Nur_Adman
Dear All, I have table like this : Id | Category | Date| Value 1 | A | 2005-02-21 | 2000 2 | A | 2004-01-21 | 3000 3 | B | 2006-01-2

RE: [PHP-DB] Query that generates href links

2005-03-20 Thread Juffermans, Jos
Hi, Please send the code that you used with the hrefs so we can see where the error occurs. Tell us what line the error occured (and what line in your copied code that is). Jos -Original Message- From: John Burroughs [mailto:[EMAIL PROTECTED] Sent: 21 March 2005 03:29 To: php-db@lists.ph

Re: [PHP-DB] Query that generates href links

2005-03-20 Thread Evert | Rooftop Solutions
John Burroughs wrote: Hi everyone, I've created a database for my poetry that I've written. I have a table called Titles. It is made up of: [snip] How can I do this. Everytime I tried adding to the above code, I kept getting error messages in php saying that there was an unexpected '>'character

Re: [PHP-DB] Query was empty - Strange problem

2005-03-16 Thread Stephen Johnson
I do not see where you are populating $Query --> therefore your query would be empty -- On Mar 16, 2005, at 10:30 PM, Vinayakam Murugan wrote: Hi I have an application in which i am connecting to three different databases. I have three connect and query procedure. I am facing problems with one

Re: [PHP-DB] Query was empty - Strange problem

2005-03-16 Thread Vinayakam Murugan
Here is the entire function function Executequery($Query) { global $Error, $Hostname,$Loginname,$Passwd,$Dbname,$Conn; $Conn = mysql_pconnect($Hostname,$Loginname,$Passwd); $Re

Re: [PHP-DB] Query was empty - Strange problem

2005-03-16 Thread Vinayakam Murugan
This is a common procedure. $Query is being passed to it. As I had said before, i had tried echoing $Query before and after the mysql_query statement and it displays a proper query. That's what driving me nuts! :-( On Wed, 16 Mar 2005 22:36:13 -0800, Stephen Johnson <[EMAIL PROTECTED]> wrote: > I

Re: [PHP-DB] query is not executing data is not entering in created database

2004-12-26 Thread John Holmes
amol patil wrote: hallo, see below code. query is not executing and data is not shown in table of database.after submit button hit. how to evaluate $submit true. have Tried these statements before if statement echo "--$submit--"; echo "--$_POST["submit"]--"; echo"Submit = $submit "; but

Re: [PHP-DB] query is not executing data is not entering in created database

2004-12-26 Thread amol patil
hallo, see below code. query is not executing and data is not shown in table of database.after submit button hit. how to evaluate $submit true. have Tried these statements before if statement echo "--$submit--"; echo "--$_POST["submit"]--"; echo"Submit = $submit "; but still query is

RE: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain

2004-11-11 Thread Chip Wiegand
"Gryffyn, Trevor" <[EMAIL PROTECTED]> wrote on 11/11/2004 01:39:37 PM: > This is a common join issue. If you don't specify ANYTHING to connect > between the two tables, it'll do one row from the first table, then ALL > the rows from the second. Row #2 from the first, then ALL the rows from > th

RE: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain

2004-11-11 Thread Norland, Martin
-Original Message- From: Chip Wiegand [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 3:28 PM To: PHP DB Subject: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain I have two tables I want to get out the rows that are different between t

RE: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain

2004-11-11 Thread Gryffyn, Trevor
This is a common join issue. If you don't specify ANYTHING to connect between the two tables, it'll do one row from the first table, then ALL the rows from the second. Row #2 from the first, then ALL the rows from the second. If you had 600 rows in each table, you'd end up with 360,000 rows as a

Re: [PHP-DB] Query returns duplicate rows

2004-07-21 Thread Justin Patrin
hen all selected scores, then loop through them individually. Doing a join without an ON clause is IMHO not a good choice. > > -Original Message- > From: Justin Patrin > To: Brock Jimmy D Contr 74 MDSS/SGSI > Cc: [EMAIL PROTECTED] > Sent: 7/21/2004 5:02 PM > Subject: Re: [PH

RE: [PHP-DB] Query returns duplicate rows

2004-07-21 Thread Brock Jimmy D Contr 74 MDSS/SGSI
e the criteria for that particular element. Thanks for the help though. -Original Message- From: Justin Patrin To: Brock Jimmy D Contr 74 MDSS/SGSI Cc: [EMAIL PROTECTED] Sent: 7/21/2004 5:02 PM Subject: Re: [PHP-DB] Query returns duplicate rows On Wed, 21 Jul 2004 16:29:37 -0400, Brock Ji

Re: [PHP-DB] Query returns duplicate rows

2004-07-21 Thread Justin Patrin
On Wed, 21 Jul 2004 16:29:37 -0400, Brock Jimmy D Contr 74 MDSS/SGSI <[EMAIL PROTECTED]> wrote: > My query is returning duplicates rows. > > table: elements > elementId > standardId > elementtext > category > mcode > linenum > > table: scores > scoreId > taskId > scores > > Here's my query: > SE

Re: [PHP-DB] Query for Most Recent Entry

2004-07-02 Thread John W. Holmes
Thompson, Jimi wrote: I'm trying to figure out how to write a MySQL query that will return the highest primary key a table. 1) Why? 2) SELECT MAX(id) FROM table 3) If you're trying to find the key of the last row inserted to an auto_increment column, use mysql_insert_id() or LAST_INSERT_ID() in

Re: [PHP-DB] query repeating results???

2004-03-26 Thread Brent Baisley
Try left joining your states table also. MySQL may be joining the property_photos and the states table first, which would screw up your left join. Haven't had my morning coffee yet so I can't say for sure. Put EXPLAIN in front of your query to see what MySQL is doing. SELECT ... FROM pr

RE: [PHP-DB] Query to Array to Echo Problem--Thank you

2004-02-25 Thread Karen Resplendo
Yes! That worked! (It was returning the same field values not column names, my mistake). Now it returns what it should return. Onwards to the next snafu! Thanks! "Ryan Jameson (USA)" <[EMAIL PROTECTED]> wrote: One thing may be that you need to do a fetch to increment the result row odbc_fetch_

RE: [PHP-DB] Query to Array to Echo Problem

2004-02-24 Thread Ryan Jameson (USA)
One thing may be that you need to do a fetch to increment the result row odbc_fetch_row($result);. Though that doesn't explain your column names being in the array unless that's what's in the table. <>< Ryan -Original Message- From: Karen Resplendo [mailto:[EMAIL PROTECTED] Sent: Tuesda

[PHP-DB] Re: php-db Query

2004-02-24 Thread Frank Flynn
Peppe Don't search by month at all - use a start and stop date then order by date. Now you have one result set with all the dates in it and you can use your PHP code to figure out where to close one table and open a net one: $result = mysql_query($sql); echo ""; $thisMonth = $result[3]; //

Re: [PHP-DB] Query Sum problem

2003-12-16 Thread CPT John W. Holmes
From: "Larry Sandwick" <[EMAIL PROTECTED]> > I appreciate the quick response, but I should have been more clear. > > I understand the query below, but I would only have 2 total and it is > not group by the companies. > > The query below gives me the main information without totals. > > How do I ad

Re: [PHP-DB] Query Sum problem

2003-12-16 Thread CPT John W. Holmes
From: "Larry Sandwick" <[EMAIL PROTECTED]> > I need to sum the field *COST* in this query where data in *STATUS* is > equal to "HELD" and "OPEN", so I will have 2 totals passed below and do > not know where to begin . SELECT status, SUM(cost) FROM Table WHERE status IN ('HELD','OPEN') GROUP BY sta

Re: [PHP-DB] Query Case In-sensitive

2003-11-19 Thread mustafa ocak
19, 2003 2:36 PM Subject: Re: [PHP-DB] Query Case In-sensitive As an Oracle DBA (9+ years, versions 7.x - 9.x) I just wanted to make a correction. The LIKE command uses wild card characters ( _ and % ) for substitutions. Oracle IS a case-sensitive RDBMS and the LIKE command will NOT do

Re: [PHP-DB] Query Case In-sensitive

2003-11-19 Thread roy.a.jones
7:11 To [EMAIL PROTECTED] cc Subject Re: [PHP-DB] Query Case In-sensitive Use "LIKE" clause instead of "=" SELECT item_number FROM item WHERE item_code LIKE 'M1234' ; This will perform case-insensitive matching on all databases I used before (Including Oracle,

Re: [PHP-DB] Query Case In-sensitive

2003-11-19 Thread mustafa ocak
ki" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 18, 2003 5:46 AM Subject: Re: [PHP-DB] Query Case In-sensitive > Generally in DBs, data is case sensitive. > > Simply you can do an uppercase or lowercase conversion in both

Re: [PHP-DB] Query Case In-sensitive

2003-11-18 Thread Andrei Migatchev
you can convert both of the sides to one case, similar to this: select item_number from item where upper (item_code) = upper ("M1234"); this way you ensure that both the value in the database and the selection variable are in one and the same case: capital. this should work in just about every

Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread ramki
Generally in DBs, data is case sensitive. Simply you can do an uppercase or lowercase conversion in both sides. Ex : Select item number from item where upper(item_code) = upper("m1234"); -ramki - Original Message - From: "Larry Sandwick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent

Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread Pedro Pais
Hey! At least in Postgresql you can do something like: SELECT * FROM table where item_code ILIKE 'blabla'; But I guess it's standard, so you can use it in any DB. Larry Sandwick wrote: Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data b

Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread CPT John W. Holmes
From: "Larry Sandwick" <[EMAIL PROTECTED]> > Is there a way to run a query so that it ignores the case, and the query > is not case sensitive? What's this have to do with PHP and what database are you using? ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Query Case In-sensitive

2003-11-17 Thread roy.a.jones
In Oracle you have a couple of choices. (1) If you can ensure that the data stored is in one case you can apply a function to the keyed in data SELECT item_number FROM item WHERE item_code = lower('M1234'); (2) If you can not ensure data case then you can apply the function to both side

Re: [PHP-DB] Query or code?

2003-11-06 Thread Peter Beckman
On Thu, 6 Nov 2003, John W. Holmes wrote: > I'd still like an answer to this question. Why is there a need for a > separate table with scores? The log is a "snapshot" in time -- what was the "total points" at the time of the log entry. The score table is always the accurate current score. >

Re: [PHP-DB] Query or code?

2003-11-06 Thread John W. Holmes
[EMAIL PROTECTED] wrote: On Thu, 6 Nov 2003, CPT John W. Holmes wrote: From: "Peter Beckman" <[EMAIL PROTECTED]> I have this data: Table Log: appid userid points datetype Table Score: appid userid score I want to verify that the last entry in table log of type "x" is equal to the sum

Re: [PHP-DB] Query or code?

2003-11-06 Thread beckman
On Thu, 6 Nov 2003, CPT John W. Holmes wrote: > From: "Peter Beckman" <[EMAIL PROTECTED]> > > > I have this data: > > > > Table Log: appid userid points datetype > > Table Score: appid userid score > > > > I want to verify that the last entry in table log of type "x" is equal to > >

Re: [PHP-DB] Query or code?

2003-11-06 Thread CPT John W. Holmes
From: "Peter Beckman" <[EMAIL PROTECTED]> > I have this data: > > Table Log: appid userid points datetype > Table Score: appid userid score > > I want to verify that the last entry in table log of type "x" is equal to > the sum of the scores in table score for the same appid and us

RE: [PHP-DB] Query Error

2003-11-04 Thread Robert Sossomon
or a horse! -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 1:31 PM To: Robert Sossomon; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Query Error From: "Robert Sossomon" <[EMAIL PROTECTED]> > The err

Re: [PHP-DB] Query Error

2003-11-04 Thread CPT John W. Holmes
From: "Robert Sossomon" <[EMAIL PROTECTED]> > The errors as it prints are: > > The query I just ran was: select * from GCN_items where `item_num` = > '%fm-a294%' > The query I just ran was: Resource id #2 > 0 Those aren't errors; it's just what you asked the script to display. Your query simply

RE: [PHP-DB] Query Error

2003-11-04 Thread Robert Sossomon
t Sossomon; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Query Error From: "Robert Sossomon" <[EMAIL PROTECTED]> > And here is the additem.php file where it check for the info in the > field and it is erroring out. It would be rather useful to know the error... > $get_

Re: [PHP-DB] Query Error

2003-11-04 Thread CPT John W. Holmes
From: "Robert Sossomon" <[EMAIL PROTECTED]> > And here is the additem.php file where it check for the info in the > field and it is erroring out. It would be rather useful to know the error... > $get_iteminfo = "select * from GCN_items where 'item_num' LIKE > '%$_POST[sel_item_id]%'"; Take aw

Re: [PHP-DB] Query works but can't echo variable :'(

2003-10-26 Thread Micah Stevens
You're using an alias of 'date' instead of DateOfOrder, so that should be reflected in the array key. So: $Date = $OrderDate["date"]; -Micah On Sun October 26 2003 4:22 pm, Graeme McLaren wrote: > Hey everyone, the following query and code works fine but I can't > understand why I can't echo

Re: [PHP-DB] query for multiple values

2003-10-15 Thread Ignatius Reilly
SELECT * FROM table WHERE column IN ( 'this', 'that', 'theother' ) Ignatius _ - Original Message - From: "Robbie Staufer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 12:10 AM Subject: [PHP-DB] query for multiple value

Re: [PHP-DB] Query Filter in GUI

2003-09-22 Thread CPT John W. Holmes
From: <[EMAIL PROTECTED]> > I have a PHP GUI in which a select box gets populated by a query of a > MySQL DB for all CD's by all artists when the page is first opened. I am > now trying to implement > the same query but with a WHERE clause that filters the returned CD's to > be displayed in the sa

RE: [PHP-DB] Query Filter in GUI

2003-09-22 Thread Griffiths, Daniel
how are you testing the check boxes?, looks like the the query string is empty because both the tests you are doing in the code below return false. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 15:01 To: [EMAIL PROTECTED] Subject: [PHP-DB] Qu

Re: [PHP-DB] Query runs fine on Console but not in PHP

2003-08-20 Thread Robert Twitty
--- Original Message - > From: "Robert Twitty" <[EMAIL PROTECTED]> > To: "vish.kohli" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, August 18, 2003 8:28 AM > Subject: Re: [PHP-DB] Query runs fine on Console but not in PHP > >

Re: [PHP-DB] Query runs fine on Console but not in PHP

2003-08-19 Thread vish.kohli
Message - From: "Robert Twitty" <[EMAIL PROTECTED]> To: "vish.kohli" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 8:28 AM Subject: Re: [PHP-DB] Query runs fine on Console but not in PHP > What platform are you using? Since

Re: [PHP-DB] Query runs fine on Console but not in PHP

2003-08-18 Thread Robert Twitty
What platform are you using? Since it appears that the script is crashing, you are probably on Linux or some other UNIX flavor. If this is the case, the TDS protocol setting may not be correct. What type of date are you retrieving with this stored procedure? -- bob On Sun, 17 Aug 2003, vish.ko

Re: [PHP-DB] Query Cache not Working? MySQL 4.0.14-standard

2003-08-14 Thread CPT John W. Holmes
From: "Matt Babineau" <[EMAIL PROTECTED]> > For some reason my MySQL doesn't seem to be caching queries! And you expect PHP to solve this how? Do you want PHP to cache the queries? You must say please... You need to set the four variables mentioned at the following URL in your my.cnf file. http:

Re: [PHP-DB] query works fine on console but not with PHP - why?

2003-08-03 Thread Doug Thompson
You have an error in your PHP code, just as the error says. Including only the query, which you've already tested, isn't very helpful. The error message is telling you that the result "link identifier" used in your fetch statement isn't the same as returned by the query statement OR there was an

Re: [PHP-DB] query works fine on console but not with PHP - why?

2003-08-03 Thread Matthew McNicol
> The error I am getting on the browser is: > > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL > result resource in http://www.martekbiz.com/KCS/utils.inc on line 52 line 52 is the following return statement in the db_fetch function : function db_fetch($results) { return

RE: [PHP-DB] query works fine on console but not with PHP - why? SOLVED

2003-08-03 Thread Aaron Wolski
ts! Aaron -Original Message- From: Matt [mailto:[EMAIL PROTECTED] Sent: August 3, 2003 10:11 AM To: Aaron Wolski; [EMAIL PROTECTED] Subject: Re: [PHP-DB] query works fine on console but not with PHP - why? - Original Message - From: "Aaron Wolski" <[EMAIL PROTECTED]> To

Re: [PHP-DB] query works fine on console but not with PHP - why?

2003-08-03 Thread Matt
- Original Message - From: "Aaron Wolski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 03, 2003 9:59 AM Subject: [PHP-DB] query works fine on console but not with PHP - why? > The error I am getting on the browser is: > > Warning: mysql_fetch_array(): supplied argume

Re: [PHP-DB] query, display and grouping.. one way works but notanother

2003-07-26 Thread John W. Holmes
Aaron Wolski wrote: Hi Guys, Have a multiple select box. I'm trying to group columns and display records under their paired groupings. [snip] What I'd like is to display them like: Manufactuer - Type Manufacturer - Type Manufacturer - Type I tried this code but only seems to group one T

RE: [PHP-DB] query and display acting weird...

2003-07-25 Thread Aaron Wolski
As usual. John knows best. Thanks! Aaron -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: July 25, 2003 3:05 PM To: Aaron Wolski; [EMAIL PROTECTED] Subject: Re: [PHP-DB] query and display acting weird... Probably need: ORDER BY t.manufacturer, t.colourID

Re: [PHP-DB] query and display acting weird...

2003-07-25 Thread CPT John W. Holmes
Probably need: ORDER BY t.manufacturer, t.colourID ---John Holmes... - Original Message - From: "Aaron Wolski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 2:58 PM Subject: [PHP-DB] query and display acting weird... > Hi Guys, > > Code: > > echo " style=

RE: [PHP-DB] Query problem

2003-07-22 Thread jeffrey_n_Dyke
<[EMAIL PROTECTED]> .net.il> cc: Subject: RE: [PHP-DB] Query problem

RE: [PHP-DB] Query problem

2003-07-22 Thread Boaz Yahav
Assuming you run MySQL, why don't you just remove the " ' "? SELECT * FROM MyTable WHERE MyField=NULL Sincerely berber Visit http://www.weberdev.com/ Today!!! To see where PHP might take you tomorrow. Share your code : http://addexample.weberdev.com -Original Message- From: Ron All

Re: [PHP-DB] Query problem

2003-07-22 Thread Ron Allen
How would the entire query look select * from ticket where Type = 'Phone' and ??? "Dirk Kredler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen: > > This is what I have > > select * from ticket where Type = 'Line' and Closeddate

RE: [PHP-DB] Query problem

2003-07-22 Thread Peter Lovatt
select * from ticket where Type = 'Line' and (Closeddate IS NULL OR Closeddate ='') or select * from ticket where Type = 'Line' and Closeddate IS NULL HTH Peter -Original Message- From: Ron Allen [mailto:[EMAIL PROTECTED] Sent: 22 July 2003 10:29 To: [EMAIL PROTECTED] Subject: [PHP-DB]

Re: [PHP-DB] Query problem

2003-07-22 Thread Dirk Kredler
Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen: > This is what I have > select * from ticket where Type = 'Line' and Closeddate = ' empty space' > and have tried the following > select * from ticket where Type = 'Line' and Closeddate = 'Null' > select * from ticket where Type = 'Line' and Close

Re: [PHP-DB] query selection

2003-06-16 Thread CPT John W. Holmes
> the first list that is displayed has an ID for each product. But when I > click on it, it goes to the next page but does not display the rest of the > products that are listed in the second table. > > $query = "SELECT * FROM product_list WHERE productid = id"; > > Id being the description ID t

  1   2   3   >