Sql

[sanu]

TALBLE user_auth;
pri

uid | username| password | email | rank | cat_id

87 | sa | 2a13ff5587e1| [e-mail] | user| 6 |

100 |saa | 9e4aedb824 | [e-mail]| mod| 5 |

101| sas | b8242d | [e-mail] | mod | 7 |

table cat

pri
cat_id | cat | cat_des | date|

7 |Opinion | your opinion | 2003-01-13 |
6 | Expression | expression | 2003-01-13 |
5 | Life Style | life style of Kath | 2003-01-13 |
8 | blaH | blah | 2003-01-13 |
9 | test | tesat | 2003-01-13 |

these are my table structure

$query_catlist=mysql_query("Select cat.cat_id,cat.cat,cat.cat_des,user_auth.username,user_auth.rank from cat,user_auth where cat.cat_id=user_auth.cat_id order by cat.cat");
while($row=mysql_fetch_row($query_catlist))

this query returns 3 records(i,e 5,6,7) now my problem is i want to display rest data(i.e 8,9) from table 'cat' which are not in table user_auth can anybody please help me

[nnichols]

You need to use a LEFT JOIN. Try this -

SELECT cat.* FROM cat
LEFT JOIN user_auth
ON user_auth.cat_id=cat.cat_id
WHERE user_auth.cat_id IS NULL

Hope this helps 😉

[sanu]

Thank you ..it worked..