How to retrive items from listview and listbox and use it in mysql

[DavidTigerch]

Hi all . I got the following sql statemnt that insert data to mysql db . Currently i have to enter artistsname and albumname manually(shown in bold beleow) but i want to collect them from listview and also get one extra item information which is from listbox(cdpic) .

I be happy if some one help me construct the correct sql by collecting correct data from listview and listbox. thanks

My current insert statement:

      CNN.Execute "INSERT INTO songs (filename,title,artist,album) VALUES('" & path & "','" & title & "',' [B]Andy[/B]',[B]'Live concert in Germany[/B]')"

1)artist and album data ==> from first row of 3th and 4th column of listview
( 3th and 4th listview column names artistName,albumName)

2)cdpic data ======> from first row of listbox

Note: i want t add http://localhost prefix to the value of first row of listbox then use the whole value in sql statment.
cdpic = http://localhost/+ first item of listbox

create the insert statemetn just like this with bold parts those information i want to collect from listbox and listview:

CNN.Execute "INSERT INTO songs (filename,title,[B]artist,album,cdpic[/B]) VALUES('" & path & "','" & title & "',' [B]????[/B]','[B]?????[/B]','[B]??????[/B]')"

 

[johnwm]

Several of your recent questions seem to be looking for us to write simple alterations to basic code. The concept of using variables is absolutely fundamental to any programming exercise. In thread222-1224170 I pointed you to some beginners tutorials, which will provide you with an understanding of how variables work, and how they are used. I suggest you go back and review those tutorials. When you have done so, the answer to this will be very obvious.

Have a try, and come back if you still have a specific problem. You will never progress and learn if you get others to write all your code for you!

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller