subject:"displaying sql query"

Re: displaying sql query

2010-06-06 Thread ytbryan

I see. Thank you!

On Jun 5, 8:26 pm, Dilip Godhani dilip.godh...@gmail.com wrote:
 its return array and u print array in echo ,,echo cnt display arrayy
 so it is not work.

 On Fri, Jun 4, 2010 at 3:21 PM, Dilip Godhani dilip.godh...@gmail.comwrote:



  try this
  function getResult()
  {

        $result = $this-query(SELECT * FROM `downloads`
  WHERE `index`=123);
        print_r($result);

   }

  On Fri, Jun 4, 2010 at 3:16 PM, Toby Ashley lowpi...@gmail.com wrote:

  You never return $result from the getResult function. You need:

  function getResult()
  {

        $result = $this-query(SELECT * FROM `downloads`
  WHERE `index`=123);
        return $result;

   }

  On Fri, Jun 4, 2010 at 10:40 AM, ytbryan ytbr...@gmail.com wrote:

  Hi all,

  Can someone help me with this.

  I do a query on my database from model.

  function getResult()
  {

                          $result = $this-query(SELECT * FROM `downloads`
  WHERE
  `index`=123);

         }

  I call assign the query result to the view from controller.

  function index(){
                 $this-set('result', $this-MosDownload-getResult());
  }

  I call the variable on the view.

                 h2?php echo $result; ?/h2

  But the result is not displayed. What is wrong ?

  Check out the new CakePHP Questions sitehttp://cakeqs.organd help
  others with their CakePHP related questions.

  You received this message because you are subscribed to the Google Groups
  CakePHP group.
  To post to this group, send email to cake-php@googlegroups.com
  To unsubscribe from this group, send email to
  cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
   more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en

   Check out the new CakePHP Questions sitehttp://cakeqs.organd help
  others with their CakePHP related questions.

  You received this message because you are subscribed to the Google Groups
  CakePHP group.
  To post to this group, send email to cake-php@googlegroups.com
  To unsubscribe from this group, send email to
  cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
   more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en

  --
  Dilip Godhani
  Jr Software Developer, Entourage Solutions
  e-mail: di...@entouragesolutions.com
            dilip.godh...@gmail.com
  Web.:www.entouragesolutions.com
  m. 9913822582

 --
 Dilip Godhani
 Jr Software Developer, Entourage Solutions
 e-mail: di...@entouragesolutions.com
           dilip.godh...@gmail.com
 Web.:www.entouragesolutions.com
 m. 9913822582

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Re: displaying sql query

2010-06-05 Thread ytbryan

THanks guys !

print_r works!

But i wonder why the return function doesn't work.

On Jun 4, 5:51 pm, Dilip Godhani dilip.godh...@gmail.com wrote:
 try this
 function getResult()
 {

       $result = $this-query(SELECT * FROM `downloads` WHERE `index`=123);
       print_r($result);

  }



 On Fri, Jun 4, 2010 at 3:16 PM, Toby Ashley lowpi...@gmail.com wrote:
  You never return $result from the getResult function. You need:

  function getResult()
  {

        $result = $this-query(SELECT * FROM `downloads`
  WHERE `index`=123);
        return $result;

   }

  On Fri, Jun 4, 2010 at 10:40 AM, ytbryan ytbr...@gmail.com wrote:

  Hi all,

  Can someone help me with this.

  I do a query on my database from model.

  function getResult()
  {

                          $result = $this-query(SELECT * FROM `downloads`
  WHERE
  `index`=123);

         }

  I call assign the query result to the view from controller.

  function index(){
                 $this-set('result', $this-MosDownload-getResult());
  }

  I call the variable on the view.

                 h2?php echo $result; ?/h2

  But the result is not displayed. What is wrong ?

  Check out the new CakePHP Questions sitehttp://cakeqs.organd help
  others with their CakePHP related questions.

  You received this message because you are subscribed to the Google Groups
  CakePHP group.
  To post to this group, send email to cake-php@googlegroups.com
  To unsubscribe from this group, send email to
  cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
   more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en

   Check out the new CakePHP Questions sitehttp://cakeqs.organd help
  others with their CakePHP related questions.

  You received this message because you are subscribed to the Google Groups
  CakePHP group.
  To post to this group, send email to cake-php@googlegroups.com
  To unsubscribe from this group, send email to
  cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
   more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en

 --
 Dilip Godhani
 Jr Software Developer, Entourage Solutions
 e-mail: di...@entouragesolutions.com
           dilip.godh...@gmail.com
 Web.:www.entouragesolutions.com
 m. 9913822582

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Re: displaying sql query

2010-06-05 Thread Dilip Godhani

its return array and u print array in echo ,,echo cnt display arrayy
so it is not work.

On Fri, Jun 4, 2010 at 3:21 PM, Dilip Godhani dilip.godh...@gmail.comwrote:

 try this
 function getResult()
 {

   $result = $this-query(SELECT * FROM `downloads`
 WHERE `index`=123);
   print_r($result);

  }


 On Fri, Jun 4, 2010 at 3:16 PM, Toby Ashley lowpi...@gmail.com wrote:

 You never return $result from the getResult function. You need:

 function getResult()
 {

   $result = $this-query(SELECT * FROM `downloads`
 WHERE `index`=123);
   return $result;

  }



 On Fri, Jun 4, 2010 at 10:40 AM, ytbryan ytbr...@gmail.com wrote:

 Hi all,

 Can someone help me with this.

 I do a query on my database from model.

 function getResult()
 {

 $result = $this-query(SELECT * FROM `downloads`
 WHERE
 `index`=123);

}

 I call assign the query result to the view from controller.

 function index(){
$this-set('result', $this-MosDownload-getResult());
 }

 I call the variable on the view.


h2?php echo $result; ?/h2


 But the result is not displayed. What is wrong ?

 Check out the new CakePHP Questions site http://cakeqs.org and help
 others with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
  more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en


  Check out the new CakePHP Questions site http://cakeqs.org and help
 others with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
  more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en




 --
 Dilip Godhani
 Jr Software Developer, Entourage Solutions
 e-mail: di...@entouragesolutions.com
   dilip.godh...@gmail.com
 Web.: www.entouragesolutions.com
 m. 9913822582




-- 
Dilip Godhani
Jr Software Developer, Entourage Solutions
e-mail: di...@entouragesolutions.com
  dilip.godh...@gmail.com
Web.: www.entouragesolutions.com
m. 9913822582

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

displaying sql query

2010-06-04 Thread ytbryan

Hi all,

Can someone help me with this.

I do a query on my database from model.

function getResult()
{

 $result = $this-query(SELECT * FROM `downloads` WHERE
`index`=123);

}

I call assign the query result to the view from controller.

function index(){
$this-set('result', $this-MosDownload-getResult());
}

I call the variable on the view.


h2?php echo $result; ?/h2


But the result is not displayed. What is wrong ?

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Re: displaying sql query

2010-06-04 Thread Toby Ashley

You never return $result from the getResult function. You need:

function getResult()
{

  $result = $this-query(SELECT * FROM `downloads` WHERE `index`=123);
  return $result;

 }



On Fri, Jun 4, 2010 at 10:40 AM, ytbryan ytbr...@gmail.com wrote:

 Hi all,

 Can someone help me with this.

 I do a query on my database from model.

 function getResult()
 {

 $result = $this-query(SELECT * FROM `downloads`
 WHERE
 `index`=123);

}

 I call assign the query result to the view from controller.

 function index(){
$this-set('result', $this-MosDownload-getResult());
 }

 I call the variable on the view.


h2?php echo $result; ?/h2


 But the result is not displayed. What is wrong ?

 Check out the new CakePHP Questions site http://cakeqs.org and help others
 with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
  more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en


Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Re: displaying sql query

2010-06-04 Thread Dilip Godhani

try this
function getResult()
{

  $result = $this-query(SELECT * FROM `downloads` WHERE `index`=123);
  print_r($result);

 }


On Fri, Jun 4, 2010 at 3:16 PM, Toby Ashley lowpi...@gmail.com wrote:

 You never return $result from the getResult function. You need:

 function getResult()
 {

   $result = $this-query(SELECT * FROM `downloads`
 WHERE `index`=123);
   return $result;

  }



 On Fri, Jun 4, 2010 at 10:40 AM, ytbryan ytbr...@gmail.com wrote:

 Hi all,

 Can someone help me with this.

 I do a query on my database from model.

 function getResult()
 {

 $result = $this-query(SELECT * FROM `downloads`
 WHERE
 `index`=123);

}

 I call assign the query result to the view from controller.

 function index(){
$this-set('result', $this-MosDownload-getResult());
 }

 I call the variable on the view.


h2?php echo $result; ?/h2


 But the result is not displayed. What is wrong ?

 Check out the new CakePHP Questions site http://cakeqs.org and help
 others with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
  more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en


  Check out the new CakePHP Questions site http://cakeqs.org and help
 others with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
  more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en




-- 
Dilip Godhani
Jr Software Developer, Entourage Solutions
e-mail: di...@entouragesolutions.com
  dilip.godh...@gmail.com
Web.: www.entouragesolutions.com
m. 9913822582

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Re: displaying sql query

Re: displaying sql query

Re: displaying sql query

displaying sql query

Re: displaying sql query

Re: displaying sql query

6 matches

Site Navigation

Mail list logo

Footer information