Posted for [EMAIL PROTECTED]
hi,
i'm using php to query a database and output a selection of records.
the problem is that i don't want the output in an html table format.
i
want just a listing of records.
all i'm trying to do now is get rid of the column headers. they are
currently stretching across the page and i don't want any of them
there. you can see what i mean at www.webgal.com/jane/edit2.php
how do i get rid of the column heads?
below is what i have right now:
$sql ="SELECT
recordid,firstname,lastname,title,organization,department,streetadd,city
,state,zip,phone,fax,email,questions
FROM $table_name WHERE lastname LIKE \"$param1%\" AND organization
LIKE \"$param2%\" ORDER BY lastname";
$total_result = @mysql_query($sql, $connection) or die("Error #".
mysql_errno() . ": " . mysql_error());
$total_found = @mysql_num_rows($total_result);
$nav_block .= "<link rel=stylesheet href=style.css type=text/css>";
while ($row = mysql_fetch_array($total_result)){
$recordid=$row['recordid'];
$firstname=$row['firstname'];
$lastname=$row['lastname'];
$title=$row['title'];
$organization=$row['organization'];
$department=$row['department'];
$streetadd=$row['streetadd'];
$city=$row['city'];
$state=$row['state'];
$zip=$row['zip'];
$phone=$row['phone'];
$fax=$row['fax'];
$email=$row['email'];
$questions=$row['questions'];
$display_block .= "<tr><td><a
href=\"edit_detail.php?recordid=$recordid\">$firstname</a>
$lastname<br>$title<br>$organization<br>$department<br>$streetadd<br>$ci
ty,
$state $zip<br>Phone: $phone<br>Fax: $fax<br>Email: <a
href=mailto:$email>$email</a><br>Question:
$questions</td></tr><tr><td><hr></td></tr>";
}
$nav_block .= "<br><br><a href=\"edit.html\">Search Again</a>";
thanks for any help you can provide!!!!!!!
dana
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
