[SOLVED] I cant locate the table, help

[newbtophp]

Im going mad!!!!! 

 

I have a table called "site_bans" which contains another table called "ip" how would i do a from?

 

 

Heres what i've been trying (but no luck)

 

$sql="select Rows,ip from site_bans ( ip ) order by Rows";

 

Help! 

[Rommeo]

$sql="select Rows,ip from site_bans ( ip ) order by Rows";

try ;

$sql="select Rows,ip from site_bans order by Rows";

 

what do you expect with " ( ip ) " there ?

 

or do you want to ;

$sql="select Rows,ip from site_bans where ip =$ip order by Rows";

[newbtophp]

( ip ) is...

 

Im trying to select the columns Rows and ip which are located within the ip table which is a subtable of site_bans

 

So when i go to phpmyadmin i have to click site_bans then click a table called ip then it displays 2 columns Rows and ip.

[MatthewJ]

It sounds like site_bans is the name of your database and ip is the name of the table that stores the banned ip's

 

how about

 

"SELECT * FROM ip ORDER BY Rows ASC"