Nope, I needed to extract the most recent data by date, but then sort it by
keyword once extracted. This is based on two different fields in the same
table. I do apologise for saying drop it into another table when I am putting
it into an array.
***
$sql = 'SELECT * FROM dbtable WHERE page_url = "' . $_SERVER['PHP_SELF'] . '"
ORDER BY load_date DESC LIMIT 30';
***
This gets the most recently entered data as "load_date" is a DATETIME column.
But then i need to sort it by a seperate column "keyword" alphabetically.
AFAIK (which isn't much) neither SQL or any PHP mysql_XXX functions allow
that, so i need to drop it into an array first then sort the array. It works
with Simons method, I'm good unless someone has something more elegant now i
have explained more.
On Friday 11 March 2011 19:40, Chathura Jayasekara wrote:
> INSERT INTO xxxxtable (xxx1field, xxx2field, xxx3fieldl )
> SELECT y.xxx1field, y.xxx2field, y.xxx3field FROM yyy y where {condition}
>
> just do above man with simple mysql_quiry I think this is what need
> to simply archive...
>
> CJ
>
> On Fri, Mar 11, 2011 at 10:30 AM, Simon J Welsh <[email protected]> wrote:
> > $foo = array();
> > while($row = mysql_fetch_assoc($result)) {
> > $foo[] = $row;
> > }
> >
> > Alternatively, array_push($foo, $row); would also work.
> >
> > On 11/03/2011, at 5:55 PM, Michael Adams wrote:
> > > Is there a simple way to do this so my whole weekend isn't spoiled
> >
> > worrying
> >
> > > about it.
> > >
> > > I want to take all the data from a MySQL query and drop it into another
> >
> > table.
> >
> > > I tried:
> > > ****
> > > $foo = array( );
> > > while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
> > > $foo -> append($row);
> > > }
> > > ****
> > >
> > > But that was a PHP5 solution and even on PHP5 did not seem to like
> >
> > appending
> >
> > > the first result to an empty array.
> > >
> > > This is the best i can do at present which would be extremely wasteful
> > > if
> >
> > i
> >
> > > had 20 columns in the table instead of the three i am showing here:
> > > ****
> > > $foo = array( );
> > > $i = 1;
> > > while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
> > > $foo[i] = array ('tagID' => $row['id'],
> > > 'date' => date("d-m-Y H:i",strtotime
> >
> > ($row['load_date'])),
> >
> > > 'keyword' => htmlspecialchars($row['keywords']))
> > > ; i++;
> > > }
> > > ****
> > >
> > > TIA
> > >
> > > --
> > > Michael
> > >
> > > --
> > > NZ PHP Users Group: http://groups.google.com/group/nzphpug
> > > To post, send email to [email protected]
> > > To unsubscribe, send email to
> > > [email protected]
> >
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
