How do you create ascii line breaks in a text paragraph in mysql?.
When displaying text taken from a mysql row it displays it all as a flowing paragraph
ie
sdf sdfgfj fgjhgfh fgj fgj hfj hj hg gh hgk ghk gj gh kg k hg hg jh j fgj fg
When i need to look like
sdf sdfgfj fgjhgfh
fgj fgj hfj hj
I have a mysql table column called 'imagecolumn' The rows contain links i.e.
image.gif
image.gif
null
image.gif
image.gif
To display in my web page im using:
This displays the above images in my html page
The problem i have is where the field in my table is left blank (null), a web browser
Out of interest is there any advantage of using a primary key?, or is it
perfectly ok/normal not to specify one?.
Im not quite sure what a primary does. I only used a primary key on one
table which had auto_increment column only because it forced me to add it.
??
> Hello
>
> I belive this is no
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
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
I have one column as an auto increment for adding numbers:
1
2
3
4
5
If i delete row 3 then add a new row and view the results i get:
1
2
4
5
6
As you can see 3 has been deleted and its now added 6!
Is this normal?. How can i get it to always display numbers in this column
in sequence.
TIA
> SET @rank:=5;
>
> UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
> UPDATE music SET chart=chart+1 WHERE chart<@rank;
>
Thanks Don
Unfortunately though i think we need to be able to make the changes in
something we can see which is why we are using mysqlcc.
With mysqlcc any of us can simply
Can anyone advise how we should improve this method of updating our database.
We have a Music chart it is a table with 3 columns
Chart Number (ie, 1,2,3,4,5,6,7,8,9,10..)
Artist (Artists Name)
Title (Title of Song)
Each week we login using mysql control center to make changes to the chart pos