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:31 AM
Subject: RE: [PHP] PHP SQL Code
I would like yo show
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 thats out.
Sorry,
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.
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
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 Spel
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
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
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 little about
, 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:07 AM
Cc: [EMAIL PROTECTED]
Subject: [PHP] SQL+php
Dose anyone know how to search and replace a string
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
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 being
--- 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. I
--- 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
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
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:
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 how to search and replace a string in a
mysql_query
]]
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 string in a
mysql_query output.
Yes.
---John W. Holmes
, 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 string in a
mysql_query output.
Yes.
---John W. Holmes
Message-
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
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, visit: http://www.php.net/unsub.php
--
PHP General Mailing List
: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 string in a
mysql_query output.
Yes.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP
, 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 string in a
mysql_query output.
Yes.
---John W. Holmes...
PHP Architect
.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're
.
---John Holmes...
-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 how to search and replace a string in a
mysql_query output
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 Professionals. If I read
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
\(':\)',
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
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:
You have an error in your SQL syntax near
-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
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
-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 you
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,
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, and am
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
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
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
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
]
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/Eastern, Marco Tabini wrote:
where is a reserved
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
(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 fine on my
-
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 fine.
thanks!
Jule
On Tuesday, Nov 5, 2002
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.department,
[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.
[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
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 would work
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 statement above is totally
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;
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
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
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
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
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, I'm scared...
Please excuse me but may I
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
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 works AND
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,
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,
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,
mernaj
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
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 does the As Answer-A mean and what does it do?
Why not examine the manual
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,
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 PROTECTED]
Subject: Re: [PHP] SQL ?
Date: Mon, 12 Aug 2002 15:49:45 +0100
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
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
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 position
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.
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 sure
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
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
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
this
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 unique.So i
ROTECTED]...
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
-
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 kat.In this
field are entries like this :
Light
Dark
Dark
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 this field are
entries like
ðÒÉ×ÅÔ!
[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
:)
ÐÏËÁ
áÌØÂÅÒÔÏ
ëÉÅ×
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
You see that
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 short query
('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...
but I thought your opinion not actually right..
I've a sql :
$query = Select dfl_desc
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
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
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 line for
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
--
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 you look
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)
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
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:
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
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
. 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 test tool
Has anyone seen
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
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
-Original Message-
From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2002 04:46
Would you please direct your attention to this URL
http://testphp.netfirms.com/code1.html
Look at the bottom where the big orange commented syntax is
and explain what
is going on
Subject: RE: [PHP] SQL Warning
-Original Message-
From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2002 04:46
Would you please direct your attention to this URL
http://testphp.netfirms.com/code1.html
Look at the bottom where the big orange commented syntax
Hi all,
Would you please direct your attention to this URL
http://testphp.netfirms.com/code1.html
Look at the bottom where the big orange commented syntax is and explain what
is going on there?
Thanks
Jennifer
--
The sleeper has awaken
---
Outgoing mail is certified Virus Free.
Checked by
Would you please direct your attention to this URL
http://testphp.netfirms.com/code1.html
Look at the bottom where the big orange commented syntax is
and explain what is going on there?
{$config[prefix]}
I think this should be
${config[prefix]}
... also, it's handy to actually echo
or make it
$config[prefix]
-Original Message-
From: Jason Murray [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 1:51 PM
To: 'Jennifer Downey'; [EMAIL PROTECTED]
Subject: RE: [PHP] SQL Warning
Would you please direct your attention to this URL
http
On Wed, 24 Apr 2002, Jason Murray wrote:
{$config[prefix]}
I think this should be
${config[prefix]}
Those are equivalent.
miguel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The reason why I said that is 'cause the array was inside quotes, so quoting
again would break out of the original quotes
-Original Message-
From: Miguel Cruz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 2:03 PM
To: Jason Murray
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] SQL
Hi There.
I want to ceate a query that deletes the duplicates for a certain
attributes.The table consits of a company id and a course.
If a company id and a certain course appears more than once it must be
deleted
Thank you.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
Group,
My consulting company has a fulltime open position located in Vancouver
WA. We are a fast-moving/flexible/customer driven company looking for
the same in our new PHP/SQL programmer. If interested please send your
resume and salary history to: [EMAIL PROTECTED]
Thank you for your time
On Saturday, March 30, 2002, at 06:29 PM, Alberto Wagner wrote:
$Sql_Query_Login = Mysql_Query(SELECT Nome FROM users WHERE User =
'Anyone')
There isn't a user if name Anyone...
Why
If (!$Sql_Query_Login) {
Echo Ninguem;
}
Is returning False?
The query is succeeding, it's just
401 - 500 of 618 matches
Mail list logo