[Phpsig] Issue with web page display of MySQL values

[randall perry]

--=======3E33525=======
Content-Type: text/plain; x-avg-checked=avg-ok-766045B1; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 8bit

At 03:16 PM 9/12/2002 -0400, you wrote:

>More questions:
>
>Why do you have four queries in lines 94 - 112 that are essentially the same?
It was supposed to ease navigation when returning 1 page of info at a time.

>For example, if you changed line 107 to be
>
>$num_rows = mysql_num_rows($show);
>
>you could eliminate an entire query (lines 96, 101, & 106).
>
>Why do all the queries only look at one table, ipaddress?  Are you 
>intending on
>getting information from the other tables site and device?  If so, you 
>have to call
>them, changing this:
>
>SELECT * from ipaddress WHERE $wherez LIKE \"%$search%\"

This is EXACTLY what I was looking for!! Thanks Bill.

>to this
>
>SELECT * from ipaddress, site
>WHERE site_name LIKE \"%$search%\"
>AND ipaddress.siteid=site.siteid

Randall Perry
www.fasnap.com
www.davenport.edu
www.domain-logic.com

--=======3E33525=======
Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-766045B1
Content-Disposition: inline


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.385 / Virus Database: 217 - Release Date: 9/4/2002

--=======3E33525=======--