Help With Mysql Query with 2 fields

scottparkin69 · #1 08-Jan-2008, 07:40

Hi All

I'am having problem's how to work out what seems to be a simple Query i writing a simple database to keep track of our vast cartridge collection with set order levels

the 2 field in question are <Qty> and <Order Level> .I'm wanting to display all items that the number in <qty> is equal or lower then <Order Level>

Thanks in advance

NHDriver4 · #2 08-Jan-2008, 10:29

Hi Scott.

Are these two fields in the same table? Provide an example of the database layout, and I could help you better. If they are in the table, then this should work for you:

Code:

SELECT * FROM items WHERE items.qty <= items.orderlevel

The above code returns only the HP cartridge on the following database, because that's the one with quantity being lower than orderlevel:

Code:

id 	name 	qty 	orderlevel
1 	Cannon Xp-1200 	5 	4
2 	HP LJ 1255 	5 	6

scottparkin69 · #3 09-Jan-2008, 01:43

That's great thanks alot works perfectly

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
mysql insert query in php	mrjameer	MySQL / PHP Forum	0	20-Nov-2006 14:23
combining 2 fields in a single mysql select query	mrjameer	MySQL / PHP Forum	1	28-Sep-2006 19:38
Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx	Webhosting-live	Web Hosting Forum	1	01-Sep-2006 02:54
Tricky MySQL query involving multiple primary keys...	TreyAU21	MySQL / PHP Forum	4	18-Apr-2006 09:56

Help With Mysql Query with 2 fields

Re: Help With Mysql Query with 2 fields

Re: Help With Mysql Query with 2 fields