Invalid for each

[darkfreaks]

need some help i can't figure out what i am doing wrong

 

foreach($ct->data as $key => $value){

	$ct->data[$key][3]='<a class="ezjax" href="view_message.php?id='.$ct->data[$key][0].'">'.$ct->data[$key][3].'</a>'; 

}

[The Little Guy]

Run this code, to see how a foreach loop works:

 

$myArray = array("cat"=>"a cat", "dog"=>"a dog");
foreach($myArray as $key => $value){
    echo "Key: $key<br>";
    echo "Valaue: $value<br>";
    echo "<br>";
}

 

It is hard to work with your code, because I have no idea what $ct->data is or what it looks like. My example may help you out though.

[Maq]

Are you sure the variable 'data' from the $ct object is an array?  Show us how it's being generated.

[darkfreaks]

im getting errors in the file which all that is defined about mysql_free result and fetch_row()

$this->total_items=mysql_fetch_row($result);

mysql_free_result($result)

 

i am not sure if this code is the problem or just apart of it

NOT a valid MYSQL resource

[Maq]

That usually means your query failed, which means mysql_query() returned false, which means $result is false, hence your error.

[darkfreaks]

  // total of items
        if($this->total_items<=0){
            if($this->table_key)
                $result=mysql_query(str_replace($bd_fields,'count('.$this->table_key.')',$this->get_sql_select()).$this->get_sql_where(false));
            else
                $result=mysql_query(str_replace($bd_fields,'count('.$this->sql_fields[0].')',$this->get_sql_select()).$this->get_sql_where(false));
            $this->total_items=mysql_fetch_row($result);
            $this->total_items=$this->total_items[0];

            mysql_free_result($result);
        }

 

how would i fix this?

[Maq]

Added some debugging code:

  // total of items
        if($this->total_items            if($this->table_key)
            {
                $sql = "str_replace($bd_fields,'count('.$this->table_key.')',$this->get_sql_select()).$this->get_sql_where(false)";
                echo "IF QUERY: " . $sql;
                $result=mysql_query($sql) or die(mysql_error());
            }
            else
            {
                $sql = "str_replace($bd_fields,'count('.$this->sql_fields[0].')',$this->get_sql_select()).$this->get_sql_where(false)";
                echo "ELSE QUERY: " . $sql;
                $result=mysql_query($sql) or die(mysql_error());
                $this->total_items=mysql_fetch_row($result);
                $this->total_items=$this->total_items[0];
            }

            mysql_free_result($result);
        }

[darkfreaks]

ELSE QUERY: str_replace(id,received_by,date,subject,'count('.Array[0].')',()).(false)You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'str_replace(id,received_by,date,subject,'count('.Array[0].')',()).(false)' at line 1

[Maq]

Oops, sorry take of the double quotes for the query strings.

[darkfreaks]

$result = mysql_query("SELECT * FROM notifications WHERE status=1 AND member_id=$m_id") or die(mysql_error());

 

i rearranged the statement abit still getting same error

 

ithe original way it was told me the error was near 'AND

[Maq]

What type is the status column?

[darkfreaks]

Welcome: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status=1' at line 1

 

 

 

i am assuming this is something wrong with members?

 

 

 

[Maq]

You're changing your query around...

 

First it was:

WHERE status=1

 

Now it's:

AND status=1