Could someone....

donkeychoker

Please tell me where I am going wrong!

All I want to do is display a mysql count on my homepage(index.htm)

I have this code which works on another page(although that is a .php page rather than .htm)

<?php
require ($_SERVER["DOCUMENT_ROOT"] ."/conf/db_con.php");
$connection = mysql_connect ($db_host, $db_user, $db_password) or die ("error connecting");
mysql_select_db ($db_name, $connection);
$query = "SELECT count() FROM my_table WHERE postcode LIKE '%'";
$result=mysql_query ($query, $connection);
$count=mysql_result ($result,0,"count()");
echo $count;
?>

Is it the positioning of my code because it is a .html page? Is it because it is an index.html page?
As i said this code works fine on another page
😕

$count is a count of all the postcodes received. No error messages just blank

it is giving me a headache, hope someone can tell me where i am going wrong

thorpe

php needs to be run in .php files. htm or html files wont work without some unrecommended server adjustments.

donkeychoker

Thank you for your help. So I can put html into a php page but not php into a html page?

Is there a simple way around what i am trying to achieve?

Kudose

Yes, there is a simple way around it.

Change the file name from index.html to index.php.

donkeychoker

Hi Thx, but if someone goes to my site and the address doesn't include the index.php then it will not load will it?
Am I not right in thinking that it either has to be a .htm.html.shtml?

If i am correct I was thinking of creating a new page called index.html and having a redirect but would prefer not to.

Kudose

Index.whatever will always be the first thing looked for.

i.e.

index.html
index.htm
index.shtml
index.php
index.asp
index.jsp
etc...

Those are all basically the same. Index pages.

Now index.html (i believe) takes precedence over index.php. So, you can only have one index page.

Try index.php, then visit your website without adding index.php to the URL. It will load, if you have PHP installed.

So...no, you're not right in thinking that it must be a .htm extension on the index or any page.

donkeychoker

I just tried your advice and worked perfectly.
I can't thank you enough.
Much appreciated, it has been my intention to learn something new everyday, that makes 3 today so 2 days off.

jami3

As php is an extension of html php wont work in html as it dosenot contain the required features you will find if you name files php they will not have any diffrance to html/htm files.
However you should note that index.html will be visited rather than index.php if you had both of them on your server if you put your url as http://www.sitename.com/index

donkeychoker

Thanks.
I now only have one index page and it is an index.php