|
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  
> category varchar(20) No
> address1 varchar(50) No
> address2 varchar(50) No
> city varchar(25) No
> state char(2) No
> zipcode varchar(5) No  
> 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
Navigation:
[Reply to this message]
|