Hello, newbie here...

SoonerPride

I'm not far from "Hello World" in PHP, so bear with me.

This is my php section:

<?php

$db = mysql_connect("localhost", "username", "password");
mysql_select_db("yasakusu_myfirstdb",$db);

$result = mysql_query("SELECT * FROM CONTACT",$db);
printf("First Name: %s<br>\n", mysql_result($result,0,"FIRSTNAME"));

I get this error:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/yasakusu/public_html/testphp.php on line 18
First Name:

Sorry if this is a dumb question

stolzyboy

<?
$db = mysql_connect("localhost", "username", "password"); 
mysql_select_db("yasakusu_myfirstdb",$db); 

$result = mysql_query("SELECT * FROM CONTACT",$db); 

while ($row = mysql_fetch_array($result))
{
echo "First Name: " . $row['fieldname'] . "<br>"; //replace fieldname with the name of the first name field
}
?>

SoonerPride

Thanks for the quick reply!...however, I'm still getting the same error message...

http://216.74.74.12/~yasakusu/testphp.php

Am I on the wrong version of PhP or something? My site is hosted by http://2mhost.com/2m/

Here is my entire file:

<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>

<body>
<?php

$db = mysql_connect("localhost", "username", "password");
mysql_select_db("yasakusu_myfirstdb",$db);

$result = mysql_query("SELECT * FROM CONTACT",$db);

while ($row = mysql_fetch_array($result))
{
echo "First Name: " . $row['FIRSTNAME'] . "<br>"; //replace fieldname with the name of the first name field
}

</body>
</html>

stolzyboy

usually that means that you aren't getting any results from the query, use telnet or phpMyAdmin to run that query to ensure you are getting something from the query, remember mysql field names are case sensitive