[Phpsig] Issue with web page display of MySQL values

[Paul VandenBosch]

I tried to take a look but got a parse error on line 107.

randall perry said:
> I was helping a student with a project, and I am near the end of my
> expertise on PHP and MySQL (the class was on neither).  I gave him some
>  code and helped him make the initial site, but now he is looking to
> improve  it, and I am not much help here.
>
> Take a look:
> http://www.domain-logic.com/class/Davenport/cis241/view.php
>
> Device Type and Site should pull up their respective links in this view
> and  not their numbers.
> Here is the database schema:
>
> mysql> show tables;
> +---------------------+
> | Tables_in_ipaddress |
> +---------------------+
> | device              |
> | ipaddress           |
> | site                |
> +---------------------+
>
>
> mysql> describe device;
> +----------+-------------+------+-----+---------+----------------+ |
> Field    | Type        | Null | Key | Default | Extra          |
> +----------+-------------+------+-----+---------+----------------+ |
> devtype  | varchar(15) |      | UNI |         |                | |
> typecode | smallint(6) |      | PRI | NULL    | auto_increment |
> +----------+-------------+------+-----+---------+----------------+ 2
> rows in set (0.00 sec)
>
> mysql> describe ipaddress;
> +----------+-------------+------+-----+---------+-------+
> | Field    | Type        | Null | Key | Default | Extra |
> +----------+-------------+------+-----+---------+-------+
> | ip_add   | varchar(15) |      | PRI | 0.0.0.0 |       |
> | ufname   | varchar(30) | YES  |     | NULL    |       |
> | ulname   | varchar(30) | YES  |     | NULL    |       |
> | devname  | varchar(30) | YES  |     | NULL    |       |
> | typecode | smallint(6) | YES  |     | NULL    |       |
> | siteid   | smallint(6) | YES  |     | NULL    |       |
> | appl     | varchar(35) | YES  |     | NULL    |       |
> +----------+-------------+------+-----+---------+-------+
> 7 rows in set (0.00 sec)
>
> mysql> describe site;
> +-----------+-------------+------+-----+---------+----------------+ |
> Field     | Type        | Null | Key | Default | Extra          |
> +-----------+-------------+------+-----+---------+----------------+ |
> site_name | varchar(40) |      | UNI |         |                | |
> siteid    | smallint(6) |      | PRI | NULL    | auto_increment |
> +-----------+-------------+------+-----+---------+----------------+ 2
> rows in set (0.00 sec)
>
> I also made some links to the source code.  Hey Paul! Take a look and
> maybe  learn something (or maybe you are already past this?)
> Randall Perry
> www.fasnap.com
> www.Davenport.edu


-- 
Paul VandenBosch
Guide to Sailing and Cruising Stories
http://cruisenews.net