On 02-Jun-2003 Jay Blanchard wrote:
> [snip]
> Its just a query. And theyre being displayed on a webpage.
>
> [/snip]
>
> This just caught my eye ... "And theyre being displayed on a webpage."
>
> SO, there is another language afoot here, right? You have to have
> something to retrieve to the
ot;Daniel Crompton" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, 02 June, 2003 14:43
Subject: RE: Displaying numbers with results - any ideas?
[snip]
Its just a query. And theyre being displayed on a webpage.
[/snip]
This just caught my eye ... "And theyre being di
[snip]
Its just a query. And theyre being displayed on a webpage.
[/snip]
This just caught my eye ... "And theyre being displayed on a webpage."
SO, there is another language afoot here, right? You have to have
something to retrieve to the web page, like PHP, PERL, VBScript, etc.
You can also
[snip]
You will have to do two things, set a variable to zero and then add to
it on each iteration. Yes...those are variables and that is a colon in
the SELECT statement.
SET @count=0;
SELECT @count:[EMAIL PROTECTED], this_column, that_column, etc
FROM your_table;
[/snip]
I should have mentioned
You will have to do two things, set a variable to zero and then add to
it on each iteration. Yes...those are variables and that is a colon in
the SELECT statement.
SET @count=0;
SELECT @count:[EMAIL PROTECTED], this_column, that_column, etc
FROM your_table;
HTH!
Jay
--
MySQL General Mailing Lis
Hi Jay
Its just a query. And theyre being displayed on a webpage.
Its a chart so i need each result displayed with sequential numbers starting
at 1 - ...
down the left hand side of the results ie.
1
2
3
4
5
etc.
Any thoughts?
[snip]
Any ideas how to get sequential numbers to display with
[snip]
Any ideas how to get sequential numbers to display with results?.
...
Any ideas?
{/snip]
Are you just doing this in a query? Or is there another language
involved?
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Any ideas how to get sequential numbers to display with results?.
SELECT * FROM musicchart WHERE artistcountry = ''uk''
I need to get the result to show with numbers down the left side such as:
1 mark
2 john
3 pete
4 mike
5 tom
i.e. if it pulls back 3 results show as
1 john
2 mike
3 tom
I ca
