Help and advice needed for code and desing

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

http://dev.mysql.com/doc/mysql/en/group ... fiers.html says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
row['date'])
{
// this is the total
}
else
{
// not the total
}
}
e use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
rs.html[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // thisql.com/doc/mysql/en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_nsql.com/doc/mysql/en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
 ith PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
else
{
// not the total
}
}
l[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
is the total
}
else
{
// not the total
}
}
w.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc( do it in the query..

With PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
sql.com/doc/mysql/en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
ysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
sql.com/doc/mysql/en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row&#111h PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the sql.com/doc/mysql/en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($rowї'dp.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
tch_assoc($rs))
{
if (is_null($row['date'])
{
// this is the total
}
else
{
// not the total
}
}
ml[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
);

while ($row = mysql_fetch_assoc($rs))
{
ifodifiers.html[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  iy-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
sql.com/doc/mysql/en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
...);

while ($row = mysql_fetch_assoc($rs))
{
if (is_null($row['date'])
{
// this is the total
}
else
{
// not the total
}
}
f (is_null($row['date'])
{
// this is the total
}
else
{
// not the total
}
}
assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
difiers.html[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($rowї'datesql.com/doc/mysql/en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use [url]http://www.php.net/mysql_fetch_assoc[/url].

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
sql.com/doc/mysql/en/group-by-modifiers.html[/url] says you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
s you can't do it in the query..

With PHP you can for example use http://www.php.net/mysql_fetch_assoc.

Code: Select all

$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
$rs = mysql_query(...);

while ($row = mysql_fetch_assoc($rs))
{
  if (is_null($row['date'])
  {
    // this is the total
  }
  else
  {
    // not the total
  }
}
Post Reply