mysql_query

chrianne29

I would just like to ask if mysq_query has limitations? Every time I use inner join, there is no ouput. By the way, the ouput will be placed in a html table.

dagon

sounds like an issue with your query not the php function to run the query.

chrianne29

dagon;10960667 wrote:
sounds like an issue with your query not the php function to run the query.

ok here is my query:

mysql_query("Select stk_trns_d.ccode, stk_trns_d.rno, stk_trns_d.tcode, stk_trns_d.hdid,rds.hname, stk_trns_d.tdate, stk_trns_d.quantity, stk_trns_d.lot_no, stk_trns_d.dprice from stk_trns_d inner join rds on stk_trns_d.hdid = rds.hdid where stk_trns_d.ccode = '$ccode' and stk_trns_d.tdate like '%$year-$month-%'");

i use 3 variables to get the input from the user. The code and the year and date are inputs from the user.

dagon

echo out the query and run it in something like phpmyadmin, or the mysql command line

chrianne29

dagon;10960676 wrote:
echo out the query and run it in something like phpmyadmin, or the mysql command line

I already ran it and it works but everytime i run it and place it in a html table, the table is outputed but there are no table values.

dagon

then it sounds like how your trying to output it, please post the code you are using

jeremyphphaven

If you run the query and it returns values, but when you put those values in html code it disappears... it sounds like a problem with your HTML code.
Please also show us how you're building that table (code).