Posted by Norman Peelman on 07/25/07 10:27

up2trouble wrote:
> php my admin for gui
>
> ab_person
> Field Type Null Default
> ID int(10) No
> business varchar(50) No  
> firstName varchar(20) No  
> lastName varchar(20) No  
> dob varchar(5) No &nbsp
> category varchar(20) No  
> address1 varchar(50) No  
> address2 varchar(50) No  
> city varchar(25) No  
> state char(2) No
> zipcode varchar(5) No &nbsp
> telephone varchar(10) No  
> cellphone varchar(10) No  
> email1 varchar(75) No  
> email2 varchar(75) No  
> aimid varchar(20) No  
> url varchar(150) No  
> notes mediumtext No
> approved tinyint(1) No 0
>
>
> Indexes:
> Keyname Type Cardinality Field
> PRIMARY PRIMARY 20 ID
>
>
> Space usage:
> Type Usage
> Data 2,176 B
> Index 2,048 B
> Total 4,224 B
> Row Statistics:
> Statements Value
> Format dynamic
> Rows 20
> Row length ø 108
> Row size ø 211 B
> Next Autoindex 27
> Creation Jul 20, 2007 at 11:12 AM
> Last update Jul 20, 2007 at 01:00 PM
>
>

Try your query in phpmyadmin and see what the results are. Also try
just a "SELECT * FROM dir_links" to see what your table actually holds.
And the schema you posted is for $db_table4 (ab_person), not $db_table8
(dir_links) which is where you say your problem is.

Norm

[Back to original message]