It should be ` (back-ticks) not single quotes
SELECT `ID`, `Vacancy Role`, `Vacancy Salary`, `Vacancy Location`, `Vacancy Type`
FROM vacancy_details
WHERE Publish = 'Yes'
But you don't really need the back-ticks!
Thijs
Ford, Mike [LSS] wrote:
> -Original Message-
> From: Harlequin
-Original Message-
From: Harlequin
To: [EMAIL PROTECTED]
Sent: 04/08/04 01:55
Subject: [PHP] Query Results Question
I have the following query which should return just two rows:
SELECT 'ID', 'Vacancy Role', 'Vacancy Salary', 'Vacancy Location',
'Vacancy
Type'
FROM vacancy_details
WHER
I know what's going to happen though Richard. I'll dump it in their site and
it'll look terrible because they don't know how to use CSS effectively. But
hey - that's part of the fun.
Hyperlinks tomorrow though :|
--
-
Michael Mason
Arras People
www.arraspeople.co.u
Looks good :)
-
Thank you,
Richard Bewley
[EMAIL PROTECTED]
Equinox Systems and Development
Website: http://www.eq-dev.com/
Also, please look at our webhosting services, specializing in business web
hosting starting from $15 per
Many thanks Richard.
I have the table presenting neatly now, thanks for all your help with this
one...!
--
-
Michael Mason
Arras People
www.arraspeople.co.uk
-
"Richard Bewley" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Curt.
Thanks for the pointer and yes, I should be doing that and overlooked it
this time.
It's working now as I seem to be echoing the second record in the table and
will plug away at getting the table defined.
Thanks for all your help Curt.
--
-
Michael Mason
Arr
> I'm only selecting a few fields Richard as I want to try and drop them
into
an array and display in a table.
> I know I'm probably going the long way around doing this but I need to
learn
from scratch exactly how to do it.
> I appreciate your help and patience very much.
> I've managed to get
I'm only selecting a few fields Richard as I want to try and drop them into
an array and display in a table.
I know I'm probably going the long way around doing this but I need to learn
from scratch exactly how to do it.
I appreciate your help and patience very much.
I've managed to get the quer
* Thus wrote Harlequin:
> Richard
>
> Thanks firstly for your help. I renamed the fields so the spaces are
> underscores and amended your query but still receive an error:
>
> "not a valid MySQL result resource "
>
> Still tinkering though...
All this tinkering and database schema's are simply
> Richard.
> Public. I changed it to "Publish".
> But if I use a query window to interrogate the database I still get just
two
rows using the following query with field names not values for the row cell
contents:
> SELECT
'ID','Vacancy_Role','Vacancy_Salary','Vacancy_Location','Vacancy_Type'
F
Richard.
Public. I changed it to "Publish".
But if I use a query window to interrogate the database I still get just two
rows using the following query with field names not values for the row cell
contents:
SELECT
'ID','Vacancy_Role','Vacancy_Salary','Vacancy_Location','Vacancy_Type'
FROM vaca
> Richard
> Thanks firstly for your help. I renamed the fields so the spaces are
underscores and amended your query but still receive an error:
> "not a valid MySQL result resource "
> Still tinkering though...
Can you paste me
a.) Your database structure
b.) The exact query you are using
Als
Richard
Thanks firstly for your help. I renamed the fields so the spaces are
underscores and amended your query but still receive an error:
"not a valid MySQL result resource "
Still tinkering though...
--
-
Michael Mason
Arras People
www.arraspeople.co.uk
--
* Thus wrote Harlequin:
> I have the following query which should return just two rows:
>
> SELECT 'ID', 'Vacancy Role', 'Vacancy Salary', 'Vacancy Location', 'Vacancy
> Type'
> FROM vacancy_details
> WHERE Publish = 'Yes'
>
> As only two rows have Publish set to "Yes".
>
> yet even if I exe
Hi,
Take the spaces out of your field names, and then use this:
-
Thank you,
Richard Bewley
[EMAIL PROTECTED]
Equinox Systems and Development
Website: http://www.eq-dev.com/
--
PHP General Mailing List (http://www.php.net/)
To
15 matches
Mail list logo
