#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    12
    Rep Power
    0
    I want to execute a composed request, ie :

    $result = mysql_query("SELECT NomDem FROM reversation WHERE datrep= (SELECT MAX(datrep) FROM Représentation WHERE DatRep<='31-12-99')");

    but PHP doesn't seems to like the second SELECT...

    Any solution ?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    32
    Rep Power
    15
    oh.. hehe i think i answered on the php board.. oops..

    read there first.. =)

    scoobydoo
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    3
    Rep Power
    0
    Joce..

    U can't give (sub-selects) or (sub-queries) in MySql, instead of sub-selects U can use
    Joins . Sub-selects are possible in MySql 3.22.24 version ,yet to be released.


    Vijay

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. MySQL to MS SQL 2000
    By diskord in forum MySQL Help
    Replies: 0
    Last Post: February 6th, 2004, 08:00 PM
  3. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 01:35 PM
  4. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 01:27 AM

IMN logo majestic logo threadwatch logo seochat tools logo