To: Daniel Krook/White Plains/IBM@IBMUS
Cc: PHP Database List php-db@lists.php.net
Date: 08/21/2013 11:59 PM
Subject: Re: [PHP-DB] mysql query
On 08/21/2013 11:30 PM, Daniel Krook wrote:
Ethan,
It's hard to tell from the code formatting in your email what the
exact problem might
:
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: Daniel Krook/White Plains/IBM@IBMUS
Cc: PHP Database List php-db@lists.php.net
Date: 08/21/2013 11:59 PM
Subject: Re: [PHP-DB] mysql query
On 08/21/2013 11:30 PM, Daniel Krook wrote:
Ethan,
It's hard to tell from
1) What is the error message?
2) This has an error:
values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql describe Inventory;
On 08/21/2013 07:52 PM, Toby Hart Dyke wrote:
1) What is the error message?
2) This has an error:
values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql
Ethan,
It's hard to tell from the code formatting in your email what the exact
problem might be, but a few reasons that this might fail in PHP rather
than when sent to MySQL with hardcoded values:
1. var_dump/print_r $_POST to see what you're getting as input is what
you expect (and
@IBMUS
Cc: PHP Database List php-db@lists.php.net
Date: 08/21/2013 11:59 PM
Subject: Re: [PHP-DB] mysql query
On 08/21/2013 11:30 PM, Daniel Krook wrote:
Ethan,
It's hard to tell from the code formatting in your email what the
exact problem might be, but a few reasons that this might fail
ron.pigg...@actsministries.org wrote:
The query from my previous post was only part of a larger query. This is
the entire query:
SELECT GREATEST( IF( CURDATE( ) = DATE_SUB( DATE( FROM_UNIXTIME(
1239508800 ) ) , INTERVAL LEAST( 14, (
SELECT COUNT( * )
FROM `verse_of_the_day_Bible_verses`
WHERE
Chris I spent 3 hours debugging this query myself. I got as far as
putting '' around 2009-12-25 to get the desired results. I just added the
word DATE. It works, thanks.
Chris I run a verse of the day e-mail list. This query determines the
logic of the content (year round, Easter and
I found the problem. The first subquery needed AS aliases. I am
learning more of what mySQL is capable of and appreciate the help. Ron
-Original Message-
From: TG tg-...@gryffyndevelopment.com
To: ron.pigg...@actsministries.org
Subject: Re: [PHP-DB] mySQL query syntax error
Date: Sat
snip
error_log(Hey, the SQL is: $sql);
Then look in your php error log (you do have error logging enabled,
right?)
[McGovern, Dave] Enabled, yes. Usefully enabled, no (correcting this
helped a lot).
If that SQL in the error log is fine, then your problem is
On Fri, 23 Jan 2009, dave.mcgov...@sungard.com wrote:
Hi,
I am running: PHP 5.2.8, Apache 2.2.11, MySQL 5.1.30 on Win32/XP.
I have a number of queries on my page which are very similar in
structure, and they all work except for the following one.
$mysql['process'] =
Man- when the query is fired through the web interface- it rans on
mysql server
max_execution_time - wont' help evn I stop apache itself...
Yes it will. Apache will be instructed to stop execution of any script
by the mod_php module (assuming you are using mod_php). But mysql
Piyush Kumar wrote:
I'm using http://myclient.polarlava.com/ as web query interface for mysql server
Now I want to add Query Timeout functionality to it
For that I need to get the PID for last ran mysql query and then using kill
PID - I can kill the process on MySQL server
Please explain how
Just put the time out in your PHP.INI file
max_execution_time = 30 ; Maximum execution time of each script, in
seconds
2008/10/16 Piyush Kumar [EMAIL PROTECTED]
I'm using http://myclient.polarlava.com/ as web query interface for mysql
server
Now I want to add Query Timeout functionality
Man- when the query is fired through the web interface- it rans on
mysql server
max_execution_time - wont' help evn I stop apache itself...
The query runs on mysql server - so I have to kill the PID on server itself...
Thanks
Piyush
On Thu, Oct 16, 2008 at 7:57 AM, Jack van Zanen [EMAIL
Piyush Kumar wrote:
Hi Chris,
As I mentioned in my query I want to Kill only the query ran by web
client not all queries running on the server.
The perl script kill all queries - which are been running from for
last 120(or any threshold set)
Issues:
How do I get the PID of my last select
Piyush Kumar wrote:
show full processlist ; gives me whole query -- but I want some php
function -- like mysql_info() -- to return the PID of last run query
Please do not email me directly. Always send to the mailing list.
If it's not listed under php.net/mysql somewhere, then it's not
That's one of the uses of Ajax.
http://www.xajaxproject.org/
http://wiki.xajaxproject.org/Tutorials:Learn_xajax_in_10_Minutes
You don't have to use an iframe.
Regards,
Dwight
-Original Message-
From: Todd A. Dorschner [mailto:[EMAIL PROTECTED]
Sent: Friday, May 11, 2007 8:31 AM
SELECT c.eventid, e.ID
FROM col_links c left outer join calendar_v2 e
ON c.eventid = e.ID
where e.id is null
LIMIT 0, 999;
From: Keith Spiller [EMAIL PROTECTED]
To: [PHP-DB] php-db@lists.php.net
Subject: [PHP-DB] MySQL Query
Date: Sat, 19 Nov 2005 19:29:25 -0700
Hi,
I'm tring to run this
The code looks correct so my guess is that you are parsing it inorrectly in
actionscript...
Bastien
From: Juan Stiller [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL query result with some errors!
Date: Tue, 11 Oct 2005 18:14:42 -0300 (ART)
Hi,
Im trying to get a query
is there a join in the sql? Joins can be tricky since the order of the joins
can determine the number of records selected from each table. If the joins
result in a larger table joining with a smaller table, it could result in
more than 30% of the rows being selected and the optimizer will
yeah...errora are important. I do not escape my quotation marks in a
query. I use single quotes within my insert and select statements.
If it says No valis MySQL resource then you are returning 0 records
which may be caused by escaping the quotations.
I follow this pattern
$sql =INSERT INTO
-db@lists.php.net
Subject: Re: [PHP-DB] MySQL query problems...
Date: Thu, 24 Mar 2005 08:35:56 -0500
yeah...errora are important. I do not escape my quotation marks in a query.
I use single quotes within my insert and select statements.
If it says No valis MySQL resource then you are returning 0
: J. Connolly [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 24, 2005 7:36 AM
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQL query problems...
yeah...errora are important. I do not escape my quotation marks in a
query. I use single quotes within my insert and select statements.
If it says
um, the errors might be helpful
bastien
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL query problems...
Date: Wed, 23 Mar 2005 17:18:44 -0600
I am getting errors for the following queries. This query seems
to work fine in phpMyAdmin.
Unlike ASP, $result1 is a handle to the dataset, not the data set itself.
You need to access the data first and then incorporate that into your query
like this:
$l = 2;
$result1 = (SELECT * FROM Drivers WHERE League = $l);
$row = mysql_fetch_array($result1);
$driverID = $row['DriverID'];
I am looking to do the following w/ MySQL and PHP. Have 1 query that
gets
results, then use those results in another query:
$l = 2;
$result1 = (SELECT * FROM Drivers WHERE League = $l);
$result2 = mysql_query(SELECT DriverID, Driver, CarNbr FROM Drivers
LEFT
JOIN $LeagueList ON
Justin Patrin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Fri, 13 Aug 2004 15:20:36 +0200, Quentin Cotillard
[EMAIL PROTECTED] wrote:
Consider a table similar to the one below.
What I want to do is to get ONE random record from categories(cat) A
and 5 random record from
On Fri, 13 Aug 2004 19:39:59 +0200, Torsten Roehr [EMAIL PROTECTED] wrote:
Justin Patrin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Fri, 13 Aug 2004 15:20:36 +0200, Quentin Cotillard
[EMAIL PROTECTED] wrote:
Consider a table similar to the one below.
What I want to do
On Tuesday 06 July 2004 17:58, [EMAIL PROTECTED] wrote:
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'
Matt Matijevich wrote:
This is probably a question for for a mysql list but I figured someone
out here knows the answer.
[snip]
SELECT * FROM sometable WHERE 1
SELECT * FROM sometable
Just that :) (do I hear you slapping your forehead? :)
Bruno Ferreira.
---
[This E-mail scanned for viruses
snip
SELECT * FROM sometable
Just that :) (do I hear you slapping your forehead? :)
Bruno Ferreira.
/snip
Thanks for the answers guys. My problem was I am a mysql novice and
there was a bunch of existing queries that use the WHERE 1 syntax.
--
PHP Database Mailing List (http://www.php.net/)
Yes, where evaluates to true.
On Wed, 2004-03-17 at 12:03, Matt Matijevich wrote:
This is probably a question for for a mysql list but I figured someone
out here knows the answer.
I am working with an existing mysql application and there is a bunch of
queries that are formatted something
it simple
Ryan
-Original Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 10:15 AM
To: Matt Matijevich
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySql query
Yes, where evaluates to true.
On Wed, 2004-03-17 at 12:03, Matt Matijevich wrote
On Monday 01 March 2004 18:53, [EMAIL PROTECTED] wrote:
What I need to do for a new report, is say how many downloads were
recorded for each Business unit?
I can select the Business units using Distinct, but hhow can I then count
them?
I've tried:
SELECT DISTINCT(bu)buname,
To
[EMAIL PROTECTED]
cc
Subject
Re: [PHP-DB] MySQL query... count?
On Monday 01 March 2004 18:53, [EMAIL PROTECTED] wrote:
What I need to do for a new report, is say how many downloads were
recorded for each Business unit?
I can select the Business units using Distinct, but hhow can I
remove the comma after cadet.photo, ie
select cadet.relation2,cadet.photo FROM
HTH steve
Matthew Moldvan, Jr. wrote:
I would say try single quotes instead of double quotes ... let me know if
that works ...
Regards,
Matt.
- Original Message -
From: Sean Smitz [EMAIL
That solved the problem Steve. thanks,
Sean
Steve Davies [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
remove the comma after cadet.photo, ie
select cadet.relation2,cadet.photo FROM
HTH steve
Matthew Moldvan, Jr. wrote:
I would say try single quotes instead of
I would say try single quotes instead of double quotes ... let me know if
that works ...
Regards,
Matt.
- Original Message -
From: Sean Smitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 4:32 PM
Subject: [PHP-DB] MySQL Query not working via PHP
I have a
is there something wrong with my SQL Query? I didnt get any results
neither errors..
?php
$link = mysql_connect('localhost', 'username') or die('Cannot connect to
the database.');
mysql_select_db(profiles,$link);
$SQLQuery = INSERT INTO profyles (username, fname, mname, lname, address,
Ian Bert Tusil wrote:
is there something wrong with my SQL Query? I didnt get any results neither errors..
[snip]
mysql_query($SQLQuery,$link);
That's because you're not checking for errors...
mysql_query($SQLQuery,$link) or die(mysql_error());
--
---John Holmes...
Amazon Wishlist:
How do I avoid the problem in the subject hereto? SELECT query uses
variable in the WHERE clause. Fails on the following query:
SELECT Tbl.fld FROM Tbl WHERE Tbl.fld2='11301201 0603A HKA 3902 #3708_JD's
AE Exp' AND ...
Escape it.
SELECT Tbl.fld FROM Tbl WHERE Tbl.fld2='11301201 0603A HKA
try putting a \ before the apostrophe
-Original Message-
From: Dillon, John [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 12:59 PM
To: 'PHP-DB'
Subject: [PHP-DB] MySQL query failing on apostrophe in data
How do I avoid the problem in the subject hereto? SELECT query uses
From: Dillon, John [EMAIL PROTECTED]
How do I avoid the problem in the subject hereto? SELECT query uses
variable in the WHERE clause. Fails on the following query:
SELECT Tbl.fld FROM Tbl WHERE Tbl.fld2='11301201 0603A HKA 3902 #3708_JD's
AE Exp' AND ...
Escape the single quote with a
if you're using php to generate this query you could use addslashes() to
the piece that is holding 11301201 0603A HKA 3902 #3708_JD's
AE Exp. this will escape the slashes making them \'
similarly if you're getting \' in your return values you can use
stripslashes()
www.php.net/addslashes
I just set up a test db using your info, and the query you have
worked ok. It provided a zero. Here's what I have (slightly modified
from yours, but not appreciably).
select ports.port, sum(stats.amount) as Total from ports left join
stats on ports.port=stats.to_port group by ports.port order by
Message-
From: Mark [mailto:[EMAIL PROTECTED]
Sent: 12 March 2003 15:36
To: Griffiths, Daniel
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Query help please!
I just set up a test db using your info, and the query you have
worked ok. It provided a zero. Here's what I have (slightly modified
Jeremy,
This question probably should be posted to the MySql mailing list but here
goes.
Take a look at this link:
http://www.mysql.com/doc/en/Where_optimisations.html
Your example was not very explicit so I am not sure, but I believe you are
in need of a
WHERE clause. For example;
Select a,
It is safe to test if the divisor is zero:
replace
columnB/columnC
by
IF( columnC = 0, 0, columnB/columnC )
(the 0 could be anything else; this depends on your business logic)
Ignatius
- Original Message -
From: Jeremy [EMAIL PROTECTED]
To:
I need some help from you MySQL gurus out there. This is pure SQL by
the
way..no front-end.
Lets say you have a table that has 2columns.columnA,
ColumnB and columnC
I have something like this
Oh CRAP! You lost me... you said two columns but listed 3! ;)
if (columnA'7',
i am unfarmillar with InnoDB, i am currently using MyISAM i believe. just
the default one.
i am a complete noobie with InnoDB, do i have to convert my db?
cheers
Andrey Hristov [EMAIL PROTECTED] wrote in message
At 1:01 PM +0100 5/3/02, CM wrote:
SELECT Periode.LibPeriode, PaysPeriode.RefPaysPeriode,
PaysPeriode.DateDebut,PaysPeriode.DateFin
FROM Periode, PaysPeriode, Pays
WHERE Pays.RefPays = PaysPeriode.Refpays
AND Periode.RefPeriode = PaysPeriode.RefPeriode
AND PaysPeriode.DateDebut 2002020700
It's not the IN, it's the sub-query you cannot use. MySQL doesn't support
them and it's just about the main reason I don't like it.
Alternatives? You could execute your subquery and return the results to an
array. Loop through the array, using the index and the indexed element to
drive a
On Sat, 27 Oct 2001 13:36:57 +1000
Andrew Duck [EMAIL PROTECTED] wrote:
Error
SQL-query :
CREATE TABLE mail (
from int(32) NOT NULL default '0',
to int(32) NOT NULL default '0',
subject varchar(80) NOT NULL default '',
message text NOT NULL
) TYPE=MyISAM
MySQL said:
Assuming you're using MySQL - 35 seconds is all it took to find:
http://www.mysql.com/doc/P/a/Pattern_matching.html
Good luck!
Russ.
On Thu, 25 Oct 2001 14:16:40 +0300 =?iso-8859-1?Q?Niklas_Lamp=E9n?=
[EMAIL PROTECTED]
wrote:
How can I query for specified fields that has to contain atleast
REGEXP '..+'
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 6:17 AM
To: Php-DB
Subject: [PHP-DB] mySQL Query and blank fields
How can I query for specified fields that has to contain atleast 2
charters?
Example:
Field AAA contains
On Thursday 25 October 2001 13:16, Niklas Lampén wrote:
How can I query for specified fields that has to contain atleast 2
charters?
SELECT * FROM foo_table WHERE length(bar_field)=1;
Arpi
Example:
Field AAA contains '' (NULL) = No match
Field BBB contains ' ' (one charter) = No
Change that to:
SELECT * FROM foo_table WHERE length(bar_field)1;
-Original Message-
From: Tamas Arpad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:01 AM
To: Niklas Lampén; Php-DB
Subject: Re: [PHP-DB] mySQL Query and blank fields
On Thursday 25 October 2001 13:16
' not '98765' as I expected.
Niklas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 25. lokakuuta 2001 15:56
To: Php-DB
Subject: RE: [PHP-DB] mySQL Query and blank fields
Change that to:
SELECT * FROM foo_table WHERE length(bar_field)1;
-Original Message
?
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:04 AM
To: Php-DB
Subject: RE: [PHP-DB] mySQL Query and blank fields
Thanks a lot! I quite didn't know what to look for in the manual.
I actually have another question:
If I want to update
On Thursday 25 October 2001 15:08, Rick Emery wrote:
First, I wouldn't use length(), I'd use REGEXP: SELECT * FROM
foo_table WHERE fieldname REGEXP '..+'
It's quicker.
regular expression is faster then a length() call? that's seems
strange considering how complex a regexp can be
with
: Re: [PHP-DB] MySQL Query Weirdness
When you use mysql_fetch_array you're actually retrieving an array with
two copies of the value you're looking for. One is indexed by the column
number and one indexed by the column name. So it looks like you're
looping through them both and printing each out
When you use mysql_fetch_array you're actually retrieving an array with
two copies of the value you're looking for. One is indexed by the column
number and one indexed by the column name. So it looks like you're
looping through them both and printing each out. You might want
mysql_fetch_assoc
on 7/26/01 11:11 AM, Steve Fitzgerald ([EMAIL PROTECTED]) wrote:
ran the query in the MySQL client and got the ERROR 1054: Unknown column
'$ContactID' in 'where clause'. I know the column ContactID exists.
Of course it did. It can't find the text $ContactID in the table. Try
putting in a
64 matches
Mail list logo