[msql database php help]

Thank you for your help I have rewrote my connect to database script using mysqli now just for the rest. I must sound so thick right now

[msql database php help]

so am I right in thinking instead of using mysqli_fetch I should use mysql_store_results?

[How to handle sessions in sign up registration page in PHP using mysql ?]

What exactly do you need help with, your question is rather vague

[Hello from a lover of php]

Well where to begin; my name is Christina I live in the north east of england and as you may tell from the title I love php, however do need a little bit of help from time to time, which is why I am here

 

I am currently in the process of creating my portfolio in the hope I find a job as a php developer, which once completed I will post a link to it so I can get everyones opinions on it.

 

I think thats it.

[msql database php help]

I am trying to display items from my database that occur after the current date but within the next 28 days. I have wrote my script and the part that retrieves the information from the database works in phpmyadmin however when I load the page in the browser nothing below my php script is showing up on the page, where have I gone wrong?

<?php
//connect to the database
include 'php/database_connection.php';
//retrieve all the information for the events within 28 days of the current date from the database
$dateSQL = "SELECT eventID, eventTitle, eventDescription, eventStartDate, eventEndDate
	FROM te_events
	WHERE eventStartDate > CURRENT_DATE AND eventStartDate < CURRENT_DATE + INTERVAL 28 DAY
	ORDER BY eventStartDate";
//execute the query and store the results
$queryDate = mysqli_query($dateSQL)
	or die(mysqli_error());
									
//loop through database and store in variables
while ($row = mysqli_fetch_array($queryDate)) {
	$eID = $row['eventID'];
	$start = $row['eventStartDate'];
	$end = $row['eventEndDate'];
	$title = $row['eventTitle'];
	$desc = $row['eventDescription'];
	//echo events within the 4 week timeframe
		echo "<div class=\"date\">$start - $end</div> ";
		echo "<div class=\"title\"><a href=\"full_details.php?eventID=$eID\"></a></div> ";
		echo "<div class=\"desc\">$desc</div>\n ";
}
?>