i dont know if this will work, but you can try selecting them in the
query... i.e.:
select * from database.table
I am by no means a guru on sql queries, but it may work.
-Original Message-
From: PHP freak [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 08, 2002 8:39 PM
To: [EMAIL PROTECT
How would you keep two different MySQL connections to two different MySQL databases
(on two different MySQL servers) up and available with two different pointers (id),
and not need to always do "select_db()" to switch between them?
I thought that if I did this:
--- php: -
$
However, on a different, FreeBSD platform, this is not the case. A linked
file can call an include and have the desired file be called instead of the
source one. That's where I'm getting confused.
- Jonathan
-Original Message-
From: olinux [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 0
You must use absolute paths in includes. essentially
the include will reference itself as the starting
point, rather than the script you are calling it from.
olinux
--- Jonathan Hilgeman <[EMAIL PROTECTED]> wrote:
> I'm on a red hat system, and I've soft-linked two
> directories:
> /www/dir1/su
Hi guys,
does anybody know where to get freetype 2 for win2k as a binary? I did try
it on freetype.org and through google but all links seem to lead to nothing.
Maybe someone has the .dll already installed on his machine. If so, please
send me a copy I would appreciate it.
Thanx for any help
A
Leif,
IF i understood this correctly you would like to add up the values of a
particular column and return it to PHP with a different name right?
You can do:
$query="select sum(column_name) as nameyouwant from tablename"; // this will
return the sum of the column in a column called nameyouwant
$r
PEAR, Metabase, and ADODB are all good db abstraction packages with
their respective merits. But if your looking for something simple,
efficient, for mysql only try:
http://www.phpclasses.org/browse.html/package/107.html
The package contains basic connection, sql command, and recordset
classes. I
list($sum)=mysql_fetch_assoc(mysql_query('SELECT SUM(salary') FROM employes;'));
Best regards,
Andrey Hristov
On Friday 08 March 2002 09:17 pm, you wrote:
> I need to add up the (integer) values of columns, and return the added up
> value as one column to php. Is this possible? Or is there som
Here's an example for how to select the sum of a column in SQL. Maybe that
will help.
-Natalie
http://www.devguru.com/Technologies/jetsql/quickref/sum.html
> -Original Message-
> From: Leif K-Brooks [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 08, 2002 2:17 PM
> To: [EMAIL PROTECTE
I need to add up the (integer) values of columns, and return the added up
value as one column to php. Is this possible? Or is there something else
to do it? (I'd rather not have to mysql_fetch_array() in a while loop and
add it up there, it might be a lot of rows)
--
PHP Database Mailing List
on 3/8/02 1:04 PM, Michael Zornek at [EMAIL PROTECTED] appended the
following bits to my mbox:
> I'm looking for a good MySQL db abstraction layer. I'm just coming back to
> PHP/MySQL and rather writing my own I figured I'd try to see if any are
> already out there.
>
> The layer should obviousl
Try those provided in PEAR(in the distro).
Best regards,
Andrey Hristov
On Friday 08 March 2002 08:04 pm, you wrote:
> I'm looking for a good MySQL db abstraction layer. I'm just coming back to
> PHP/MySQL and rather writing my own I figured I'd try to see if any are
> already out there.
>
> The
I'm looking for a good MySQL db abstraction layer. I'm just coming back to
PHP/MySQL and rather writing my own I figured I'd try to see if any are
already out there.
The layer should obviously have the basics, of connect, query, and close,
and possibly some error checking and handling.
thanks,
My limited understanding of Unix hard and soft links is that
/www/dir2/subdir is not a directory, it is a pointer to the inode that
is pointed to by /www/dir1/subdir. I think to accomplish what you want,
/www/dir2/subdir would have to be a true directory, filled with soft
links to each of the
You may try to put session_start(); at the most begining.
But should you also add a session path first?
"Ryan Snow" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> when I do:
> session_start();
> session_register('signor');
> session_r
On Fri, 8 Mar 2002, Robert V. Zwink wrote:
> The simple answer might be:
>
> SELECT member.*
> FROM `member`
> WHERE DAYOFYEAR(member_dob) >= DAYOFYEAR(CURDATE())
> ORDER BY member_dob DESC LIMIT 1
>
> Seems to work for me.
Not for me. I think it should be ordered like this:
ORDER BY DAYOFYEAR(
The simple answer might be:
SELECT member.*
FROM `member`
WHERE DAYOFYEAR(member_dob) >= DAYOFYEAR(CURDATE())
ORDER BY member_dob DESC LIMIT 1
Seems to work for me. The problem is that it wouldn't support members that
have a birthday on the same day :) To solve that I would select the next
bi
No. Some mail servers (qmail for sure) have the user auth section seperated
from the piece that accepts mail from the internet. As long as the mail is
for the correct domain, it will accept it, and passes it to a seperate
program that checks for the user and either bounces or delivers the mail.
hi there,
is there any way to check the existence of an e-mail address without
sending an email?
i mean not only DNS lookup, but also user validation?
10x,
cristi radulescu
http://translator.urbanxp.org
http://www.urbanxp.org
ML> On Fri, 2002-03-08 at 04:10, CrossWalkCentral wrote:
>> How wou
On Fri, 2002-03-08 at 04:10, CrossWalkCentral wrote:
> How would I go about doing the DNS look up part?
with checkdnsrr() I'd assume:
checkdnsrr($host)
"Searches DNS for records of type type corresponding to host. Returns
TRUE if any records are found; returns FALSE if no records were found or
mysql_affected_rows(int resource_id);
This will return the number of rows that were affected by the last
operation, so you could do something like this:
if(mysql_affected_rows($connection) == 1){
//insert, update or delete succeeded
}else{
//operation failed
}
- Original Message --
I have a table called 'members' with a field (among many others)
'member_dob' - the birthday of a particular member. The data type of this
field is date (-mm-dd).
What I'd like to do now is to fetch one particular row from the database
(I am using MySQL 3.23.37) - namely the row of the member
Hi Chris
> I have delete working perfectly by doing the following:
>
> include("connectionstart.php");
>
> mysql_query ("DELETE FROM emaillist WHERE EMail = '$email'
> ");
>
> However, how do I return a true or false flag whether the row was
deleted or
> not? I basically need to know how to do a
23 matches
Mail list logo
