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> </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
Annonceindlæg fra gavdi
11. november 2003 - 18:07
#1
Du skal afslutte php scriptet når du bruger html, eller skrive det ud med f.eks echo.
11. november 2003 - 18:08
#2
Dette er linie 43: <tr>;
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> </p> </body> </html>
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>
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>;
11. november 2003 - 18:10
#6
ztyxx>> Han skal nok ikke have alle de semikolonner med :)
11. november 2003 - 18:13
#7
michael_stim> tænker du på dem i <? echo $row[login];?>
11. november 2003 - 18:15
#8
der kommer 100m tomme linier med ";" :P
11. november 2003 - 18:15
#9
Nej dem efter </td>
11. november 2003 - 18:16
#10
nååh nej, dem havde jeg ikke lige fået fjernet ;-)
11. november 2003 - 18:16
#11
Du skal have dine variabler indenfor '' echo $shop['shop'];
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> </p> </body> </html>
11. november 2003 - 18:17
#13
Sådan, nu virker den. Kan i begge ikke lige lave et svar?
11. november 2003 - 18:18
#14
jo da ;-)
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>; } ?>
11. november 2003 - 18:30
#16
lynz> du har også fået alle ;erne med efter </td> ;-)
11. november 2003 - 18:38
#17
takker for point ;-)
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.
11. november 2003 - 21:43
#19
hehe, ja jeg skal nu ikke dømme folk, men det kan da være.... c",)
Vi tilbyder markedets bedste kurser inden for webudvikling