Php mysql table column name conflict

Question

Running into an issue here caused by something beyond my control. I am running a DB query on a table I did not create, it has a table column named "end". This is screwing up my foreach loop as it only gets the first instance and then stops on that particular variable.

Here is my current code:

$eventDates = array();
  foreach( $events as $event ) :
    $eventDates[ $event->post_id ] = $event->start; 
    $eventEnd[ $event->post_id ] = $event->end; 
    $eventVenue[ $event->post_id ] = $event->venue;     
endforeach;

The $event->end; is the problem. Is there another way I can output that data that won't cause a conflict?

score 2 · Accepted Answer · answered Mar 31 '17 at 09:04

2

Try aliasing the column name in the request otherwise.

select end as thisIsTheEnd ...

answered Mar 31 '17 at 09:04

St3an

726
1
6
21

since i used SELECT * in my query, how do I specify this and still get other columns? – RiotAct Mar 31 '17 at 09:10
i used SELECT post_id, end AS finish and that worked. Thanks! – RiotAct Mar 31 '17 at 09:48

Php mysql table column name conflict

1 Answers1