Bryan wrote:
SELECT * FROM productgroup WHERE groupid = $productid
AND label = 'Cats' ORDER BY title
SELECT * FROM productgroup WHERE groupid = $productid
AND label != 'Cats' ORDER BY label,title
I'd like to find a way to combine these 2 statements. I want to list out
all the products,
Try this:
SELECT * FROM productgroup WHERE groupid = $productid
ORDER BY label = 'Cats' DESC, title
The test SQL I did to make sure I understood it was this (against our Users
table):
select * from users order by first = 'Bob' DESC, first, last
It put all the Bobs first, sorting them by
I think there's one small piece of data I left out. I'm working with
php/mssql, no mysql. I'll move to mysql when I get everything else
built. Mssql 2000 doesn't seem to like the = sign in the order by
clause. It looks like both of you so far have come up with the same
syntax though so it must
I think there's one small piece of data I left out. I'm working with
php/mssql, not mysql. I'll move to mysql when I get everything else
built. Mssql 2000 doesn't seem to like the = sign in the order by
clause. It looks like both of you so far have come up with the same
syntax though so it
PHPDiscuss - PHP Newsgroups and mailing lists wrote:
Hello everybody,
I'm building a small application and I have trouble passing a POST
variable form one page to another inside the SQL statement.
The query displayed below works great without the
.$_POST['CompanyName'].
$query_company_listing =
missing the singles quotes around the company name text element
$query_company_listing = SELECT CompanyID, CompanyName,
CompanyOrDepartment, BillingAddress, City, PostalCode, PhoneNumber FROM
company WHERE company.CompanyName='.$_POST['CompanyName'].' ORDER BY
CompanyName ASC;
bastien
From:
Jason,
can you please turn off the return receipts on emails you send to the list.
it's bloody annoying to have 'The Sender wishes to be notified'
popup messages everytime I read one of your emails (and, alas, I don't
have the skill to hack the return receipt crap right out of Tbird). BTW
Hi,
To stop the return receipt dialog appearing in Tbird...
Tools... Options... Advanced... Return Receipt and select Never send a
return receipt. Or you can choose some of the other selections.
graeme
Jochem Maas wrote:
Jason,
can you please turn off the return receipts on emails you send to
First off - $_POST['CompanyName'] is valid, right?
Can you do something like this?:
if (isset($_POST['CompanyName'])){
$sqlCompanyName = $_POST['CompanyName'];
} else {
return them back to the form, or something?
}
$query_company_listing = SELECT CompanyID, CompanyName,
Jimi,
PHP does not return an error because it knows nothing about valid sql.
It's just knows if it's a valid PHP statement. (which it is because
you've got the 's in the right place and a ; at the end. ) :)
It's up to MySQL to return an error.
As to your statement.
1: It's easier and valid in
Thompson, Jimi wrote:
So then I try do this
?php
if ($fk_phone != NULL) {
$sqlwrk = SELECT `pk_phone_reports`, SUM(`calls`) AS `total_calls`,
`date`, `calls` , `fk_ph_num` FROM `phone_reports`;
$sqlwrk .= WHERE `pk_phone_number` = . $fk_phone;
$rswrk =
Gurhan:
snip
I was wondering if you'd wanna use temporary tables to accomplish it..
Actually, another person on this list came up with the following:
SELECT s1.site_id
FROM site_category AS s1
JOIN site_category AS s2
WHERE s1.category_id=10
AND s2.category_id=12
On Tuesday 19 March 2002 10:22, Summit wrote:
For some reason I keep thinking that this should be simple - but I just
can't seem to figure it out. Help??? Please??? [I've been working on
it for two days now.]
Overview: What I'm trying to do is query one table by passing it two
different
ok it is 1:37 am here and i have been up since 6:00 am (the day before) and
have to be awake ths mornign again at 6:00 am so if I make any mistakes
trying to answer your question, please take it easy:)
I was wondering if you'd wanna use temporary tables to accomplish it..
You may wanna do:
Well it's sorta' simple once you get your mind around this - you need two
tables but you've only got one. And there's no OR, you need both to be true
for a site_id ...
The query would be easy if you actually had two tables so we'll search off
of the same table twice giving it different names
alter table remove column_name
Or something along those lines.
Hope that helps a little bit.
Wesley Choate
Daymark Group
Programmer / Web Developer
Phone: (501)-968-4038 X2204
Email: [EMAIL PROTECTED]
Web: www.daymarkgroup.com
-Original Message-
From: Scott Fletcher [SMTP:[EMAIL
16 matches
Mail list logo