dazase1
Last Activity: Apr 22 '13, 05:14 PM
Joined: Mar 2 '13
Location:
-
Rabbit thank you for your reply. I will try this method out also along with other ways that have been suggested. Thanks -
hi Rabbit,
How would I do this? As this is what I keep getting stuck on. Like what I need is...
while there are 'potential matches' keep looping... I do this using
which would list those matching sellers.Code:while ($rows1 = mysql_fetch_assoc($queryQuantity2)){
Then check.. If the first row == $requestQuantit y then output only the first matching row .. i.e. quantity has been met..
Else...Leave a comment:
-
Fetch rows until quantity has been met
Hi,
I have a SQL Database and I wish to obtain records until the customer's quantity requested has been met. Here is what I mean.
Request Table
here is the SQL query to obtain matches:Code:Product Quantity Price ----------------------- Apple 10.0 5.00
...Code:select c.FName, p.ProductName, s.Description, -
Hi, Luuk
Yes I believe this is what I need to do but that is precisly the problem I dont know how I should go abouts doing this.
Here is an example: Requests table
That table is outputted in PHP...Code:Product Quantity Price ----------------------- Apple 10.0 5.00
here is the potential matches
...Code:Name(seller) | Product | Descp
Leave a comment:
-
Reducing Quantities Request and Seller table
I have a small problem.
I have 4 tables. Customers (holding customer data e.g. id, names, address email, password etc), products table holding product info(product id, name), a requests table where the customer 'Requests' a product i.e. shows intrest (request id, customerID[forignkey], productid[FK] quantity and price they wish to purchase at ) and finally a sellers table where sellers can say (ID, customerid[fk], productid[FK], descrip,...
No activity results to display
Leave a comment: