[PHP-DB] 2008 : MySQL client run out of memory

Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is

Re: [PHP-DB] Attachment

You must look at the RFC1341 (if you have not already did so) to learn about mime types. It is also very useful to send (you) messages with attached files and the look at the source. A tip : to send you own forged mail you must use the mail() function like this :

RE: [PHP-DB] LDAP and special chars

Hi Christian, ... you could urlencode() when inserting and urldecode() on fetching the data. Perhaps this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16

[PHP-DB] blinking background

hello! is there anyone who can give me an idea on how i can write a php script that can make my table row background blinking. thanks :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

Re: [PHP-DB] 2008 : MySQL client run out of memory

I thought I was an answer to my question...I'm disappointed. Anyway did you try make clean before make ? But theses parse errors are strange. You should check (if you not already did so) your gcc version and if all the gcc components are installed. I had the same problem compiling linuxthreads

Re: [PHP-DB] blinking background

is there anyone who can give me an idea on how i can write a php script that can make my table row background blinking. Why on earth would you want to do that?? It would fully distract anyone looking at the information within the table - which I *presume* is why you want information in the

[PHP-DB] order by date

Hi, I am querying a mysql database and am returning data ordered by date, the trouble is it returns the data from least recent to most recent, I want it to return the data the other way round. Is there a way of having the mysql database doping this re-ordering for me rather than coding it

RE: [PHP-DB] order by date

you can use order by date DESC for descending or order by date for ascending nice to see a PHP-Database question in here ;-) Dave -Original Message- From: Scott Chapman [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 10:50 To: [EMAIL PROTECTED] Subject: [PHP-DB] order by date

RE: [PHP-DB] order by date

Hi Scott, RTFM. Anyway: '... ORDER BY Date DESC' will do the job for you. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16

Re: [PHP-DB] 2008 : MySQL client run out of memory

Not at all. The exact error is : 2008 : MySQL client run out of memory On the mysql online support they say It may happen when a query returns to much rows. But It's not the case. Moreover the query works with phpMyAdmin, which gives me a bit of hope... That's all. Le jeu, 09 aoû 2001, vous

Re: [PHP-DB] blinking background

i just want to catch the attention of the user and the blinking effect of the table row is not forever, it will stop after a certain time. :) - Original Message - From: Russ Michell [EMAIL PROTECTED] To: J- E- N [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001

RE: [PHP-DB] blinking background

I guess it's either a timer thing, and change the td bgcolor= or a timer thing and change the img src= from an animated to a non-animated GIF surely there's a better way? bgcolor and background images for tables are not enitrely cross-browser compliant - why not use JavaScript and send an Alert?

RE: [PHP-DB] blinking background

Hi jen, even if it's silly, here your answer: It's _not_ possible in PHP, use JavaScript. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16

RE: [PHP-DB] MSSQL: Spaces in database name

Why have spaces in names at all? To me it's long term aggravation, unnecessary keystrokes, and a future source of bugs. Besides, the end user rarely sees these names. Another case of do it just because you can? If this is an inherited database, my apologies. If you are just starting the

Re: [PHP-DB] blinking background

Fergawdsake -- WHY?!! Irritating, annoying, amateurish -- go read Jakob Nielsen on usability. Here's an alternate suggestion: A contrasting colour for the row you wish to highlight, keeping in mind that some people are colour blind. Miles Thompson At 05:53 PM 8/9/01 +0800, J- E- N wrote:

[PHP-DB] Re: semi newbie Q

Hi, Here is a quick question. Cane the mail() function handle file attachments? I couldnt find anything like that on the PHP reference but maybe someone knows out there. If not does anyone have any simple scripts that will allow me to do this? I think it doesn't. Check e.g

Re: [PHP-DB] 2008 : MySQL client run out of memory

Hello, I tried with unbuffered queries and It doesn't solve the problem at all. I have an weird error performing select id from categories where name = 'Hifi'. The error is now : '0 : ' (nothing). There's an error but it is not defined ?!? Note that only the crashing query is

[PHP-DB] PHP4, MySQL, errors....

Just to have said it... Im green in both PHP4 and MySQL. Can anyone say what I've been doing wrong here, and how to fix it, or even better. Debug the whole shit! =) The error is like this: -- Members who are $prof s \n); while ($row = mysql_fetch_array($retid)) { $email = $row[email]; $loc =

Re: [PHP-DB] blinking background

catch the attention of the user hell why don't you just make a blinking page i'm sure that will grab some attention, and possibly cause a ton of epillectic fits around the world when people finally do look at your page e. - Original Message - From: J- E- N [EMAIL PROTECTED] To:

RE: [PHP-DB] blinking background

LMAO! -Original Message- From: Mark Collin [mailto:[EMAIL PROTECTED]] Sent: 09 August 2001 12:34 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] blinking background catch the attention of the user hell why don't you just make a blinking page i'm sure that will grab some attention, and

[PHP-DB] Another SELECTING problem :-(

I've a feeling I've asked this before, but checked my old messages and couldn't see it in there for the excess of non PHP-Database questions flying around (yep - that's a joke, but I've been here a while - forgive me!). I have (many many many) tables ... two of which are linked by a third, so

RE: [PHP-DB] Another SELECTING problem :-(

PS This is for a web page, so it's PHP related!!! :-) -Original Message- From: Dave Watkinson Sent: 09 August 2001 12:51 To: PHP-DB List (E-mail) Subject: [PHP-DB] Another SELECTING problem :-( I've a feeling I've asked this before, but checked my old messages and couldn't see it in

Re: [PHP-DB] blinking background

Fergawdsake -- WHY?!! Irritating, annoying, amateurish -- go read Jakob Nielsen on usability. Here's an alternate suggestion: A contrasting colour for the row you wish to highlight, keeping in mind that some people are colour blind. 1. You can create an animated gif with the an asterisk

Re: [PHP-DB] Another SELECTING problem :-(

Dave Watkinson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... PS This is for a web page, so it's PHP related!!! :-) -Original Message- From: Dave Watkinson Sent: 09 August 2001 12:51 To: PHP-DB List (E-mail) Subject: [PHP-DB] Another SELECTING problem

Re: [PHP-DB] Attachment

First of all. Take a look at MIME tutorial @ http://www.zend.com its great.. read all 3. i wrote a perl script after that tutorial.. it attach a .log file.. take a look im 100% sure you can port it to php using mail() function just build up $header and insert into the function.

RE: [PHP-DB] MS SQL connect by ODBC

Sommai, Yes, you want to compile PHP --with-iodbc per the HOWTO at www.iodbc.org. This will give PHP the ability to use ODBC drivers. You will still need to install an ODBC driver on your linux box, and configure the DSN connection attributes in your odbc.ini. You may use OpenLink's Multi-Tier

RE: [PHP-DB] MSSQL: Spaces in database name

I guess it would depend on your view of usability. To me, there's no shortage of blanks in the world, so I prefer to use them asOpposedToHopingTheCapitalizationIsPreserved kind of names. Once I finish designing an app *I* don't have to look at the names much, either, but I prefer the longer,

RE: [PHP-DB] Another SELECTING problem :-(

At 12:52 PM +0100 8/9/01, Dave Watkinson wrote: I have (many many many) tables ... two of which are linked by a third, so that there can be a one-to-many relationship. What I'd like to do is find which ids from table 1 have more than one relation in table 2, via table 3. I've tried this...

RE: [PHP-DB] Another SELECTING problem :-(

thanks for that ... I've made some comments within yours... Your getting a lot of errors, because the statement has well a lot of mistakes. Let's start near the beginning, you state: SELECT empid, COUNT(empid) FROM emp_cont , employers, contacts This statement should produce an error,

Re: [PHP-DB] blinking background fwd

Heh, there's a reason the blink tag has been depreciated... Actually I tried finding it in the newest version of HTML and can't even find it there anymore :-) That's cos it was a Nutscrape proprietry tag Russ Date: Thu, 9 Aug 2001 09:47:59 -0600 From: John Pickett [EMAIL PROTECTED]

Re: [PHP-DB] blinking background

Depending on the frequency of the blink, it could induce seizures in epileptics, aside from being extremely annoying. Highlighting rows with a sufficiently contrasting color will draw attention to the item, and will be seen by color blind visitors. avoid blink. it's an excellent way to get

Re: SV: [PHP-DB] Empty error ? (HELP ME)

hpMyAdmin writes : 3.23.40-log Why -log, don't know ?... Le jeu, 09 aoû 2001, vous avez écrit : What version of Mysql is it? -Opprinnelig melding- Fra: Patrice Garbe [mailto:[EMAIL PROTECTED]] Sendt: 9. august 2001 19:45 Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne:

[PHP-DB] Objects in and out of a DB

This is probably a FAQ, but the on-line manual is rather confusing and I can't get it to work! The problem: I have a fairly complicated set of objects, all interconnected through the instance variables of one object storing the value of another and so on. Other instance variables hold

[PHP-DB] Re: PHP4, MySQL, errors....

Cato Larsen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Just to have said it... Im green in both PHP4 and MySQL. Can anyone say what I've been doing wrong here, and how to fix it, or even better. Debug the whole shit! =) First, make sure PHP is actually

[PHP-DB] fopen function

I made a simple submissions form that writes to a backup file using the fopen function. I use the variable a+ or a, for the backup. it goes to the end of the file and adds the new info. I need it to add the new data at the beginning of the file, but leave the file in tact. Does anyone have

[PHP-DB] Oracle CLOBs and carriage returns

Hi folks. I have an interesting problem with regards to data I am retrieving from a CLOB stored in my database. The data consists of several paragraphs of information with multiple carriage returns and other formatting mechanisms. Now when I attempt to retrieve the data and display it on the

RE: [PHP-DB] Oracle CLOBs and carriage returns

Tom: I suspect that your problem is with the HTML, not the CLOB itself. Have you tried echoing $lob_data in between PRE tags or using the nl2br function in PHP? It converts nl's to BR tags. Hope it helps, Anthony -Original Message- From: Tom Tsongas [mailto:[EMAIL PROTECTED]] Sent:

RE: [PHP-DB] Oracle CLOBs and carriage returns

On Thursday, August 09, 2001 at 2:09 PM, Tom Tsongas said: Here is the code I am using: $sql_comments = OCIParse($connection,SELECT COMMENTS FROM INCIDENT WHERE INCIDENT='$incident'); OCIExecute($sql_comments); while ( OCIFetchInto($sql_comments, $row, OCI_ASSOC+OCI_RETURN_NULLS)) {

Re: [PHP-DB] Oracle CLOBs and carriage returns

Thanks Anthony. The PRE tags worked perfectly! Tom Anthony Carlos wrote: Tom: I suspect that your problem is with the HTML, not the CLOB itself. Have you tried echoing $lob_data in between PRE tags or using the nl2br function in PHP? It converts nl's to BR tags. Hope it helps,

RE: [PHP-DB] Another SELECTING problem :-(

At 3:10 PM +0100 8/9/01, Dave Watkinson wrote: You'll note that both step requires a return, which general means a subquery, I believe for MySQL to hanle subqueries you actually have to perform to separate queries. If your not using MySQL then you could write a statement such as: SELECT

RE: [PHP-DB] Another SELECTING problem :-(

Another possible solution (although more drastic) is to switch DBMS's. I use PostgreSQL with no troubles. However, 6.5 and earlier are not so great performance wise. 7.0.3 is OK, and 7.1.2 is exceptional. It also now (finally) supports outer joins and write ahead locking. If you are at the

[PHP-DB] Inexplicable PHP/MySQL behaviour

Hi there! Say I have a MySQL table like this: Away_Team Score Home_Team Score   spread Atlanta255San Francisco255 2 The team names are loaded into the table before my application starts, and all scores are given a default value of 255.

Re: [PHP-DB] Inexplicable PHP/MySQL behaviour

Aaron, Try this: if($row[home_score] == 255) == is test for equality = is used for assignment of value Hope it solves the problem - Miles PS We've all been bitten by it. At 09:40 PM 8/9/01 -0400, Aaron Vegh wrote: Hi there! Say I have a MySQL table like this: Away_Team Score

RE: [PHP-DB] 'replace' with 'where'

snip $result_insert = mysql_query(replace into wantlist where id = '$id' values ('', '$artist', '$title', '$tracks', '', '', '')); the $id is already defined in the url, by the way (ex. snip The way replace works is it looks for a unique index key in your update list, if it finds one it uses