need help with mysql query ... - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

pepe_lepew1962 · 04-30-2010, 02:39 PM

Hello:

I am trying to get a mysql query together an not quite sure how to apply it, whether it is with distinct, join and all. What I am looking is to get the ID, qty ( number of users ), max and min number. Can anyone help me with this please.

Name ID Name
123ABC Engine
649DFA Transmission
854UDF Window

User ID User Name User Amount
123ABC Paul 300
123ABC John 190
649DFA Ian 500
123ABC Mary 210
123ABC Mark 225
649DFA Steve 360

Required Result:

ID Qty Max Mix
123ABC 4 300 190
649DFA 2 500 360

osho · 06-11-2010, 08:37 AM

dear use google for and search it

janeparker · 06-19-2010, 02:44 AM

yes u can find in google just give a time to search

alibills · 06-20-2010, 08:23 PM

google rocks man

rafealjales · 06-28-2010, 09:58 AM

ya go for google..

manzar · 08-04-2010, 01:03 AM

Try Google, search on +mysql +blob +php (assuming you are using PHP).
if you use asp than Google search to +asp

jalicia18 · 01-24-2011, 12:22 AM

try to use php mysql aliases and group by.

Try this simple scripting to display ID, qty ( number of users ), max and min number

Quote:

echo "ID QTY Max Min";
$query = mysql_query("SELECT ID, qty, maximum, minimum FROM tablename");
while($row = mysql_fetch_array($query))
{
echo $row['ID'] . " " . $row['qty'] . " " . $row['maximum'] . " " . $row['minimum'] . "<br/>";
}