få vist antallet af søgeresultater og vise dem i en tabel 9x9

Der skal du bruge explode: http://dk2.php.net/manual/da/function.explode.php

prøver lige at fixe en kode

<?php
$images = $row["Billeder"];
$image = explode(" ", $images);

//DENNE SKAL IND FØR DIN QUERY

    $range = 20; // Antal resultater pr. side
    $offset = isset($_GET['offset']) ? $_GET['offset'] : 0;

// !!! QUERY !!! Denne skal sættes ind bagerst i query'en LIMIT $offset, $range


print "<table border=1 align='center'>";
while ($row = mysql_fetch_array($galleri))
{
    print "<tr>";
    print "<td><a href='billeder/pix_".$image[0]."/index.php'>".$image[0]."</a></td>";
    print "<td><a href='billeder/pix_".$image[1]."/index.php'>".$image[1]."</a></td>";
    print "<td><a href='billeder/pix_".$image[2]."/index.php'>".$image[2]."</a></td>";
    print "<td><a href='billeder/pix_".$image[3]."/index.php'>".$image[3]."</a></td>";
    print "<td><a href='billeder/pix_".$image[4]."/index.php'>".$image[4]."</a></td>";
    print "<td><a href='billeder/pix_".$image[5]."/index.php'>".$image[5]."</a></td>";
    print "<td><a href='billeder/pix_".$image[6]."/index.php'>".$image[6]."</a></td>";
    print "<td><a href='billeder/pix_".$image[7]."/index.php'>".$image[7]."</a></td>";
    print "<td><a href='billeder/pix_".$image[8]."/index.php'>".$image[8]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[9]."/index.php'>".$image[9]."</a></td>";
    print "<td><a href='billeder/pix_".$image[10]."/index.php'>".$image[10]."</a></td>";
    print "<td><a href='billeder/pix_".$image[11]."/index.php'>".$image[11]."</a></td>";
    print "<td><a href='billeder/pix_".$image[12]."/index.php'>".$image[12]."</a></td>";
    print "<td><a href='billeder/pix_".$image[13]."/index.php'>".$image[13]."</a></td>";
    print "<td><a href='billeder/pix_".$image[14]."/index.php'>".$image[14]."</a></td>";
    print "<td><a href='billeder/pix_".$image[15]."/index.php'>".$image[15]."</a></td>";
    print "<td><a href='billeder/pix_".$image[16]."/index.php'>".$image[16]."</a></td>";
    print "<td><a href='billeder/pix_".$image[17]."/index.php'>".$image[17]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[18]."/index.php'>".$image[18]."</a></td>";
    print "<td><a href='billeder/pix_".$image[19]."/index.php'>".$image[19]."</a></td>";
    print "<td><a href='billeder/pix_".$image[20]."/index.php'>".$image[20]."</a></td>";
    print "<td><a href='billeder/pix_".$image[21]."/index.php'>".$image[21]."</a></td>";
    print "<td><a href='billeder/pix_".$image[22]."/index.php'>".$image[22]."</a></td>";
    print "<td><a href='billeder/pix_".$image[23]."/index.php'>".$image[23]."</a></td>";
    print "<td><a href='billeder/pix_".$image[24]."/index.php'>".$image[24]."</a></td>";
    print "<td><a href='billeder/pix_".$image[25]."/index.php'>".$image[25]."</a></td>";
    print "<td><a href='billeder/pix_".$image[26]."/index.php'>".$image[26]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[27]."/index.php'>".$image[27]."</a></td>";
    print "<td><a href='billeder/pix_".$image[28]."/index.php'>".$image[28]."</a></td>";
    print "<td><a href='billeder/pix_".$image[29]."/index.php'>".$image[29]."</a></td>";
    print "<td><a href='billeder/pix_".$image[30]."/index.php'>".$image[30]."</a></td>";
    print "<td><a href='billeder/pix_".$image[31]."/index.php'>".$image[31]."</a></td>";
    print "<td><a href='billeder/pix_".$image[32]."/index.php'>".$image[32]."</a></td>";
    print "<td><a href='billeder/pix_".$image[33]."/index.php'>".$image[33]."</a></td>";
    print "<td><a href='billeder/pix_".$image[34]."/index.php'>".$image[34]."</a></td>";
    print "<td><a href='billeder/pix_".$image[35]."/index.php'>".$image[35]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[36]."/index.php'>".$image[36]."</a></td>";
    print "<td><a href='billeder/pix_".$image[37]."/index.php'>".$image[37]."</a></td>";
    print "<td><a href='billeder/pix_".$image[38]."/index.php'>".$image[38]."</a></td>";
    print "<td><a href='billeder/pix_".$image[39]."/index.php'>".$image[39]."</a></td>";
    print "<td><a href='billeder/pix_".$image[40]."/index.php'>".$image[40]."</a></td>";
    print "<td><a href='billeder/pix_".$image[41]."/index.php'>".$image[41]."</a></td>";
    print "<td><a href='billeder/pix_".$image[42]."/index.php'>".$image[42]."</a></td>";
    print "<td><a href='billeder/pix_".$image[43]."/index.php'>".$image[43]."</a></td>";
    print "<td><a href='billeder/pix_".$image[44]."/index.php'>".$image[44]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[45]."/index.php'>".$image[45]."</a></td>";
    print "<td><a href='billeder/pix_".$image[46]."/index.php'>".$image[46]."</a></td>";
    print "<td><a href='billeder/pix_".$image[47]."/index.php'>".$image[47]."</a></td>";
    print "<td><a href='billeder/pix_".$image[48]."/index.php'>".$image[48]."</a></td>";
    print "<td><a href='billeder/pix_".$image[49]."/index.php'>".$image[49]."</a></td>";
    print "<td><a href='billeder/pix_".$image[50]."/index.php'>".$image[50]."</a></td>";
    print "<td><a href='billeder/pix_".$image[51]."/index.php'>".$image[51]."</a></td>";
    print "<td><a href='billeder/pix_".$image[52]."/index.php'>".$image[52]."</a></td>";
    print "<td><a href='billeder/pix_".$image[53]."/index.php'>".$image[53]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[54]."/index.php'>".$image[54]."</a></td>";
    print "<td><a href='billeder/pix_".$image[55]."/index.php'>".$image[55]."</a></td>";
    print "<td><a href='billeder/pix_".$image[56]."/index.php'>".$image[56]."</a></td>";
    print "<td><a href='billeder/pix_".$image[57]."/index.php'>".$image[57]."</a></td>";
    print "<td><a href='billeder/pix_".$image[58]."/index.php'>".$image[58]."</a></td>";
    print "<td><a href='billeder/pix_".$image[59]."/index.php'>".$image[59]."</a></td>";
    print "<td><a href='billeder/pix_".$image[60]."/index.php'>".$image[60]."</a></td>";
    print "<td><a href='billeder/pix_".$image[61]."/index.php'>".$image[61]."</a></td>";
    print "<td><a href='billeder/pix_".$image[62]."/index.php'>".$image[62]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[63]."/index.php'>".$image[63]."</a></td>";
    print "<td><a href='billeder/pix_".$image[64]."/index.php'>".$image[64]."</a></td>";
    print "<td><a href='billeder/pix_".$image[65]."/index.php'>".$image[65]."</a></td>";
    print "<td><a href='billeder/pix_".$image[66]."/index.php'>".$image[66]."</a></td>";
    print "<td><a href='billeder/pix_".$image[67]."/index.php'>".$image[67]."</a></td>";
    print "<td><a href='billeder/pix_".$image[68]."/index.php'>".$image[68]."</a></td>";
    print "<td><a href='billeder/pix_".$image[69]."/index.php'>".$image[69]."</a></td>";
    print "<td><a href='billeder/pix_".$image[70]."/index.php'>".$image[70]."</a></td>";
    print "<td><a href='billeder/pix_".$image[71]."/index.php'>".$image[71]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[72]."/index.php'>".$image[72]."</a></td>";
    print "<td><a href='billeder/pix_".$image[73]."/index.php'>".$image[73]."</a></td>";
    print "<td><a href='billeder/pix_".$image[74]."/index.php'>".$image[74]."</a></td>";
    print "<td><a href='billeder/pix_".$image[75]."/index.php'>".$image[75]."</a></td>";
    print "<td><a href='billeder/pix_".$image[76]."/index.php'>".$image[76]."</a></td>";
    print "<td><a href='billeder/pix_".$image[77]."/index.php'>".$image[77]."</a></td>";
    print "<td><a href='billeder/pix_".$image[78]."/index.php'>".$image[78]."</a></td>";
    print "<td><a href='billeder/pix_".$image[79]."/index.php'>".$image[79]."</a></td>";
    print "<td><a href='billeder/pix_".$image[80]."/index.php'>".$image[80]."</a></td>";
    print "</tr>";
}
print "</table>";

    echo "<hr>";

    $offset = (isset($_GET['offset']) && is_numeric($_GET['offset'])) ? $_GET['offset'] : 0;

    $antal = mysql_result(mysql_query("SELECT COUNT(*) FROM forum"),0);
    if ($offset >= $range) { $forrige = $offset-$range; echo "<a href='?offset=$forrige'>Forrige</a> | "; }
    else { echo 'Forrige | '; }
    if ($antal > $offset+$range) { $naeste = $offset+$range; echo "<a href='?offset=$naeste'>Næste</a>"; }
    else { echo 'Næste '; }
?>

selve scriptet virker men der kommer intet text
den finder de data der skal bruges men der kommer intet frem i tabelen

Hvilken tekst er det som ikke bliver vist?

næste og forrige teksten eller?

<a href='billeder/pix_".$image[80]."/index.php'>".$image[80]."</a>
$image[x] vises ikke

Prøv med:

<?php
$images = $row["Billeder"];
$image = explode(" ", $images);

//DENNE SKAL IND FØR DIN QUERY

    $range = 20; // Antal resultater pr. side
    $offset = isset($_GET['offset']) ? $_GET['offset'] : 0;

// !!! QUERY !!! Denne skal sættes ind bagerst i query'en LIMIT $offset, $range


print "<table border=1 align='center'>";
while ($row = mysql_fetch_array($galleri))
{
    print "<tr>";
    print "<td><a href='billeder/pix_".$image[0]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[1]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[2]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[3]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[4]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[5]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[6]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[7]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[8]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[9]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[10]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[11]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[12]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[13]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[14]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[15]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[16]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[17]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[18]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[19]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[20]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[21]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[22]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[23]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[24]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[25]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[26]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[27]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[28]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[29]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[30]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[31]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[32]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[33]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[34]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[35]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[36]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[37]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[38]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[39]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[40]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[41]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[42]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[43]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[44]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[45]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[46]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[47]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[48]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[49]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[50]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[51]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[52]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[53]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[54]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[55]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[56]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[57]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[58]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[59]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[60]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[61]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[62]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[63]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[64]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[65]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[66]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[67]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[68]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[69]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[70]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[71]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";

    print "<tr>";
    print "<td><a href='billeder/pix_".$image[72]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[73]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[74]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[75]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[76]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[77]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[78]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[79]."/index.php'>".$row["Billeder"]."</a></td>";
    print "<td><a href='billeder/pix_".$image[80]."/index.php'>".$row["Billeder"]."</a></td>";
    print "</tr>";
}
print "</table>";

    echo "<hr>";

    $offset = (isset($_GET['offset']) && is_numeric($_GET['offset'])) ? $_GET['offset'] : 0;

    $antal = mysql_result(mysql_query("SELECT COUNT(*) FROM forum"),0);
    if ($offset >= $range) { $forrige = $offset-$range; echo "<a href='?offset=$forrige'>Forrige</a> | "; }
    else { echo 'Forrige | '; }
    if ($antal > $offset+$range) { $naeste = $offset+$range; echo "<a href='?offset=$naeste'>Næste</a>"; }
    else { echo 'Næste '; }
?>

så kommer der text men linket virker ikke for den skriver kun /pix_/index.php den mangler selve pix_2133

jeg har et asp script der gør det men igen det kan jeg ikke lave om til php men måske kan du :

<html><head>
<title>Paging af et recordset</title>
<meta name="Generator" content="Stone's WebWriter 4" />
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
</head><body>
<div style="text-align:center">
<%
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
  intPage = 1
End If

Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:\web\blueeye.dk_p7e8vv\db\links.mdb"
conn.Open strDSN
strSQL = "SELECT * FROM link"

rs.Open strSQL, Conn, 1
If Not (rs.BOF Or rs.EOF) Then
  rs.PageSize = 100  'Antal billeder pr. side
  rs.AbsolutePage = intPage
  intRecCount = rs.PageSize
  intPageCount = rs.PageCount

  antalPrRow = 5 'antal billeder pr række
  noPrRow=0 'tælle variable

  Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>"
  response.Write "<table>"
  Do While Not rs.EOF And intRecCount > 0
    if noPrRow=0 then Response.Write "<tr>"

    Response.Write "<td><a href='" & rs("Links") & "' target='display'>" & rs("ID") & "</a></td>"

    noPrRow=noPrRow+1
    if noPrRow=antalPrRow then
      response.write "</tr>"
      noPrRow=0
    end if
    intRecCount = intRecCount - 1
    rs.MoveNext
  Loop
  if noPrRow>0 then response.write "</tr>"
  response.write "</table>"
End If
rs.Close
Set rs = Nothing
Conn.Close
Set Conn=nothing

Response.Write "<p>Gå til side "
For intNum = 1 To intPageCount
  Response.Write "<a href=?page=" & intNum & ">" & intNum & "</a> "
Next

Response.Write "<p>"
If Clng(intPage) > 1 Then
  Response.Write "<a href=?page=" & intPage - 1 & ">&lt;&lt;</a>"
Else
  Response.Write "&lt;&lt;"
End If

Response.Write "&nbsp;"

If Clng(intPage) < Clng(intPageCount) Then
  Response.Write "<a href=?page=" & intPage + 1 & ">&gt;&gt;</a> "
Else
  Response.Write "&gt;&gt;"
End If

Nope desværre, det skal stilles i asp forummet :-)

jeg kan ikke få det php scrip til at skrive det det skal (glem jeg asp spørgsmålet)

fandt selv løsningen eller noget af den så jeg kikker vider men tak for hjælpen
du får da lidt for det

delløsnigen var :

$count = 0;
while ($row = mysql_fetch_array($galleri))
{
    print "<td><a href='billeder/pix_".$row["Billeder"]."/index.php'>".$row["Billeder"]."</a></td>";
   
    if ($count == 20)
        print "</tr><tr>";
    else
        ;
   
    if ($count == 20)
        $count = 0;
    else
        $count=($count + 1);   
    }
print "</tr></table>";