hi code green,
thanks for your reply.
yes i too thought that but according to my knowledge of database i am not getting to the solution
before i use to do this with getting individual product_id by looping over product table and passing product_id to other tables and getting required data from that tables based on that product id
but i think this is very in-efficient solution and required too much looping and...
samikhan83
Last Activity: Dec 5 '08, 10:59 PM
Joined: Sep 23 '07
Location:
-
How to retrive data from four tables
i am having a problem in getting data from four tables based on a common field in one query.
1. i have product,open_ba lance,purchase, sales tables and product_id is primary key of product and foreign key in rest of the tables
2. i want to get the sum of the open_balance,pu rchase and sales for a product based on product key to get current quantity in stock
i used Left Join i think i am not writing the query correctly...Last edited by Atli; Dec 6 '08, 08:27 PM. Reason: Fixed the [code] tags and added a couple of new-lines to the query. -
Thanx for ur help guyzz...I REALLY APPRECIATELeave a comment:
-
yaah i will give it a try... i think it should work
thanx for your suggestion....Leave a comment:
-
Thanks For Your Reply....
i to thought of doing that ...... but is there anyway of caching the element and the values and reusing it .....
instead of regenerating all the elements again.... because it very complex form...
where form is for Purchase Invoice Entry of inventory system where user will scan product after product like multiple product with there serial number so
for each product upc...Leave a comment:
-
how to keep created elements in javascript on reload
hi All Experts.... once again i am in some problem.......
i have a form which creates a new textbox elements when a new product is scanned with barcode scanner.
Problem is when i submit the form and check for server side validation if the form have some error according to validation it is going to the form again and all the generated textbox vanishes ... and i am loosing all the entered data and fields.
... -
Tree in mysql
hi...
i am designing the database for an inventory system while designing it forming tree like structure.... so i am unable to implement tree in database so can anyone help with this....
its like category->sub-category->sub-sub-category......
THANX IN ADAVANCE -
i did not used mysqldump i am usingmysql query browser ide schedule back up feature which is in mysql administrator of query browser
i will try what you have suggested ....
thanx alti ..... YOU ARE EVERYWHERE FOR HELP...Leave a comment:
-
hi to all
i came here for clarification that what is best but with three of you giving three different replies it like what i got from googling .......
still confused please little more clarification.. ..
thank you all i really appreciate all your repliesLeave a comment:
-
hi mark
i did not said that that echo is not fine it works fine.... i did not said double quotes does not support concatenation ......
i said using double quotes to it potential ..
i am a newbe and i am here to learn i did some mistake please rectify it i will be pleased..
Thanx......Leave a comment:
-
hi....
1. check that ur get ur desired value from database.
2. there is no use of using concatination operator when u are using echo " " of php... bcoz php interpreter will differentiate wat is variable and text.....
when u are using echo ' ' u have to use it......
3. u will get ur value with4. FIELD_NAME should be ur combo box name......Code:$value = $_POST["FIELD_NAME"];
Leave a comment:
-
hi......
1. U R getting some error ...... for page not found.... if yes write the proper action for form...
2. check weather ur getting all ur required data for ur query...... by echoing or printing the data.....
3. check ur query with the database...
4. using PHP_SELF is better than using form action.....
5. if none of the above then paste ur code.....Leave a comment:
-
hi... which is the best framework for php.....
hi i am planning to use php framework and i google for that but there are some many of them .....
i am unable to decide which one is good.....
so please suggest me which one is best and why ????
WAITING FOR REPLY.... THANX IN ADAVANCE -
How to schedule MySQL backups?
i love mysql.....
i have my applications running on mysql database... everything works fine.....
if i execute the back up manually i am getting the full back up......
i am having the problem with schedule back up...
how i need to configure schedule back feature....i followed all the step given in mysql manual but i am not getting the schedule database back up....
i am trying this for first... -
those one's that i set later on.......Leave a comment:
-
i have a form which is toooo much complex in structure .... basically i am developing an online inventory system for my company where i am using barcode reader... i am using barcode reader to scan product UPC and SNO......
warning !!!!!! its too junckyyy..... i am a beginner .....
[CODE=javascript]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">...Leave a comment:
-
Problem with .focus() in IE
i am using focus() function of javascript it works great in FireFox but does blunder's in IE is there any problem of focus() in IE .... OR some fix OR.. some other method for IE...
Please Reply Fast... URGENT.. -
hi...
this is the product table
[CODE=MYSQL]
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
`p_id` int(10) unsigned NOT NULL auto_increment,
`p_manufacturer ` varchar(60) NOT NULL,
`p_name` varchar(60) NOT NULL,
`p_upc_code` varchar(40) NOT NULL,
`p_model_number ` varchar(40) NOT NULL,
`p_description` varchar(150) NOT NULL,
`p_price_a`...Leave a comment:
-
Foreign key problem
hi...
i am having a problem assigning a foreign to a table....
i have two tables product table which is having two primary key and quantity table which have quant_poduct_up c_code
1. product_id which is of integer type and auto increment
2. product_upc_cod e which is of varchar type with size 40
what i want to do is reference product_upc_cod e of product with the quantity product_upc_cod e... -
thanx Atli
for the information
from now on i will use <?php echo $id?> instead of <?=$id?>...Leave a comment:
No activity results to display
Leave a comment: