I'm not sure if there is an SQL statement, but a short amount of PHP code
will do this...
just run thru each row you need to check, and do
while ($myrow = mysql fetch row ($result)) {
$mailboxsize += strlen( $myrow["emailbody"] );
}
Siggy
- Original Message -
From: "phpLover" <[EMA
Hi,
I'm having problems compiling the latest version of php4 with db2 support.
The configure script runs properly, but make bombs out saying:
"In file included from internal_functions.c:38:
/home/csbook/php-4.0.4pl1/ext/odbc/php_odbc.h:16: sqlcli.h: No such file or
directory
I have db2 installe
I am sorry for posting this question here. I cannot find any mySQL news
group so please bear this question here.
I have made an online email sort of system and backend database is MySQL for
all inbox messages. To every user, I give 1mb space for his inbox. Now I
want to see if a users inbox excee
Here you go:
Error " . mysql_errno() . ": " . mysql_error() .
"");}
else{echo("Query executed successfully!");}
?>
-Jim
- Original Message -
From: "Marc Bragg" <[EMAIL PROTECTED]>
To: "Jim" <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 4:50 PM
Subject: Re: [PHP-DB] parsing error
> if ($result == 0);
You have a wrong semicolon at the end of the line above.
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Original-
De: Marc Bragg <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: sábado, 3 de fevereiro de 2001 20:44
Assunto: [PHP-DB] parsing error
>
Another strange error, parsing:
Error " . mysql_errno() . ": " . mysql_error() . "");
elseif (mysql_num_rows($result) == 0);
echo("Query executed successfully!");
else:
?>
on the 'elseif' statement.
suggestions? is there a parse checker, that identifies errors?
--
PHP Database Mailing List (
This is an invitation to you to visit a new Web site, THE SCHENK
REPORT (http://www.SchenkReport.com), where the subjects are politics
and culture from a generally liberal point of view.
THE SCHENK REPORT features:
**Insightful commentary, generally from the left but sometimes veering
off in ot
Why would the following:
give me an error message, unable to parse the first line . . .$host ?
any help appreciated. thanx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list adm
Never used pgsql; but try DEFAULT NOW() NOT NULL ??
Siggy
- Original Message -
From: "Cameron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 5:18 AM
Subject: [PHP-DB] mysql to pgsql
> can someone help me convert this to do the same in pgsql? below is the
can someone help me convert this to do the same in pgsql? below is the
current structure for one item in my database, i need pgsql to be able
to produce the same results as what mysql is currently. suggestions?
i want the database to return the current date when "nothing" is
inserted into that fi
Addressed to: Nashirak Bosk <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from Nashirak Bosk <[EMAIL PROTECTED]> Sat, 03 Feb 2001
04:05:07 -0500
>
> I am writing a PHP script that accesses a MYSQL database when the
> adminstrator (the client) wants to add something to a ca
Assuming one of the fields in the row of timedate type, you can just do
DELETE FROM table WHERE datefield BETWEEN #date# AND #otherdate#
#date# can be something old like 1980-01-01 and #otherdate# is simply 28
dayes ago...
See mktime()
Siggy
- Original Message -
From: "Nashirak Bosk"
I am writing a PHP script that accesses a MYSQL database when the
adminstrator (the client) wants to add something to a calendar
(dynamically PHP generated). I have written the callendar and have the
whole thing setup to be able to update it regularly, through a easy user
interface on the admin
13 matches
Mail list logo
