[PHP-DB] This query makes never gets done... and it keeps a thread open in the processlist for a long time!!! Very annoying!

This query can sometimes draw back the whole database causing some, or all, data that is extracted from the database to not show. Can u experts scan through this for me? I really need some help! SQL- -- SELECT DISTINCT $

[PHP-DB] Which Virus was it?

Hey there ppl! What was the name of the virus that was sent to this list??? -Trond? -- 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 administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] dividing an mysql_fetched_array...

Hi there... I was thinking of dividing a front page displaying 15 newsarticles into three parts. The first part, will contain only one article... Below the first article there will be an ad, before to columns suceeding this banner displays 2*7 articles... how do I do this? I know the array has i

[PHP-DB] Query qizzle quackarooney! :|

Hey there fellow querieres I summon your power! (eh..) well.. enough with the nonsense :) I have a littlebit of problem: I am displaying 15 different newsarticles on a page. The articles are displayed in three different tables. First there`s one article (the main-top-story) that is shown i

RE: [PHP-DB] Virus alert

> > If this is the wrong list, please forgive, but I could have swore it was > > this one ;) > Yes it was but fortunately the attachment wasn't there I saw an attachment on that mail... but I just deleted it... Are you sure??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] How can i extract txt files from my db that can be imported into Excel? (tabular separated values) + a second question for server admins

Hey there. I need to extract a table in my db where users have registrered some information about themselves. Now I need to extract these tables so some of the employees here can use them in Excel... How do I do this? ---Query 2 What is the minimun capacity a web server should have on it`s

[PHP-DB] Setting cookies that are valid for two or more domains

Hey there... I need to set a cookie with variables that will be valid for two domains with different names. In reality these two domains are on the same server, and even in the same dir we use: php4, apache, Linux -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [

[PHP-DB] mysql_fetch_array problem...!

I want to run a query to my db, fetching different fields from three different tables. In order to recognise the individual fields I give them names: select portal.portal as portal, portal.portalid as id... etc etc How can I refer to one specific row in this query..? What I mean is, how can i r

[PHP-DB] If`s in MySQL.... Having some trouble here...

Hi there... I want to query two tables in my db. One containing a list of numbers ranging from 1 - 10200, the other table is storing information that is relative to some of the numbers: Eks: Table1.record1: number=1 Table2.record1: number=1 name=John Now I want to query these to t

[PHP-DB] Mysql and memory issue

Hi, maybe this list isn't the best place to ask for this but... I keep getting "memory exhausted" errors from mysql, on a system running as mail/mysql/apache+php server. (rh7.1) Is it my queries that are inefficient? Is it my modelling-scheme that sucks or could it be that mysql is leaking memory

[PHP-DB] RE: Mysql and memory issue

porary; Using filesort" These are three drawbacks of my query? > -Original Message- > From: Yasuo Ohgaki [mailto:[EMAIL PROTECTED]] > Sent: 9. april 2002 17:14 > To: Trond Erling Hundal > Subject: Re: Mysql and memory issue > > > Trond Erling Hundal wrote: > &

[PHP-DB] Puzzeling a little...

I made a big mistake... Med vennlig hilsen Trond Erling Hundal Daglig leder Epost: [EMAIL PROTECTED] Internett: www.innovationmanagement.no Telefon: 73 54 03 80 Mobil: 918 41 117 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Virus alarm!

h. 2. Look in all the harddrives on your computer (C:, D:, E: etc) 3. search for a file named: "sulfnbk.exe" 4. If you find it delete it, then delete it from your recycle bin. 5. Warn everyone who is in your adressbook! Med vennlig hilsen Trond Erling Hundal Daglig leder Epo

[PHP-DB] Anti-virus alarm! Sulfbnk var inget virus.

, this file "sulfnbk.exe" only restores long filenames. Here's a link to a page that explains how you can restore the file. http://netsquirrel.com/msconfig/sulf.html Med vennlig hilsen Trond Erling Hundal Daglig leder Epost: [EMAIL PROTECTED] Internett: www.innovationmanagement.no Telef

[PHP-DB] Sub queries...

I want to run a query to fetch out a navigation menu on a site I am working on. I always have paranoia of destroying the db with ineffecient queries... Now, as I understand it, sub-queries is a bad thing. They are very slow in MySQL?? This menu I am making will be displayed on each page the user

[PHP-DB] Sub queries in MySQL

I want to run a query to fetch out a navigation menu on a site I am working on. I always have paranoia of destroying the db with ineffecient queries... Now, as I understand it, sub-queries is a bad thing. They are very slow in MySQL?? This menu I am making will be displayed on each page the user

SV: [PHP-DB] wildcard in mysql search with php

The % can be empty space or 'n' characthers. The LIKE command in mysql also make the query very dynamic. - trond > -Opprinnelig melding- > Fra: Dave Watkinson [mailto:[EMAIL PROTECTED]] > Sendt: 18. oktober 2001 14:50 > Til: [EMAIL PROTECTED] > Emne: RE: [PHP-DB] wildcard in mysql search

SV: RE: [PHP-DB] sending bulk emails

I say. Help those who want to be helped. Or else, don't bother. And if they complain, format their harddrive. eh... Come on guys.. don't you remember the first time you made a spam-script/newsletter-script?? ...the feeling you felt when all those mail streamed out of the server... it IS special.

SV: [PHP-DB] sending bulk emails

Come on ppl! You can't seriously say that we have become evil creatures luring idees on the list..? come on man! > -Opprinnelig melding- > Fra: Rick Emery [mailto:[EMAIL PROTECTED]] > Sendt: 2. november 2001 17:05 > Til: PHP DB list > Emne: RE: [PHP-DB] sending bulk emails > > > my commen

SV: [PHP-DB] sending bulk emails

Yes, you will get a timeout. I made a script that wrote a * on the page for each sent mail. This way your script won't time out, and the sending process looks REALLY cool.. hehe Here's a sample snippet: \nContent-Type: text/plain; charset=iso-8859-1\nContent-Transfer-Encoding: 8bit\nReply-To: Hav

SV: [PHP-DB] COPY files = Warning permission denyed

This is a problem in your server. Not apache, but the OS itself... Linux gives user access based on certain values... php normally runs as the user "nobody", so what you have to do is to make sure user nobody has the right to read/write in your temp folder (defined in php.ini) Or else... >

SV: [PHP-DB] Excel to Mysql

I am sure there are several ways of doing this. What I do, is just save the excel file as a tab-separated txt file... Then in mysql you call the "LOAD DATA local infile "/tmp/test.txt" into tabel tablename (columnname1, columnname2)" ; I have made a little upload script for this.. If you want it

SV: [PHP-DB] Re: php/mysql error

I agree with mr. Torrent here... you are not logged on to your mysql server when you issue the query! Check your password/username... > -Opprinnelig melding- > Fra: torrentUK [mailto:[EMAIL PROTECTED]] > Sendt: 20. november 2001 18:35 > Til: [EMAIL PROTECTED] > Emne: [PHP-DB] Re: php/mys

SV: [PHP-DB] Execution of non-PHP code from within PHP

heh.. Cool. > -Opprinnelig melding- > Fra: Andrey Hristov [mailto:[EMAIL PROTECTED]] > Sendt: 26. november 2001 12:15 > Til: Matthew Tedder > Kopi: [EMAIL PROTECTED] > Emne: Re: [PHP-DB] Execution of non-PHP code from within PHP > > > $result = `ls -al`; > var_dump($result); >

[PHP-DB] How to update all the column types in a table...

I need to change a varchar into password(varchar) for a password column. What is the common SQL syntax to do this. The table allready has all of the password's stored. I just need to encrypt them with password($value) ...Or will I have to just make a php script to extract and update? __ _

SV: [PHP-DB] The file '/tmp/phpxw2cJS' must be in the database directory or be readable by all

Looks like an uploaded file... (Did you make a page that lets you upload the file then run it into your table?) Upload the file manually, chmod it to 777 or whatever... But when you uploaded it, the file has your default read/write permissions that should work within mysql. Then you should be abl