Question.
I am looking to try and pull the last modified date out and display it. So
lets say I have 1000 records. I want to only display the date of the last
modified time, I dont care about the id or the name or anything. How do I
query for that?
[snip]
I am looking to try and pull the last modified date out and display it.
So
lets say I have 1000 records. I want to only display the date of the
last
modified time, I dont care about the id or the name or anything. How do
I
query for that?
[/snip]
If you have a lst modified date column
Hi
I am a newbie to php + mysql and wanted to ask for some help on a
particular item which I can't seem to find the right key in the
documentation. I am trying to set up a simple QA system with an entry
page where one can select to either have all questions answers from a
mysql database
You should use the like clause whch allows the use of wild cards %
and ?.
Have a look at the MySQL manual, it should be explained there.
HTH
Gianluca
WS I am a newbie to php + mysql and wanted to ask for some help on a
WS particular item which I can't seem to find the right key in the
Subject: [PHP] php query for mysql table
Hi
I am a newbie to php + mysql and wanted to ask for some help on a
particular item which I can't seem to find the right key in the
documentation. I am trying to set up a simple QA system with an entry
page where one can select to either have all questions
: 20 August 2001 11:22
To: php-general
Subject: [PHP] php query for mysql table
Hi
I am a newbie to php + mysql and wanted to ask for some help on a
particular item which I can't seem to find the right key in the
documentation. I am trying to set up a simple QA system with an entry
page where one
On Mon, 20 Aug 2001 13:35:39 +0300, Niklas Lampén wrote:
% works as a wildcard in mySQL.
Example:
SELECT * FROM table WHERE Question LIKE '%life%' would return all rows
with field Question containing string life.
Hello all helpers,
well ... thanks to those who have already replied and helped
Notice that if a user enters
life anger
in the search field
SELECT * FROM table WHERE question LIKE %life anger% none of the
questions
[1] How do you deal with anger?
[2] Ever been full of anger in your life?
[3] Is life always easy?
will match. For that you must split the query by and
-
From: Morten Winkler Jørgensen [mailto:[EMAIL PROTECTED]]
Sent: 20. elokuuta 2001 13:47
To: [EMAIL PROTECTED]
Subject: Re[2]: [PHP] php query for mysql table
Notice that if a user enters
life anger
in the search field
SELECT * FROM table WHERE question LIKE %life anger% none
select * from yourtable where question like '%life%'
-- Original Message --
From: Wolfgang Schneider [EMAIL PROTECTED]
Reply-To: Wolfgang Schneider [EMAIL PROTECTED]
Date: Mon, 20 Aug 2001 12:22:15 +0200
Hi
I am a newbie to php + mysql and wanted to ask
FIND_IN_SET('value',set_col)0;
-Original Message-
From: Wolfgang Schneider [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 4:22 AM
To: php-general
Subject: [PHP] php query for mysql table
Hi
I am a newbie to php + mysql and wanted to ask for some help on a
particular item which
11 matches
Mail list logo