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
Dear List -
I can't figure this out
mysql describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| UPC | varchar(14) | YES | |
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
/21/2013
07:48:12 PM:
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: PHP Database List php-db@lists.php.net
Date: 08/21/2013 07:48 PM
Subject: [PHP-DB] mysql query
Dear List -
I can't figure this out
mysql describe Inventory
@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
Does anyone see anything wrong with this query? Do I have one of the , =
or mixed up? The purpose is to figure out if it is within 14 days of
Christmas AND if there is content for Christmas available. 2 is symbolic
in the database being Christmas. Ron
IF( CURDATE( ) = DATE_SUB(
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 seasonal_use =1 ) )
DAY )
AND CURDATE(
I am getting the following error message:
#1054 - Unknown column 'customers.email' in 'order clause'
from the query below --- I don't understand why. Would someone help me
please? Ron
SELECT 'first_name', 'last_name', 'email'
FROM (
(
SELECT `firstname` , `lastname` , `buyer_email`
FROM
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
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'] = $client2-real_escape_string($clean['process']);
$sql = SELECT f.name,
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
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 to do that in PHP
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
-- Forwarded message --
From: Piyush Kumar [EMAIL PROTECTED]
Date: Thu, Oct 16, 2008 at 9:09 AM
Subject: Re: [PHP-DB] MySQL Query Timeout program in PHP
To: Chris [EMAIL PROTECTED]
Hi Chris,
As I mentioned in my query I want to Kill only the query ran by web
client not all
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
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL Query on the Fly
Good Morning,
I've been searching and toying with this solution for some time but
can't find that right answer. Looking for solutions/suggestions to the
following:
I created a program that will allow people to track
Good Morning,
I've been searching and toying with this solution for some time but
can't find that right answer. Looking for solutions/suggestions to the
following:
I created a program that will allow people to track sales and depending
on what they've sold, they will either get a set
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 reminder email.
The first
Hi,
I'm tring to run this query to find orphan entries.
SELECT c.eventid, e.ID
FROM col_links c left outer join calendar_v2 e
ON c.eventid = e.ID
LIMIT 0, 999;
Then I have to scan the list to find entries where
e.ID equals NULL.
I was wondering if anyone know how to expand this
query with a
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
Hi,
Im trying to get a query result from mysql database to
show it on a flash animation, so far i have this code
that its supposed to connect to mysql server , make
the query and get the results, store them on variables
so that flash can read them. Basically i have these
main fileds like :
Hi,
Im trying to get a query result from mysql database to
show it on a flash animation, so far i have this code
that its supposed to connect to mysql server , make
the query and get the results, store them on variables
so that flash can read them. Basically i have these
main fileds like :
Hi,
Im trying to get a query result from mysql database to
show it on a flash animation, so far i have this code
that its supposed to connect to mysql server , make
the query and get the results, store them on variables
so that flash can read them. Basically i have these
main fileds like :
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
I have 2 tables employees transactions. 'employees' carry info about the
employees and transactions carry there payslip info for each period.
I am trying to display a list of employees that don't have transactions in
the current ($pp_id) period,
thus doing an array of the $emp_ids, having
Hello,
We are working to optimize a few queries. When we run the query with
Explain, it appears that the query optimizer is not using one of the
tables index and doing a full table scan while it appears to use other
tables' indices properly. We then remove the table with the full
scan, run
table join into 3 queries and application based arrays, I
reduced the run time to about 10 seconds with 50x the output.
Bastien
From: Eddie Peloke [EMAIL PROTECTED]
Reply-To: Eddie Peloke [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] mysql query plan
Date: Wed, 13 Apr 2005 15:42:41
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
I am getting errors for the following queries. This query seems
to work fine in phpMyAdmin.
$query2 = SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, accounts
WHERE AllMid_Data.CPU_IN_SVC = \Y\
AND AllMid_Data.CPU_DNS = \sbcld.sbc.com\
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
'];
$result2 = mysql_query(SELECT DriverID, Driver, CarNbr FROM Drivers LEFT
JOIN $LeagueList ON Drivers.DriverID = $driverID
WHERE $driverID) Is Null ORDER BY Drivers.DriverID);
hth
Bastien
From: Pete Ruby [EMAIL PROTECTED]
Reply-To: Pete Ruby [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB
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
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
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 category B
| ID | computer | name | cat |...
1 dell 834A
2 ibm526A
3 apple 134B
4 sony 333A
5
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
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 once.)
What am
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
This problem pertains to a system that records all downloads from our
site:
I have a field in my DB, that states which business unit owns the download
that was recorded...
What I need to do for a new report, is say how many downloads were
recorded for each Business unit?
I can select the
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
i want to search the table called comments, and i want to count the number of times
artid appears. then i want to group them all together, but then i want to order them
by most appearances to fewest. so if artid 1 appeared 40 times and it was the most, i
want that to be retrieved first. if
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 4:32 PM
Subject: [PHP-DB] MySQL Query not working via PHP
I have a query that works in MySQL but when I try to execute it in PHP I
encounter the following error:
//Generated by the script
Couldn't execute query!
// Generated by MySQL
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 query that works in MySQL
I have a query that works in MySQL but when I try to execute it in PHP I
encounter the following error:
//Generated by the script
Couldn't execute query!
// Generated by MySQL
MySQL reports: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for
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
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, country,
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 ...
John
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
:
Subject: [PHP-DB] MySQL query failing
on apostrophe in data
08/27/2003 12:59
PM
Hi guys,
I have been working in php/oracle for quite some time now but recently had to shift
myself to mysql and I am struggling with a particular query here.
Scenario is, certain researchers can submit their proposals and those proposal are
stored in a table researcher.
proposals are of 2
Hi all,
I have 2 tables that I need to extract data from, say PORTS and STATS.
PORTS contains a list of Sea Ports in PORT i.e. : -
PORTS.PORT
UK
FRANCE
GERMANY
NETHERLANDS
SPAIN
ITALY
STATS contains a few thousand records that with among other things has the elements
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
Hello,
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
if (columnA'7', (columnB/columnC) + 52, columnB/ColumnC) as Number
however i need to test
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,
]
To: [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 10:29 PM
Subject: [PHP-DB] MySQL Query Question
Hello,
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
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',
how would i go about making a few queries into a transaction - that is, if
one of them fails, the previous queries get rolled back...
cheers
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 04, 2002 3:04 PM
Subject: [PHP-DB] [mysql] query atomicity
how would i go about making a few queries into a transaction - that is,
if
one of them fails, the previous queries get rolled back...
cheers
--
PHP Database Mailing Li
this function doesnt work
function query($sql)
{
return mysql_query($sql, $this-mysql_link) or die(query
failed: $sql);
}
but this one does
function query($sql)
{
$mysql_result = mysql_query($sql, $this-mysql_link) or
I seem to have run into another problem with a query that I am doing
exactly like the example in the MySQL documentation, I think. The following
query is not working on my PHP page, and it is not working from a MySQL
command line either. This looks exactly the same as an example in the
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 could have been looking at it too long.
Here is the query:
$query = UPDATE articles2 SET title=\$title, brief=\$brief\, doclink=\$doclink\
WHERE
Hi. I am having trouble after migrating an Access Database to MySQL.
Basically the Access query I was using for my application was:
SELECT Periode.LibPeriode, PaysPeriode.RefPaysPeriode,
PaysPeriode.DateDebut, PaysPeriode.DateFin
FROM Periode INNER JOIN (Pays INNER JOIN PaysPeriode ON
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
Hi there. I would like to return the 2 most recent events from my table,
for each author (Author_ID). Here's my table structure (simplified).
tblEvents
ID
Title
Create_Date
Author_ID
Is there a way to do this with a query instead of getting every record,
sorted by Author_ID, displaying the
Hello.
I am wishing to store all mysql querys in a single file and when they needed
to be ran call them using include mysql.php;
But I keep getting errors saying that its an invalid number of mysql
resoruces or something like that when I bring the query into the atuual file
and dont run it from
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
I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative
that would work?
select * from lib_asset_tbl where material_id '' and asset_id in (select
asset_id from lib_copy_tbl)
Help is appreciated.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
--
PHP
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:
You have an error in your SQL syntax near 'from int(32) NOT NULL default '0',
to
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:
How can I query for specified fields that has to contain atleast 2
charters?
Example:
Field AAA contains '' (NULL) = No match
Field BBB contains ' ' (one charter) = No match
Field CCC contains 'ab' = Match
Field DDD contains 'abcdefg' = Match
Niklas
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
Hello,
I'm new at this php/mysql stuff, so go easy on my guys.
I've got my query script up and working, but the problem is I'm getting the
same column printed twice on the html output. Here is the output:
Connected successfully
Chris Chris
Mark Mark
Mike Mike
Dee Dee
etc...
Here is my
1 - 100 of 103 matches
Mail list logo
