[RESOLVED] pnp not running inside HTML with css

Lanandor

the following pnp works fine when executed alone
but when placed in my html between <div></dev> does nothing
Do I need to do something to make it work within CSS?

$dbhost = 'mysql.secureserver.net';
$dbuser = '';
$dbpass = '';
$dbname = '***';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
@mysql_select_db($dbname);

$id = Rand(1, 18);

$query = "SELECT FACT FROM FACTS WHERE FID ='$id'";
$result = mysql_query($query);

echo mysql_result($result,"FACT");

mysql_close($conn);

Thanks for any suggestion

wilku

I'm going to ask a stupid question. You do it that way, right?

<div>
<?php
$dbhost = 'mysql.secureserver.net';
$dbuser = '***';
$dbpass = '***';
$dbname = '***';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
@mysql_select_db($dbname);

$id = Rand(1, 18);

$query = "SELECT FACT FROM FACTS WHERE FID ='$id'";
$result = mysql_query($query);

echo mysql_result($result,"FACT");

mysql_close($conn);
?>
</div>

<?php and ?> are what I'm asking about.

Edit: Tip for choosing random facts - you can use this query

SELECT fact FROM facts ORDER BY RAND() LIMIT 0,1

That way you don't need to change number of facts in your code every time you add the next fact to you database. This query orders your facts randomly and chooses the first one.

leatherback

A .css file is not by default processed as containing php. You need to change your php.ini settings (I think) to do that.

Alternatively: there is nothing stopping you from using a file: css.php as a stylesheet.

Lanandor

Thanks for replies

yes i'm using
<?php and ?>

works the same as
<script language='php'>
</script>

and thanks for random record tip, I'll use that

the code I posted works fine as a .php file

but emedded in my web page code,which using css, it does not display the data.

I tried renaming the css file to php but didn't work, do I have to re-structure the css code into php code?

I have several pages on the site and only need this database info on one of them so would hate to have tor ewrite the css code into php code.

But am asking if the embedded php code, as I wrote it above , should be having problems running within <div> ... </div>

I'm new with php and mysql so not sure what my options are.

I've been writing html for some time.

Thanks again for any suggestions

leatherback

Hi,

As long as you ensure that the page is read by you php compiler (e.g., is included in a php file, or is a php file itself) it should not require a specific format.
And as said by wilku: You need to have <?php ?> tags around it.
Oh, and dop you make sure that the quotes (") have closed properly before you place the php tags?

Lanandor

so are you saying i need something like

<?php
include 'hello.php';
?>

inside my html?

as i was coding the entire php inside the actual html code

leatherback

1) You need to make sure .html files are processed by your php compiler (default not, as it is a huge overhead unless all your html files have php in it. Check the apache configuration)

2) You need to 'tell' the compiler that php code is starting, so yes.. You need to place <?php ?> around the sections of the code that are php.

Lanandor

Actually not sure how to be sure page is read by php

wait, yes I do, your saying my page.html needs to be a page.php?

Lanandor

OMG
I changed my page to have .php and it ran fine

Thanks for all your help, figured it had to be something simple.

leatherback

No problem. Just mark the thread resolved, so other people can skip it.(See thread tools)