Jump to content

Katherine

Members
  • Posts

    3
  • Joined

  • Last visited

    Never

Contact Methods

  • Website URL
    http://

Profile Information

  • Gender
    Not Telling

Katherine's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. One way is to use a subquery... Select count(*) as ibf_members_count, (select count(*) from ibf_posts ) as ibf_posts_count From ibf_members
  2. Well you need a GROUP BY somewhere With something like: SELECT cli_id, wpn_id, cli_fname, cli_lname, max(wpn_edit_date) FROM `progress_notes` p, `clients` c GROUP BY cli_id, wpn_id, cli_fname, cli_lname WHERE c.cli_id=p.wpn_cliid ORDER BY wpn_id DESC, cli_lname ASC You need to figure a criteria for deciding which note is the most recent. Here I assume the max(wpn_edit_date) will do the trick. Possibly you need to choose another fields depending on your table structure.
  3. Why don't you simply create a folder outside of the web server root ?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.