Search found 8 matches

by chelflores
Fri Jul 24, 2009 1:12 am
Forum: Databases
Topic: Problem: Counting Rows
Replies: 2
Views: 327

Re: Problem: Counting Rows

I just solve my problem a while ago. But thanks anyway :)


This is the query:

SELECT COUNT(*), fmnum FROM db_profile GROUP BY fmnum HAVING COUNT(*) = 3
by chelflores
Wed Jul 22, 2009 8:14 am
Forum: Databases
Topic: Problem: Counting Rows
Replies: 2
Views: 327

Problem: Counting Rows

this is my table:

profile(id,name,fnum)

example in the fmnum field their are 3 rows with the same values.

now i just want to count how many 3 rows with the same values in that table..

can u help me on this...thank you..
by chelflores
Thu May 28, 2009 1:13 am
Forum: PHP - Code
Topic: calculate person's birthdate using age
Replies: 1
Views: 102

calculate person's birthdate using age

is it possible to compute the birthdate of person using age??
can anyone help me on this..thanks....
by chelflores
Sun Aug 31, 2008 4:25 am
Forum: Databases
Topic: compare date range
Replies: 1
Views: 294

compare date range

Hi, I'm having a small problem with a hotel booking script i'm writing, here gos The hotels have a number of different rooms and can be reserved, and i need to calculate the availability date range of a room, eg. 31/08/08 - 10/09/08 The date where the guest want to reserve and the room is reserved i...
by chelflores
Thu Aug 21, 2008 11:29 pm
Forum: Databases
Topic: Stored Procedure Insert Problem
Replies: 0
Views: 303

Stored Procedure Insert Problem

My stored procedure doesnt insert new record, when i try the query only, it works

CREATE PROCEDURE insertguest(in_gname VARCHAR(30))
BEGIN
DECLARE gid INT;
SELECT MAX(GuestID) as id FROM guest;
SET gid = id;
SET gid = gid + 1;
INSERT INTO guest(GuestID,Gname) VALUES(gid,in_gname);

END
by chelflores
Mon Jul 07, 2008 6:06 am
Forum: PHP - Code
Topic: My shopping cart
Replies: 4
Views: 312

My shopping cart

can u help me in my shopping cart to fix it and make remove item cart.php <?php session_start(); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Hardwarez - Online Hardware Store</title> <meta http-equiv="Content-Type" content="text/ht...
by chelflores
Thu Jul 03, 2008 10:43 pm
Forum: PHP - Code
Topic: Simple Shopping Cart
Replies: 4
Views: 4623

Simple Shopping Cart

can u help in making a cart without database
by chelflores
Tue Jun 24, 2008 7:03 pm
Forum: PHP - Code
Topic: Inventory system database
Replies: 2
Views: 630

Inventory system database

can u help me on making a inventory database for a motor dealer???