Using PHP to insert a record in MSSQL 1

[Garabaldi]

Folks,

I'm having issues getting php to update a table in Sql server 7...

This is my code so far:

$sqlInsertName = "INSERT INTO Person1
([Name],[Age],[Birthday],[Age_tester])
VALUES ('$Name','$Age','$Birthday', '$Age_test')";
mssql_execute($sqlInsertName)

Does anyone know the proper way to do this?

Thanks,

 

[sleipnir214]

What issues are you having?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Garabaldi]

The issue i am having is that it is not updating the table... I keep getting an error stating that mssql_execute() is not valid...

The sql portion is correct. I just need to figure out the command in php that will execute it.

Thanks,

 

[sleipnir214]

You mean that PHP is saying the function does not exist?

mssql_query() is documented here:

http://www.php.net/manual/en/ref.mssql.php

but the manual says it is for stored procedures. You might try mssql_query(), the documentation for which you can find from the link above.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Garabaldi]

Thanks very much for your help... mssql_query() seems to have been the ticket.

Thanks again.

 

[frozenpeas]

Twinkle, twinkle...

frozenpeas

 

[sleipnir214]

Thanks, frozenpeas. I'm sure it just slipped Garabaldi's mind.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Garabaldi]

no... actually it didn't... i'm a relatively new user to php... done all my previous scripting in asp so i had no idea what to use to execute the function... I'm a bozzo and I don't care...

 

[sleipnir214]

Garabaldi:
frozenpeas and I are talking about marking a post helpful. What are you talking about?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Garabaldi]

uhhh... nu- - nuthing... *whispers to the voices in his head to shut up*