tware Engineer, Advanced Cloud Solutions, GTS
> >
> > IBM Senior Certified IT Specialist - L3 Thought Leader
> > The Open Group Certified IT Specialist - L3 Distinguished
> > Cloud, Java, PHP, BlackBerry, DB2 & Solaris Certified
> >
> >
> >
> &g
, DB2 & Solaris Certified
>
>
>
>
>
>
> Ethan Rosenberg wrote on 08/21/2013
> 11:59:19 PM:
>
> > From: Ethan Rosenberg
> > To: Daniel Krook/White Plains/IBM@IBMUS
> > Cc: PHP Database List
> > Date: 08/21/2013 11:59 PM
> > Subject: Re: [PHP-
> 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 in
&
fied
Ethan Rosenberg wrote on 08/21/2013
07:48:12 PM:
> From: Ethan Rosenberg
> To: PHP Database List
> Date: 08/21/2013 07:48 PM
> Subject: [PHP-DB] mysql query
>
> 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> des
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;
+-+-+-
Dear List -
I can't figure this out
mysql> describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| UPC | varchar(14) | YES | | NUL
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 Christma
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
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(
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( DATE(2009-
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
To: ron.pigg...@actsministries.org
Subject: Re: [PHP-DB] mySQL query syntax error
Date: Sat, 14 Nov 2009 07:1
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 `
> 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
> $client2->multi_query
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'] = $client2->real_escape_strin
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, f.descript
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
process
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
availa
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 query
-- 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
cl
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 PR
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" functi
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
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 Tha
nt: Friday, May 11, 2007 8:31 AM
> 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/sugges
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 bonus
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 tabl
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]"
Subject: [PHP-DB] MySQL Query
Date: Sat, 19 Nov 2005 19:29:25 -0700
Hi,
I'm
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
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
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 : lastnam
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 : lastnam
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 : lastnam
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 trans
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 Ap
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 again
c.com
-Original Message-
From: 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 inser
t;[EMAIL PROTECTED]>
CC: php-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 va
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 V
um, the errors might be helpful
bastien
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To:
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.
$
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\"
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 Drivers.Drive
Ruby" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL - Query within a query
Date: Wed, 16 Mar 2005 00:03:19 -0500
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
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 Drivers.Driv
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.
> >
"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 r
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 category B
>
> | ID | computer | name | cat |...
>1dell 834
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
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.d
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
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 Matijev
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 somethi
SELECT * FROM sometable
Just that :) (do I hear you slapping your forehead? :)
Bruno Ferreira.
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/)
To unsu
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
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 like this:
SELECT * FROM sometable WHERE 1
does "WHERE 1" just return every row?
thanks
>
01/03/2004 11:03
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 uni
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, COUNT(bun
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 Busin
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 artid
van, 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 PROTECTED]>
> >To
t; <[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 but when I try to execute it in PHP I
encounter the following error:
//Generated by the script
Couldn't exe
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 work
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 t
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: www.amazon.co
is there something wrong with my SQL Query? I didnt get any results
neither errors..
$link = mysql_connect('localhost', '') or die('Cannot connect to
the database.');
mysql_select_db("profiles",$link);
$SQLQuery = "INSERT INTO profyles (username, fname, mname, lname, address,
country, gender,
is there something wrong with my SQL Query? I didnt get any results neither errors..
') or die('Cannot connect to the
database.');
mysql_select_db("profiles",$link);
$SQLQuery = "INSERT INTO profyles (username, fname, mname, lname, address, country,
gender, sexuality, status, bday, race, yahoo,
o.uk>cc:
Subject: [PHP-DB] MySQL query failing
on apostrophe in data
08/27/2003 12:59
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 w
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
> 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
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
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 typ
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 mod
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 T
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
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', (c
t; <[EMAIL PROTECTED]>
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 th
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, b
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 te
t; Hope this is clear.
>
> Best regards
> Andrey Hristov
>
>
> - Original Message -----
> From: ":B nerdy" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 04, 2002 3:04 PM
> Subject: [PHP-DB] [mysql] query atomicity
dy" <[EMAIL PROTECTED]>
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...
>
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
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
d
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 M
in Clifford" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 20, 2002 10:03 AM
Subject: [PHP-DB] MySQL Query Acting Up
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
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
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 > 20020207000
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 Pays.RefPay
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 fir
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 serie
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
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
>
>
>
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 int
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 reg
ew_char') WHERE
some_condition
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:37 AM
To: Php-DB
Subject: RE: [PHP-DB] mySQL Query and blank fields
I'd like to do it in mySQL, I think it will be done much quicker since
it a large
I'd like to do it in mySQL, I think it will be done much quicker since
it a large database. The type of the field is allready varchar.
Niklas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 25. lokakuuta 2001 16:08
To: Php-DB
Subject: RE: [PHP-DB] mySQL Quer
r can it be a CHAR string?
-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
PROTECTED]>
To: "Php-DB" <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 3:03 PM
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 several fields,
.." the
value turns into '9881' 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_
1 - 100 of 113 matches
Mail list logo
