how about :
SELECT (count( b.unique_id ) + 1) ranking
FROM table_name a, table_name b
WHERE a.unique_id = '4' AND b.score > a.score
Mike wrote:
Let's say I have a database and I want to find the position of a row when it is
ordered by a specific column
before a sort:
UNIQUE ID | SCORE
00
As a kind soul pointed out, I missed the string joining you need to do, so I
feel tasked with addressing this further..
Simple answer: I don't see a way to do this with a single query unless you're
using a DB with subqueries.. in which case you might be able to figure
something out, but withou
<[EMAIL PROTECTED]> wrote:
> I know something must be missing in my home setup, I hope I will learn that
> later. However when I uploaded the files to my ISP, the email functionality
> would work and emails went through with absolutely no problem.
u need an MTA set up on the machine (eg. qmail,
Just reorder your list of selected fields.
SELECT from WHERE
-Micah
On Sunday 06 March 2005 01:10 pm, Wendell Frohwein wrote:
> Hello all,
>
> Have a question for you, don't know how simple this is. I want the
> output that mysql sends to arranged a certain way and I don't know if it
> i
Hello all,
Have a question for you, don't know how simple this is. I want the
output that mysql sends to arranged a certain way and I don't know if it
is possible.
Here is the select statement:
SELECT cart_search.id, cart_search.year, cart_makes.thename as makename,
cart_models.thename as mod
Hello,
I had a very similar problem when I was trying to incorporate this
functionality. I have my development system at home with Windows XP home
edition, Apache server, and PHP5 and it would just not send the email from my
local machine even after changing the settings in the ini file, I kno
Hi Ron
Use nl2br()...its adds in tags. The other option is to use str_rplace
and replace the characters with ones of your choice
bastien
From: "Ron Piggott" <[EMAIL PROTECTED]>
To: "PHP DB"
Subject: [PHP-DB] mysql_real_escape_string for HTML ???
Date: Sat, 5 Mar 2005 23:21:14 -0500
I know of t
You actually need (it's in the manual) nl2br for this.
It converts newline (nl) to (2) break (br) so this text (\n indicates a
newline character or 'enter' as you've called it)
This\n
is\n
a\n
test\n
Would become
This\n
is\n
a\n
test\n
Make sure you strip those if you intend to put the content b
