Re: [PHP-DB] mysql/php time out issue

2010-04-09 Thread ad
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,

Re: [PHP-DB] mysql/php time out issue

2010-04-09 Thread ad
-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

Re: [PHP-DB] mysql/php time out issue

2010-04-09 Thread Chaitanya Yanamadala
-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

Re: [PHP-DB] mysql/php time out issue

2010-04-09 Thread Chaitanya Yanamadala
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

Re: [PHP-DB] MySQL + PHP on WinXP x64 = ?? - clarification

2009-03-12 Thread Chris
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

Re: [PHP-DB] MySQL + PHP on WinXP x64 = ?? - clarification

2009-03-12 Thread YVES SUCAET
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-

Re: [PHP-DB] MySQL + PHP on WinXP x64 = ??

2009-03-12 Thread Chris
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

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Bastien Koert
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

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Andrew Darby
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

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Brad Bonkoski
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

RE: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Bastien Koert
I approach this by assigning a value to a variable and then comparing to see if i need to write out a new title $oldDVD = ""; while ($rows=mysql_fetch_array($result)) { //decide whether to show the DVD title if ($oldDVD != $rows['title']) { echo "".$rows['title'].""; $oldDVD = $rows

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread tg-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

Re: [PHP-DB] MySQL/PHP how to put the results of one query in another query

2005-06-26 Thread Ross Honniball
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

Re: [PHP-DB] mysql, php error

2005-03-07 Thread Martin Norland
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

Re: [PHP-DB] MySQL PHP hosting

2005-02-09 Thread Robby Russell
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

Re: [PHP-DB] MySQL PHP hosting

2005-02-09 Thread Marcus Joyce
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

Re: [PHP-DB] MySQL PHP hosting

2005-02-08 Thread J. Connolly
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

RE: [PHP-DB] MySQL PHP hosting

2005-02-08 Thread Bastien Koert
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 .NET that would be good also

Re: [PHP-DB] MySql PHP API

2004-03-01 Thread Doug
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

Re: [PHP-DB] MySql PHP API

2004-03-01 Thread Doug Thompson
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

Re: [PHP-DB] mysql + php

2003-12-08 Thread CPT John W. Holmes
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>

RE: [PHP-DB] mysql + php

2003-12-08 Thread Ryan Jameson (USA)
James, (B (BThe consensus of developers here seems to have been not to store binary objects in the (Bdatabase. Rather store them in the file system and simply store reference records in (Bthe database. It is much easier this way. If doing it differently is not an option (Bfor you hopefully

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Ignatius Reilly
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Ignatius Reilly
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Ignatius Reilly
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

RE: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Hutchins, Richard
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Peter Beckman
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

RE: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Griffiths, Daniel
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Ruprecht Helms
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread David T-G
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Peter Beckman
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

RE: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Griffiths, Daniel
its nothing to do with php as your working from the shell in your eg. mysql will default to 2000 for a year value if you pass it "" as an entry because it will accept short values for the years this century, eg pass it "1" and it'll give you 2001, so it thinks "" is nothing. if you want to defau

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Peter Beckman
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

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread David T-G
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... ... %

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Ignatius Reilly
Read the MySQL manual. "0" value is interpreted as 2000. Your empty string is converted to an integer, thus 0. HTH Ignatius _ - Original Message - From: "Peter Beckman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 3:39 AM Subject: [P

Re: [PHP-DB] MySQL, PHP, and XML

2003-06-11 Thread Jeff Shapiro
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

Re: [PHP-DB] mysql, php, mp3 - a variable problem

2003-06-07 Thread Ole Hornauer
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 (

Re: [PHP-DB] mysql, php, mp3 - a variable problem

2003-06-07 Thread Ole Hornauer
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 =

Re: [PHP-DB] mysql, php, mp3 - a variable problem

2003-06-07 Thread Allowee
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

Re: [PHP-DB] mysql, php, mp3 - a variable problem

2003-06-07 Thread Ruprecht Helms
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(

Re: [PHP-DB] mysql, php, mp3 - a variable problem

2003-06-07 Thread Allowee
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

Re: [PHP-DB] mysql, php, mp3 - a variable problem

2003-06-07 Thread Ole Hornauer
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); > > > >

Re: [PHP-DB] mysql, php, mp3 - a variable problem

2003-06-07 Thread Allowee
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;

Re: [PHP-DB] MySql, PHP, and Dates

2003-03-30 Thread Bruce Feist
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

Re: [PHP-DB] MySql, PHP, and Dates

2003-03-30 Thread Jason Wong
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

Re: [PHP-DB] MySql, PHP, and Dates

2003-03-29 Thread Bruce Feist
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

RE: [PHP-DB] MySql, PHP, and Dates

2003-03-28 Thread John W. Holmes
> 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

Re: [PHP-DB] mysql +php

2003-02-17 Thread G
Thanks got it working -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] mysql +php

2003-02-17 Thread Ryan Jameson (USA)
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

RE: [PHP-DB] mysql +php

2003-02-17 Thread Ryan Jameson (USA)
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 +php Hi I was wonder if any k

RE: [PHP-DB] [mysql - php] Newline to BR problem

2003-01-09 Thread Aaron Wolski
You want to look at nl2br() function. It takes newlines from a text like: Hello My name is Aaron Which when outputted normally would look like: Hello my name is aaron Using echo nl2br($dbquery); would produce: Hello My name is Aaron In your HTML code which then would output in a browse lik

RE: [PHP-DB] MySQL/PHP dropping characters

2002-09-24 Thread Ford, Mike [LSS]
> -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

RE: [PHP-DB] MySQL/PHP

2002-08-30 Thread Hutchins, Richard
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

RE: [PHP-DB] MySQL/PHP

2002-08-29 Thread Beau Lebens
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 find a goo

RE: [PHP-DB] MySQL/PHP Update

2002-03-28 Thread Jason
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:

Re: [PHP-DB] MySQL/PHP Update

2002-03-28 Thread Jason Wong
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

RE: [PHP-DB] MySQL/PHP Update

2002-03-28 Thread Rick Emery
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, but it doesn't

Re: [PHP-DB] MySQL/PHP Update

2002-03-28 Thread cristi radulescu
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

Re: [PHP-DB] MySQL/PHP Update

2002-03-27 Thread Marius Ursache
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 > >

Re: [PHP-DB] MySQL/PHP Update

2002-03-27 Thread Maxwell
> 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:

RE: [PHP-DB] MySQL/PHP date functions

2002-02-20 Thread Markus Lervik
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'

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread DL Neil
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

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jeroen Timmers
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

RE: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Rick Emery
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

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jonathan Underfoot
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:

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread DL Neil
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

RE: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Rick Emery
Yes, you can re-select from the same database without opeing a new connection. I recommend that you print the contents od $newquery to verify it contains the string you think it should. Perhaps the apostrophes you've enclosed the $row[] variable are not expanding. -Original Message- Fr

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jeroen Timmers
Hello, something that you can help is the follow try var_dump($newquery); then you see the complete query and run it in phpmyadmin. Jeroen - Original Message - From: "Jonathan Underfoot" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 2:43 PM Subject: [PHP-DB

Re: [PHP-DB] MySQL/PHP and the case of "Good Lord, that's a lot ofstatements"

2002-01-15 Thread Daniel Barton
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

RE: [PHP-DB] mysql - php DATE QUESTION...

2001-10-03 Thread Rick Emery
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

RE: [PHP-DB] mysql - php DATE QUESTION...

2001-10-03 Thread Rick Emery
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 - php DATE QUE

RE: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ?

2001-09-06 Thread Rick Emery
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

Re: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ?

2001-09-06 Thread Bas Jobsen
> 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

RE: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ?

2001-09-06 Thread Rick Emery
: 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

Re: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ?

2001-09-05 Thread Bas Jobsen
Hello, > 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 ret

RE: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ?

2001-09-05 Thread Rick Emery
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 returned by the mysql_q

Re: [PHP-DB] mysql-php

2001-05-10 Thread Nickolas Heyde
If I were U I would convert it to UNIX date first subtract and then restore to normal format what do U think !?!?! ""Mikail"" <[EMAIL PROTECTED]> escreveu na mensagem 008c01c0d2f2$2e0df880$bb02a8c0@maz">news:008c01c0d2f2$2e0df880$bb02a8c0@maz... > hi, > I'm a newbie from Italy > I use php wi

Re: [PHP-DB] mysql/php select using date in where clause

2001-05-03 Thread Dan Eskildsen
IT works! Thanks! ""martin helie"" <[EMAIL PROTECTED]> skrev i en meddelelse 9crqud$voj$[EMAIL PROTECTED]">news:9crqud$voj$[EMAIL PROTECTED]... > Here's how I'd do it: > > SELECT * FROM customers WHERE Site='egebjergnet' AND > > TO_DAYS(NOW()) - TO_DAYS(date_column) <= '45' > > where date_colum

Re: [PHP-DB] mysql/php select using date in where clause

2001-05-03 Thread martin helie
Here's how I'd do it: SELECT * FROM customers WHERE Site='egebjergnet' AND TO_DAYS(NOW()) - TO_DAYS(date_column) <= '45' where date_column contains record dates... Martin ""Dan Eskildsen"" <[EMAIL PROTECTED]> wrote in message 9crq7l$mfb$[EMAIL PROTECTED]">news:9crq7l$mfb$[EMAIL PROTECTED]..

Re: [PHP-DB] mysql --> php

2001-04-08 Thread B. van Ouwerkerk
At 21:20 8-4-01 +0200, Adam wrote: >Hello, >I have a fresh instalation of mysql from the ditribution of RH7. >What do I have to put into the user and host tables so that >I can use MySQL through PHP (I doesn't have to be super-secure, >just so that not everybody could get to my databases) I don't

Re: [PHP-DB] MySQL/PHP Form & Addslashes() command

2001-01-26 Thread Mage
Hello! JJeffman wrote: > There is the "nl2br()" function too : > // From php manual : > > nl2br -- Converts new lines to HTML line breaks. > Description > > string nl2br(string string); > > Returns string with '' inserted before all new lines. > Sure, but never add any html tag

Re: [PHP-DB] MySQL/PHP Form & Addslashes() command

2001-01-26 Thread JJeffman
gem Original- De: Rubanowicz, Lisa <[EMAIL PROTECTED]> Para: 'James Smith' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Enviada em: sexta-feira, 26 de janeiro de 2001 07:59 Assunto: RE: [PHP-DB] MySQL/PHP Form & Addslashes() command > I am a beginner but did it like this,

RE: [PHP-DB] MySQL/PHP Form & Addslashes() command

2001-01-26 Thread Rubanowicz, Lisa
I am a beginner but did it like this, with a little help from my friends!! $query = "INSERT INTO guests "; $query .= "(guest_id, guest_name, "; $query .= "guest_email, guest_time, guest_message) "; $query .= "values(, '$name', '$email', NULL, '" . str_replace("\n","", $message) . "