e-
From: Chaitanya Yanamadala mailto:dr.virus.in...@gmail.com>>
Date: Fri, 09 Apr 2010 19:26:22
Cc: mailto:php-db@lists.php.net>>
Subject: Re: [PHP-DB] mysql/php time out issue
have u checked max_execution_time
Chaitanya
On Fri, Apr 9, 2010 at 7:17 PM,
-Original Message-
From: Chaitanya Yanamadala mailto:dr.virus.in...@gmail.com>>
Date: Fri, 09 Apr 2010 19:26:22
To: Stephen Sunderlinmailto:stephen.sunder...@verizon.net>>
Cc: mailto:php-db@lists.php.net>>
Subject: Re: [PHP-DB] mysql/php time out issu
-3753
>
> -Original Message-
> From: Chaitanya Yanamadala
> Date: Fri, 09 Apr 2010 19:26:22
> To: Stephen Sunderlin
> Cc:
> Subject: Re: [PHP-DB] mysql/php time out issue
>
> have u checked max_execution_time
>
>
> Chaitanya
>
>
>
> On Fri, Ap
have u checked max_execution_time
Chaitanya
On Fri, Apr 9, 2010 at 7:17 PM, Stephen Sunderlin <
stephen.sunder...@verizon.net> wrote:
> I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to loop
> through a while statement to send about 3000 email using phpmailer. It's
> work
I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to
loop through a while statement to send about 3000 email using
phpmailer. It's worked well in the past but after an upgrade it seems
to be timing out now after 200-300 emails over 1 minute or two. I've
added set_time_limi
YVES SUCAET wrote:
Hi Chris,
I don't need 120 concurrent connections. The problem arises from subsequently
opening connections and the script is a way to simulate the problem: the
first
100 connections e.g. open up fine; then the next 5 mess up; then the next 7
are good to go again etc...
I'm u
basic PHP php_mysql.dll driver. I've used MDB2 from PEAR as
well: same result. I think both of these use the C API, and not the
ODBC-driver.
Yves
-- Original Message --
Received: Thu, 12 Mar 2009 04:30:33 PM CDT
From: Chris
To: YVES SUCAET Cc: php-db@lists.php.net
Subject: Re: [PHP-
YVES SUCAET wrote:
Hi List,
I'm experiencing the problem as described at
http://forums.mysql.com/read.php?37,39779,136287#msg-136287
I'm using the following script to test:
Results are very unpredictable. E.g. out of 120 connection attempts, I'll have
114 successes and 6 failures.
Well to
Hi List,
I'm experiencing the problem as described at
http://forums.mysql.com/read.php?37,39779,136287#msg-136287
I'm using the following script to test:
Results are very unpredictable. E.g. out of 120 connection attempts, I'll have
114 successes and 6 failures.
The solution that's mentioned
test both and let us know
bastien
From: "Andrew Darby" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQL/PHP Left Join Question
Date: Thu, 25 May 2006 12:33:15 -0400
Thanks to Bastien and TG for their suggestions. I'd been looking at
it Basti
Thanks to Bastien and TG for their suggestions. I'd been looking at
it Bastien's way, but TG's is probably better suited to what I want to
do. I'd forgotten about that possibility, cramming it all into an
array . . . .
Again, thanks for the help,
Andrew
p.s. I'd be curious about the relative
Some good examples of how to deal with this in PHP have already been
given, especially the associative array solution.
The question I have is with something like this, how do you weight out
the pros/cons of code development versus speed?
i.e. for code development breaking the logic up into 2 qu
$rows['title']."";
$oldDVD = $rows['title'];
}
//echo out the rest of the data
echo "".$rows['comment']."";
}
hth
Bastien
From: "Andrew Darby" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL/PHP
One thing I've done in situations like this is just load your returned DB data
into an array. Something like this would do:
$dvdarr[$result['call_number']]['Title'] = $result['title'];
$dvdarr[$result['call_number']]['Publisher'] = $result['publisher'];
$dvdarr[$result['call_number']]['Comments
Hello, all. I don't know if this is a php-mysql question or just a
mysql, but here goes:
I have a list of DVDs that my library loans out, and I'd like to allow
people to add comments to each item. Since this list gets regenerated
periodically (it's extracted from another system, the library
cat
This is what I use when needing to do this:
1. Put all the values you want to search for in an array $vals (loop
around the first result)
2. $query = "
select count(Nome) from Aeromodelistas
where year(AnoQuota)=2005
and Sexo='Masculino' and Distrito IN ".sqlIn($vals)
;
function sq
Hi
I have two MySQL databases, on for aeromodelistas (aeromodelling) and
another for Códigos Postais (Postal Codes). I whant to do the
following query
SELECT CódigoPostal FROM Aeromodelistas
WHERE CódigoPostal IN
(SELECT distinct(CP4) FROM codigopostal.LOCART,codigopostal.DISTRITO
WHERE co
James wrote:
I'm pretty new to this...I've set this book example up on my PC and it's
fine.
I've attempted this on two Macs...
Here's the error I get when I try to run the application. What does the
error mean?
UNHANDLED ERROR on line 84 in
/Library/WebServer/Documents/wda2-winestore/index.ph
I'm pretty new to this...I've set this book example up on my PC and
it's fine.
I've attempted this on two Macs...
Here's the error I get when I try to run the application. What does
the error mean?
UNHANDLED ERROR on line 84 in
/Library/WebServer/Documents/wda2-winestore/index.php.
[PHP Error
On Tue, 2005-02-08 at 16:07 -0500, J. Connolly wrote:
> Is there a site that someone could recommend that does PHP, Mysql
> hosting? If they do .NET that would be good also. This is for practice
> and development not for a company so I am looking to keep the costs
> down. There are so many sites
You could also try www.vitalspeeds.com they dont host any microsoft
stuff like .Net or ASP but they are reliable and cheap. Hope this helps.
Regards,
Marcus Joyce
J. Connolly wrote:
Is there a site that someone could recommend that does PHP, Mysql
hosting? If they do .NET that would be good also
joe,
thanks for the advicei just can't host where i work and trying to
develop only on my laptop only at work is becoing tedious. The sys admin
is not happy about me running iis or apache on my laptop here. But at
least I didn't ask how you how to configure my php and mysql
richard,
thank
i buy my hosting on ebay. haven't had a problem
bastien
From: "J. Connolly" <[EMAIL PROTECTED]>
To: PHP list
Subject: [PHP-DB] MySQL PHP hosting
Date: Tue, 08 Feb 2005 16:07:47 -0500
Is there a site that someone could recommend that does PHP, Mysql hosting?
If they do .N
Is there a site that someone could recommend that does PHP, Mysql
hosting? If they do .NET that would be good also. This is for practice
and development not for a company so I am looking to keep the costs
down. There are so many sites, I thought maybe someone here might have a
good solution.
j
I'm confused.
I replied to your inquiry to tell you what information you need to
provide if you are to receive help.. Why are you asking me questions
about *your* problem?
And keep the discussion on the list.
Doug
Mike Ni wrote:
Do you know for certain whether it is a matter of
installati
On Mon, 1 Mar 2004 17:16:01 -0800 (PST), Mike Ni wrote:
>Hey everyone,
>
>
>Does anyone outhere is running Apache/Linux/PHP/Mysql?
>
>I am having hard time with "MYSQL PHP API". Apache/PHP
>simply would not recognize any cmysql function call
>such as "mysql_connect".
>
>I have recompile the php wi
Hey everyone,
Does anyone outhere is running Apache/Linux/PHP/Mysql?
I am having hard time with "MYSQL PHP API". Apache/PHP
simply would not recognize any cmysql function call
such as "mysql_connect".
I have recompile the php with mysql extension and th
problem continue tobe there.
I run the
From: "Will Contact" <[EMAIL PROTECTED]>
(B
(B> Now I am programming php+mysql. I put word, excel, mpeg and
(B> any binaries into
(B> the mySQL database using php on linux server,But I can take out these
(Bbinay
(B> from mySQL database. I would like to see the files and save my pc from
(B>
to:[EMAIL PROTECTED]
(BSent: Monday, December 08, 2003 1:10 PM
(BTo: [EMAIL PROTECTED]
(BSubject: [PHP-DB] mysql + php
(B
(Bhi!
(B
(BI am first question of php in this news group. I would like to ask my question about
(Bphp + mysql. Now I am programming php+mysql. I put word,
hi!
(B
(BI am first question of php in this news group. I would like to ask my
(Bquestion about
(Bphp + mysql. Now I am programming php+mysql. I put word, excel, mpeg and
(Bany binaries into
(Bthe mySQL database using php on linux server,But I can take out these binay
(Bfrom mySQL data
El Jue 28 Ago 2003 17:20, Ignatius Reilly escribió:
> Well, you're certainly right (except I didn't get the meaning of 'FS' -
> anything obscene?). However:
File System.
> 1. The job of this ML is to help people get things done
> 2. For criticisms concerning the design of MySQL, you may get bette
Beckman"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 9:37 PM
Subject: Re: [PHP-DB] MySQL, PHP or ghost?
El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió:
> Well, it IS logical provided one is aware of the rules of the game,
> meaning, as you rig
El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió:
> Well, it IS logical provided one is aware of the rules of the game,
> meaning, as you rightly point out, that MySQL does not reject SQL
> statements for incorrect values, but attempts at converting them "at any
> price". I have no clue whether i
kman"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 2:36 PM
Subject: Re: [PHP-DB] MySQL, PHP or ghost?
El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió:
> Hmmm...
>
> You have a point; the doc is not quite clear.
>
> "Illegal YEAR
El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió:
> Hmmm...
>
> You have a point; the doc is not quite clear.
>
> "Illegal YEAR values are converted to "
>
> My understanding is that any illegal value will be first converted into
> '', then into the corresponding year inside the 1901-2155
e logical. I have no quarrel with this behaviour.
Ignatius
_
- Original Message -
From: "Peter Beckman" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 4:13 PM
hing in the way of an
explanation.
I'm just as puzzled by this as Peter is/was and I'm just interested in the
explanation. I'm not trying to start an argument here.
Rich
> -----Original Message-
> From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August
On Wed, 27 Aug 2003, Ruprecht Helms wrote:
> you have chosen a wrong format. The format for year is . With string
> the field years don't know what to do.
Right -- and if it doesn't know what to do, why would it insert a value
that isn't correct and not give me an error? It does give a war
er Beckman [mailto:[EMAIL PROTECTED]
Sent: 27 August 2003 15:29
To: Griffiths, Daniel
Subject: RE: [PHP-DB] MySQL, PHP or ghost?
On Wed, 27 Aug 2003, Griffiths, Daniel wrote:
> mysql will default to 2000 for a year value if you pass it "" as an entry
> because it will accept short
Hi Peter Beckman,
> Seems that either I don't understand mysql, or something.
>
> My table, with the non-important things removed...
>
> mysql> explain plate;
>
> +-+---+--+-+-++
> | Field | Type
Peter, et al --
...and then Peter Beckman said...
%
% On Wed, 27 Aug 2003, David T-G wrote:
%
% > Looks like it, though I admit that the manual doesn't adequately explain
% > your results. Check out section 6.2.2.4 for details.
%
% I did; see my previous (moments ago) email on my read on that
On Wed, 27 Aug 2003, David T-G wrote:
> Looks like it, though I admit that the manual doesn't adequately explain
> your results. Check out section 6.2.2.4 for details.
I did; see my previous (moments ago) email on my read on that manual
section.
> % So my assumption is that if I insert with y
t;" is nothing. if you want to default to this year pass it NOW().
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: 27 August 2003 02:40
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL, PHP or ghost?
Seems that either I don't understand mysql, or something.
On Wed, 27 Aug 2003, Ignatius Reilly wrote:
> Read the MySQL manual.
Hmmm, I thought I did. 6.2.2.4:
Illegal YEAR values are converted to .
> "0" value is interpreted as 2000.
> Your empty string is converted to an integer, thus 0.
What confuses me (what I can't find) is why a quoted emp
Peter --
...and then Peter Beckman said...
%
% Seems that either I don't understand mysql, or something.
Looks like it, though I admit that the manual doesn't adequately explain
your results. Check out section 6.2.2.4 for details.
%
% My table, with the non-important things removed...
...
%
August 27, 2003 3:39 AM
Subject: [PHP-DB] MySQL, PHP or ghost?
> Seems that either I don't understand mysql, or something.
>
> My table, with the non-important things removed...
>
> mysql> explain plate;
>
+-+---+--+-+-
Seems that either I don't understand mysql, or something.
My table, with the non-important things removed...
mysql> explain plate;
+-+---+--+-+-++
| Field | Type | Null | Key | Default
A quick google search produced this:
Creating XML from MySQL (it also talks about importing XML)
http://www.zdnet.com.au/builder/architect/database/story/0,234918,20266023,00.htm
On Wed, 11 Jun 2003 21:53:56 -0500, [EMAIL PROTECTED] wrote:
> Is there an automatic way to insert an XML file
Is there an automatic way to insert an XML file into a MySQL DB through say,
Load Data InFILE?
Or does one have to Pick apart the XML with PHP and insert data into the
fields one by one, record by record?
/T
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://
moin,
sorry, my php-knowledge is not the best.
what do you mean with formfieldvalues?
i think $info->value is used to get the id3-tag info from the class,
right? this worked for me in a more simple way without the recursive
scan:
load("test.mp3");
$abfrage ="insert into mp3 (
well, you are right. the dir '/mp3' does not exist. 'mp3' is a subdir
from my htdocs dir. so i think the right path should be
'mp3/someartist/somesong', right?
i fixed that, but the original problem is still the same :(
> hmmm,
> maybe this code..
>
> $info->load("/".$dir.$file);
>
> if $dir =
On Saturday 07 June 2003 11:20, Allowee wrote:
> hmmm,
> maybe this code..
>
> $info->load("/".$dir.$file);
>
> if $dir = mp3s and $file = test.mp3
> then it will load '/mp3s/test.mp3'
>
> you got that directory?
> I've seen the class and you are hiding the fopen error message, which could
> be the
Hi,
> Where do you get $info2 from?
> I only see $info in this function.
I guess that the $info->values are formfieldvalues.
$info->[db-field] is normaly used within a whileloop for
outputing a select-statement.
In the case of formfieldvalues you can use $.
> .: Allowee
>
> > function scan_dir(
hmmm,
maybe this code..
$info->load("/".$dir.$file);
if $dir = mp3s and $file = test.mp3
then it will load '/mp3s/test.mp3'
you got that directory?
I've seen the class and you are hiding the fopen error message, which could be
the problem.
.: Allowee
On Saturday 07 June 2003 11:11, Ole Hornau
hi allowee,
sorry, this was not meant to be. $info2 is supposed to be $info. my
fault. but that is not the actual problem.
> Hi,
>
> Where do you get $info2 from?
> I only see $info in this function.
>
> .: Allowee
>
> > function scan_dir($dir)
> > {
> > $info = New mphp3(2);
> >
> >
Hi,
Where do you get $info2 from?
I only see $info in this function.
.: Allowee
> function scan_dir($dir)
> {
> $info = New mphp3(2);
>
> $handle = @opendir($dir);
> while ($file = @readdir ($handle))
> {
> if (eregi("^\.{1,2}$",$file))
> {
> continue;
hi,
i put a script together to scan a directory and its subdirectories for
all mp3 files. the tag informations and path then should be put into a
mysql database.
i included a script called mphp3.php from http://res.crea-bmb.de/mphp3/
which returns the needed tag info from one file.
the script to
Jason Wong wrote:
On Sunday 30 March 2003 11:11, Bruce Feist wrote:
I wonder why the PHP/MySql interface doesn't simply return dates as
dates instead of strings. *frowns*
How do you mean? PHP doesn't have a date type.
Ummm That's a good reason! As I said, I'm a newbie to PHP, and
somewhere
On Sunday 30 March 2003 11:11, Bruce Feist wrote:
> I wonder why the PHP/MySql interface doesn't simply return dates as
> dates instead of strings. *frowns*
How do you mean? PHP doesn't have a date type.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Inte
I originally wrote:
when I retrieve a date from MySQL into PHP, it shows up as a string instead of a date data type
> What's the best way of controlling date format?
John W. Holmes replied:
If you want a Unix timestamp, which is compatible with the date()
function in PHP, then use the UNIX_TIMES
> I'm experienced with SQL, but new to MySql and PHP, which I'm using
> together to create a dynamic web site. Right now, I'm having minor
> difficulties with date formatting. It seems that when I retrieve a
date
> from MySQL into PHP, it shows up as a string instead of a date data
> type, with f
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create a dynamic web site. Right now, I'm having minor
difficulties with date formatting. It seems that when I retrieve a date
from MySQL into PHP, it shows up as a string instead of a date data
type, with format
Thanks got it working
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
BTW... you'll need something in the anchor:
while ($row= mysql_fetch_array($result)) //retrieve a row and store in
echo "Something";
-Original Message-
From: Ryan Jameson (USA)
Sent: Monday, February 17, 2003 12:16 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP
while ($row= mysql_fetch_array($result)) //retrieve a row and store in
echo "";
That's how I'd do it.
<>< Ryan
-Original Message-
From: G [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 8:16 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql +
Hi I was wonder if any knows how 2 display sound clips held in a mysql
database using a php page ? I have stored the urls of the clips in
mysql database and I belive I need some like to (below) to display them
but its not quite working.
while ($row= mysql_fetch_row($result)) //retrieve a row
like the above.
Aaron
-Original Message-
From: Ro Stonemountain [mailto:[EMAIL PROTECTED]]
Sent: January 9, 2003 10:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] [mysql - php] Newline to BR problem
I'm trying to place a text from a textfield into a database and
displaying
it on an
I'm trying to place a text from a textfield into a database and displaying
it on another page. All works fine and well but my problem is:
If i place newline characters (press enter) in the forms textfield they
don't show up on my display page. This is logical because newlines are not
codes. So i
Ok, I've been racking my brain trying to figure this one out, so
I thought I'd post the question here and see who bytes. =)
I have a table:
id INTEGER, PRIMARY KEY
parentid INTEGER DEFAULT (0)
name VARCHAR(32) NOT NULL
Ok, and I am using this structure to make a kind of drill down
structure, so
> -Original Message-
> From: Micah Stevens [mailto:[EMAIL PROTECTED]]
> Sent: 23 September 2002 18:09
>
> I've been running into a strange problem on my server with
> scripts that
> take form input and reformat it into SQL. It only happens
> with statements
> that insert or update dat
Hi,
I've been running into a strange problem on my server with scripts that
take form input and reformat it into SQL. It only happens with statements
that insert or update data, the first four characters of the POST variables
starting at the fourth variable passed are dropped.
So lately if I
Sent: Friday, August 30, 2002 2:54 AM
To: 'Bryan McLemore'; PHP LIST
Subject: RE: [PHP-DB] MySQL/PHP
try a little thought...
http://www.google.com/search?sourceid=navclient&q=php+mysql+tutorial
// -Original Message-
// From: Bryan McLemore [mailto:[EMAIL PROTECTED]]
// Sent
try a little thought...
http://www.google.com/search?sourceid=navclient&q=php+mysql+tutorial
// -Original Message-
// From: Bryan McLemore [mailto:[EMAIL PROTECTED]]
// Sent: Friday, 30 August 2002 2:52 PM
// To: PHP LIST
// Subject: [PHP-DB] MySQL/PHP
//
//
// Where can I fi
Where can I find a good manual/tutorial on how to access mySQL w/PHP. Keep in mind
that I am new to both PHP and mySQL, and my database theory is sketchy at best.
Thanks.
Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2002 7:20 AM
To: 'Jason'; Php-Db
Subject: RE: [PHP-DB] MySQL/PHP Update
Jason, this is intriguing.
Please show us a bit more code before the mysql_query() call.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent:
On Thursday 28 March 2002 17:04, cristi radulescu wrote:
> i think the problem is bad syntax:
> you should try:
>
> mysql_query("update prod_list set prod_manu=$prod_man where
> sku='".$prod."'");
>
> that is because when you have single quotes you will not evaluate the
> expression so your querry
Jason, this is intriguing.
Please show us a bit more code before the mysql_query() call.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:54 AM
To: Php-Db
Subject: [PHP-DB] MySQL/PHP Update
I'm trying to update my MySQL database, b
i think the problem is bad syntax:
you should try:
mysql_query("update prod_list set prod_manu=$prod_man where sku='".$prod."'");
that is because when you have single quotes you will not evaluate the
expression so your querry will do the update only for sku equally with
the string '$prod'...
ho
Jason a écrit :
> I'm trying to update my MySQL database, but it doesn't seem to be taking.
>
> my code is:
>
> mysql_query("update prod_list set prod_manu=$prod_man where sku='$prod'");
>
> where
> prod_manu is an int
> $prod_man is an int
> sku is a varchar
> $prod is text
>
>
> I'm trying to update my MySQL database, but it doesn't seem to be taking.
> my code is:
> mysql_query("update prod_list set prod_manu=$prod_man where sku='$prod'");
Try: mysql_query("update prod_list set prod_manu='$prod_man' where
sku='$prod'");
Maxwell
--
PHP Database Mailing List (http:
I'm trying to update my MySQL database, but it doesn't seem to be taking.
my code is:
mysql_query("update prod_list set prod_manu=$prod_man where sku='$prod'");
where
prod_manu is an int
$prod_man is an int
sku is a varchar
$prod is text
mysql_query() comes back successful, and
On Wed, 2002-02-20 at 13:16, Sven Jacobs wrote:
> You can do it like this
> calculate the current day and extract 7 days of it
ehm? extract 7 days of it? from what?-) I'm not quite following...
> then with an array the current day until the calculated day :-)
ehm, call me stupid, but I didn'
Hello, all!
Can anyone tell me how to easily calculate which days are on which week?
ie, week 8 : 18. Feb -> 24. Feb? I retrieve information from a database
on a weekly basis, and I'd like print out what range of dates are on a
specific week. I know about date("W"...), but I really don't want to
Jonathan,
[have put the cc back to the list]
> Is it possible to make BOTH the date and venue into a single unique index?
=Why not? Like a good woman, treat her right, and SQL will do almost anything for you:
6.5.3 CREATE TABLE Syntax
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create
MAIL PROTECTED]>
Cc: "[PHP-DB]" <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 3:47 PM
Subject: Re: [PHP-DB] MySQL / PHP Database Help
> What does bool(false) mean?
>
> Thats off the vardump
>
> -J
>
> - Original Message -
> From: "Jer
lto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 8:48 AM
To: Jeroen Timmers
Cc: [PHP-DB]
Subject: Re: [PHP-DB] MySQL / PHP Database Help
What does bool(false) mean?
Thats off the vardump
-J
- Original Message -
From: "Jeroen Timmers" <[EMAIL PROTECTED]>
To: &q
What does bool(false) mean?
Thats off the vardump
-J
- Original Message -
From: "Jeroen Timmers" <[EMAIL PROTECTED]>
To: "Jonathan Underfoot" <[EMAIL PROTECTED]>
Cc: "[PHP-DB]" <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 8:
Jonathan,
I'm trying to write a script that checks for multiple entries on a table in a
database. So far I've been
plagued by MySQL errors. I'm fairly confident my scripting is ok (Then again, I've
been wrong before.) I think
moreover there might be some difficulty with my theory. Then agai
ssage-
From: Jonathan Underfoot [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 7:43 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL / PHP Database Help
I'm trying to write a script that checks for multiple entries on a table in
a database. So far I've been plagued by MyS
2:43 PM
Subject: [PHP-DB] MySQL / PHP Database Help
I'm trying to write a script that checks for multiple entries on a table in
a database. So far I've been plagued by MySQL errors. I'm fairly confident
my scripting is ok (Then again, I've been wrong before.) I think moreo
I'm trying to write a script that checks for multiple entries on a table in a
database. So far I've been plagued by MySQL errors. I'm fairly confident my
scripting is ok (Then again, I've been wrong before.) I think moreover there might be
some difficulty with my theory. Then again, I could
Could the script be hitting it's head on the ceiling and then pooping the
bed?
I've had a similar problem, when the script exceeds the (default) 8M mem
limit. Could it be that because of the size of the file?
-db
Tobyn Baugher wrote:
> Hi All,
>
> Normally I try not to take work home with me, m
Hi All,
Normally I try not to take work home with me, mainly because I'm good
enough at breaking my own code. In this case, however, I think it might
be a good idea if I knew the answer to the question I was asked.
Basically, there's a PHP script. This script is a rather kludgy way of
keeping
sorry for misspelling: curdate()
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 8:23 AM
To: 'Koutsogiannopoulos Karolos'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql - php DATE QUESTION...
Check the MySQL manual
Check the MySQL manual DATE/TIME functions.
try: DELETE FROM mytable WHERE date_column < ( CURRDATE()-30 )
-Original Message-
From: Koutsogiannopoulos Karolos [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 7:41 AM
To: 'Php-Db (E-mail)
Subject: [PHP-DB] mysql -
Can someone offer some help...?
Lets say i have a date collumn in a mysql table that includes dates that get
stored each time i enter an entry...
How can i check when i enter the page that displays the entries to delete
all entries older than 30 days?
thanks.
> > unset() simply deletes the pointer to the data without releasing the
space
> > held by the data.
> > mysql_free_result() releases the data storage pointed-to by the $result
> > pointer.
> > This is important because $result could be pointing-to a dataspace
> > containing a large number or rows
nope.
see my previous reply
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 06, 2001 10:11 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL/PHP what is the difference between unset()
and mysql_free_result() ?
> And how can i free the d
> And how can i free the data-space from a string or somting like that?
> b.e.
> $string="a very long string";
> free($string);#?
> #could i use mysql_free_result($string);
Maybe I can use: unset($string="");
or unset($array=array()); to free the data-space also
--
PHP Database Mail
: Wednesday, September 05, 2001 4:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL/PHP what is the difference between unset()
and mysql_free_result() ?
Hello,
> unset() simply deletes the pointer to the data without releasing the space
> held by the data.
> mysql_free_result() rel
1 - 100 of 117 matches
Mail list logo
