the php is dislpaying my code!!!

[irishgirl2004]

Hi,
I had a html file, which i named to php, because i want to query a database. before i add in my code, the page displays fine, but when i add the following

mysql_connect(localhost,"chusdh","dc23");
@mysql_select_db("phone") or die( "Unable to select database");
$query = "Select * from jobs";
result1 = mysql_query($query);
if (mysql_num_rows($result1) > 0)
		{

		echo result1;


	}

[code=php]

this code then displays on the page. when i put <? at the start of the file it gives me a parse error. I bet i am doing something very silly?


thanks

[Kudose]

You need to add <?php before the start of your PHP code, and ?> after it. I mean directly before and after, not at the top or bottom of the page.

[Kudose]

i.e.

<b>I'm bold text in HTML</b>
<?php
echo "I'm PHP!";
mysql_connect(localhost,"chusdh","dc23");
@mysql_select_db("phone") or die( "Unable to select database");
$query = "Select * from jobs";
result1 = mysql_query($query);
if (mysql_num_rows($result1) > 0)
{
echo result1;
}
?>
<b>I'm back into HTML</b>

[irishgirl2004]

doh!!!!

thanks....

[Kudose]

No problem. 🙂