[PHP-DB] Help needed in searching a sentence in the code

2010-05-26 Thread nagendra prasad
Hi All, I have this code where user can search a song or the entire song title. It looks like when a user search a single word its searching and giving the proper results. However if the user wants to search the entire sentence its not giving the proper results. For example let say I have

[PHP-DB] help needed.

2010-03-17 Thread Vinay Kannan
Hello Guys, I am developing an application, which would have a front end in Flash, and the backend would be MySQL, now what I am thinking is to package this as an exe file, similar to WAMP, which installs everything, So my exe should have all my files, the MySQL data dump and should auto install

[PHP-DB] Help needed - SELECT query optimization

2008-10-26 Thread Nitsan Bin-Nun
Hi, I have a mysql database with one table in it, currently it contains 36,807 records and it costs 6.8MB of space, every night another thousand~ of rows are being added to the table. The scheme (as taken from phpmyadmin) is like follows: CREATE TABLE IF NOT EXISTS `search` ( `id` int(11) NOT

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

[PHP-DB] Help needed PHP with Excel database

2008-05-31 Thread JDP
Hi I am a PHP beginner and using Namo Webeditor trial version in order to access an Excel file via ODBC...and I get no result Namo generates the following code: = ? $a_startrow = $startrow; $a_maxrows = $maxrows; require('wed_php_odbc.inc'); ?html head

[PHP-DB] Help needed

2008-05-11 Thread Velen
Hi, I'm testing a program and I need you assistance. Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program. It will display an ID, please mail me back the ID. If you can use it on several computers, it will be even better for me, I need to have as much results as

[PHP-DB] Help Needed!!

2006-11-08 Thread David Skyers
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. They will also be using Microsoft Word formatting features. 1. Is it possible for my input box to retain the formatting and

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!!

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: php-db@lists.php.net Subject: [PHP-DB] Help

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

2006-03-07 Thread Daevid Vincent
- 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 TABLE `users` (userID int(11) not null auto_increment, primary

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

2006-03-07 Thread Miles Thompson
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] Help needed creating a social network CREATE TABLE

[PHP-DB] Help needed creating a social network

2006-03-06 Thread Daevid Vincent
Anyone have some pointers at a HowTo on creating a social network? Basically I need to show people in your immediate network, and also friends of your friends, etc... Like the whole 'six degrees of separation' thing. Ala: myspace, friendster, etc. ad nauseum. I prefer mySQL and PHP, but I could

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)); ?php $friends = mysql_query(select users.name, users.userID from users

[PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Chris Payne
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 ('$txtsearchword' IN BOOLEAN MODE) LIMIT $offset,

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)

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

[PHP-DB] Help Needed

2005-07-29 Thread ReClMaples
All, I know this is the wrong distro to be sending this request for help to but I don’t know which one to send this to. If you could either point me in the direction that I should go or help me, I would greatly appreciate it. Here is my issue. I have a set of date that I want returned in

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

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

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 'Looking

[PHP-DB] Help needed

2004-10-04 Thread Manoj Japher
hi, I am new to PHP and I am not sure if this is the right forum. I am trying to run PHP thro webmin using CGI scripts. PHP runs fine except that when I am trying to read variables coming thro' a form after hitting the submit button, I get NULL values. I can read and write to the database

RE: [PHP-DB] Help needed

2004-10-04 Thread Gary Every
Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Manoj Japher [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 9:29 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Help needed hi, I am new to PHP and I am not sure if this is the right forum. I am

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

2003-08-23 Thread Mike Klein
- 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 place .'or die(mysql_error())' after any call to mysql_query

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

2003-08-14 Thread Mike Klein
I've been using JSP for some time now, and thought I'd write a couple of rdbms explorers (flat tables, simple master/detail paradigm) using other technologies, like PHP, Cocoon, etc. Well...it's been fun. I have more working than not. But now I am hung up. I am getting wierd results in a php

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

2003-08-14 Thread jeffrey_n_Dyke
] rg cc: Subject: [PHP-DB] Help needed with variable scoping? or mysql problem 08/14/2003 08:58

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 'helloworld'

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 -- pada

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 ? phpinfo() ? will be evaluated as an unknown HTML tag and come out blank. Find another tutorial that discusses how to set

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

RE: [PHP-DB] Help Needed

2002-12-26 Thread dufronte
: [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 with PHP, you are on the bleeding

[PHP-DB] Help Needed

2002-12-25 Thread dufronte
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 'helloworld' code. When I view the source by right-clicking.. it shows

[PHP-DB] Help Needed

2002-08-01 Thread Manoj Japher
hi, I have started working with PHP-MySQL recently. I have been getting a warning message which i am not able to debug. Could some one pls help me out? The message is Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/verify.php

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

[PHP-DB] HELP NEEDED!

2002-07-13 Thread Nik Alleyne
Hi there I am having a problem querrying to my database. I wish to check to see if a username is listed in the database so that I can authenticate that individual. However, when I try to echo my $_result i'm always getting 0 can someone please help. I think it should be either 1 or 0. These are

[PHP-DB] Help needed - need to access a value from DB into all pages

2002-02-21 Thread WG4- Cook, Janet
Hi there, I am struggling with a concept and can't seem to find a way to do it so hoping you all can help. We want to use PHP with MySql Db. For security reasons on the DB, it is to be accessed only through this front end i.e. via the internal web Each user will have a number of levels of

[PHP-DB] Help needed on point system

2002-02-01 Thread Jerry Leonard
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. But they only get it once per day. I am running: Xitami on WinME,

[PHP-DB] Help needed with php and db2

2002-01-30 Thread Stephanie Workman
Good day all, I am new to php and lucky me my boss has asked me to do a 'proof of concept' with php against IBM DB2. Our DB2 database resides on an OS/390 system. I'm just trying to figure out at this point if php can actually connect to our database on the OS/390. I've read about ODBC

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

[PHP-DB] HELP NEEDED! SELECT of Text Fields in MS SQL Server 7.0 Limitation

2001-12-15 Thread Niko Spyridonos
When trying to extract the contents of a text field in MS SQL Server 7.0 with PHP 4.0, I can only get up to about 8,000 characters of text out of them. Has anyone achieved to pull more data using PHP and if yes how? Thanks in advance. Niko Spyridonos Director of E-Business Services

[PHP-DB] Help Needed !! -- Handling uploaded files by a script

2001-07-05 Thread sdfdn
Hi ... my name is Peter and I'm quite a rookie in PHP but not a total starter. ok ... in the file there is a form that contains one type file field... when I'm sending it to my script ... the is_uploaded_file() doesn't do anything... the variable ($pic_file) contains only the string with the