Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
50% Quality Score
Upvotes Received
1
Posts with Upvotes
1
Upvoting Members
1
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
1 Commented Post
0 Endorsements
~8K People Reached
Interests
IT, literature, sports, movies, music
PC Specs
Intel Corei5-430m, 8GB, 1TB
Favorite Forums
Favorite Tags
php x 26
mysql x 25
query x 18
row x 15
bind x 15
Member Avatar for ashalatha

How to delete Data from multiple tables. For example Iam having category id in one data base table .in another data base table iam having this id if i delete category id it should display a message as first delete in that table if the id is there in that …

Member Avatar for Isaac_4
0
520
Member Avatar for berserk

I need help trying to get my mysqli_query() function to work right. I have this so far: $raw_results = mysqli_query($con, "SELECT * FROM numdata WHERE numb='%".$k."%' UNION SELECT * FROM numdata2 WHERE numb='%".$k."%' UNION SELECT * FROM numdata3 WHERE numb='%".$k."%' UNION SELECT * FROM numdata4 WHERE numb='%".$k."%' UNION SELECT * …

Member Avatar for diafol
0
271
Member Avatar for mutahirpirzada

hp $mysql_hostname = "localhost"; $mysql_user = "root"; $mysql_password = ""; $mysql_database = "farm_house"; $prefix = ""; $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database"); mysql_select_db($mysql_database, $bd) or die("Could not select database"); $myysql= "SELECT customerinformation.CustomerFullName, customerinformation.CustomerID, customerinformation.Housenumber, customerinformation.Sector, customerinformation.StreetNumber, customerconsumption.MilkDelieveredCow, milkrate.CowMilkRate, (customerconsumption.MilkDelieveredCow*milkrate.CowMilkRate) AS t_amount_cow, customerconsumption.MilkDeliveredBuffalow, milkrate.BuffaloMilkRate, (customerconsumption.MilkDeliveredBuffalow*milkrate.BuffaloMilkRate) AS t_amount_buff, …

Member Avatar for Bin_2
0
5K
Member Avatar for Bin_2

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 …

Member Avatar for Bin_2
0
2K
Member Avatar for Bin_2

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 …

Member Avatar for urtrivedi
0
223
Member Avatar for Bin_2

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 …

Member Avatar for Bin_2
0
117
Member Avatar for Bin_2

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 | …

Member Avatar for Bin_2
0
327