Welcome Guest, Not a member yet? Register   Sign In
CI jQUERY ajax POST data
#3

[eluser]joeizang[/eluser]
SELECT `articletitle`, `articlebody`, `articleauthor` FROM (`articles`) WHERE `articletitle` = 0

Thanks jdfwarrior. I did and this is the resultant query. I presume the problem is the articletitle=0. but how do you make the articletitle to be text and not a number then. I thought doing this (from my model) was right?

<?php

function displayby_name($name)
{
$this->db->select("articletitle,articlebody,articleauthor");
$this->db->from('articles');
$this->db->where('articletitle',$name);
$Q = $this->db->get();

if($Q->num_rows() > 0){
$text = $Q->result_array();
}
return $text;
}

?>

or is there another way?

Thanks for the help.


Messages In This Thread
CI jQUERY ajax POST data - by El Forum - 10-07-2009, 04:13 PM
CI jQUERY ajax POST data - by El Forum - 10-07-2009, 04:27 PM
CI jQUERY ajax POST data - by El Forum - 10-07-2009, 05:08 PM
CI jQUERY ajax POST data - by El Forum - 10-07-2009, 05:26 PM
CI jQUERY ajax POST data - by El Forum - 10-07-2009, 05:43 PM
CI jQUERY ajax POST data - by El Forum - 10-07-2009, 05:45 PM



Theme © iAndrew 2016 - Forum software by © MyBB