I am new to MySQL and PHP, so I am taking tutorials and following the practices it gives me. I have data in the database, but I don't know how to create an out put. This code:
Code:
$username='1883_forum'; $password='********'; $database='1883_forum'; $query='SELECT * FROM `Peopleid`'; mysql_connect('mysql',$username,$password); ($database) or die('Unable to access database'); $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $first=mysql_result($result,$i,'first'); $last=mysql_result($result,$i,'last'); $phone=mysql_result($result,$i,'phone'); $mobile=mysql_result($result,$i,'mobile'); $fax=mysql_result($result,$i,'fax'); $email=mysql_result($result,$i,'e-mail'); $web=mysql_result($result,$i,'web'); echo '$first $last
Phone: $phone
Mobile: $mobile
Fax: $fax
E-mail: $email
Web: $web
'; $i++; } ?>
Creates this output:
$first $last
Phone: $phone
Mobile: $mobile
Fax: $fax
E-mail: $email
Web: $web.
What am I doing wrong?