Help with my code

Beginners - Learning PHP
15

Okay - Thanks on both accounts.

Here is my current code

Submission Form (form.html)

[php]

First Name
Family Name
   

[/php]

[b]Communication Form /b

[php]

<?php //Variables for connecting to your database. //These variable values come from your hosting account. $hostname = "Godaddy IP address for where db is located "; $username = "username"; $dbname = "dbname"; //These variable values need to be changed by you before deploying $password = "thesetupdbpassword"; $usertable = "client"; $yourfield = "first"; $yourfield = "family"; //Connecting to your database mysql_connect($hostname, $username, $password) OR DIE ("Unable to connect to database! Please try again later."); mysql_select_db($dbname); //Fetching from your database table. $query = "SELECT * FROM $usertable"; $result = mysql_query($query); if ($result) { while($row = mysql_fetch_array($result)) { $name = $row["$yourfield"]; echo "Name: $name
"; } } ?>

[/php]

Enquiry Form (view.php)

[php]

<?php include ("comm.php"); if ($result = $mysqli->query("select * from client order by id")) { if($results->num_rows>0) { echo ""; echo ""; while ($row = $result->fetch_object()) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
ID First Name Family Name
" . $row->id ."" . $row->first ."" . $row->family ."
"; } } else { echo "Error" . $mysqli->error; } $mysqli->close(); ?>

[/php]

Which produces No input into the Table and no enquiry result - just the errors shown previously.