> > > I would like yo show the users in a list that have a date that is
more
> > > than
> > > 60 days old.
> >
> > $sql = "SELECT * FROM stompers WHERE sUpdated < CUR_DATE() -
INTERVAL 60
> > DAY AND sActive = 'Y' ORDER BY sUpdated DESC";
>
> This one returns a 'Could not get Query' warning ... so
This one returns a 'Could not get Query' warning ... so thats out.
- Original Message -
From: "John W. Holmes" <[EMAIL PROTECTED]>
To: "'Philip J. Newman'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 5:3
> I would like yo show the users in a list that have a date that is more
> than
> 60 days old.
$sql = "SELECT * FROM stompers WHERE sUpdated < CUR_DATE() - INTERVAL 60
DAY AND sActive = 'Y' ORDER BY sUpdated DESC";
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Ge
ED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 02, 2003 7:46 AM
Subject: [PHP] PHP SQL Code
> I would like yo show the users in a list that have a date that is more
than
> 60 days old.
>
>
> $sql = "SELECT * FROM stompers WHERE sUpdated <
> from_unixtime(unix_time
I would like yo show the users in a list that have a date that is more than
60 days old.
$sql = "SELECT * FROM stompers WHERE sUpdated <
from_unixtime(unix_timestamp(now())-(15760*60)) AND sActive = 'Y' ORDER BY
sUpdated DESC";
This don't quite work ..
Any suggestions?
--
Philip J. Newman
2003 11:18 PM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL Query
I have a problem writing a query that can select a Interest for a specific
user... There are tvo tables, IList and IIndex...
IList contains this :
ID SubID Interest Valid
Edit Delete 1 0 Datorer 0
Edit Delete 2 1
I have a problem writing a query that can select a Interest for a specific
user... There are tvo tables, IList and IIndex...
IList contains this :
ID SubID Interest Valid
Edit Delete 1 0 Datorer 0
Edit Delete 2 1 Spel 0
Edit Delete 3 2 Strategi 0
Edit Delete
Hi All,
I need to extract text ata from PDF files. Does anyone
know if there is a PHP PDF parser?
Also, does anyone know if there is a sql wrapper for
the ffdb-php project
(http://sourceforge.net/projects/ffdb-php/)?
John created this wonderful FFDB in PHP, and I was
wondering if there are plan
> From: "Daniel Masson" <[EMAIL PROTECTED]>
>
> I need help on this urgently.
>
> I need to connect to a ms sql server usgin windows autentication on a
> win 2000 box and IIS 5, i cant switch sql server to windows and sql
> authentication, .. I really need to know hot to connect.
I know very lit
Hello list.
I need help on this urgently.
I need to connect to a ms sql server usgin windows autentication on a
win 2000 box and IIS 5, i cant switch sql server to windows and sql
authentication, .. I really need to know hot to connect.
Thanks
Daniel E Massón.
Ingeniero de desarrollo
[EMAIL PR
> --- Sean Burlington <[EMAIL PROTECTED]> wrote:
> > I think the bandwidth wasters are those who ask
> > questions poorly (it takes several follow up mails
> > to find out what the question was) and those who
> > don't have a qucik look at the archives first
> > (is someone puuting together an FAQ
--- Sean Burlington <[EMAIL PROTECTED]> wrote:
> I think the bandwidth wasters are those who ask
> questions poorly (it takes several follow up mails
> to find out what the question was) and those who
> don't have a qucik look at the archives first
> (is someone puuting together an FAQ ?)
I agree.
John W. Holmes wrote:
.it's an log for a VoIp network, evrey voip has an ip and i whant
that instad of the VoIp's IP to put his name, instad of "1.1.1.1:xxx"
must
be "jhon doe form yyy city", it's easier to read for the people who
So where do you get the name from. You're still not bei
Sean Malloy wrote:
I see a lot of these type of answers on the list at the moment.
I'm sick of receiving smart ass answers from people. It wastes my time, and
my bandwidth.
Either answer the fucking question, even if it hasn't been asked correctly,
or don't reply at all.
Given you are a 'PHP Pr
FROM table
> >
> > or you can do it using PHP once the query has executed, on a record by
> > record basis, within a while/for loop or whatever.
> >
> > -Original Message-
> > From: Paul Marinas [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, 19 January 2003 11
I apologise for calling you a PHP Professional, clearly I was mistaken.
;)
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 19 January 2003 4:36 PM
To: 'Sean Malloy'; [EMAIL PROTECTED]
Subject: RE: [PHP] SQL+php
It's _for_ PHP Professiona
or No questions. There's even a funny FAQ on this, but I can't find
the link anywhere.
---John Holmes...
>
> -Original Message-
> From: John W. Holmes [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, 19 January 2003 11:42 AM
> To: 'Paul Marinas'
> Cc: [EMAIL
> .it's an log for a VoIp network, evrey voip has an ip and i whant
> that instad of the VoIp's IP to put his name, instad of "1.1.1.1:xxx"
must
> be "jhon doe form yyy city", it's easier to read for the people who
that
> follow the logs. .. that's it ...
So where do you get the name from. You
t;>
> >> ---John W. Holmes...
> >>
> >> PHP Architect - A monthly magazine for PHP Professionals. Get your copy
> >> today. http://www.phparch.com/
> >>
> >>> -Original Message-
> >>> From: Paul Marinas [mailto:[EMAIL PROTEC
ww.phparch.com/
>>
>>> -Original Message-
>>> From: Paul Marinas [mailto:[EMAIL PROTECTED]]
>>> Sent: Saturday, January 18, 2003 7:46 PM
>>> To: John W. Holmes
>>> Subject: RE: [PHP] SQL+php
>>>
>>>
>>>
IL PROTECTED]]
> Sent: Sunday, 19 January 2003 11:07 AM
> Cc: [EMAIL PROTECTED]
> Subject: [PHP] SQL+php
>
>
> Dose anyone know how to search and replace a string in a
> mysql_query output.
>
> Thanks, Paul
>
> --
> PHP General Mailing List (http://www.php.n
-
From: Paul Marinas [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 19 January 2003 11:07 AM
Cc: [EMAIL PROTECTED]
Subject: [PHP] SQL+php
Dose anyone know how to search and replace a string in a
mysql_query output.
Thanks, Paul
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe
Message-
> > From: Paul Marinas [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, January 18, 2003 7:46 PM
> > To: John W. Holmes
> > Subject: RE: [PHP] SQL+php
> >
> >
> > what number? .. i really need that .
> > On Sat, 18 Jan 2003, John W. Holmes wr
L PROTECTED]]
> Sent: Saturday, January 18, 2003 7:46 PM
> To: John W. Holmes
> Subject: RE: [PHP] SQL+php
>
>
> what number? .. i really need that .
> On Sat, 18 Jan 2003, John W. Holmes wrote:
>
> > > Dose anyone know how to search and replace a strin
rofessional' John, I would expect a little more from
you.
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 19 January 2003 11:42 AM
To: 'Paul Marinas'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] SQL+php
> Dose anyone know h
> Dose anyone know how to search and replace a string in a
> mysql_query output.
Yes.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: ht
Dose anyone know how to search and replace a string in a
mysql_query output.
Thanks, Paul
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
]
Sent: Monday, December 30, 2002 7:15 PM
To: PHP List
Subject: [PHP] SQL Error
I'm having some troubles. I have an install script which runs a lot of
SQL statements to create tables then insert info into them. One of them
is an emoticons table. Here's the error I'm getting:
Y
I just tried this in MySQL and it inserted no problem
INSERT INTO c_emotes VALUES (6, ':-)');
Mike
*** REPLY SEPARATOR ***
On 30/12/2002 at 7:14 PM Stephen wrote:
I'm having some troubles. I have an install script which runs a lot of SQL statements
to create tables then i
I'm having some troubles. I have an install script which runs
a lot of SQL statements to create tables then insert info into them. One of them
is an emoticons table. Here's the error I'm getting:
You have an error in your SQL syntax near '; INSERT INTO c_emotes VALUES
\(':\)', 'emotes/smile
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ohhh you're close. A little tweak, and it works. Here's what I came up with:
INSERT INTO myTable
(owner, name)
SELECT id as "owner", 'myName' as "name"
FROM users where username='myUserName';
I think if you omit the (owner, name), it thinks
At 09:01 16.12.2002, Evan Nemerson said:
[snip]
>Anyways, my question is rather simple- how do I do an INSERT using a
>subquery?
>I want something like this- only one that works:
>
>INSERT INTO myTable
>SET owner=(SELECT id FROM users WHERE username='myUsern
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
First off, sorry it's a SQL question not PHP, but I don't subscribe to
mysql-general (or whatever it's called), and I have a feeling someone on this
list will be able to help...
Anyways, my question is rather simple- how do I do an INSERT using a su
select * from table_name where (start_date >='2002-10-01' and start_date
<='2002-12-10') or (end_date >='2002-10-01' and end_date <='2002-12-10')
At 01:08 11.12.2002, [-^-!-%- said:
[snip]
>
>Hello everyone,
>
>I need to get a recordset between two dates, a
Hello everyone,
I need to get a recordset between two dates, and am having a little
trouble. I was wondering if someone could me make it more efficient.
The goal:
Each record has a start_date and end_date field. I want to be able to
extract records that has the start_date and/or end_date, withi
Original Message-
From: Jule Slootbeek [mailto:jslootbeek@;clarku.edu]
Sent: Wednesday, November 06, 2002 1:52 PM
To: Marco Tabini
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] sql error
apparently 'where' and 'with' are keywords in Java, i've changed them
and now it works
rchar(255) not null ...
---John Holmes...
-Original Message-
From: Jule Slootbeek [mailto:jslootbeek@;clarku.edu]
Sent: Tuesday, November 05, 2002 9:43 PM
To: Marco Tabini
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] sql error
Ah i see, but then why will phpMyAdmin let me use it?
it works fi
apparently 'where' and 'with' are keywords in Java, i've changed them
and now it works fine.
thanks!
Jule
On Tuesday, Nov 5, 2002, at 21:53 US/Eastern, Marco Tabini wrote:
I'm not entirely sure... different configurations perhaps? Have you
verified that that's indeed the problem?
Marco
--
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] sql error
>
> Ah i see, but then why will phpMyAdmin let me use it?
> it works fine on my local db with these names, but on my remote server
> it refuses to create the table.
>
> Jule
>
> On Tuesday, Nov 5, 2002, at 21:47 US/
I'm not entirely sure... different configurations perhaps? Have you
verified that that's indeed the problem?
Marco
---
php|architect -- The Monthly Magazine For PHP Professionals
Visit us on the web at http://www.phparch.com!
On Tue, 5 Nov
2002, Jule Slootbeek
wrote:
> Ah i see, but
Ah i see, but then why will phpMyAdmin let me use it?
it works fine on my local db with these names, but on my remote server
it refuses to create the table.
Jule
On Tuesday, Nov 5, 2002, at 21:47 US/Eastern, Marco Tabini wrote:
"where" is a reserved keyword in SQL--try changing the name of that
"where" is a reserved keyword in SQL--try changing the name of that
column to something else.
Marco
---
php|architect -- The Monthly Magazine For PHP Professionals
Visit us on the web at http://www.phparch.com!
On Tue, 5 Nov
2002, Jule Slootbeek wrote:
> I know this is the wrong mail
I know this is the wrong mailinglist, but i don't want to subscribe to
a second one for one random question.
when trying to enter this into my db:
DROP TABLE IF EXISTS dates;
CREATE TABLE dates (
id int(10) unsigned NOT NULL auto_increment,
date varchar(50) NOT NULL default '',
at varchar(
> use mysql_insert_id(). Much more reliable when and if you use the
system
> with more than one person inserting at the same time.
Sure it's for that I ask
Thanks for your help.
Christian,
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
use mysql_insert_id(). Much more reliable when and if you use the system
with more than one person inserting at the same time.
-Original Message-
From: Christian Ista [mailto:mailing-list@;istasofts.com]
Sent: Thursday, October 31, 2002 2:12 PM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL
> In a table, I have some fields and the primary key is an autoincrement
> field. I insert an row and I'd like to recover the ID used for the last
> record I inserted.
>
> For the moment, I do a select max(Id) just after the insert but there
> is, my be a best way to do it.
Stop.
Read this:
www
Check out mysql_insert_id()
> For the moment, I do a select max(Id) just after the insert but there
> is, my be a best way to do it.
--
Linux: Because rebooting is for adding hardware.
Fingerprint = CE24 057D 1E88 A253 3196 89DB 9FF0 9EF0 2F70 8BE8 BE8
signature.asc
Description: This is a digi
Hello,
In a table, I have some fields and the primary key is an autoincrement
field. I insert an row and I'd like to recover the ID used for the last
record I inserted.
For the moment, I do a select max(Id) just after the insert but there
is, my be a best way to do it.
Thanks for your help
Chri
x27;Faisal Abdullah'; [EMAIL PROTECTED]
Subject: RE: [PHP] SQL : left join from multiple tables
[snip]
"select a.name, b.department, c.position
from emp a
left join dept b
on a.staffno = b.staffno
left join position c
on a.staffno = c.staffno
where staffno = $staffno";
I know the s
Faisal,
I'd check the documentation CDs for Oracle 9i. Oracle 8 does not use the
"join" or "left" keywords but a plus sign in parenthesis "(+)" whose
position determines whether it is a left or right join. It may not be
SQL2 but its Oracle.
HTH
Chris
Marek Kilimajer wrote:
> Well, this woul
[snip]
[snip]
"select a.name, b.department, c.position
from emp a
left join dept b
on a.staffno = b.staffno
left join position c
on a.staffno = c.staffno
where staffno = $staffno";
I know the statement above is totally wrong. I'm just hoping u guys can
understand what i'm trying to achieve from i
[snip]
"select a.name, b.department, c.position
from emp a
left join dept b
on a.staffno = b.staffno
left join position c
on a.staffno = c.staffno
where staffno = $staffno";
I know the statement above is totally wrong. I'm just hoping u guys can
understand what i'm trying to achieve from it.
[/sn
Well, this would work in MySQL, I have even more LEFT JOINs, so go find
out if it is possible with Oracle.
Faisal Abdullah wrote:
>Hi again people! How's it goin?
>
>Here's the question
>How do I do left joins from multiple tables?
>I want to do something like this:
>
>"select a.name, b.departm
Hi again people! How's it goin?
Here's the question
How do I do left joins from multiple tables?
I want to do something like this:
"select a.name, b.department, c.position
from emp a
left join dept b
on a.staffno = b.staffno
left join position c
on a.staffno = c.staffno
where staffno = $staffno"
Hi,
Wednesday, August 21, 2002, 11:25:30 PM, you wrote:
n> I am a new person to PHP. I have purchased and read PHP fast & easy by
n> Julie Meloni and have also read the 24 hours PHP book. I am able to connect
n> to the SQL database and insert into the database via my html form. However,
n> the
I am a new person to PHP. I have purchased and read PHP fast & easy by
Julie Meloni and have also read the 24 hours PHP book. I am able to connect
to the SQL database and insert into the database via my html form. However,
the values are null. When I look at the data in my database, it reads "
Oops! Sorry! I meant to say "apostrophe" and not "single quotes"...
And sorry 'bout this additional post...
Regards,
- E
>Actually, I DID read the articles before I replied.
>
>If you read it again, the basic problem is not about any "extended
>SQLServer functionality"--it's about how ASP wor
Actually, I DID read the articles before I replied.
If you read it again, the basic problem is not about any "extended SQLServer
functionality"--it's about how ASP works AND how the database server was
configured AND how Window$ works.
Sorry, but the attacks mentioned CANNOT be done on any of
I didn't see that, what a waste of paper
Randy
- Original Message -
From: "Edwin @" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 1:14 PM
Subject: Re: [PHP] SQL Injection/Data Balidation
> Yeah
Yeah, I'm scared...
Please excuse me but may I say that it seems like you've sent some wrong
info to the wrong mailing list?
I use PHP NOT ASP, I use MySQL or PostgreSQL or Oracle but NOT M$ SQL
Server. And IIS? Of course, some people use it (perhaps) because of some
unavoidable circumstances
Please CC me as I'm on digest:
--
Are there any libraries for data validation available? If one reads
papers like these:
http://www.nextgenss.com/papers/advanced_sql_injection.pdf
http://www.nextgenss.com/papers/more_advanced_sql_injection.pdf
It beco
Hi Djurovski,
> I use this query to input data into MySQL DB.
> EXPIRE is Expire Date!
> My script allways inputs "1.1.0001" into database (as value of expire).
> what is wrong?
>
> My table:
>
> CREATE TABLE korpa (
>idnarudzbeukorpi int(255) DEFAULT '0' NOT NULL auto_increment,
>merna
Hi,
I use this query to input data into MySQL DB.
EXPIRE is Expire Date!
My script allways inputs "1.1.0001" into database (as value of expire).
what is wrong?
My table:
CREATE TABLE korpa (
idnarudzbeukorpi int(255) DEFAULT '0' NOT NULL auto_increment,
mernaj varchar(255) NOT NULL,
naz
Hi,
I use this query to input data into MySQL DB.
EXPIRE is Expire Date!
My script allways inputs "1.1.0001" into database (as value of expire).
what is wrong?
My table:
CREATE TABLE korpa (
idnarudzbeukorpi int(255) DEFAULT '0' NOT NULL auto_increment,
mernaj varchar(255) NOT NULL,
naz
If I have to do that for every reply then I will only reply to half as
many messages each day.
On Tue, 13 Aug 2002, Jason Wong wrote:
> On Tuesday 13 August 2002 00:03, Rasmus Lerdorf wrote:
> > I know many people hate top-posts, but when you get 1400+ emails every day
> > and answer 50+, it sur
On Tuesday 13 August 2002 00:03, Rasmus Lerdorf wrote:
> I know many people hate top-posts, but when you get 1400+ emails every day
> and answer 50+, it sure does speed things up.
It probably depends.
> Having the relevant text
> right up front means I don't have to scroll down to find it.
On Monday 12 August 2002 23:53, Analysis & Solutions wrote:
> Hi Tyler:
>
> On Mon, Aug 12, 2002 at 02:32:57PM +, Tyler Durdin wrote:
> > Why not just let such a simple question go then?
It was clearly a question that had nowt to do with PHP. Even your subsequent
posts defending your positio
I know many people hate top-posts, but when you get 1400+ emails every day
and answer 50+, it sure does speed things up. Having the relevant text
right up front means I don't have to scroll down to find it. If I don't
understand the reply and need more context, that's when I scroll down to
see w
Hi Tyler:
On Mon, Aug 12, 2002 at 02:32:57PM +, Tyler Durdin wrote:
>
> Why not just let such a simple question go then?
I was being helpful by pointing you to the manual where you could find the
answer to this particular question AND a means of figuring out answers to
future questions.
I w
my post as
it was a justified. If we have nothing nice or helpful to post to one
another, then we should post nothing at all.
>From: "DL Neil" <[EMAIL PROTECTED]>
>To: "Tyler Durdin" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
>CC: <[EMAIL PROTEC
Now then, let's all play nicely together!
Dan: relevance
It is a PHP question because whereas the SQL query SELECT fred FROM tbl
produces an array element back in PHP such as $row[ "fred" ], this
convention/mapping comes well unstuck if you submit something like SELECT IF
( answer = 'a', TRUE, FA
<[EMAIL PROTECTED]>
>To: PHP List <[EMAIL PROTECTED]>
>Subject: Re: [PHP] SQL ?
>Date: Mon, 12 Aug 2002 10:26:55 -0400
>
>On Mon, Aug 12, 2002 at 02:15:23PM +, Tyler Durdin wrote:
> > SELECT *, IF (answer = 'a', TRUE, FALSE) AS Answer-A
> > What doe
On Mon, Aug 12, 2002 at 02:15:23PM +, Tyler Durdin wrote:
> SELECT *, IF (answer = 'a', TRUE, FALSE) AS Answer-A
> What does the As Answer-A mean and what does it do?
Why not examine the manual for the answer to such a basic question,
especially one that is off topic for the list you posted
[snip]
SELECT *, IF (answer = 'a', TRUE, FALSE) AS Answer-A
[/snip]
Answer-A is a handle for the data which you can use later when trying to
display the results via PHP, as in an object line;
print($data->Answer-A);
HTH!
Jay
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe
SELECT *, IF (answer = 'a', TRUE, FALSE) AS Answer-A
What does the As Answer-A mean and what does it do?
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
PHP General Mailing List (http://w
Chris,
select distinct kat from tablename;
Its in the mysql manual, 6.4.1 SELECT Syntax.
HTH
Chris
[EMAIL PROTECTED] wrote:
>Hello
>
>I have a problem with mysql.I create a table with a field "kat".In this field are
>entries like this :
>
>Light
>Dark
>Dark
>Light
>Robot
>Find
>Dark
>Light
ðÒÉ×ÅÔ!
[EMAIL PROTECTED] wrote:
> You see that all entries are not unique.So i want to list as output all entries but
>only once.If the word "Dark" is in the table 6 times php should output dark only 1
>time.
> How should i solve this problem ?
select distinct
and RTFM
:)
ÐÏËÁ
áÌØÂÅÒÔÏ
ëÉ
SELECT DISTINCT kat FROM mytable;
Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 12:40 PM
Subject: [PHP] SQL field problem
Hello
I have a problem with mysql.I create a table with a field "kat".In t
message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > You can refer to fields by their number.
> >
> > $Row[3];
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 10, 2002 10:40 AM
> > To:
ssage
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> You can refer to fields by their number.
>
> $Row[3];
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 10, 2002 10:40 AM
> To: [EMAIL PROTECTED]
> Subject
SELECT DISTINCT kat FROM tablename; should work.
Martin
>>> <[EMAIL PROTECTED]> 07/10/02 01:40PM >>>
Hello
I have a problem with mysql.I create a table with a field "kat".In this field are
entries like this :
Light
Dark
Dark
Light
Robot
Find
Dark
Light
You see that all entries are not uniqu
I think you want to use group by:
SELECT * FROM table GROUP BY kat;
--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Wed, 10 Jul 2002 19:40:11 +0200
<[EMAIL PROTECTED]> wrote:
> Hello
>
> I have a problem with mysql.I create a table with a field "kat".In
You can refer to fields by their number.
$Row[3];
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL field problem
Hello
I have a problem with mysql.I create a table with a field &quo
Hello
I have a problem with mysql.I create a table with a field "kat".In this field are
entries like this :
Light
Dark
Dark
Light
Robot
Find
Dark
Light
You see that all entries are not unique.So i want to list as output all entries but
only once.If the word "Dark" is in the table 6 times php
ect USER From DUAL)
And AUDSID =(Select USERENV('SESSIONID') From DUAL)";
great thanks in advance to michi...
^_^
- Original Message -
From: "èdy kurniawan" <[EMAIL PROTECTED]>
Subject: Re: [PHP] SQL Statement
> thanks to michi for ASAP response...
>
this is the problem:
$query = "Select OSUSER
>From v$session
Where USERNAME = (Select USER From DUAL)
And AUDSID =(Select USERENV('SESSIONID') From DUAL)";
1.
mysql does NOT support subselects!
2.
delete the "<" in front of "FROM"
3.
you have to quote "v$session": "v\$session"
start with a shor
Hello PHP mania,
I'm a newcomer right here, i just wanna ask a litle dummy question :
I put the SQL below into my SQL Plus editor :
**
Select OSUSER
>From v$session
Where USERNAME = (Select USER From DUAL)
And AUDSID =(Select USERENV('SESSIONID') From DUAL)
Uh, Mr Flesh:
On Tue, Jun 18, 2002 at 05:54:21PM +0100, Septic Flesh wrote:
>
> for $day=1 until $day=31
> {
> count how many records (rows) there are in the tracker table,
> without counting rows that contain the same "user_id" value,
> when the day=$day.
> }
What have you tried so far?
Did y
> or one line for each sess_id with only one row:
> select * from tracker where count(sess_id)=1 and day='1' and month='
> ".$month." ' group by sess_id;
sorry that was wrong!
correct:
select * from tracker where day='1' and month=' ".$month." ' group by
sess_id having count(sess_id)=1;
michi
> select * from tracker where day='1' and month=' ".$month." ' XXX";
>
> XXX = but donot return values with the same value in the "sess_id" field
>
> what should XXX be ?
one line for each sess_id
select * from tracker where day='1' and month=' ".$month." ' group by
sess_id;
or one
select * from tracker where day='1' and month=' ".$month." ' XXX";
XXX = but donot return values with the same value in the "sess_id" field
what should XXX be ?
thanks in advance...
--
Sapilas@/dev/pinkeye
--
PHP General Mailing List (http://w
I wanna make the following sql query which looks a bit complicated., and put
it in a for loop too for all days from 1 to 31.
==
for $day=1 until $day=31
{
count how many records (rows) there are in the tracker table,
without counting rows that con
My following query :
insert into acteursenc (nuacteur,nomacteur)
(select AA, BB from
(select max(nuacteur)+1 AA from acteursenc),
(select 'Michael Sweeney' BB from acteursenc))"
produces an ORA-1: unique constraint error.
The prima
";
}
Robert W. Collins II
Webmaster
New Orleans Regional Transit Authority
Phone : (504) 248-3826
Email : [EMAIL PROTECTED]
-Original Message-
From: Scott St. John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 6:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL Server
Just attempt to connect. If it succeeds, the server is alive.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Scott St. John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 6:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL Server test tool
I would imagine that you could use fsockopen to open a socket connection on
that port in order to test it.
-Jared
-Original Message-
From: Scott St. John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 8:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL Server test tool
Has
Has anyone seen or know if it is possible to use PHP to test if a SQL
server is alive on port 1433? I know I could run a query, but was looking
for something to actually test on the port.
Thanks,
-Scott
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php
Hi!
I just wrote a SQL session handler class using some info from the
example at
http://gateway.digitaria.com/~chris/php/mysql_session_handler/.
And.. everything works perfectly, until I attempt to set a session
variable, and the custom write function get's executed. It seems that
the data param
Hi,
This is more a SQL question that a php one, but here goes:
I have a table with 3 fields, Date, IP, ISP.
Basically I have written some php to store the following in the table each time
someone hits a page on my site. Now I want to display some info about the users
currently on my site, but I
nifer Downey'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 10:05 PM
Subject: RE: [PHP] SQL Warning
> > -Original Message-
> > From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
> > Sent: 24 April 2002 04:46
> >
> &g
401 - 500 of 638 matches
Mail list logo