Problem with php(mssql)

Question

I am getting the error

"Warning: mysql_query(): supplied resource is not a valid MySQL-Link resource in on line 21"

I have tried several different Queries none of which has worked. Any help would be appreciated!

Code:

<html><body>
<form action="attempt1.php" method="post">
Interest Rate: <input type="text" name="interest_rate"><br>

<input type="Submit">
</form>
<?php
$server = <removed for safety>;
$login = <removed for safety>;
$pass = <removed for safety>;
$interest_rate=$_POST['interest_rate'];

$dblink = mssql_connect($server, $login, $pass) or die("Error1"); 
 mssql_select_db('<removed for safety>', $dblink) or die( "unable to select the database");
 $sqlquery = "INSERT INTO interest_rate VALUES('$interest_rate')";
 $res = @mssql_query($sqlquery, $dblink);


$query=" SELECT * FROM 'interest_rate' ";
$result=mysql_query($query,$dblink) or die(mysql_error());
echo "<b>Output to table</b><br>";
echo "<table border='1'>
        <tr><th>Interest Rate</th></tr>";
while ($row = mysql_fetch_array($result)) {
    echo "<tr>";
    echo "<td>" . $row['interest_rate'] . "</td>";

    echo "</tr>";

    echo $row['interest_rate'].""."<br>";
    }
echo "</table>";

?>
</body></html>

That code is really hard to read. Please set it as code... — JackMc
– JackMc, Commented Apr 10, 2011 at 19:49
What sort of database are you attempting to connect to? MySQL or MS SQL Server? — John Parker
– John Parker, Commented Apr 10, 2011 at 19:53

gbn · Accepted Answer · 2011-04-10 19:50:44Z

7

mysql_query is not mssql_query

answered Apr 10, 2011 at 19:50

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

gbn Over a year ago

@middaparka: good job this is Sunday so I had a chance to get in first ;-)

John Parker Over a year ago

The joy of being the early bird. (Enjoy your worms.) :-)

Pablo Santa Cruz · Accepted Answer · 2011-04-10 19:52:26Z

1

You are mixing stuff here.

This call:

mssql_select_db

And:

mssql_connect

Are for Microsoft SQL Server.

And you are trying to use with a mysql_query call. Decide whether you are using MySQL or SQLServer and pick function calls accordingly.

answered Apr 10, 2011 at 19:52

Pablo Santa Cruz

182k33 gold badges250 silver badges300 bronze badges

Collectives™ on Stack Overflow

Problem with php(mssql)

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related