1 message in com.mysql.lists.win32MYsql and PHP| From | Sent On | Attachments |
|---|---|---|
| k_j_...@ici.com | 06 Nov 2000 23:26 |
| Subject: | MYsql and PHP |
|---|---|
| From: | k_j_...@ici.com (k_j_...@ici.com) |
| Date: | 11/06/2000 11:26:11 PM |
| List: | com.mysql.lists.win32 |
After installing mysql on W95, using mysql commands in dos I have been able to create a database and then a table with different fields and put in data. The database name = dbase1, table name =table01, and fields are field01,field02,field03 I want to test it with PHP and obtain the records for which I have used the following script. However when I run the script the contents are not displayed, only "end" comes on the screen. Could someone tell me where I am going wrong. <?php $db=mysql_connect("localhost","root"); mysql_select_db("dbase1",$db); $result=mysql_query("SELECT * FROM table01",$db); printf("first name: %<br>\n",mysql_result($result,0,"field01")); echo "end";
?> Thanks in advance
IMPORTANT NOTICE: This email is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and email confirmation to the sender.