PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
oops yeh that was it - atleast my data is being displayed again but now I have another problem the date fields appear blank so data isnt being displayed in those fields
the code
$query = "SELECT *, DATE_FORMAT('%d/%m/%y', `dateoflastcontact`)
AS `dateoflastcontact`, DATE_FORMAT('%d/%m/%y', `datecontactagain`)
AS `datecontactagain` FROM `people` ORDER BY `firstname`";
$query = "SELECT * DATE_FORMAT(`dateoflastcontact`, '%d/%m/%y')
AS `dateoflastcontact`, DATE_FORMAT(`datecontactagain`, '%d/%m/%y')
AS `datecontactagain` FROM `people` ORDER BY `firstname`";
$query = "SELECT * DATE_FORMAT(`dateoflastcontact`, '%d/%m/%y')
AS `dateoflastcontact`, DATE_FORMAT(`datecontactagain`, '%d/%m/%y')
AS `datecontactagain` FROM `people` ORDER BY `firstname`";
This works but it doesnt display the date for some reason it isnt displaying the dates
$query = "SELECT *, DATE_FORMAT('%d/%m/%y', `dateoflastcontact`)
AS `dateoflastcontact`, DATE_FORMAT('%d/%m/%y', `datecontactagain`)
AS `datecontactagain` FROM `people` ORDER BY `firstname`";
$query = "SELECT *, DATE_FORMAT(`dateoflastcontact`, '%d/%m/%y')
AS `dateoflastcontact`, DATE_FORMAT(`datecontactagain`, '%d/%m/%y')
AS `datecontactagain` FROM `people` ORDER BY `firstname`";