Parse error

mutant

Hi, Im still a newbie here in PHP. I started to code a simple php to check if my php program is running. but it turns out that it has an error which says "Parse error: parse error in /var/www/html/test.php on line 3"

here's my simple code..:

<?php
phpinfo();
?>

Is there something wrong with my php program? Please help...

Future Thanks....

Anon

try:
<?
echo phpinfo();
?>

(the phpinfo code is in the return value)

but phpinfo() could be disabled, too.

alternatively:

<? echo "hello world"; ?>

mutant

gee thanks, I was able to run php...but I have another problem when I tried to get a certain data using mysql server as my dbase program, I can't get my code right. I follow the procedure but I can't get my data from mysql for viewing. why? Have I miss something here? Please help....

here's the code for my dbase:
I already enter a value to these fields...

CREATE TABLE personnel
(
id int NOT NULL AUTO_INCREMENT,
firstname varchar(25),
lastname varchar(20),
nick varchar(12),
email varchar(35),
salary int,
PRIMARY KEY (id),
UNIQUE id (id)
);

here's my view dbase code:

<?
$db = mysql_connect("localhost", "root", "");
mysql_select_db("test",$db);
$result = mysql_query("SELECT * FROM personnel",$db);
echo "<TABLE>";
echo "<TR><TD><B>Full Name</B><TD><B>Nick Name</B><TD><B>Salary</B></TR>";
while ($myrow = mysql_fetch_array($result))
{
echo "<TR><TD";
echo $myrow["firstname"];
echo " ";
echo $myrow["lastname"];
echo "<TD>";
echo $myrow["nick"];
echo "<TD>";
echo $myrow["salary"];
}
echo "</TABLE>";
?>

dannys

try echo mysql_error(); which will tell you of any problem with the query itself.

I personally use mysql_fetch_assoc() instead of mysql_fetch_array() so you might want to try that too.

mutant

Can you give me an example on how to get data from mysql server coz Im a little bit lost. I just can't get it right. Is there a good site that I can find to learn php that manipulates dbase from basic to advanced...?

Im very sorry for asking too much coz im a newbie here in php. this is my first time coding php and mysql.

Please help... thanks

dannys

Ok, here's how I would write the code.
I think devShed (http://devshed.com) has some good PHP articles so they'll likely have a half decent one on databases.

<?PHP

$link = mysql_connect("localhost", "root", "");
if (!$link)
die ("Could not connect to mySQL");

$db=mysql_select_db("test",$link);
$result=mysql_query("SELECT * FROM personnel",$link);
if ($result)
{
echo "<TABLE>\n";
echo "<TR><TD>Full Name<TD>Nick Name<TD>Salary</TR>\n";
while ($row = mysql_fetch_assoc($result))
{
echo "<TR><TD>";
echo "$row['firstname'] $row['lastname']";
echo "</TD><TD>";
echo $row['nick'];
echo "</TD><TD>";
echo $row['salary'];
echo "</TR>\n";
}
echo "</TABLE>\n";
}
else
echo mysql_error();

mutant

ERROR:

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'

I think something wrong with the code that you add. can you check what seems to be the problem...thanks...