Pagina 1 van 1
sql SELECT probleempje
Geplaatst: 19 sep 2004, 19:32
door CG bandicoot
Het gaat om deze site '
http://skateit.netrulon.com' en deze pagina '
http://skateit.netrulon.com/spotlist.php'.
Dit is de hele php file :
Code: Selecteer alles
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './'; // <--
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
?>
<html>
<head>
<meta name="generator" content="Namo WebEditor v5.0">
</head>
<body bgcolor="#CC9966" text="black" link="blue" vlink="purple" alink="red">
<table cellpadding="0" cellspacing="0" width="991">
<tr>
<td width="138" height="30" bgcolor="#990000">
<p> <b><font color="#CC6600">Navigatie</font></b></p>
</td>
<td width="37" height="420" rowspan="6">
<p> </p>
</td>
<td width="816" height="30" bgcolor="#990000">
<p> <b><font color="#CC6600">Nieuws</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="113" valign="top" bgcolor="#996600">
<p><? include('navigation.php') ?></p>
</td>
<td width="816" height="390" valign="top" rowspan="5" bgcolor="#996600">
<p><?
$sql= "SELECT id,spot,location FROM phpbb_spots ORDER BY id desc limit 50"
";
$res = mysql_query($query);
while($data = @mysql_fetch_array($res))
{
echo " <a href="spot.php?id=$data["id"]."">".$data['spot']."</a><br>";
}
?>
</p>
</td>
</tr>
<tr>
<td width="138" height="25" valign="top" bgcolor="#990000">
<p> <b><font color="#CC6600">Links</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="87" valign="top" bgcolor="#996600">
<p><? include('links.php') ?></p>
</td>
</tr>
<tr>
<td width="138" height="23" valign="top" bgcolor="#990000" align="center">
<p><b><font color="#CC9900">Latest event</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="142" valign="top" bgcolor="#996600">
<p> Nog geen evenementen bekend.
</p>
</td>
</tr>
</table>
<p> </p>
</body>
</html>
<?
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Dit is van regel 38 tot en met 47 :
Code: Selecteer alles
<p><?
$sql= "SELECT id,spot,location FROM phpbb_spots ORDER BY id desc limit 50"
";
$res = mysql_query($query);
while($data = @mysql_fetch_array($res))
{
echo " <a href="spot.php?id=$data["id"]."">".$data['spot']."</a><br>";
}
?>
</p>
Wat is er fout?
Geplaatst: 19 sep 2004, 19:41
door Podium4
Code: Selecteer alles
$sql= "SELECT id,spot,location FROM phpbb_spots ORDER BY id desc limit 50"
";
Moet zijn:
Code: Selecteer alles
$sql= "SELECT id,spot,location FROM phpbb_spots ORDER BY id desc limit 50";
Geplaatst: 19 sep 2004, 19:47
door CG bandicoot
Oke. Hij krijgt op spotlist.php nog steeds dezelfde fout melding. Het gaat over één of andere backslash.
Dit is nu de hele file :
Code: Selecteer alles
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './'; // <--
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
?>
<html>
<head>
<meta name="generator" content="Namo WebEditor v5.0">
</head>
<body bgcolor="#CC9966" text="black" link="blue" vlink="purple" alink="red">
<table cellpadding="0" cellspacing="0" width="991">
<tr>
<td width="138" height="30" bgcolor="#990000">
<p> <b><font color="#CC6600">Navigatie</font></b></p>
</td>
<td width="37" height="420" rowspan="6">
<p> </p>
</td>
<td width="816" height="30" bgcolor="#990000">
<p> <b><font color="#CC6600">Nieuws</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="113" valign="top" bgcolor="#996600">
<p><? include('navigation.php') ?></p>
</td>
<td width="816" height="390" valign="top" rowspan="5" bgcolor="#996600">
<p><?
$sql= "SELECT id,spot,location FROM phpbb_spots ORDER BY id desc limit 50";
$res = mysql_query($query);
while($data = @mysql_fetch_array($res))
{
echo " <a href="spot.php?id=$data["id"]."">".$data['spot']."</a><br>";
}
?>
</p>
</td>
</tr>
<tr>
<td width="138" height="25" valign="top" bgcolor="#990000">
<p> <b><font color="#CC6600">Links</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="87" valign="top" bgcolor="#996600">
<p><? include('links.php') ?></p>
</td>
</tr>
<tr>
<td width="138" height="23" valign="top" bgcolor="#990000" align="center">
<p><b><font color="#CC9900">Latest event</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="142" valign="top" bgcolor="#996600">
<p> Nog geen evenementen bekend.
</p>
</td>
</tr>
</table>
<p> </p>
</body>
</html>
<?
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Geplaatst: 19 sep 2004, 20:25
door Podium4
Het gaat fout op deze regel:
Code: Selecteer alles
echo " <a href="spot.php?id=$data["id"]."">".$data['spot']."</a><br>";
Vekeerd gebruik van de ". Als ik het niet mis heb moet ie zo worden:
Code: Selecteer alles
echo " <a href=\"spot.php?id=$data[\"id\"].\"\">\".$data['spot'].\"</a><br>";
Geplaatst: 19 sep 2004, 20:37
door CG bandicoot
Oke. Nu krijg ik weer dit :
Code: Selecteer alles
Parse error: parse error, unexpected T_CHARACTER, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/bandicoo/public_html/spotlist.php on line 43
Zo ziet de file er nu uit :
Code: Selecteer alles
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './'; // <--
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
?>
<html>
<head>
<meta name="generator" content="Namo WebEditor v5.0">
</head>
<body bgcolor="#CC9966" text="black" link="blue" vlink="purple" alink="red">
<table cellpadding="0" cellspacing="0" width="991">
<tr>
<td width="138" height="30" bgcolor="#990000">
<p> <b><font color="#CC6600">Navigatie</font></b></p>
</td>
<td width="37" height="420" rowspan="6">
<p> </p>
</td>
<td width="816" height="30" bgcolor="#990000">
<p> <b><font color="#CC6600">Nieuws</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="113" valign="top" bgcolor="#996600">
<p><? include('navigation.php') ?></p>
</td>
<td width="816" height="390" valign="top" rowspan="5" bgcolor="#996600">
<p><?
$sql= "SELECT id,spot,location FROM phpbb_spots ORDER BY id desc limit 50";
$res = mysql_query($query);
while($data = @mysql_fetch_array($res))
{
echo " <a href=\"spot.php?id=$data[\"id\"].\"\">\".$data['spot'].\"</a><br>";
}
?>
</p>
</td>
</tr>
<tr>
<td width="138" height="25" valign="top" bgcolor="#990000">
<p> <b><font color="#CC6600">Links</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="87" valign="top" bgcolor="#996600">
<p><? include('links.php') ?></p>
</td>
</tr>
<tr>
<td width="138" height="23" valign="top" bgcolor="#990000" align="center">
<p><b><font color="#CC9900">Latest event</font></b></p>
</td>
</tr>
<tr>
<td width="138" height="142" valign="top" bgcolor="#996600">
<p> Nog geen evenementen bekend.
</p>
</td>
</tr>
</table>
<p> </p>
</body>
</html>
<?
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Geplaatst: 20 sep 2004, 14:38
door mosymuis
podium4 schreef:Het gaat fout op deze regel:
Code: Selecteer alles
echo " <a href="spot.php?id=$data["id"]."">".$data['spot']."</a><br>";
Vekeerd gebruik van de ". Als ik het niet mis heb moet ie zo worden:
Code: Selecteer alles
echo " <a href=\"spot.php?id=$data[\"id\"].\"\">\".$data['spot'].\"</a><br>";
Je hebt het mis.
Code: Selecteer alles
echo " <a href=\"spot.php?id=" . $data['id'] . "\">" . $data['spot'] . "</a><br>";
Geplaatst: 20 sep 2004, 19:10
door CG bandicoot
Oke. Mosymuis zijn oplossing heeft gewerkt.
Maar nu zit ik weer met een nieuw probleem.
Ik krijg een lege lijst te zien.
Hoe moet ik dat nou oplossen?