I have a linux RedHat 7.1 system with :
php 4.0.3
apache 1.3.20
I would like to upgrade to newer version of php, ho can supply detailed
instructions.
Thanks.
Marco Coletta
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Has anybody had any luck or tried connecting to ADS from PHP? What is
required?
Thanks,
Stewart
__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
--
PHP Database Mailing List (http://www.php.ne
Cool, I didn't know you could embed mysql_query(...) inside
mysql_fetch_row(...). That's kinda nice--I hate having a line each for
1-connecting, 2-selecting, 3-querying, and 4-resulting. I'll hafta try
that. Thanks.
Ryan
On Tue, 26 Feb 2002, Stewart Gateley wrote:
> First of all that sho
First of all that should throw an error, correct syntax is mysql_result
($query, 0) meaning to grab the 0 index returned.
I am not sure about performance wise, however I dislike mysql_result
since if nothing is returned then you get a runtime error. Instead I
like to use
list($pd) = mysql_fetch_
Pretty easy really
SELECT * FROM foo WHERE bar is NULL
- DON'T use quotes "NULL" is a valid string it is not the same as NULL
- Some DBMS's allow you to say bar = NULL but technically this is wrong
because NULL is undefined and cannot be equal to anything not even another
NULL.
- Also "" is n
Would it be faster if all you wanted was one variable, or your SQL statement
only returned on cell?
--
William Fong - [EMAIL PROTECTED]
Phone: 626.968.6424 x210 | Fax: 626.968.6877
Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED]
- Original Message -
From: "Bogda
PS. You should consider using mysql_fetch_row() or at least
mysql_fetch_array() for perforance reasons.
B
Bogdan Stancescu wrote:
> $query="query";
> $result=mysql_query($query);
> $pd=mysql_result($result);
>
> Notice the zig-zag - $query is first on the left side, then on the
> right side,
Hi Robin,
Use a standard select like you normally would, and in your where clause,
use "where [field] is null" :
select field1[, field2, ...] from table1[, table2, ...] where fieldx
is null [...]
-bsh
Robin McKenzie wrote:
>I have a table of questions, and a table of responses (initiall
$query="query";
$result=mysql_query($query);
$pd=mysql_result($result);
Notice the zig-zag - $query is first on the left side, then on the right
side, then $result is first on the left side, then on the right side.
Bogdan
Ryan Snow wrote:
>Hi, Im kinda new to this list. Can anyone tell me wh
Hi, Im kinda new to this list. Can anyone tell me what is the proper way
to interpolate my php variables into my mysql queries?
I've been trying $query = "SELECT password FROM users WHERE login='$login'";
then:
mysql_query($result);
$pd = mysql_result($result);
but I get a message that say
I have a table of questions, and a table of responses (initially empty)
which gets updated every time an answer is submitted, with the question
number, member id and response.
I wish to produce a SELECT query that will find the questions that haven't
been answered by a particular member, i.e. a
Hi there:)
Take a look at nl2br() function ..it converts \n to tag
HTH Joe :)
Jairo Tcatchenco <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi all!
>
> I have a table in postgres with a field type text, where I can
> store a formated text. Whe
Hi all!
I have a table in postgres with a field type text, where I can
store a formated text. When I take this field to my page, there's no one
html tag inside the content displayed. Can I read the content of the
field, line by line, putting a at the end? How can I do something
like
try setting NLS_LANG="AMERICAN_AMERICA.WE8MSWIN1252 or ENGLISH.UNITED
KINGDOM.WE8MSWIN1252 in php.
That should work.
-Original Message-
From: michele campeotto [mailto:[EMAIL PROTECTED]]
Sent: 26 February 2002 15:53
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP, Oracle and iso-8859-1 charac
Would you have an example of that?
Jas
"Beau Lebens" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> rather than all the hidden fields and stuff you guys are trying to do -
why
> not just build the array variable you want, then save it into a session,
on
> the n
Hello,
I have a database that contains text with accented vowels (àèéìòù).
They are displayed just fine when accessing the database from Java/JSP
pages on the same machine and DB, but from PHP I get the vowels without
the accent (à => a, è => e).
The database uses UTF-8 encoding.
Platform i
Hi,
Thanks for the input,
I'll stop messing around and post some code
Be warned this code is untested :-)
It's kinda like thinking out loud.
I think this should produce a nested list output from a query.
Given this query :
SELECT count(zip) AS zipcount,zip,cust_last_name
FROM customers
GROUP BY
You can use PHP to send mail.
If you wish to set it up:
Open the php.ini and look for:
[mail function]
; For Win32 only.
SMTP= this will be your smtp server; for Win32 only
; For Win32 only.
sendmail_from= this will be your email address; for Win32 only
; For Unix only. You may supply argument
Dear Bartlomiej Pawlik,
Try:
LONG TEXT 1
LONG TEXT 2
LONG TEXT 3
Greetings,
Maarten Verheijen
- Original Message -
From: "Bartek Pawlik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 11:11 AM
Subject: [PHP-DB] PHP problem
Sorry to be a little bit off
Not entirely sure what you're trying to do, but would it be sensible to
use...
$sql="SELECT * FROM Customers ORDER BY zip ASC";
.
.
and then when you've got the results...
if ($myrow = mysql_fetch_array($result)) {
$zip=0;
$zipcount=0;
do {
if ($zip!=$myrow[
Hi Rudi,
> I've done this before in coldfusion.
> It's the one thing I'm note sure on how to do the same(ish)
> in PHP - my language of choice.
> If we have the record set the CF code would look like
>
>
>
> #zip#
>
>
> #customer#
>
>
>
>
>
> So I'm think also to use 2 loops for the sam
Bartek,
This is snipped from a working form on my site:
contains
exact match
begins with
and it works.
George
- Original Message -
From: "Bartek Pawlik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 10:49 AM
Subject: Odp: [PHP-DB] PHP pro
Hi Rudi,
> I've been struggling for a while now so I thought I'd ask.
> What's the easiest way to for to print group sql output.
> For example I need to output customers grouped by zip.
> Like:
> zip
> customer a
> customer b
> zip
> customer d
> customer e
> zip
> customer c
> custoemr f
> custo
Hi all,
I have a site where dates are being displayed and also entered by users. I
don't want to offend them by asking them to use the -mm-dd format or to
split the date into its constituent parts.
I am displaying by using the MySQL Date_Format syntax and that's fine. I get
dd/mm/ and I
Unfortunately, it doesn't work,
the same situation
> > Sorry to be a little bit off topic
> > i have code that generates:
> > LONG TEXT 1
>
> use:
> long text 1
>
> mvgr,
> Joffrey van Wageningen
>
> --
> .-[ Joffrey van Wageningen | WoLFjuh | [EMAIL PROTECTED] ]--
> | Networking
CrossWalkCentral,
> any one know how to use send mail with windows instead of linux. Will
> this work are their other options?
Beware of crosswires!
Yes one can send mail (the activity of email) from PHP running on Windows.
I wouldn't bother with loading sendmail (the name of the package) onto
Hi,
I've done this before in coldfusion.
It's the one thing I'm note sure on how to do the same(ish)
in PHP - my language of choice.
If we have the record set the CF code would look like
#zip#
#customer#
So I'm think also to use 2 loops for the same purpose in PHP.
Can I do this from
Thanks Sven,
I've already got the sql OK.
I have the records set but I want to print it "report like"
So It's needs some thing like a loop with an inner loop
Like
zip
customer
customer
zip
customer
customer
Hope this makes sense.
I'll elaborate more if you think I should.
Cheers
Rudi.
Hi friends,
I've been struggling for a while now so I thought I'd ask.
What's the easiest way to for to print group sql output.
For example I need to output customers grouped by zip.
Like:
zip
customer a
customer b
zip
customer d
customer e
zip
customer c
custoemr f
customer g
Do I need to bui
- Original Message -
From: "Bartek Pawlik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 11:11 AM
Subject: [PHP-DB] PHP problem
> Sorry to be a little bit off topic
> i have code that generates:
> LONG TEXT 1
use:
long text 1
mvgr,
Joffrey van Wageningen
Sorry to be a little bit off topic
i have code that generates:
LONG TEXT 1
LONG TEXT 2
LONG TEXT 3
in the script I check value of $xxx and I get i.e. LONG TEXT 1 despite of 1. Do you
have any idea on this.
PS. Placing at the end of each line doesn't help
thanks in advance
Bartlomiej Pawli
31 matches
Mail list logo
