[RESOLVED] ECHOING RESULTS FROM db

big-dog

How do I get this code to echo the data in the database
Or why doesnt it echo the data

<?php
include("config.inc.php");

mysql_connect(localhost,$username,$password,$dbname);
@mysql_select_db($dbname) or die( "Unable to select database");
$query= 'SELECT FullName, Address, City, Phone FROM Signatures ORDER BY FullName DESC LIMIT 0, 100';
mysql_query($query);
?>

<table width="100%">
<tr><td width="31%">
		<img border="0" src="../images/space.gif" width="200" height="50"></td>
	<td width="28%">&nbsp;</td>
	<td width="18%">&nbsp;</td>
	<td width="21%">
	<p align="right"></td></tr>
<tr><td width="98%" colspan="4">
<font face='arial' size=2>
		<b></b></td>
	</tr>
<tr><td width="31%" bgcolor="#CCCCCC"><b>Full Name:</b></td>
	<td width="28%" bgcolor="#CCCCCC"><b>Address:</b></td>
	<td width="18%" bgcolor="#CCCCCC"><b>City:</b></td>
	<td width="21%" bgcolor="#CCCCCC"><b>Phone:</b></td></tr>
<tr><td width="31%">&nbsp;<?php echo $FullName; ?></td><td width="28%"><?php echo $Address; ?></td>
	<td width="18%"><?php echo $City; ?></td><td width="21%"><?php echo $Phone; ?></td></tr>
</table>

<?php

Weedpacket

mysql_query($query);

You never use the results of this or put them any where. See Example 2 on the [man]mysql_query[/man] manual page; especially the section headed "Use result".

nadir_s

Try this ... lots had to be cleaned up / adjusted ...

<table width="100%">
<tr><td width="31%">
        <img border="0" src="../images/space.gif" width="200" height="50"></td>
    <td width="28%">&nbsp;</td>
    <td width="18%">&nbsp;</td>
    <td width="21%">
    <p align="right"></td></tr>
<tr><td width="98%" colspan="4">
<font face='arial' size=2>
        <b></b></td>
    </tr>
	<tr>
	<td width="31%" bgcolor="#CCCCCC"><b>Full Name:</b></td>
    <td width="28%" bgcolor="#CCCCCC"><b>Address:</b></td>
    <td width="18%" bgcolor="#CCCCCC"><b>City:</b></td>
    <td width="21%" bgcolor="#CCCCCC"><b>Phone:</b></td></tr>

<?php
include("config.inc.php");

mysql_connect(localhost,$username,$password,$dbname);
mysql_select_db($dbname) or die( "Unable to select database");
$query= "SELECT FullName, Address, City, Phone FROM Signatures ORDER BY FullName DESC LIMIT 0, 100";
$result = mysql_query($query);
while($nt=mysql_fetch_array($result)){

echo "<tr>
	<td width=\"31%\">$nt['FullName']</td>
	<td width=\"28%\">$nt['Address']</td>
    <td width=\"18%\">$nt['City']</td>
    <td width=\"21%\">$nt['Phone']</td>
    </tr>"
}
mysql_close();
?>
</table>

This tutorial is helpful: http://www.tizag.com/mysqlTutorial/mysqlselect.php

big-dog

I get this error

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home5public_html/Lighting/Ppg.php on line 35

which is this line
<td width=\"31%\">$nt['FullName']</td>

halojoy

There is a missing semicolon ( ; )
at the end of this echo.
And to put those array-variables inside the double quoted "string"
we need to put curly braces around them {$var['name']}

echo "<tr>
	<td width=\"31%\">{$nt['FullName']}</td>
	<td width=\"28%\">{$nt['Address']}</td>
    <td width=\"18%\">{$nt['City']}</td>
    <td width=\"21%\">{$nt['Phone']}</td>
    </tr>";

big-dog

right on
thank you very much