Peter Beckman wrote:
On Mon, 13 Nov 2006, [EMAIL PROTECTED] wrote:
Actually, that should not work, it should give you an error.
This should work:
SELECT `fkid`,max(`foo`) as foo,`bar` FROM `test2` GROUP BY `fkid`
ORDER BY `bar` ASC
Yes, but if the data is in a different order that fails a
On Mon, 13 Nov 2006, [EMAIL PROTECTED] wrote:
Actually, that should not work, it should give you an error.
This should work:
SELECT `fkid`,max(`foo`) as foo,`bar` FROM `test2` GROUP BY `fkid` ORDER BY
`bar` ASC
Yes, but if the data is in a different order that fails and doesn't maintain
r
Here's how you should do this (IMHO):
On you front page make a sql query say you want to display the latest 3
events. Your query probably will look like this:
select event_table_id, title from event_table order by date_created desc
limit 3;
then from the result make a while or for loop (for exa
I'd answer question number 3.
Well, it is just about an update section that the administrators will
input on the database for updates and event for a company, saying the
website has an updated page or simply putting an "event" for the public to
know.
Right now, I want to know how get a URL like t
Actually, that should not work, it should give you an error.
This should work:
SELECT `fkid`,max(`foo`) as foo,`bar` FROM `test2` GROUP BY `fkid` ORDER BY
`bar` ASC
Miguel Guirao wrote:
> select max(bar) from mytable where unique fkid order by bar asc
>
> as far as I remember!!
>
> -Ori
select max(bar) from mytable where unique fkid order by bar asc
as far as I remember!!
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: Lunes, 13 de Noviembre de 2006 04:59 p.m.
To: PHP-DB Mailing List
Subject: [PHP-DB] MySQL SQL Query Help
I have a table:
id fk
Hi
Try:
SELECT fkid, MAX(foo), bar FROM table GROUP BY fkid ORDER BY bar DESC
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I have a table:
id fkid foobar
1 1 345yellow
2 1 34 red
3 2 3459 green
4 2 345brown
I want to select the largest value of "foo" for a unique fkid, and return
bar, the results ordered by bar. In this case, 345 is the largest value of
foo for fkid 1, an
WOW! perfect, thanks a lot
mario
On Mon, 2006-11-13 at 16:16 -0500, Brad Bonkoski wrote:
> mario wrote:
> > Hello,
> >
> > really a mysql question. Pls. help anyway.
> >
> > Is there a simple, common way to implemt the following:
> > Say I have a table with a id autoincrement field.
> > I wish
mario wrote:
Hello,
really a mysql question. Pls. help anyway.
Is there a simple, common way to implemt the following:
Say I have a table with a id autoincrement field.
I wish to insert a record but just ist id value, get back the id value,
use it to update the record.
Do I need three separa
Hello,
really a mysql question. Pls. help anyway.
Is there a simple, common way to implemt the following:
Say I have a table with a id autoincrement field.
I wish to insert a record but just ist id value, get back the id value,
use it to update the record.
Do I need three separate mysql queries
Yes...
But, the experts on this list need more info in order to help you out.
1. Where are the stories going to come from? If you plant to take news
stories from other sites and use them on your own site, there are
serious legal issues involved.
2. If you want to write the stories yourself,
I've got a website using PHP and MySQL. I would like to make a "news
preview" on the webpage's frontpage with a link to the full story.
Is it possible to use one (1) .PHP file to generate full stories, with
MySQL involved?
I'm just a newcomer in the world of PHP but I am doing my best in reading
13 matches
Mail list logo
