Sudantha

just echo the HTML tags inside the loop while($data=mysql_fetecharray($result){ echo "<img src=".$data['image_path']."width=xx hight=xx><img>" }

thanks rapa ! ,, i got a solution but donno is this the best method http://sudantha.wordpress.com/2010/05/25/running-microsoft-sql-mssql-stored-procedures-in-php/

i have problems with running MSSQL in PHP Stored procedures but i figured out how to do it check my blogpost http://sudantha.wordpress.com/2010/05/25/running-microsoft-sql-mssql-stored-procedures-in-php/

Guys i need to get the return value from this code how to do it ? CREATE PROC getLogin @username varchar(50),@password varchar(50) AS if exists (SELECT * FROM Operator WHERE Call_ID=@username AND PASSWORD=@password) BEGIN return 1 END else return 0 MY php code is following $stmt=mssql_init('getLogin',$connection); mssql_bind($stmt,"@username",&$uid,SQLVARCHAR,false,true,60); mssql_bind($stmt,"@password",&$password,SQLVARCHAR,false,true,60); $result=mssql_execute($stmt); $arr=mssql_fetch_row($result);

1. Install a SQL server instant or run a one 2.Configure php.ini in extensions uncomment mssql.dll 3.use mssql function (same as mysql function refer to php doc )

Are u using IIS ?

u can use Microsoft SQL Server Management Studio Express as a PHPmyAdmin equivalent http://www.en.wikipedia.org/wiki/SQL_Server_Management_Studio Download Link : http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Guys whats the best method in creating reports in PHP like crystal reports in .net platform !

double check ur file path also why using % as hierarchy separates

Hi guys i have a problem creating stored procedures in MySQL 5.1.45 through phpMyAdmin 3.2.4 , it ways give a SQL error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 Some how i manged to create two stored procedures and they are working properly , thing is even i change the variable names and procedure name and use the same code and compile it gives the same error

i think you can fire trigger for this !

yes ! it cant be ,, btw to u get any data from a database in this page ? does that db contain any encrypted stuff ? [some times encrypted stuff may be showed in stupid characters ] some times it may be ur browser rendering prob .. change that and see !

lol! $string=sha1($string); $string=md5($string); echo $string; what will generate this

i thought ur running in localhost !

is this a compiled page .. looks like some parts are compiled and some are not , wired , btw why dont u compile in another machine and see dunno ur php complier is corrupted or not