$row output

[dcjones]

I am very new to PHP so please help if you can.

The code I am working on is simple to most of you I know. All I am trying to do is produce the out put from a database and have the fields displayed on different lines on the screen.

Below id the code I am working with:
<?php
include 'error.inc';
include 'db.inc';

function displayhotels($result)
{

 // Start a table, with column headers
 echo "\n<table border=\"0\" cellpadding=\"2\" cellspacing\"1\">" .
	  "<caption><b><font color=\"black\" size=\"-1\"> Warwickshire Hotels</b></caption>" .
	  "\n\t<th width=\"10%\" bgcolor=\"#cccccc\" ><font color=\"black\" size=\"-1\" >Code   </th>" .
	  "\n\t<th width=\"40%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" face=\"airal\"><b>Hotel Name   </th>" . 
      "\n\t<th width=\"15%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" >Telephone No   </th>" .
      "\n\t<th width=\"15%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" >Faxsmile No   </th>" . 
      "\n\t<th width=\"20%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" >Email Address   </th>" .
	  "\n\t<th width=\"10%\" bgcolor=\"#cccccc\" ><font color=\"black\" size=\"-1\" >Website   </th>" .
	  "\n</tr>";
	   echo "\n<tr>\n\t<td></td>\n</tr>";
       echo "\n<tr>\n\t<td></td>\n</tr>";
       echo "\n<tr>\n\t<td></td>\n</tr>";



 // Until there are no rows in the result set,
 // fetch a row into the $row array and ...
 while ($row = @ mysql_fetch_row($result))
 {
    // ... start a TABLE row ...
    echo "\n<tr>";


    // ... and print out each of the attributes
    // in that row as a separate TD (Table Data).
   foreach($row as $data)
      echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"airal\"> $row["name"] .  " ". </td>";
      echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"airal\"> $row["street"] . " " . </td>";
	//   echo "\n<tr>\n\t<td></td>\n</tr>";
   //    echo "\n<tr>\n\t<td></td>\n</tr>";
   //   echo "\n<tr>\n\t<td></td>\n</tr>";

    // Finish the row
   echo "\n</tr>";
 }

 // Then, finish the table
 echo "\n</table>\n";

}

//$query = "SELECT name, street, FROM accom order by name";

$query ="select
set name = $name, " .
street = $street, " .
from accom order by name";

// Connect to the MySQL server
if (!($connection = @ mysql_connect($server,
$user,
$password)))
die("Cannot connect");

if (!(mysql_select_db("db66511019", $connection)))
showerror();

// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();

// Display the results
displayhotels($result);

// Close the connection
if (!(mysql_close($connection)))
showerror();
?>

When I run the code I get the following error:

I did say I was new to this.

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'

Can anyone help.

Kind regards.

Dereck

[bernouli]

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'

but in which line??

what are you going to do with this line?

query ="select 
                    set name = $name, " . 
                    street = $street, " . 
                    from accom order by name"; 

[dcjones]

I am getting the error in line 54

echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"airal\"> $row["name"] . " ". </td>";

As for the other part

                query ="select 
                set name = $name, " . 
                street = $street, " . 
                from accom order by name";

I thought that was the way to format the select.

can you HELP PLS.

Regards

Dereck

[bernouli]

the correct one are

echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"arial\">".$row["name"] ." </td>";

and

query ="select ";
query . = "$name;
query . = ",";
query .= $street;
query . = "from accom order by name";

[dcjones]

I have changed the coding as you suggested. I get the error

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /homepages/41/d43000764/htdocs/TraveltoEngland/Accomodation/PHP/hotels.php on line 54

Here are line 51 to 73

// ... and print out each of the attributes
// in that row as a separate TD (Table Data).
foreach($row as $data);
echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"airal\"> $row["name"] . " </td>";
echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"airal\"> $row["street"] . " </td>";
// echo "\n<tr>\n\t<td></td>\n</tr>";
// echo "\n<tr>\n\t<td></td>\n</tr>";
// echo "\n<tr>\n\t<td></td>\n</tr>";

    // Finish the row
   echo "\n</tr>";
 }

 // Then, finish the table
 echo "\n</table>\n";

}

//$query = "SELECT name, street, FROM accom order by name";

$query = "select";
$query .= "$name;
$query .= ",";
$query .= "$street;
$query .= "from accom order by name";

Any idea and can I thank you now for helping.

Dereck

[dcjones]

Hi ,

If you wanted to output onto the screen the following what would you advise for code.

---

Name: DCJONES Tel: [phone]
Fax: [phone]
Address: The House
Anywhere
England

---

How do I postion the out put. I can already get all the data displayed in one row. It's the positioning I am having problems with.

Sorry to be a pain.

Many Thanks

Dereck

[bernouli]

you did NOT do what i told you
read carefully which codes i posted to you
and just COPY and PASTE, do NOT rewrite

[dcjones]

Sorry, the "-" is space between data.

Name:--- DCJONES-------------- Tel: [phone]
--------------------------------------Fax: [phone]
Address: The House
------------Anywhere
------------England

Many thanks again

Dereck

[dcjones]

Sorry, I did what you said, copy and paste, see below

// ... and print out each of the attributes
// in that row as a separate TD (Table Data).
foreach($row as $data);
echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"arial\">".$row["name"] ." </td>";
echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"arial\">".$row["name"] ." </td>";

	//   echo "\n<tr>\n\t<td></td>\n</tr>";
   //    echo "\n<tr>\n\t<td></td>\n</tr>";
   //   echo "\n<tr>\n\t<td></td>\n</tr>";

    // Finish the row
   echo "\n</tr>";
 }

 // Then, finish the table
 echo "\n</table>\n";

}

//$query = "SELECT name, street, FROM accom order by name";

query ="select ";
query . = "$name;
query . = ",";
query .= $street;
query . = "from accom order by name";

Lines 51 to 75.

I now get the following error:

Parse error: parse error in /homepages/41/d43000764/htdocs/TraveltoEngland/Accomodation/PHP/hotels.php on line 71

Thanks once again.

Dereck

[bernouli]

Its now my fault 😃

the correct one should be

$query ="select ";
$query .= $name;
$query .= ",";
$query .= $street;
$query .= "from accom order by name";

[dcjones]

Hi again, sorry but now I get the error:

Error 1064 : You have an error in your SQL syntax near 'from accom order by name' at line 1

Here is the complete code, any idea. Please.

<!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Hotels</title>
</head>
<body background="../../Gif/Background.gif">
<table width="100%" height="100%">
<tr>
<td align="center" valign="middle">

		<table width="80%" border="0" align="center">
			<tr>
			<td>
			<div align="justify">

<?php
include 'error.inc';
include 'db.inc';

function displayhotels($result)
{

 // Start a table, with column headers
 echo "\n<table border=\"0\" cellpadding=\"2\" cellspacing\"1\">" .
	  "<caption><b><font color=\"black\" size=\"-1\"> Warwickshire Hotels</b></caption>" .
	  "\n\t<th width=\"10%\" bgcolor=\"#cccccc\" ><font color=\"black\" size=\"-1\" >Code   </th>" .
	  "\n\t<th width=\"40%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" face=\"airal\"><b>Hotel Name   </th>" . 
      "\n\t<th width=\"15%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" >Telephone No   </th>" .
      "\n\t<th width=\"15%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" >Faxsmile No   </th>" . 
      "\n\t<th width=\"20%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" >Email Address   </th>" .
	  "\n\t<th width=\"10%\" bgcolor=\"#cccccc\" ><font color=\"black\" size=\"-1\" >Website   </th>" .
	  "\n</tr>";
	   echo "\n<tr>\n\t<td></td>\n</tr>";
       echo "\n<tr>\n\t<td></td>\n</tr>";
       echo "\n<tr>\n\t<td></td>\n</tr>";



 // Until there are no rows in the result set,
 // fetch a row into the $row array and ...
 while ($row = @ mysql_fetch_row($result))
 {
    // ... start a TABLE row ...
    echo "\n<tr>";


    // ... and print out each of the attributes
    // in that row as a separate TD (Table Data).
   foreach($row as $data);
      echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"arial\">".$row["name"] ." </td>"; 
	  echo "\n\t<td bgcolor=\"#ffffff\"><font size=\"-1\"face=\"arial\">".$row["street"] ." </td>"; 


	//   echo "\n<tr>\n\t<td></td>\n</tr>";
   //    echo "\n<tr>\n\t<td></td>\n</tr>";
   //   echo "\n<tr>\n\t<td></td>\n</tr>";

    // Finish the row
   echo "\n</tr>";
 }

 // Then, finish the table
 echo "\n</table>\n";

}

$query ="select "; 
$query .= $name; 
$query .= ","; 
$query .= $street; 
$query .= "from accom order by name";

// Connect to the MySQL server
if (!($connection = @ mysql_connect($server,
$user,
$password)))
die("Cannot connect");

if (!(mysql_select_db("db66511019", $connection)))
showerror();

// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();

// Display the results
displayhotels($result);

// Close the connection
if (!(mysql_close($connection)))
showerror();
?>
</div>
</td>
</tr>
</table>
</table>
</body>
</html>

Thanks

Dereck

[bernouli]

I dont know much about your table in your sql, but you can try this anyway

$query = "select '".$name."','".$street."' from accom order by '".$me."'";

[dcjones]

Hi again,

Well it''s getting close. the script now reads the code and displays the headings for the data. but no actual data is output.

The table structure is very simple ( a wee bit like me ).

it has the following

field ID INT Autoincrement
field Location TEXT
field NAME TEXT
field STREET TEXT
field SUBURB TEXT
field TOWN TEXT
field COUNTY TEXT
field POSTCODE TEXT
field TEL TEXT
field FAX TEXT
field EMAIL TEXT
field WEBSITE TEXT
field ACCTYPE TEXT

Thats it.

I have been working on this for days trying to get it right. As I say I get get an outpurt with all the data in one row. But I need to be able to display the data at any give X - Y location on the screen.

I do not no where to go from here.

Thanks for all that you have done.

Dereck

[bernouli]

Which codes did you write in order to print it in a row?
I think thats now HTML things to print it out in give X - Y location, isnt it?

[dcjones]

Hello again

The code I used to print the data in a row was:

// Start a table, with column headers
echo "\n<table border=\"0\" cellpadding=\"2\" cellspacing\"1\">" .
"\n\t<th width=\"10%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" >Code </th>" .
"\n\t<th width=\"40%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" face=\"airal\"><b>Hotel Name </th>" .
"\n\t<th width=\"15%\" bgcolor=\"#cccccc\"><font color=\"black\" size=\"-1\" >Telephone No </th>" .
"\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";

 // Until there are no rows in the result set,
 // fetch a row into the $row array and ...
 while ($row = @ mysql_fetch_row($result))
 {
    // ... start a TABLE row ...
    echo "\n<tr>";


    // ... and print out each of the attributes
    // in that row as a separate TD (Table Data).
   foreach($row as $data)
      echo "\n\t<td background=\"../../Gif/Background.gif\"><font size=\"-2\"face=\"arial\"> $data </td>";

This gives me a row of :

ID Hotel Name Tel

I have been playing with this all day and now half the night just trying to get all three fields on different rows on the screen.

Again I thank you

Dereck

[bernouli]

foreach($row as $data)
echo "\n\t<td background=\"../../Gif/Background.gif\"><font size=\"-2\"face=\"arial\"> $data </td>";

This gives me a row of :

ID Hotel Name Tel

try this

foreach($row as $field=>$data)
echo "\n\t<td background=\"../../Gif/Background.gif\"><font size=\"-2\"face=\"arial\"> $data </td>";