mga_ka_php Posted March 5, 2007 Share Posted March 5, 2007 in VB if i want to get the data of a column i use Set ra = DB.OpenRecordset("select * from employee") While Not ra.EOF itmX.SubItems(1) = ra!name wend how do i do this in php? what is the ra!name in php? thanks Quote Link to comment Share on other sites More sharing options...
fert Posted March 5, 2007 Share Posted March 5, 2007 $cn=@mysql_connect("host","username","password") or die(mysql_error()); @mysql_select_db("database",$cn) or die(mysql_error()); $result=@mysql_query("SELECT * FROM `table`",$cn) or die(mysql_error()); while($row=mysql_fetch_array($result)) { $var=$row['column']; } Quote Link to comment Share on other sites More sharing options...
mga_ka_php Posted March 5, 2007 Author Share Posted March 5, 2007 THANKS A LOT! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.