It works fine with mysql but not with mssql, way?

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

February 6th, 2003, 08:29 PM

straw

Join Date: Apr 2007

Location: Stockholm, Sweden

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

It works fine with mysql but not with mssql, way?

Hey people!

Is there some one how can help me with this.
I have made i forum with a login in php and mysql.
Now i have to make it work with mssql but i get a error that says:
Warning: Use of undefined constant password - assumed 'password' in C

atawebbarwww.tradgard.orgroottradgardlogin.php on line 3

Warning: Undefined index: password in C

atawebbarwww.tradgard.orgroottradgardlogin.php on line 3

And here is the code:

php Code:

Original - php Code
<? if ($_POST[password]) { include("common.php"); $link = dbConnect(); $query="SELECT * FROM user"; $result=mssql_query($query) or die(mssql_error()); $row = mssql_fetch_array($result); if ($_POST[password] == $row[password]) {

 
<?
 
if ($_POST[password]) {
 
   include("common.php");
   $link = dbConnect();
   $query="SELECT * FROM user";
   $result=mssql_query($query) or die(mssql_error());
   $row = mssql_fetch_array($result);
 
 
   if ($_POST[password] == $row[password]) {

I have never made anything with mssql so i dont know if the connection is right but what i understund from the php.net is that i have to change the mysql_query to mssql_query, i hope thats right.

Looking forward to see what i have done wrong.
Best regard
Micke

February 7th, 2003, 12:46 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: It works fine with mysql but not with mssql, way?

I don't think it has anything to with mssql..try this:

php Code:

Original - php Code
if (isset($_POST['password'])) { include("common.php"); $link = dbConnect(); $query="SELECT * FROM user"; $result=mssql_query($query) or die(mssql_error()); $row = mssql_fetch_array($result); if ($_POST['password'] == $row['password']) {

if (isset($_POST['password'])) {
 
   include("common.php");
   $link = dbConnect();
   $query="SELECT * FROM user";
   $result=mssql_query($query) or die(mssql_error());
   $row = mssql_fetch_array($result);
 
 
   if ($_POST['password'] == $row['password']) {

Viewing: Codewalkers Forums > Other Technologies > Database Help > It works fine with mysql but not with mssql, way?

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump