[PHP-DB] table match lookup!

2003-12-18 Thread JeRRy
Hi, If I have a table named quote and the field has 30 words in it is there a way to pin-point a certain word and match it with another query in PHP? So a quote may say: "Tomorrow never comes" And I wanted 'never' to be dragged out of all quotes and counted in another table to keep a track of h

RE: [PHP-DB] Search Query

2003-12-18 Thread Ford, Mike [LSS]
On 18 December 2003 05:26, Ng Hwee Hwee wrote: > Dear all, > > i need help with my search query statement.. what is wrong > with my code? Nothing obvious that I can see, except a little inefficiency. Where do $keyword and $table come from? -- is this a register_globals issue? > > $wor

Re: [PHP-DB] Search Query

2003-12-18 Thread Ng Hwee Hwee
thanx Mike for your help!! appreciatively, hh - Original Message - From: "Ford, Mike [LSS]" <[EMAIL PROTECTED]> To: "'Ng Hwee Hwee'" <[EMAIL PROTECTED]>; "DBList" <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 6:06 PM Subject: RE: [PHP-DB] Search Query > On 18 December 2003 05:26

[PHP-DB] .DOC to PDF on line

2003-12-18 Thread Webmaster D.G.R.E.R.
Hi: My name is Sergio Barreira, i want to know if there are any method (in PHP) for to convert any .DOC to PDF on line and show it. Thank You! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: php mail() question

2003-12-18 Thread JeRRy
Hi, Just to follow-up on this. I knuckled down and did some work regarding this thread. What I achieved makes things work a tad faster than previously however it did not work out as I wanted entily but has fastened the process somewhat but still have a question regarding it. I have managed to b

[PHP-DB] DB, XML and & sign

2003-12-18 Thread Muhammed Mamedov
Hello everyone, I read input from user, then via XML send it to DB. thing is that when user enters "&" sign XML is no more well-formatted, what causes error. Does anyone has any suggestions on how to remove & sign from user input, considering that data entered by users can be multilingual, that

[PHP-DB] Planetside

2003-12-18 Thread Madaleno
Hi, can someone help me on how to access Planetside database to get some character info? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP-DB Problem

2003-12-18 Thread John Greco
*Sorry if this is a duplicate* Using mySQL db to store my data. Using a select statement on my PHP page. When it lists out the data it seems to be skipping the first row. Any ideas? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Skipping a row

2003-12-18 Thread John Greco
I have a select statement that goes to my mySQL db and selects some data from there. I thought it was working great BUT it is skipping the first row. Any ideas? I know it has to be somehting simple I am missing. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

Re: [PHP-DB] Skipping a row

2003-12-18 Thread Martin Marques
El Jue 18 Dic 2003 18:27, John Greco escribiĆ³: > I have a select statement that goes to my mySQL db and selects some data > from there. I thought it was working great BUT it is skipping the first row. > Any ideas? I know it has to be somehting simple I am missing. Depends on how you are fetching y

[PHP-DB] Reading emails with PHP

2003-12-18 Thread Chris Payne
Hi there everyone, A quick question, is it possible to read a failed mail email and pick out the failed email address? I have around 900 failed emails (Don't ask, long story) from a client and what I want to do is just put the emails in a folder and cycle through the folder and pickout the ema

Re: [PHP-DB] Reading emails with PHP

2003-12-18 Thread David T-G
Chris -- ...and then Chris Payne said... % % Hi there everyone, Hi! % % A quick question, is it possible to read a failed mail email ... % % Any help, tips would be REALLY appreciated as I REALLY don't want to spend a few days doing it manually. It may be sacrilege to mention it here, but

Re: [PHP-DB] Skipping a row

2003-12-18 Thread Fedde van Feggelen
I have a select statement that goes to my mySQL db and selects some data from there. I thought it was working great BUT it is skipping the first row. Any ideas? I know it has to be somehting simple I am missing. What is the SQL statement you're currently using? Fedde ~=There's a fine line betwee

Re: [PHP-DB] Skipping a row

2003-12-18 Thread John Greco
$sql2 = "select * from product where whseNum = '".$whseNumber."' order by prodNum"; "Fedde Van Feggelen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > >I have a select statement that goes to my mySQL db and selects some data > >from there. I thought it was working great BUT it i

[PHP-DB] Re: Where's the mix-up?

2003-12-18 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Help: > > > $sql = "select id1 from GCN_Salesmen where username = '$PHP_AUTH_USER'"; > $user_id = mysql_query($sql) or die(mysql_error()); > > > Produces: You have an error in your SQL syntax near 'id #2' at line 1 > > > $sql = "sel

[PHP-DB] Re: Search Query

2003-12-18 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Dear all, > > i need help with my search query statement.. what is wrong with my code? > > > $word = split(" ", $keyword); > $num_words = count($word); > $word_str = ""; > $criteria = ""; > > for ($i=0; $

[PHP-DB] Re: PHP-DB Problem

2003-12-18 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > *Sorry if this is a duplicate* > > Using mySQL db to store my data. Using a select statement on my PHP page. > When it lists out the data it seems to be skipping the first row. Any ideas? > Without seeing your code, I'll have to guess t

[PHP-DB] No php_pgsql.dll in PHP 5.0.0b2 for Windows

2003-12-18 Thread Gezeala 'Eyah' BacuƱo II
Hi! I've just downloaded php 5.0.0b2 for Windows.. I've already configured Apache 2.0.47 which is also running on Windows to run php 5. I also tested installing PHP as a module and as a CGI binary for Apache..All works fine.. Now I want to run my scripts which accesses a postgreSQL database..

[PHP-DB] Data Representation

2003-12-18 Thread Sai Hertz And Control Systems
Dear All, I was looking for some PHP GPL 'ed package which will retrieve my data from backend (PostgreSQL 7.4) and let you do what ever you like with it i.e . Total of field values , Sub Total of others , Supports labeling of table fields the package must also have the paging facility moreov