MYSQL query help

[zumadi]

Hello,

Code: Select all

$id="2";


$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('column');
$query->from($db->quoteName('#__table_name'));
$query->where($db->quoteName('id')." = ".$id);
 
$db->setQuery($query);
$db->execute();
$result = $db->getNumRows();

What is wrong here? $id
$query->where($db->quoteName('id')." = ".$id);

Thanks

[sudo-web]

Use this format:

Code: Select all

$query->where($db->quoteName('id')." = ".$db->quote($id));

You find more details and examples in the documentation:
https://docs.joomla.org/Selecting_data_using_JDatabase

[zumadi]

Thank you for the answer,

This is working

Code: Select all

		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$query->select('column_name');
		$query->from($db->quoteName('#__table_name'));
		$query->where($db->quoteName('id')." = ".$db->quote($id));
 
		$db->setQuery($query);
		$db->execute();
		$rr = $db->loadColumn();
  
		foreach ($rr as $sult) {
    		$result = $sult;
		}

I want one result, Why am I getting array?
What is wrong?

[sudo-web]

Because a Query could have more than one result. We both know that the id is unique and you only select one Colum, so it is logic for us the there should be only one result, but sometimes things are different, and you get no result or more than one.