4
mysql_pconnect('localhost', 'douglas', '') or die ("Can't connect to DB");
mysql_query("USE customers");
echo "<table cellpadding=4 border=1><tr><td>id</td><td>userid</td><td>Last</td><td>first</td><td>phone</td><td>ip
</td><td>comment</td></tr>";
$query = "SELECT id,userid,last,first,phone,ip,comment FROM cdata where userid like '%doug%'";
$result = mysql_query($query);
while ($data = mysql_fetch_object($result)) {
echo "<tr>
<td>$data->id</td>
<td>$data->userid</td>
<td>$data->last</td>
<td>$data->first</td>
<td>$data->phone</td>
<td>$data->ip</td>
<td>$data->comment</td>
</tr>";
}
echo "</table>";
You have to echo or print the "html" in php
no need for <? ?> if you set the block to php
global $xoopsDB; is only for connection to XOOPS database. No need here.
why </body></html>? I don't think you want to stop your web rendering after the block?
If you have tested MySQL query to be working. You should be okay.
