Man My Brain Hurts - Codewalkers

Codewalkers Forums Sponsor:

August 12th, 2002, 01:23 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

Man My Brain Hurts

Can someone help me write code to enter my data into a webpage.
When i get my results from my php script, getting info from MYSQL it writes it so sloppy, Id like to put the info recieved in a nice HTML table. Any IDEAS? I have been trying for 3 dats now , and my brain is fried!
the page in question is
http://www.thevirtualpilotplanner.com/searchform1.php
the info in the middle is what id like to contain in an html table, or any table, with headers of
PilotID Departure Destination Route and Hours.
Please help!

August 12th, 2002, 01:44 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Man My Brain Hurts

forgot to send my code, Told ya my brain isnt quite right now

<html>

<body>

<?php

mysql_connect (localhost, xxx, xxx);

mysql_select_db (xxx);
include("header.php");
if ($pilotid == "")
{$pilotid = '%';}

$result = mysql_query ("SELECT * FROM pirep
WHERE pilotid LIKE '$pilotid%'
");

if ($row = mysql_fetch_array($result)) {

do {

PRINT "<CENTER>";
PRINT "<BR>";
print $row["pilotid"];
print $row["departure"];
print $row["destination"];
print $row["route"];
print $row["hours"];
} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}
PRINT "<CENTER>";
PRINT "<BR>";
PRINT "<CENTER>";
include("footer2.php");
?>

</body>

</html>

August 12th, 2002, 03:01 AM

Matt

Contributing User

Codewalkers Specialist (4000 - 4499 posts)

Join Date: Apr 2007

Location: Florida

Posts: 4,158

Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6

RE: Man My Brain Hurts

Here, give something like this a try:

php Code:

Original - php Code

<html>
<body>
<?php
 
mysql_connect (localhost, xxx, xxx);
 
mysql_select_db (xxx);
include("header.php");
if ($pilotid == "")
 {$pilotid = '%';}
 
$result = mysql_query ("SELECT * FROM pirep WHERE pilotid LIKE '$pilotid%'");
 
if ($row = mysql_fetch_array($result)) {
 print "<CENTER>";
 print "<TABLE BORDER="1">n";
 print "<TR>n<TD><b>PilotID</b></TD>n";
 print "<TD><b>Departure</b></TD>n";
 print "<TD><b>Destination</b></TD>n";
 print "<TD><b>Route</b></TD>n";
 print "<TD><b>Hours</b></TD>n</TR>n";
 do {
  print "<TR>n";
  print "<TD>{$row['pilotid']}</TD>n";
  print "<TD>{$row['departure']}</TD>n";
  print "<TD>{$row['destination']}</TD>n";
  print "<TD>{$row['route']}</TD>n";
  print "<TD>{$row['hours']}</TD>n";
  print "</TR>n";
 } while($row = mysql_fetch_array($result));
 print "</TABLE>n</CENTERn";
} else {print "Sorry, no records were found!";}
print "<BR>n";
include("footer2.php");
?>
</body>
</html>

August 12th, 2002, 06:48 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Man My Brain Hurts

you rock!,
Thank you very Much!
Michael

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: