Re: What's wrong????

Arpan De, you have mysql not mssql. Your statement might work if you change it from mssql_connect() to mysql_connect() Hope this helps, Hugh ----- Original Message ----- From: "Arpan De" <dearpan1974@hotmail.com> To: <php-general@lists.php.net> Sent: Monday, April 29, 2002 6:09 PM Subject: Re: [PHP] What's wrong???? > Hi John, > > Thanks for your prompt reply. I am using PHP 4.2.0 version. I checked the > PHP.ini file where it is given the following: > > ;Windows Extensions > ;Note that MySQL and ODBC support is now built in, so no dll is needed for > it. > ; > ;extension=php_bz2.dll > ................................... > ................................... > ;extension=php_mssql.dll > > which, I guess, is already uncommented. What do I do now to execute some > transaction with SQL Server 7.0? Also what do I search for in phpinfo()? > > Regards, > > Arpan > > "John Holmes" <holmes072000@charter.net> wrote in message > news:001901c1effa$ec9c8e30$b402a8c0@mango... > > You don't have MSSQL support in your PHP installation. Uncomment the > > line in PHP.ini that loads the MSSQL .dll > > > > Use a phpinfo() file to see what modules are loaded. > > > > You're making this hard on yourself...PHP is easy to learn. > > > > ---John Holmes... > > > > > -----Original Message----- > > > From: Arpan De [mailto:dearpan1974@hotmail.com] > > > Sent: Monday, April 29, 2002 5:42 PM > > > To: php-general@lists.php.net > > > Subject: [PHP] What's wrong???? > > > > > > What is wrong with the following code? > > > > > > <?php > > > $connection=mssql_connect("SQLServerName","sa","") > > > or die("Couldn't make connection"); > > > > > > $db=mssql_select_db("DBName",$connection); > > > $sql="SELECT FName,LName,UserID FROM tblName ORDER BY FName"; > > > > > > $sqlResult=mssql_query($sql,$connection); > > > > > > while($row=mssql_fetch_array($sqlResult)){ > > > $firstname=$row["FName"]; > > > $lastname=$row["LName"]; > > > $userid=$row["UserID"]; > > > > > > echo("<tr>"); > > > echo("<td>$firstname</td>"); > > > echo("<td>$lastname</td>"); > > > echo("<td>$userid</td>"); > > > echo("</tr>"); > > > } > > > > > > mssql_free_result($sqlResult); > > > mssql_close($connection); > > > ?> > > > > > > When the above code is executed, I am getting the following error: > > > > > > Fatal error: Call to undefined function mssql_connect() > > > > > > which points to the 2nd line in the code. Even the die() function > > doesn't > > > get executed. I just copied & pasted the code from a tutorial I found > > on > > > the > > > web but am still getting this error !!! Is learning PHP so > > frustrating? I > > > have never encountered such frustration while learning any other > > software > > > languages. It's making me too dependent on this newsgroup !!! > > Sometimes it > > > does happen that in other languages, if you are getting an error, one > > can > > > overcome that particular error by employing some trial & error methods > > but > > > whatever & whenever I have tried to do the same in PHP, I could never > > > overcome the error. > > > > > > Thanks, > > > > > > Arpan > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >