Re: [PHP-DB] Help needed - SELECT query optimization

2008-10-26 Thread Chris
It should be a rapidshare links database (which updates with a PHP crawler I wroted last Saturday). I would like to change the snippet to title and add another column for the snippet, My main queries are INSERT's - a big insert (usually 10-100 links per insert) in each hour. My crawler is checki

RE: [PHP-DB] Help Needed!!

2006-11-08 Thread Bastien Koert
1. yes, user a rich text editor plugin in you web page (http://www.kevinroth.com/rte/ is one such beast) 2. sure, in a text / blob field 3. yes, but likely you'll need to do it as CDATA hth Bastien From: "David Skyers" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] Help Needed!! Date: Wed, 8

Re: [PHP-DB] Help Needed!!

2006-11-08 Thread John Meyer
Forgive me for saying this, but you should be posting this to the Oracle mailing list, not here. David Skyers wrote: > Hello, > > I have an input field that inserts data into an oracle table. The users > of the system will be composing the data that goes into this input field > in Microsoft Word.

RE: [PHP-DB] Help needed creating a social network

2006-03-07 Thread Miles Thompson
: You know bob who knows john who knows carrol who knows Sam. Sam <- carrol <- john <- bob <- you Etc. > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: Monday, March 06, 2006 10:28 PM > To: php-db@lists.php.net > Subject: Re: [PHP-DB

RE: [PHP-DB] Help needed creating a social network

2006-03-07 Thread Daevid Vincent
t;- carrol <- john <- bob <- you Etc. > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: Monday, March 06, 2006 10:28 PM > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Help needed creating a social network > > > CREATE TA

Re: [PHP-DB] Help needed creating a social network

2006-03-06 Thread Micah Stevens
CREATE TABLE `users` (userID int(11) not null auto_increment, primary key(userID), name tinytext not null, email tinytext not null); CREATE TABLE `links` (userID int(11), key (userID), friendID int(11), key(friendID)); You have friends!!"; while ($f = mysql_fetch_assoc($friends)) { echo "{$f['

Re: [PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Murray @ PlanetThoughtful
On 26/02/2006 3:03 PM, Chris Payne wrote: Hi there everyone, This line of code USED TO WORK but now it gives me a Coudln't Execute Query error: $query2 = "SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('$t

RE: [PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Chris Payne
Hi there, I'm using asd just to test the search, here's the output from the statement echoed to the screen: SELECT word,def,photo, if(locate('asd',word),1,2) as meFirst ,MATCH(word,def) AGAINST ('asd' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('asd' IN BOOLEAN MODE) ORDE

RE: [PHP-DB] Help Needed

2005-07-29 Thread ReClMaples
You ROCK!!! Thanks so much, this worked perfectly!!! Thanks -Rich -Original Message- From: Alain Rivest [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 10:10 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Help Needed ReClMaples a écrit : >Sorry, the data under '

Re: [PHP-DB] Help Needed

2005-07-29 Thread Alain Rivest
ReClMaples a écrit : Sorry, the data under 'Looking something like this' should be in a table format with 3 columns and 4 rows. -Original Message- From: ReClMaples [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 8:46 PM To: PHP Subject: [PHP-DB] Help Needed All, I know this

RE: [PHP-DB] Help Needed

2005-07-29 Thread ReClMaples
Sorry, the data under 'Looking something like this' should be in a table format with 3 columns and 4 rows. -Original Message- From: ReClMaples [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 8:46 PM To: PHP Subject: [PHP-DB] Help Needed All, I know this is the wrong distro to

RE: [PHP-DB] Help needed

2004-10-04 Thread Gary Every
Check to see if your register_globals is set to off in php.ini. If so (likely, since it defaults to that value) you'll need to access your POST and GET variables like this: GET vars: $var = $_GET['var']; POST vars: $var = $_POST['var']; Gary Every Sr. UNIX Administrator Ingram Entertainment Inc

RE: [PHP-DB] Help needed with variable scoping? or mysql problem

2003-08-23 Thread Mike Klein
2000 records is not nice... thanks buddy... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 8:10 AM To: Mike Klein Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Help needed with variable scoping? or mysql problem best way to tell is to

Re: [PHP-DB] Help needed with variable scoping? or mysql problem

2003-08-14 Thread jeffrey_n_Dyke
best way to tell is to place .'or die(mysql_error())' after any call to mysql_query() to see what mysql is complaining about. personally I sometimes declare the query first so i can echo that as well after the msyql_error() function, so i can see the query that has just been excecuted. helpf

RE: [PHP-DB] Help Needed

2002-12-26 Thread dufronte
ubject: Re: [PHP-DB] Help Needed At 02:36 PM 12/26/02 +0700, dufronte wrote: > >Hi. >I juz installed a RedHat 8.0 on my machine. >But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20.. Apache 2 and PHP are not ready for prime time. If you must use Apache 2 wi

Re: [PHP-DB] Help Needed

2002-12-26 Thread Rick Widmer
At 02:36 PM 12/26/02 +0700, dufronte wrote: Hi. I juz installed a RedHat 8.0 on my machine. But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20.. Apache 2 and PHP are not ready for prime time. If you must use Apache 2 with PHP, you are on the bleeding edge, and should plan o

Re: [PHP-DB] Help Needed

2002-12-26 Thread 1LT John W. Holmes
> Everything's perfect.. except my browser keep blank when I run my php > files... No, obviously it's not perfect because it's not working at all. Your page is blank because will be evaluated as an unknown HTML tag and come out blank. Find another tutorial that discusses how to set up what you w

RE: [PHP-DB] Help Needed

2002-12-26 Thread dufronte
Everything's perfect.. except my browser keep blank when I run my php files... --www.kapsul.org-- DuFronte -Original Message- From: adi setiawan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 5:00 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Help Needed --

Re: [PHP-DB] Help Needed

2002-12-26 Thread adi setiawan
-- pada 2002-12-26, 14:36:00 [EMAIL PROTECTED] menulis: -- > >Hi. >I juz installed a RedHat 8.0 on my machine. >But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20.. >It's preety weird.. coz there's nothing shown up in the browser when I >run phpinfo(); or even a simple 'hellow

Re: [PHP-DB] Help Needed

2002-08-01 Thread leo g. divinagracia iii
you need a second REQUIRED parameter: mysql_result (PHP 3, PHP 4 ) mysql_result -- Get result data Description mixed mysql_result ( resource result, int row [, mixed field]) as cop

Re: [PHP-DB] Help needed on point system

2002-02-01 Thread Jason Wong
On Saturday 02 February 2002 00:08, Jerry Leonard wrote: > Hi all, > > I am relatively new to php and mysql and would appreciate any help you can > provide. Here is the task: > > I need to have a point system added to my site. What I would like is when a > user logs in they will get 1000 points. B

Re: [PHP-DB] HELP NEEDED! SELECT of Text Fields in MS SQL Server 7.0 Limitatio n

2001-12-16 Thread Miles Thompson
Don't have any suggestions, but have these questions been asked: Presumably your query works just fine at the SQL Server console? What happens - the first 8k display, and then the rest of your page appears? Or do you get an error message? Timeout? What do you get? Are you hitting an array size