PHP/msSQL

[sotto]

On Wed, 25 Jun 2003 17:04:18 -0400, Adam wrote:

> Is there a url that explains how to either compile it or add the modules
> cause I have no idea heh..
>
> Thanks!!
>
> -Adam!
>
> "sotto" <junk@sotto.be> wrote in message
> news:pan.2003.06.25.18.03.02.346271@sotto.be...

>> On Wed, 25 Jun 2003 13:23:57 -0400, Adam wrote:
>>

>> > Hello everyone, looking for some help here..
>> >
>> > I have PHP 4.2.2 running on my windows server and im trying to figure

> out

>> > what I need to do, so that I can connect to an existing msSQL Server

> 2000.

>> >
>> >
>> > The only facts about PHP I have are version: 4.2.2, Server API: CGI
>> >
>> > I have no idea where to begin, or what needs to be done, all I know is
>> > that I need to get msSQL and PHP working together.
>> >
>> > -Both are on the same win2k webserver.
>> >
>> > Thanks in advance!
>> >
>> > -Adam

>>
>> Probably you need to compile your php-server with msSQL support, or add
>> some mssql support via modules (i know it's like that for PostGreSQL ...
>> so i guess it would be the same for mssql)
>>
>> Anyway, when you got that working, you can use this "layer" to access
>> your database: [url]http://php.weblogs.com/portable_sql[/url] (to me it seems like
>> usefull thing)
>>
>>

Yes there is.
let me tell you: [url]www.google.com[/url] ... and i'd say you search for php+mysql
howto

hmm... i tried it for you just right now ... guess what??? OOoohh i found
something usefull i think!

[url]http://www.phpbuilder.com/columns/alberto20000919.php3[/url]


ps, sorry, i get pissed off sometimes when people don't try google before
asking help.

[Jochen Daum]

Hi sotto!

On Thu, 26 Jun 2003 18:41:26 +0200, "sotto" <junk@sotto.be> wrote:

>Yes there is.
>let me tell you: [url]www.google.com[/url] ... and i'd say you search for php+mysql
>howto
>

Must be a typo.He is looking for PHP and Microsoft (MS) SQL



Jochen
--
Jochen Daum - CANS Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
[url]http://sourceforge.net/projects/phpdbedittk/[/url]

[Adam]

hmm ok, ill look into that dll file, and i did try google first :D
But mysql is easy to make work, microsoft is not as easy.

so far anyway..

Thanks guys!


"Jochen Daum" <jochen.daum@cans.co.nz> wrote in message
news:btckfvsg0m6ulho9g4ch2ca5d4770ctv6i@4ax.com...

> Hi !
>
> On Wed, 25 Jun 2003 13:23:57 -0400, "Adam" <adoeler@sharklogic.com>
> wrote:
>

> >Hello everyone, looking for some help here..
> >
> >I have PHP 4.2.2 running on my windows server and im trying to figure out
> >what I need to do, so that I can connect to an existing msSQL Server

2000.

> >
> >
> >The only facts about PHP I have are version: 4.2.2, Server API: CGI
> >
> >I have no idea where to begin, or what needs to be done, all I know is

that

> >I need to get msSQL and PHP working together.
> >
> >-Both are on the same win2k webserver.
> >

> I think you need to enable the mssql extension - something like
> php_mssql.dll in php.ini
>
> Thats it as far as I know
>
> Jochen
> --
> Jochen Daum - CANS Ltd.
> PHP DB Edit Toolkit -- PHP scripts for building
> database editing interfaces.
> [url]http://sourceforge.net/projects/phpdbedittk/[/url]

[Darren]

Hi there.

Tried a number of methods.

I basically want to extract a GUID from a MSSQL database and use it in
another SELECT.

When I get the company name and company no the company no outputs like...
63180001000000000000000000000000

I wanted to reference another table so I...
$query = "SELECT ACTIVITYHEADERNO,COMPANYNO FROM ACTIVITYHEADER WHERE
COMPANYNO='$companyno'";

And of course this wouldn't work and the error was:

Warning: Sybase message: Syntax error converting from a character string to
uniqueidentifier.

I have been looking at...

[url]http://uk.php.net/manual/en/function.mssql-guid-string.php[/url]

But when using mssql_guid_string i get...

Fatal error: Call to undefined function: mssql_guid_string() in
/export/home/darrenm/web/scripts/guid.php on line 32.

php-4.3.1
freetds-0.61

and yes it was compiled with --enable-msdblib --with-tdsver=7.0

If i do...

$query = "SELECT cast(COMPANYNO as varchar(36)),USERSTRING1 FROM CONTACT
WHERE USERSTRING1='$iusername'";

it gets one result (which is correct) but COMPANYNO is blank when i try and
print it (because it's something that can't be printed? i have no idea!)


Any help would be great!

Thank you very much.

Darren