asp to php

[mivec]

to all,
hie...i am not sure what the code is in php. u see in asp it's like this:

1) <%if DBRecordset.EOF then%>
2) if not DBRecordset.EOF then
DBRecordset.MoveFirst // DBRecordset is self defined
While not DBRecordset.EOF
3) <%=DBRecordset("QuesText")%>
4) <%if DBRecordset("Answer") = "true" then%>

all these are in asp. how do u change it to php code? i am zonked in ideas.pls help experts.thanks......a million

Note*:set DBRecordset = Server.CreateObject
("ADODB.Recordset")

[andy_117]

Hope this helps

<?php

	$linkid = odbc_connect('dsn','username','pwd');

	$query = " SELECT MembershipNumber, email, requireMail  FROM tblmembers WHERE requireMail = 'Y' AND requireMail = 'y' ";		

	$result = odbc_exec($linkid, $query);

		while(odbc_fetch_row($result))
		{
			$mn = odbc_result($result,1);	

			$em = odbc_result($result,2);		

			$rm = odbc_result($result,3);

			echo("<br>");
			echo($mn);
			echo("<br>");
			echo($em);
			echo("<br>");
			echo($rm);
			echo("<br>");
			echo("message to user goes here")

		}
		odbc_close($linkid);