question

[Nothadoth]

I am using this to define a variable:

 

$cat = $nav['name'];

 

It works because if i tell it to echo that variable it does return words such as "The Club" which is what I want.

 

 

 

But when I select to select from a database table it doesn't work - i'll use this code (database is already connected to):

 

$querysubnav = mysql_query("SELECT * FROM nav WHERE category='$cat' ORDER BY id ASC");

 

It doesn't give any results when i display the data. However if i change it to category='The Club' it does give the results I want. But I know that the variable $cat contains "The Club" anyway.

 

 

 

Anyone help me? Ive even tried putting category='$nav['name']' and it didn't work.

[hackerkts]

Hmm.. What about

$querysubnav = mysql_query("SELECT * FROM nav WHERE category='".$cat."' ORDER BY id ASC");

[teng84]

echo your query then give us the result

 

echo "SELECT * FROM nav WHERE category='$cat' ORDER BY id ASC";

[Nothadoth]

hackerkts: didn't work

 

teng: how do i echo that :S sorry my mind frazzled at the moment been up all night and im new at this lol

[Nothadoth]

Sorry i think i did it:

 

Came back with "Resource id #6"

 

:S

[hackerkts]

Actually the query on the first thread should works, not sure why it didn't work for you in the first place..