Bin_2

i would be better if u submit ur table structure here so that suggestion would be more clearer.. u can select row from second table with that id and if number of rows is 'greater than 0' or 'not 0' then u can echo or print the message u wish..

union generally selects equal number of columns. so u cant use `select * from........' unless u have equal numbers of fields on all the tables. so select one by one columns and make all the column aliases same for all the tables... like SELECT t1col1 as one FROM numdata WHERE …

looks like a bit aged question and u might have solved this. if not: two suggestions first: 1) use "mysqli" in stead of "mysql". it is more secured and "improved"(i've read everywhere this suggestion) than mysql. 2) use "html 5". u just need to declare 'doctype' like this - <!DOCTYPE …

hi all! it might look similar to previous question but actually different.. i'm trying to calculate stock value. for this i want to use "average last purchase value" of item. like if closing stock is 14 and purchase detail is like this 2014/2/2 15pc @ 38000 2014/2/15 5pc @ 36000 …

i made union to two mysql tables select cashid, sum(amt) as ramt, NULL AS pamt from receipt where cashid in ('17', '23') GROUP BY cashid union all select cashid, NULL AS ramt, sum(amt) as pamt from payment where cashid in ('17', '23') GROUP BY cashid and now i want to …

i am trying to command mysql to sum until it reaches certain value from my table 'purchase', for each 'sid' starting from the last row, i need sum of 'pqty' until the result equals a value from string (but to try i've given a certain value). let me define with …

hey guys! this is my first post to daniweb. and also i've not been so long on php. i m trying to manage customer transection records but stuck on one place and i need help.. here is my mysql table for transection of customer id-1 => +-----+------+----------+--------+------+-------| | svn | …