Hmm.. You should be a little more specific, when you ask for help.
Do you mean that you have a database with fields called column1, column2,
column3 ? and you want to make an SQL statement which returns an array of
"column1 => value1", "column2 => value2", "column2 => value2" ?
If so you must first create the table (done with the simple sql statement
which follows:)
CREATE TABLE test (
column1 TEXT,
column2 TEXT,
column3 TEXT);
then you could insert the values into the table using the INSERT sql
statement:
INSERT INTO test (column1,column2,column3) VALUES
('value1','value2','value3');
And finally you can use the mssql functions in php to extract the data from
your mssql server, and fetch into an array perhaps?
$server = "localhost";
$user = "youruser";
$pass = "yourpassword";
$database = "mydb";
mssql_connect($server,$user,$pass);
mssql_select_db($database);
$result = mssql_query("SELECT * FROM test;");
while($arr = mssql_fetch_array($result))
{
print("column1 = " . $arr["column1"] . "<br>column1 = " .
$arr["column2"] . "<br>column3 = " . $arr["column3"]);
}
Or you could always just print_r it.. ($arr = mssql_fetch_array($result);
print_r($arr);)
well, I hope this was of some help..
"Martin" <martini@mailme.dk> wrote in message
news:eojbbt47ubh5umr1aesriq5eukginobj3b@4ax.com...
> kolonne 1, kolonne 2, kolonne 3 osv
>
> Hvordan får man det til at stå
>
> sådan her
> VALUE I KOLONNE 1 VALUE I KOLONNE 2 VALUE I KOLONNE 3 ?
>
> Jeps du gættede rigitg... jeg ER newbie
> --
>
> \ Bye for now Martin /
> /\
http://www.geocities.com/lsvdk/ /\
> >=)'> Email: martini@mailme.dk <'(=<
> \/ ICQ: 58847459 \/
> / \