Group By, you'll generate an error if you forget it), then order
them, should work.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.
ation
* networking (with 1 items)
networks, telecommunications, protocols, routers, etc.
The above explains the more complicated query between three tables,
but you can also do this with a single table, or two tables.
Alnisa
--
.........
Alnisa Allgood
ave a
better idea of which pre-built systems will work for you or not.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
.org/ to download, or http://www.iviking.org/FX/
to test.
Alnisa
--
.............
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
using the http:// method at
all since its outside of your web root.
Alnisa
--
.....
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.non
ds changes the count results on occasion.
Alnisa
--
.........
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofi
2 from mdfaq_faq_cat faq_cat, mdfaq_category cat
> 3 where faq_cat.cat_id (+) = cat.id
> 4 group by cat.id, cat.name;
>
Funny, I think I just sent you something somewhat similar. Glad it worked.
Alnisa
--
.........
Alnisa Allgood
Exec
f not remove the cat.id and see if
it works, or what error is returned. All these different
implementations of SQL occasional kill me.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415
roup by. But this statement should work for you, as
well.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
(url) http://www.tech-library.org
...
$display_employee .="";
}
else
{
$display_employee .="
$empid";
};
}
?>
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415
LE ezsearch SELECT CONCAT(membername, \" \", mission, \"
\", brief, \" \", city, \" \", state, \" \", programs) AS searchable,
memberid FROM members
I get massive errors.
I'm reading MySQL from New Riders, but I can't seem to figure this
out bas
11 matches
Mail list logo
