RE: [PHP] Query Results Question
-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 WHERE Publish = 'Yes' As only two rows have Publish set to Yes. yet even if I execute the query through phpMyAdmin I get two rows with field headings as field values. -- I may be wrong, as I don't use mySQL, but shouldn't those be back-ticks around the column names and not single quotes? With the quotes, you're just asking the database to return the literal text as if it were a column value. Back ticks are used to enclose column names that contain non-alphanumeric characters. Cheers! Mike Any suggestions on where I'm going wrong...? I'm pretty sure my query syntax is accurate as I've used this type of query many times before and have even checked the syntax by using a query window. -- - Michael Mason Arras People www.arraspeople.co.uk - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query Results Question
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 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 WHERE Publish = 'Yes' As only two rows have Publish set to Yes. yet even if I execute the query through phpMyAdmin I get two rows with field headings as field values. -- I may be wrong, as I don't use mySQL, but shouldn't those be back-ticks around the column names and not single quotes? With the quotes, you're just asking the database to return the literal text as if it were a column value. Back ticks are used to enclose column names that contain non-alphanumeric characters. Cheers! Mike Any suggestions on where I'm going wrong...? I'm pretty sure my query syntax is accurate as I've used this type of query many times before and have even checked the syntax by using a query window. -- - Michael Mason Arras People www.arraspeople.co.uk - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query Results Question
Hi,
Take the spaces out of your field names, and then use this:
?php
$query = mysql_query(SELECT
id,vacancy_role,vacancy_salary,vacancy_location,vacancy_type FROM
vacancy_details WHERE Public='yes');
while($result = mysql_fetch_array($query)) {
echo $result[id] - $result[vacancy_role];
}
?
-
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 unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query Results Question
* 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 execute the query through phpMyAdmin I get two rows with field headings as field values. Any suggestions on where I'm going wrong...? I'm pretty sure my query syntax is accurate as I've used this type of query many times before and have even checked the syntax by using a query window. stab in=the darkmysql_error()/stab Curt -- First, let me assure you that this is not one of those shady pyramid schemes you've been hearing about. No, sir. Our model is the trapezoid! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query Results Question
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
-
Richard Bewley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
Take the spaces out of your field names, and then use this:
?php
$query = mysql_query(SELECT
id,vacancy_role,vacancy_salary,vacancy_location,vacancy_type FROM
vacancy_details WHERE Public='yes');
while($result = mysql_fetch_array($query)) {
echo $result[id] - $result[vacancy_role];
}
?
-
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 unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query Results Question
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 Also, you may want to do $query = mysql_query(SELECT * from vacancy_details) or die(mysql_error()); I don't care about the first part of that, but try putting in the mysql_error() in the form I used above, and see if it gives you any other information. - 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 month! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query Results Question
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 vacancy_details WHERE Publish='Yes' -- - Michael Mason Arras People www.arraspeople.co.uk - Richard Bewley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 Also, you may want to do $query = mysql_query(SELECT * from vacancy_details) or die(mysql_error()); I don't care about the first part of that, but try putting in the mysql_error() in the form I used above, and see if it gives you any other information. - 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 month! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query Results Question
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 vacancy_details WHERE Publish='Yes' Take out the quotes. Make your query say: SELECT ID,Vacancy_Role,Vacancy_Salary,Vacancy_Location,Vacancy_Type FROM vacancy_details WHERE Publish='Yes'; Also, if you are selecting every field, then why not do a SELECT *? - 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 month! -- - Michael Mason Arras People www.arraspeople.co.uk - Richard Bewley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 Also, you may want to do $query = mysql_query(SELECT * from vacancy_details) or die(mysql_error()); I don't care about the first part of that, but try putting in the mysql_error() in the form I used above, and see if it gives you any other information. - 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 month! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query Results Question
* 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 the long way around things. Just use mysql_error() after you query. mysql_query($sql) or die(mysql_error()); You'll know exactly whats wrong. Curt -- First, let me assure you that this is not one of those shady pyramid schemes you've been hearing about. No, sir. Our model is the trapezoid! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query Results Question
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 query returning some results now. An array. I'm going to have to spend a little, well actually quite a bit, of time now working out how to present these in a table. I assume a for statement will get me pointing in the right direction...? -- - Michael Mason Arras People www.arraspeople.co.uk - Richard Bewley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 vacancy_details WHERE Publish='Yes' Take out the quotes. Make your query say: SELECT ID,Vacancy_Role,Vacancy_Salary,Vacancy_Location,Vacancy_Type FROM vacancy_details WHERE Publish='Yes'; Also, if you are selecting every field, then why not do a SELECT *? - 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 month! -- - Michael Mason Arras People www.arraspeople.co.uk - Richard Bewley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 Also, you may want to do $query = mysql_query(SELECT * from vacancy_details) or die(mysql_error()); I don't care about the first part of that, but try putting in the mysql_error() in the form I used above, and see if it gives you any other information. - 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 month! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query Results Question
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 query returning some results now. An array. I'm
going to have to spend a little, well actually quite a bit, of time now
working out how to present these in a table.
I assume a for statement will get me pointing in the right direction...?
You are correct that the mysql_fetch_array will return an array which you
can format into a table. You can use a while loop if you would like, which
is probably the simplest.
?php
$query = mysql_query(SELECT
ID,Vacancy_Role,Vacancy_Salary,Vacancy_Location,Vacancy_Type FROM
vacancy_details WHERE Publish='Yes');
echo table cellspacing=\4\ cellpadding=\4\ width=\50%\\n;
echo trtdbID:/b/tdtdbVacancy Role:/b/tdtdbVacancy
Salary/b/tdtdbVacancy Location/b/tdtdVacancy
Type/b/td/tr\n;
while($result = mysql_fetch_array($query)) {
echo
trtd$result[id]/tdtd$result[Vacancy_Role]/tdtd$result[Vacancy_S
alary]/tdtd$result[Vacancy_Location]/tdtd$result[Vacancy_Type]/td
/tr\n;
}
echo /table;
?
-
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 month!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query Results Question
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 Arras People www.arraspeople.co.uk - Curt Zirzow [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] * 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 the long way around things. Just use mysql_error() after you query. mysql_query($sql) or die(mysql_error()); You'll know exactly whats wrong. Curt -- First, let me assure you that this is not one of those shady pyramid schemes you've been hearing about. No, sir. Our model is the trapezoid! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query Results Question - Solved
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]
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 query returning some results now. An array. I'm
going to have to spend a little, well actually quite a bit, of time now
working out how to present these in a table.
I assume a for statement will get me pointing in the right direction...?
You are correct that the mysql_fetch_array will return an array which you
can format into a table. You can use a while loop if you would like,
which
is probably the simplest.
?php
$query = mysql_query(SELECT
ID,Vacancy_Role,Vacancy_Salary,Vacancy_Location,Vacancy_Type FROM
vacancy_details WHERE Publish='Yes');
echo table cellspacing=\4\ cellpadding=\4\ width=\50%\\n;
echo trtdbID:/b/tdtdbVacancy Role:/b/tdtdbVacancy
Salary/b/tdtdbVacancy Location/b/tdtdVacancy
Type/b/td/tr\n;
while($result = mysql_fetch_array($query)) {
echo
trtd$result[id]/tdtd$result[Vacancy_Role]/tdtd$result[Vacancy_S
alary]/tdtd$result[Vacancy_Location]/tdtd$result[Vacancy_Type]/td
/tr\n;
}
echo /table;
?
-
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 month!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query Results Question - Solved
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 month! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query Results Question - Solved
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.uk - Richard Bewley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 month! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
