On Thursday, April 25, 2002, at 05:38 PM, Steve Buehler wrote:
> Thank you for wanting to try and tackle this in PHP/MySQL. I will
> include the code that I have and also the sql for the tables.
...
> Here is my Select statment
> Select * from $temp2 where sea_id = '$sea_id' order by pts DE
Thank you for wanting to try and tackle this in PHP/MySQL. I will include
the code that I have and also the sql for the tables.
CREATE TABLE b863765470 (
team_id int(10) default NULL,
name varchar(30) default NULL,
sea_id int(10) default NULL,
w int(10) default '0',
l int(10) default '0
First off, thank you Miguel and Nathan for responding.
The ordering changes. Here is what I have for my query:
$searchStmt="Select * from $temp2 where sea_id = '$sea_id'
order by pts DESC";
if($aa){$searchStmt .= ",$aa DESC";}
if($bb){$searchSt
On Thu, 25 Apr 2002, Steve Buehler wrote:
> I am using PHP to access a mysql database. I was told that what I need to
> do needs to be done in PHP and not mysql. I can get mysql to order things
> like this:
> Select * from $temp2 where sea_id = '$sea_id' order by pts DESC
> The problem is that
I am using PHP to access a mysql database. I was told that what I need to
do needs to be done in PHP and not mysql. I can get mysql to order things
like this:
Select * from $temp2 where sea_id = '$sea_id' order by pts DESC
The problem is that if there is a tie (as in ranking 4 and 5 below), I
5 matches
Mail list logo
