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 0 or 1 I
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
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
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
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 would
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.
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
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
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');
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
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,
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
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 obviously
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
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
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/subdir
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
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
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: -
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
20 matches
Mail list logo