sql help needed

[erikson]

hi all

i have some questions regards sql

so i have a db with 2 fields

the first field is the nr.crt ( 1, 2 , 3 etc )

the second field is "free" and contains 1 or 0

i insert this querry

$sQuery = "SELECT nr.crt FROM db_name WHERE free='1' "

to select get all the fields who contain in the "free" value 1

now all i whant is that i can write somewere this fields

example

------------------

nr.crt | free |

------------------

1 | 1 |

------------------

2 | 0 |

------------------

3 | 1 |

------------------

4 | 1 |

------------------

so i whant to write somewere the fields who contain 1

like :

1 , 3, 4

can anyone tell me if this is possible and how to do it?

note thet i used mysql.au3

Edited March 8, 2007 by erikson

[guwguw]

hi all

i have some questions regards sql

so i have a db with 2 fields

the first field is the nr.crt ( 1, 2 , 3 etc )

the second field is "free" and contains 1 or 0

i insert this querry

$sQuery = "SELECT nr.crt FROM db_name WHERE free='1' "

to select get all the fields who contain in the "free" value 1

now all i whant is that i can write somewere this fields

example

------------------

nr.crt | free |

------------------

1 | 1 |

------------------

2 | 0 |

------------------

3 | 1 |

------------------

4 | 1 |

------------------

so i whant to write somewere the fields who contain 1

like :

1 , 3, 4

can anyone tell me if this is possible and how to do it?

It's possible, but which version of SQL are you talking about?

MySQL?

Microsoft SQL?

Oracle?

Normally, "nr.crt" would be an illegal field name, because the letters before the dot refer to the name of the database.

[erikson]

MySQL - 4.0.21-nt

Protocol version: 10

with ODBC 3.51 DRIVER

[ptrex]

@erikson

The best way to get started with SQL is looking here :

SQL School

by the way the link shows you how to do an UPDATE statement need to write something to the DB

Regards

ptrex

[erikson]

@erikson

The best way to get started with SQL is looking here :

SQL School

by the way the link shows you how to do an UPDATE statement need to write something to the DB

Regards

ptrex

dude you just don`t understaind what i ask ....

for the others i find the solution

CODE

$var = _Query($sql,"SELECT * FROM table WHERE free = '1' ")

With $var

While NOT .EOF

FileWriteLine("c:\test.txt",.Fields("numar").value & @CRLF)

.MoveNext

WEnd

EndWith

ps . i know sql

Edited March 8, 2007 by erikson

[guwguw]

dude you just don`t understaind what i ask ....

for the others i find the solution

CODE

$var = _Query($sql,"SELECT * FROM table WHERE free = '1' ")

With $var

While NOT .EOF

FileWriteLine("c:\test.txt",.Fields("numar").value & @CRLF)

.MoveNext

WEnd

EndWith

ps . i know sql

Does that mean you solved what you were looking for?

Because I read your initial post that you were trying to get a comma separated list of those entries with "free" set to 1 (which your code snippet is close to but not quite there yet).

If I'm wrong, try to be a better communicator, please