for partial match
like 'value' doesn't work, use
like '%value%'
Hop that helps
Nitin
- Original Message -
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 11:57 AM
Subject: [PHP-DB] how to do query on partial field contents ???
hi
Hi
I'm a new member to the list and using php of rthe first time. I have
decided to use adodb so I can make a dsn-less connection to an access
database.
I have managed to get my script to run without errors but thats all I've
tried using a Select statement but it does nothing...
here's my
Hi Nadine,
Turn on debugging. Eg.
$db = ADONewConnection('access');
$db-debug = 1;
-* Nadine *- [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi
I'm a new member to the list and using php of rthe first time. I have
decided to use adodb so I can make a dsn-less connection to an
Hi I have this query
$sql = SELECT * FROM events WHERE ( YEAR(datum) = ' . $year . ') ORDER BY
datum ASC;
$result = mysql_query($sql);
$numRows = mysql_num_rows($result);
for ($row = 1; $row = $numRows; $row++) {
$rowArray = mysql_fetch_array($result);
$datum=
Thanx, I tried that but it didn't show anything :(
...
Hi Nadine,
Turn on debugging. Eg.
$db = ADONewConnection('access');
$db-debug = 1;
_
Get fast, reliable access with MSN 9 Dial-up. Click here for
[EMAIL PROTECTED] wrote:
Good Morning,
This post is somewhat OT -- please forgive me. I've spent over 3 days
trying to get sendmail configured and I've lost some patience and
reasoning ability in the process.
I have a Linux (RH9), Apache 2.0.48, PHP 4.3.4, MySQL GUI that creates a
PDF
And if you'd like to make wild carding optional keep your code the way it
is:
$query .= AND `model` LIKE '.$_GET['search'].';
And put a comment on the web page Use the % for wild cards.
The thing about:
$query .= AND `model` LIKE '%.$_GET['search'].%';
Is it will return many
Frank Flynn wrote:
And if you'd like to make wild carding optional keep your code the way it
is:
$query .= AND `model` LIKE '.$_GET['search'].';
And put a comment on the web page Use the % for wild cards.
The thing about:
$query .= AND `model` LIKE '%.$_GET['search'].%';
Is it will
Peppe
Don't search by month at all - use a start and stop date then order by date.
Now you have one result set with all the dates in it and you can use your
PHP code to figure out where to close one table and open a net one:
$result = mysql_query($sql);
echo TABLE;
$thisMonth = $result[3];
Too true - this is why a page that I promised would only take a few minutes
winds up taking all week.
But it makes steady employment for the QA team...
Frank
On 2/24/04 10:37 AM, Andy Armstrong [EMAIL PROTECTED] wrote:
Frank Flynn wrote:
And if you'd like to make wild carding optional
Found the answer to the first part of my question:
SELECT D_Num = IDENTITY(int, 1, 1),*
INTO temptable
FROM
someViewOrTable
Frank Flynn [EMAIL PROTECTED] wrote:
On 2/19/04 4:09 PM, [EMAIL PROTECTED]
wrote:
From: Karen Resplendo
Date: Thu, 19 Feb 2004 11:37:48 -0800 (PST)
To: [EMAIL
I have a client that does not want to use a DBMS for storing the email
addresses the surfers input. Is there a class available that has a
search function as well as an append?
I would like to have several fields separated by a tab or : .
Todd
--
PHP Database Mailing List
Todd Cary wrote:
I have a client that does not want to use a DBMS for storing the email
addresses the surfers input. Is there a class available that has a
search function as well as an append?
I would like to have several fields separated by a tab or : .
Todd
I have heard that SQLite is
Here is the webpage that demonstrates my code problem:
http://170.104.158.16/chemlatestPAGETEST.php3?pwsno=00100
I'm so close I can smell it. Hoping someone can troubleshoot my code. Here is the
piece that doesn't work. It returns the 2 column names, over and over. For some reason
I'm not
One thing may be that you need to do a fetch to increment the result row
odbc_fetch_row($result);. Though that doesn't explain your column names
being in the array unless that's what's in the table.
Ryan
-Original Message-
From: Karen Resplendo [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
Hi,
I have installed php5b4 and test run my existing application, it failed for
the below error:
[25-Feb-2004 10:24:21] PHP Notice: Object of class Template could not be
converted to string in D:\Easyfind\library\template.php on line 71
Please help to give me any ideal what went wrongs and
Todd Cary wrote:
I have a client that does not want to use a DBMS for storing the email
addresses the surfers input. Is there a class available that has a
search function as well as an append?
I would like to have several fields separated by a tab or : .
Todd
I've been writing a lot of
Richard Davey wrote:
Hello Justin,
Monday, February 23, 2004, 5:30:16 PM, you wrote:
JP The real hairy part is dealing with joins as the syntax is very
JP different across the DBs. This can be solved by simply not doing them or
I wish :)
JP using a syntax that most use. Or you can try to use
18 matches
Mail list logo