Avatar billede kgp43 Nybegynder
11. november 2003 - 17:59 Der er 17 kommentarer og
2 løsninger

Tabel problemer

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.5span {
    padding-right: 5px;
    padding-left: 5px;
}
-->
</style>
</head>

<body>

<table width="96%" border="0" cellspacing="0" cellpadding="0" class="5span">
  <tr bgcolor="#000066">
    <td width="50">
      <div align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FFFFFF">ID</font></strong></font></div></td>
    <td><div align="left"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>shops</strong></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
  </tr>
 
<?
 
include("../db.php");

$query = mysql_query("SELECT * FROM shops");

while($row = mysql_fetch_array($query)) {
<tr>;
<td width="50">;
    <div align="left">echo $row[id];</div></td>;
    <td><div align="left">echo $shop[shop]</div></td>;
    <td><div align="left">echo $row[adress];</div></td>;
    <td><div align="left">echo $row[postno];</div></td>;
    <td><div align="left">echo $row[city];</div></td>;
    <td><div align="left">echo $row[state];</div></td>;
    <td><div align="left">echo $row[phone];</div></td>;
    <td><div align="left">echo $row[fax];</div></td>;
    <td><div align="left">echo $row[login];</div></td>;
    <td><div align="left">echo $row[pass];</div></td>;
    <td><div align="left">echo $row[email];</div></td>;
    <td><div align="left">echo $row[link];</div></td>;
    <td><div align="left">echo $row[ip];</div></td>;
    <td><div align="left">echo $row[signup];</div></td>;
</tr>;
}

?>
</table>

<p>&nbsp;</p>
</body>
</html>


--------------------

Jeg prøver at få noget data ud fra MySQL i en tabel, men den kommer med denne error:

Parse error: parse error in /home/fedtmco/public_html/mytackle/admin/show_shop.php on line 43
Avatar billede michael_stim Ekspert
11. november 2003 - 18:07 #1
Du skal afslutte php scriptet når du bruger html, eller skrive det ud med f.eks echo.
Avatar billede kgp43 Nybegynder
11. november 2003 - 18:08 #2
Dette er linie 43: <tr>;
Avatar billede ztyxx Nybegynder
11. november 2003 - 18:08 #3
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.5span {
    padding-right: 5px;
    padding-left: 5px;
}
-->
</style>
</head>

<body>

<table width="96%" border="0" cellspacing="0" cellpadding="0" class="5span">
  <tr bgcolor="#000066">
    <td width="50">
      <div align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FFFFFF">ID</font></strong></font></div></td>
    <td><div align="left"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>shops</strong></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
  </tr>
 
<?
 
include("../db.php");

$query = mysql_query("SELECT * FROM shops");

while($row = mysql_fetch_array($query)) {
?><tr>;
<td width="50">;
    <div align="left"><? echo $row[id];?></div></td>;
    <td><div align="left"><? echo $shop[shop]?></div></td>;
    <td><div align="left"><? echo $row[adress];?></div></td>;
    <td><div align="left"><? echo $row[postno];?></div></td>;
    <td><div align="left"><? echo $row[city];?></div></td>;
    <td><div align="left"><? echo $row[state];?></div></td>;
    <td><div align="left"><? echo $row[phone];?></div></td>;
    <td><div align="left"><? echo $row[fax];?></div></td>;
    <td><div align="left"><? echo $row[login];?></div></td>;
    <td><div align="left"><? echo $row[pass];?></div></td>;
    <td><div align="left"><? echo $row[email];?></div></td>;
    <td><div align="left"><? echo $row[link];?></div></td>;
    <td><div align="left"><? echo $row[ip];?></div></td>;
    <td><div align="left"><? echo $row[signup];?></div></td>;
</tr>;
<?
}

?>
</table>

<p>&nbsp;</p>
</body>
</html>
Avatar billede michael_stim Ekspert
11. november 2003 - 18:09 #4
<?
 
include("../db.php");

$query = mysql_query("SELECT * FROM shops");

while($row = mysql_fetch_array($query)) {
<?
<tr>
<td width="50">;
    <div align="left"><?echo $row[id];?></div></td>
    <td><div align="left"><?echo $shop[shop];?></div></td>
    osv osv...
    </tr>
<?
}

?>
</table>
Avatar billede kgp43 Nybegynder
11. november 2003 - 18:10 #5
Michail stim: Vil du have mig til at sætte Echo foran alle disse linier:

<tr>;
<td width="50">;
    <div align="left">echo $row[id];</div></td>;
    <td><div align="left">echo $shop[shop]</div></td>;
    <td><div align="left">echo $row[adress];</div></td>;
    <td><div align="left">echo $row[postno];</div></td>;
    <td><div align="left">echo $row[city];</div></td>;
    <td><div align="left">echo $row[state];</div></td>;
    <td><div align="left">echo $row[phone];</div></td>;
    <td><div align="left">echo $row[fax];</div></td>;
    <td><div align="left">echo $row[login];</div></td>;
    <td><div align="left">echo $row[pass];</div></td>;
    <td><div align="left">echo $row[email];</div></td>;
    <td><div align="left">echo $row[link];</div></td>;
    <td><div align="left">echo $row[ip];</div></td>;
    <td><div align="left">echo $row[signup];</div></td>;
</tr>;
Avatar billede michael_stim Ekspert
11. november 2003 - 18:10 #6
ztyxx>>
Han skal nok ikke have alle de semikolonner med :)
Avatar billede ztyxx Nybegynder
11. november 2003 - 18:13 #7
michael_stim> tænker du på dem i <? echo $row[login];?>
Avatar billede kgp43 Nybegynder
11. november 2003 - 18:15 #8
der kommer 100m tomme linier med ";" :P
Avatar billede michael_stim Ekspert
11. november 2003 - 18:15 #9
Nej dem efter </td>
Avatar billede ztyxx Nybegynder
11. november 2003 - 18:16 #10
nååh nej, dem havde jeg ikke lige fået fjernet ;-)
Avatar billede michael_stim Ekspert
11. november 2003 - 18:16 #11
Du skal have dine variabler indenfor ''
echo $shop['shop'];
Avatar billede kgp43 Nybegynder
11. november 2003 - 18:17 #12
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.5span {
    padding-right: 5px;
    padding-left: 5px;
}
-->
</style>
</head>

<body>

<table width="96%" border="0" cellspacing="0" cellpadding="0" class="5span">
  <tr bgcolor="#000066">
    <td width="50">
      <div align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FFFFFF">ID</font></strong></font></div></td>
    <td><div align="left"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>shops</strong></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
    <td><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><font face="Verdana, Arial, Helvetica, sans-serif"></font></font></font></div></td>
  </tr>
 
<?
 
include("../db.php");

$query = mysql_query("SELECT * FROM shops");

while($row = mysql_fetch_array($query)) {
?><tr>
<td width="50">
    <div align="left"><? echo $row[id];?></div></td>
    <td><div align="left"><? echo $shop[shop]?></div></td>
    <td><div align="left"><? echo $row[adress];?></div></td>
    <td><div align="left"><? echo $row[postno];?></div></td>
    <td><div align="left"><? echo $row[city];?></div></td>
    <td><div align="left"><? echo $row[state];?></div></td>
    <td><div align="left"><? echo $row[phone];?></div></td>
    <td><div align="left"><? echo $row[fax];?></div></td>
    <td><div align="left"><? echo $row[login];?></div></td>
    <td><div align="left"><? echo $row[pass];?></div></td>
    <td><div align="left"><? echo $row[email];?></div></td>
    <td><div align="left"><? echo $row[link];?></div></td>
    <td><div align="left"><? echo $row[ip];?></div></td>
    <td><div align="left"><? echo $row[signup];?></div></td>
</tr>
<?
}

?>
</table>

<p>&nbsp;</p>
</body>
</html>
Avatar billede kgp43 Nybegynder
11. november 2003 - 18:17 #13
Sådan, nu virker den.

Kan i begge ikke lige lave et svar?
Avatar billede ztyxx Nybegynder
11. november 2003 - 18:18 #14
jo da ;-)
Avatar billede Slettet bruger
11. november 2003 - 18:29 #15
Tjahh prøv også med :
<?PHP <<< (tror du mangler php)
 
include("../db.php");

$query = mysql_query("SELECT * FROM shops");

while($row = mysql_fetch_array($query)) {
<tr>;
<td width="50">;
    <div align="left">echo $row[id];</div></td>;
    <td><div align="left">echo $shop[shop]</div></td>;
    <td><div align="left">echo $row[adress];</div></td>;
    <td><div align="left">echo $row[postno];</div></td>;
    <td><div align="left">echo $row[city];</div></td>;
    <td><div align="left">echo $row[state];</div></td>;
    <td><div align="left">echo $row[phone];</div></td>;
    <td><div align="left">echo $row[fax];</div></td>;
    <td><div align="left">echo $row[login];</div></td>;
    <td><div align="left">echo $row[pass];</div></td>;
    <td><div align="left">echo $row[email];</div></td>;
    <td><div align="left">echo $row[link];</div></td>;
    <td><div align="left">echo $row[ip];</div></td>;
    <td><div align="left">echo $row[signup];</div></td>;
</tr>;
}

?>
Avatar billede ztyxx Nybegynder
11. november 2003 - 18:30 #16
lynz> du har også fået alle ;erne med efter </td> ;-)
Avatar billede ztyxx Nybegynder
11. november 2003 - 18:38 #17
takker for point ;-)
Avatar billede michael_stim Ekspert
11. november 2003 - 19:32 #18
Tak for points. styxx, tror bare lynz var ude efter billige points, men kgp43 gik ikke i fälden.
Avatar billede ztyxx Nybegynder
11. november 2003 - 21:43 #19
hehe, ja jeg skal nu ikke dømme folk, men det kan da være.... c",)
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester