I would like this script to echo the values from the row with the id 2.

PHP Code:

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

require_once ('inc/config.php');
$query = "SELECT FirstName, LastName, MiddleName FROM testing WHERE id = '2'";
$result = mysql_query ($query); 
while ($row = mysql_fetch_assoc($result)) 
{
   echo $row['FirstName'];
   echo $row['LastName'];
   echo $row['MiddleName'];
}
?>

There are also no errors or warnings or notices.

I updated the code to this

PHP Code:

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

require_once ('inc/config.php');
$query = "SELECT * FROM testing WHERE FirstName, LastName, MiddleName";
$result = mysql_query ($query); 
while ($row = mysql_fetch_assoc($result)) 
{
   echo $row['FirstName'];
   echo $row['LastName'];
   echo $row['MiddleName'];
}
?>

And I get this error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/runehost/public_html/update2.php on line 8

I fixed that now there is a new error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'LastName', 'MiddleName'' at line 1

PHP Code:

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

require_once ('inc/config.php');
$query = "SELECT * FROM testing WHERE FirstName, LastName, MiddleName";
$result = mysql_query($query) or die(mysql_error()); 
while ($row = mysql_fetch_array ($result)) 
{
   echo $row['FirstName'];  
 echo $row['LastName'];
   echo $row['MiddleName'];
}
?>

PHP Code:

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

require_once ('inc/config.php');
$query = "SELECT * FROM testing";
$result = mysql_query($query) or die(mysql_error()); 
while ($row = mysql_fetch_array ($result)) 
{
     echo 'First Name: ';
   echo $row['FirstName']; 
     echo '<br>Last Name: ';
 echo $row['LastName'];
      echo '<br>Middle Name: ';
   echo $row['MiddleName'];
}
?>

FIXED IT!

I was about to say it...
Your query in the post #3 is malformed.

A correct query is

SELECT [fields list]
FROM [tables list]
WHERE [conditions]

A condition must always evaluate to something.
Thus the

WHERE FirstName, LastName, MiddleName

is wrong.
It could be

WHERE FirstName IS NOT NULL
AND (
  MiddleName IS NOT NULL
  OR 
  LastName IS NOT NULL
)

for example.

So is my code correct? I have fixed that problem.

Now i got a question...


I would like to echo it separately in different places of my webpage, can I just do this?

At the top of the page

PHP Code:

 <?php
require_once ('inc/config.php');
$query = "SELECT * FROM testing";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array ($result))
?>

Around the webpage.

PHP Code:

<?php $row['MiddleName'] ?>

or

PHP Code:

<link rel="stylesheet" type="text/css" href="<?php $row['Url'] ?>/css/style.css" />

or

PHP Code:

    <title><?php $row['WebsiteTitle'] ?></title>

Like that? Or I have to have it echo?

PHP Code:

<?= $row[0] ?>

What would be an example of that? Like this?

<?= $row[Title] ?>

PHP Code:

<?= $var ?>

is a short version of

PHP Code:

<?php echo $var; ?>

So in your case, you could do

PHP Code:

<?php echo $row['Title']; ?>

I'm not sure, but wasn't this short version going to be removed in some php version?

I'm not sure, but wasn't this short version going to be removed in some php version?

I hope not & as for the shorthand:

PHP Code:

// ## Worst: If you used $row = mysql_fetch_array($rs) then:
<?= $row[0] ?> or <?= $row['column_name'] ?> will work.
// ## Better: If you used $row = mysql_fetch_assoc($rs) then:
Only <?= $row['column_name'] ?> will work.
// ## Best: If you used $row = mysql_fetch_row($rs) then:
Only <?= $row[0] ?> will work.