first of all , let me apologize for the top post, second let me apologize for 
not giving more detail.  The main problem is basically "pagination" , i have 
failed to add pagination code to my own code simply because it is not as 
simple as i thought.  Considering i am a begginer in PHP , i must give myself 
some credit for reaching where i am ,  as for code snippet here goes,


[snip]




<html>
<title>IP Addresses</title>
<body>

<?php


  // Get the search variable from URL

  $var = @$_GET['q'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

// check for an empty string and display a message.
if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }




$link = mysql_connect("localhost", "me","me2");
mysql_select_db("ip", $link);
$qry = mysql_query("SELECT * FROM IP_Addresses where free like '%".
$_GET['q']."%'", $link);

?>
<table border="1" width="100%"><tr><?php

if (mysql_num_rows($qry)==0 ) {

print " Oops No records found ";
?>
<br>
<a href="http://localhost/ipsearch2.html";>Back</a>
</br>
<?
exit();
}
if (mysql_num_rows($qry) > 0) {
   for ($i = 0; $i<mysql_num_fields($qry); $i++) {
           echo "<td align=center><strong>" . mysql_field_name($qry, $i) . 
"</td>";
}
}

?>

</tr><?php

if (mysql_num_rows($qry) > 0) {
   for ($j = 0; $j<mysql_num_rows($qry); $j++) {

       ?><tr><?php

       for ($k = 0; $k<mysql_num_fields($qry); $k++) {
           echo "<td align=center>" . mysql_result($qry,$j, $k) . "</td>";
       }

       ?></tr><?php

   }
}

?>
</table>
<br>
<br>
<a href="http://localhost/index.html";>Main Page</a>
<br>
<br>
<a href="http://localhost/ipsearch2.html";>IP Address Search</a></br></br>
</br>
</br>
</body>
</html>


[/snip]


i had posted some time back that i have problems with pagination and got alot 
of help , but the problem is i have never known how to put the code together 
with what i have .. any help is appreciated...


cheers





















On Tuesday 04 January 2005 04:17, Jochem Maas wrote:
> David Ziggy Lubowa wrote:
> > On Tuesday 04 January 2005 10:10, David Ziggy Lubowa wrote:
> >>Hey guys ,
> >>
> >> I was wondering , i have 16 records within a table in my Database , i
> >> have managed to have a form which can add and modify the records. My
> >> only problem is how i can display on a form when i search. Can someone
> >> give me heads up on how i can code this in php, to display the records
> >> in a tabular manner when i search.
>
> how does somebody manage to create a working script to insert/update
> data in a table and not be able to figure out how to output a simple
> HTML table listing the current records?????
> I mean, do you want us to teach you how to write PHP? (My rate is
> 40euros/hour)
>
> --
> Sorry David but your email shows little to no effort on your part to:
>
> a, define you problem succinctly
> b, show context (e.g. code,SQL snippets)
> c, show that you have made a decent effort to work the problem.
>
> given those facts you can consider yourself lucky to recieve any replies
> at all.
>
> ANYWAY... seeing as I'm bitchin' at ya I might as well give you a small
> clue....
>
> the process, roughly speaking is:
>
> 1. do a SQL select query. (e.g. SELECT id,name FROM mytable)
> 2. loop thru the result, for each row output some HTML for a table row
>       e.g.
>
>       echo '
>       <tr>
>               <td><a href="/edit.php?id='.$row['id'].'">edit</td>
>               <td>'.$row['id'].'</td>
>               <td>'.$row['name'].'</td>
>       </tr>'
> 3. don't forget to add begin- and ending TABLE tags.
>
>
> try googling 'display a MYSQL result set with PHP':
> I came up with:
> http://juicystudio.com/tutorial/php/mysql.asp
> (which is pretty funny cos the guy wrote a tutorial on mysql/php on an
> ASP based site!!)
>
> > sorry i meant 16 fields  not records : )
>
> whether you tables has 16 rows or fields seems to me to be completely
> irrelevant.
>
> >>Any help is highly appreciated.
> >>
> >>
> >>cheers
> >>
> >>-Z

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to