Info not displayed

[Alicia]

Hi,

 

I am trying to join 2 tables and select the info I want but it doesnt seem to work.. can somebody please advise on my code :

 

 $result = @mysql_query("SELECT * FROM profile,vrequest WHERE profile.id=vrequest.by, profile.type = Student AND vrequest.status= Accepted AND vrequest.to=$vID"); 

 

What i want is actually output the information from profile table where it meets the condition that type of students, status and 'to' value as given... all other tables are storing the ID only and the full info is in profile table..

 

Tried this as well but not working too.

$result = @mysql_query("SELECT * FROM profile,vrequest WHERE profile.type = 'Student' AND vrequest.status= 'Accepted' AND vrequest.to='$vID'");

 

Please advise

[Zane]

post your table layout

[Alicia]

vrequest structure

  rid int(10)  No  auto_increment             

  by varchar(5) latin1_swedish_ci  No               

  to varchar(5) latin1_swedish_ci  No                       

  status varchar(5) latin1_swedish_ci  No               

  type varchar(5) latin1_swedish_ci  No               

 

profile

  mid int(5)  No  auto_increment             

  id varchar(5) latin1_swedish_ci  No               

  pro longtext latin1_swedish_ci  No               

  resume mediumtext latin1_swedish_ci  No               

  type varchar(100) latin1_swedish_ci  No               

  date timestamp  ON UPDATE CURRENT_TIMESTAMP No CURRENT_TIMESTAMP               

  info varchar(200) latin1_swedish_ci  No                           

  status varchar(20) latin1_swedish_ci  No Active

 

 

* Type and status for both tables are having different info.. only the vrequest to and by column value which used to store ID needs to refer back to profile table id to get the other information.

 

Thanks

 

[fenway]

Since you're supressing errors, we're not going to get very far.

[Alicia]

what do you mean?

 

there is no error displayed in my page even I used mysql_error()

 

please advise.

[fenway]

The "@" suppresses errors....