sql-query problemer

$connection = mysql_pconnect("host","user","pass");
mysql_select_db("database");

host, user, pass og database er de oplysninger du har fået af dit webhotel til at komme i kontakt med din database.

$select = "SELECT * FROM mydomain ORDER BY stamp DESC LIMIT $offset, 100";
$connection = mysql_connect("localhost","database_1","password");
mysql_select_db("database_com_1");
$query = mysql_query($select,$connection) or die ("QUERY failed.");


jeg får bare "QUERY failed."...
det der undrerer mig er at det overhovedet er nødvendigt med den connection, for på det tidspunkt har jeg allerede includet min connnectdb.php som indeholder:
<?
mysql_connect("localhost","database_1","password");
mysql_select_db("database_com_1");
?>

Nej jeg ville gøre sådan her:

$connection = mysql_pconnect("host","user","pass");
mysql_select_db("database");
$select = "SELECT * FROM mydomain ORDER BY stamp DESC LIMIT $offset, 100";
$query = mysql_query($select) or die ("QUERY failed.");

hmm jeg kan ikke få det til at virke... her er lidt mere kode:

<?
include("connectdb.php");

$offset = $_GET['offset'];
if ($offset == "") { $start = "0"; }

$connection = mysql_connect("localhost","mydomain","password");
mysql_select_db("mydomain_1");
$select = "SELECT * FROM min_tabel ORDER BY stamp DESC LIMIT $offset, 100";
$query = mysql_query($select) or die ("QUERY failed.");


while($row = mysql_fetch_array($query))
{
$i = $i + 1;

$location = $row[location];
echo $location;

}

?>

<?
include("connectdb.php");

$offset = $_GET['offset'];
if ($offset == "") { $start = "0"; }

$select = "SELECT * FROM min_tabel ORDER BY stamp DESC LIMIT $offset, 100";

while($row = mysql_fetch_array($query)){
$i = $i + 1;

$location = $row[location];
echo $location;

}

?>

hov:

<?
include("connectdb.php");

$offset = $_GET['offset'];
if ($offset == "") { $start = "0"; }

$select = "SELECT * FROM min_tabel ORDER BY stamp DESC LIMIT $offset, 100";

while($row = mysql_fetch_array($select)){
$i = $i + 1;

$location = $row[location];
echo $location;

}

?>

jeg fik ingen fejl, dog virker det stadig ikke, men det ligger sikkert et andet sted i koden. Mange tak!

Ellers vend tilbage så må viu løse det.

mystisk... det generer intet output...

<?
include("connectdb.php");

$offset = $_GET['offset'];
if ($offset == "") { $offset = "0"; }

$select = "SELECT * FROM psclan_iplog ORDER BY stamp DESC LIMIT $offset, 100";
while($row = mysql_fetch_array($select)){
$i = $i + 1;


$location = $row[location];
echo $location;
}





-her kommer den samlede, uredigerede kode:



<?
include("connectdb.php");

$offset = $_GET['offset'];
if ($offset == "") { $offset = "0"; }

$select = "SELECT * FROM psclan_iplog ORDER BY stamp DESC LIMIT $offset, 100";
while($row = mysql_fetch_array($select)){
$i = $i + 1;

?>
<head>
<style type="text/css">
<!--
A
{
color: #cccccc;
font-weight: bold;
text-decoration: none;
}
A:link
{
color: #cccccc;
font-weight: bold;
text-decoration: none;
}
A:visited
{
color: #cccccc;
font-weight: bold;
text-decoration: none;
}
A:active
{
color: #FFcccc;
font-weight: bold;
text-decoration: none;
}
A:hover
{
color: #FFaaaa;
font-weight: bold;
text-decoration: underline;
}
-->
</style>
<title>Psclan IP-log</title>
</head>
<body bgcolor=black style="font-family: tahoma; color: silver; font-weight: bold; font-size: 20px;">
<center>
<font size=5>Psclan.com IP-log</font><br>
<table cellpadding=2 cellspacing=0 style="border: 1px solid white; width: 100%;">
<tr>
<td style="border-bottom: 1px solid silver; width: 25%;" bgcolor=#333333><u>Time:</u></td>
<td style="border-bottom: 1px solid silver; width: 20%;" bgcolor=#333333><u>IP-Address:</u></td>
<td style="border-bottom: 1px solid silver; width: 55%;" bgcolor=#333333><u>Page Accessed:</u></td>
</tr>
<?
                                    /* while ($list = @mysql_fetch_object($query)) { */


$location = $row[location];
$location = str_replace("link-added",        "Admin: Link added to database.","$location");
$location = str_replace("news-added",        "Admin: News added to database.","$location");
$location = str_replace("link-deleted",        "Admin: Link was deleted.","$location");
$location = str_replace("news-deleted",        "Admin: News was deleted.","$location");
$location = str_replace("link-edited",        "Admin: Link was edited, and changes saved.","$location");
$location = str_replace("news-edited",        "Admin: News was edited, and changes saved.","$location");
$location = str_replace("pre-link-edit",    "Admin: Link-edit page opened.","$location");
$location = str_replace("createmember",        "Admin: Member added to database.","$location");
$location = str_replace("pre-edit-member",    "Admin: Member-edit page opened.","$location");
$location = str_replace("member-edited",    "Admin: Member was edited, and changes saved.","$location");
$location = str_replace("pre-deletemember",    "Admin: Member-delete page opened.","$location");
$location = str_replace("member-deleted",    "Admin: Member was deleted.","$location");
if ($location == "links") { $location = str_replace("links", "Guest: Links-page was accessed.","$location"); }
if ($location == "memeberspage") { $location = str_replace("memeberspage", "Guest: Members-page was accessed.","$location"); }
if ($location == "newslist") { $location = str_replace("newslist", "Guest: News/Main-page was accessed.","$location"); }
if ($location == "newslistall") { $location = str_replace("newslistall", "Guest: AllNews-page was accessed.","$location"); }

$location = str_replace("Admin:", "<font color=red>Admin:</font>", "$location");
$location = str_replace("Guest:", "<font color=green>Guest:</font>", "$location");

$stamp = $row[stamp];
$stamp = date("jS M Y - H:i:s", $stamp);

echo "
<tr>\n
<td NOWRAP>$stamp&nbsp;&nbsp;&nbsp;</td>\n
<td NOWRAP><a title='Lookup ip-address' href=http://kresch.com/resources/lookup.php?ipname=$row[addy]>$row[addy]</a></td>
<td NOWRAP>$location</td>
</tr>\n";
}


$f = $offset + 100;
$b = $offset - 100;
if($f > 100){
echo "<tr><td colspan=4 align=center style='border-top: 1px solid #444444 dashed;'>";
    echo ("<a href=$PHP_SELF?offset=$b><small><--</small></a>");
    if($i == 100){
      echo (" | ");
      }
}
if($i == 100){
    echo ("<a href=$PHP_SELF?offset=$f><small>--></small></a>");
echo "</td></tr>";
}


?>
<tr>
<td colspan=4 align=right style='border-top: 1px solid silver;' bgcolor=#333333><i>IP-logger by Me - <a href="mailto:removed@eksperten.dk?subject=ip-logger">mail me</a>.</i></td>
</tr>
<?










?>

<?
include("connectdb.php");

$offset = $_GET['offset'];
if ($offset == "") { $offset = "0"; }

$select = mysql_query("SELECT * FROM psclan_iplog ORDER BY stamp DESC LIMIT $offset, 100");
while($row = mysql_fetch_array($select)){
$i = $i + 1;


$location = $row[location];
echo $location;
}

perfekt! mange tak!
Vil du have 15 points?

Hvis du mener mit arbejde er det værd, så siger jeg da ja tak, men ellers så vil jeg da ikke ;o)

http://www.eksperten.dk/spm/334651

Hvis du ønsker at give mig 15 mere så opret et spm. i denne kategori med titlen points til ahv og husk at skrive et ref til dette spm.

http://www.eksperten.dk/spm/334629