---
Nicole Swan
Web Programming Specialist
Carroll College CCIT
(406)447-4310
-Original Message-
From: Gabe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 23, 2004 8:59 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQL help
I'm using PHP with ADOdb ( and an MS Access 2000 db ) to write a si
st
Carroll College CCIT
(406)447-4310
-Original Message-
From: Gabe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 23, 2004 8:59 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQL help
I'm using PHP with ADOdb ( and an MS Access 2000 db ) to write a simple
SQL statement but was running
I'm using PHP with ADOdb ( and an MS Access 2000 db ) to write a simple
SQL statement but was running into some case sensitivity issues. Here's
my SQL currently:
SELECT autoQuesID,fldQuesTitle,fldBody
FROM tblFAQ_Question
WHERE fldBody LIKE '%$strSearchFor%';
All I'm trying to do is have the us
Hi Barry--
First, I want to see if I understand what you mean, then I'll take a shot
at some SQL to solve the problem.
I take it you have two tables, "a" and "b". They may look something like
this:
Table: a
id name
--- --
001 Bob
002 Ted
003 Mary
004 S
Hi,
Here's another SQL query problem:
How do I construct a query that returns 1 if a value is present and zero if
it is not, for a list of values returned in another query?
i.e. select a.id, a.name, c.selected from table-with-id-and-name a,
(select 1 as selected from another-table b if a.id
Sweet!!
Many thanks!
Russ
#---#
"Believe nothing - consider everything"
"Web Developers do it on-the-fly."
Russ Michell
A
Russ Michell wrote:
>
> Hi there folks, I have a small prob regarding SQL on MySQL 3.22.32
> using php4.0.3pl1 :
>
> I want to select DISTINCT sports from one table WHERE a username and a
> password match a username and a password in another table - not sure
> how to construct my query.
>
> In
Hi there folks, I have a small prob regarding SQL on MySQL 3.22.32
using php4.0.3pl1 :
I want to select DISTINCT sports from one table WHERE a username and a
password match a username and a password in another table - not sure
how to construct my query.
In an ideal world it's gonna look somet
