Reply to Desperate help needed on tables in .php — PHP Programming Language

Posted by Ladysniper@gmail.com on 05/29/06 07:08

DESPERATE doesn't begin to describe it.

Can someone PLEASE tell me what is WRONG with this code?

Now..a bit of background. It is a search results page for
http://www.azsoma.info/directory.htm. (use Scottsdale for the city)

If you go look, you see that the search results post (I do have my
table borders up for debugging) but it doesn't line up with the table
above it...the whole scroll background doesn't show up and I cannot get
my results to have a space between them. And on top of it...they want
an inline frame! I haven't even attempted that...at all....

Please...can someone help me. Hell, I'll pay someone if I have to...be
glad to...but this page needs to be done for the client....

Warning...long coding....

Thank you in advance....please, if someone could/would help me....

Code:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Directory Search Results</title>
</head>

<body bgcolor="#000000">
<div align="center">

<table width="800" border="1" cellpadding="0" cellspacing="0"
height="100%">
<table width ="800" border="1" cellpadding="0" cellspacing="0"
height="15%>

<tr>
<td width="4"></td><td valign="top" align="center" height="19%">
<img border="0" src="images/header3.gif" width="800"
height="150"></td></tr></table>

<table width ="800" border="1" cellpadding="0" cellspacing="0"
height="10%">
<tr>
<td width ="800" height="19" bgcolor="e1d7a4" valign="top"
align="center">

 
 
<a href="/index.htm">Home</a>    
 
<a href="application.htm">Member
Application</a>    

<a href="/membership.htm">Member
Benefits/Products</a>     

<a href="/directory.htm">Member
Directory</a>     

<a href="/news.htm">Announcements/News/Links</a></td></tr></table>

<table width = "800" border ="1" cellpadding="0" cellspacing="0"
align="center" background="images/scroll.jpg" length="800">
<form method="post" action="http://azsoma.info/results.php">












<tr>

php:

<?php
//print_r($_POST);
//echo " \n";

$hostname = "***DON'T SHOW***"; // The server.
$username = "***DON'T SHOW***"; // The username you created for this
database.
$password = "***DON'T SHOW***"; // The password you created for the
username.
$usertable = "***DON'T SHOW***"; // The name of the table you made.
$dbName = "***DON'T SHOW***"; // This is the name of the database you
made.

MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection
unavailable");
@mysql_select_db( "$dbName") or die( "Unable to select database");

//error message (not found message)begins
// $XX = "No Record Found, to search again please close this window";

/*+-------------------------------------------------------------------------------------+

| Query Details Begin:
|

+-------------------------------------------------------------------------------------+

| Since I don't know if phpForms has a built in search function and I
don't have time |
| to try to decipher how they are storing/retrieving information from
the tables, |
| this is the long way around it but it should work.
|

+-------------------------------------------------------------------------------------+

| May 2006 - AJM re-edited by RJP
|

+-------------------------------------------------------------------------------------+*/

/*+-------------------------------------------------------------------------------------+

| First we get all distinct records that have the matching criteria
from the search |
| page (directory.htm)
|

+-------------------------------------------------------------------------------------+

| Determine which fields they have used: Name, City, Zip - and build
the WHERE clause |

+-------------------------------------------------------------------------------------+*/

$sql = "SELECT DISTINCT sub_rec_id "
." FROM pf_submissions "
." WHERE ";

if($_POST['Name']>"")
$sql .= " (sub_fld_name LIKE '%name%' AND sub_fld_value LIKE '%".
$_POST['Name']. "%') AND ";

if($_POST['City']>"")
$sql .= " (sub_fld_name LIKE '%city%' AND sub_fld_value LIKE '%".
$_POST['City']. "%') AND ";

if($_POST['Zip']>"")
$sql .= " (sub_fld_name LIKE '%zip%' AND sub_fld_value LIKE '%".
$_POST['Zip']. "%') AND ";

$sql .= " 1=1 "
." ORDER BY sub_rec_id ASC";

//echo "sql=".$sql." \n";
$qry = mysql_query($sql);

/*+-------------------------------------------------------------------------------------+

| Now, if there are any records, we'll step through getting the name
first. |

+-------------------------------------------------------------------------------------+*/

while($row=@mysql_fetch_array($qry))
{
$sqlName = "SELECT sub_fld_value "
." FROM pf_submissions "
." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
." AND sub_fld_name = 'Full Name'";
//echo "sqlName=".$sqlName." \n";

$qryName = mysql_query($sqlName);
$rowName = @mysql_fetch_row($qryName);
//print_r($rowName);
//print(" \n");

print(" <tr height='20'><td valign='top'>".$rowName[0]."</td></tr> \n");

/*+---------------------------------------------------------------------------------+

| Now, if there are any records, we'll step through getting the
office address. |

+-----------------------------------------------------------------------------------+*/

$sqlAddress = "SELECT sub_fld_value "
." FROM pf_submissions "
." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
." AND sub_fld_name = 'Office Address'";
// echo "sqlAddress=".$sqlAddress." \n";

$qryAddress = mysql_query($sqlAddress);
$rowAddress = @mysql_fetch_row($qryAddress);
print(" <tr height='20' valign='top'><td valign='top'>".$rowAddress[0]."</td></tr> \n");

/*+-----------------------------------------------------------------------------------+

| Now, if there are any records, For now we get the Office City.
|

+-------------------------------------------------------------------------------------+*/

$sqlCity = "SELECT sub_fld_value "
." FROM pf_submissions "
." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
." AND sub_fld_name = 'Office City'";
//echo "sqlCity=".$sqlCity." \n";

$qryCity = mysql_query($sqlCity);
$rowCity = @mysql_fetch_row($qryCity);
print(" <tr height='20'><td valign='top'>".$rowCity[0]."</td></tr> \n");

/*+-------------------------------------------------------------------------------------+

| Now, if there are any records, we'll step through getting the
Office state. |
| RJP 05/28/06
|

+-------------------------------------------------------------------------------------+*/

$sqlState = "SELECT sub_fld_value "
." FROM pf_submissions "
." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
." AND sub_fld_name = 'Office State'";
//echo "sqlState=".$sqlState." \n";

$qryState = mysql_query($sqlState);
$rowState = @mysql_fetch_row($qryState);
print(" <tr height='20'><td valign'top'>".$rowState[0]."</td></tr> \n");

/*+-------------------------------------------------------------------------------------+

| Now, if there are any records, we'll step through getting the
Office zip. |
| RJP 05/17/06
|

+-------------------------------------------------------------------------------------+*/

$sqlZip = "SELECT sub_fld_value "
." FROM pf_submissions "
." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
." AND sub_fld_name = 'Office Zip'";
//echo "sqlZip=".$sqlZip." \n";

$qryZip = mysql_query($sqlZip);
$rowZip = @mysql_fetch_row($qryZip);
print(" <tr height='20'><td valign'top'>".$rowZip[0]."</td></tr> \n");

/*+------------------------------------------------------------------------------------+

| Now, if there are any records, we'll step through getting the
Office Phone Number. |
| RJP 05/17/06
|

+-------------------------------------------------------------------------------------+*/

$sqlPhone = "SELECT sub_fld_value "
." FROM pf_submissions "
." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
." AND sub_fld_name = 'Office Phone'";
//echo "sqlPhone=".$sqlPhone." \n";

$qryPhone = mysql_query($sqlPhone);
$rowPhone = @mysql_fetch_row($qryPhone);
print(" <tr height='20'><td valign='top'>".$rowPhone[0]."</td></tr> \n");

/*+------------------------------------------------------------------------------------+

| Now, if there are any records, we'll step through getting the
Website. RJP 05/17/06 |

+-------------------------------------------------------------------------------------+*/

$sqlWeb = "SELECT sub_fld_value "
." FROM pf_submissions "
." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' "
." AND sub_fld_name = 'Website Address'";
//echo "sqlWeb=".$sqlWeb." \n";

$qryWeb = mysql_query($sqlWeb);
$rowWeb = @mysql_fetch_row($qryWeb);
print(" <tr height='20'><td valign='top'>".$rowWeb[0]."</td></tr> \n");

print(" </tr>\n");
}

//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
// echo " </tr>\n";
}
//end

?>

</table>

</table>

</div>
</body>

</html>

[Back to original message]

Удаленная работа для программистов • Как заработать на Google AdSense • England, UK • статьи на английском • PHP MySQL CMS Apache Oscommerce • Online Business Knowledge Base • DVD MP3 AVI MP4 players codecs conversion help

Home • Search • Site Map • Set as Homepage • Add to Favourites

Сайт изготовлен в Студии Валентина Петручека —
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация