convert asp code to php code

[mbarmawi]

Dear All,

Please help me convert this asp code to php code.
database connection has been already established.

<%
SQL = "SELECT ref_ID, title FROM tblreferences ORDER BY ref_ID"
Set rs = con.Execute(SQL)
While NOT rs.EOF
%>
<option value="<%=rs.fields("ref_ID")%>"><%=rs.fields("ref_ID")%>, <%=LEFT(rs.fields("title"), 40)%>...</option>
<%
rs.MoveNext
Wend
rs.Close
%>

[gyash]

Try this out

<?php
$SQL = "SELECT ref_ID, title FROM tblreferences ORDER BY ref_ID";
$result=mysql_query($SQL);
while($row=mysql_fetch_array($result))
{
?>
<option value="<?php echo $row['ref_ID']; ?>" ><?php echo $row['ref_ID']; ?>,<?php echo $row['title']; ?></option>
<?php
}
mysql_close()
?>

Also there is one utility in Linux asp2php that convert asp code to php.

🙂