how to write this select statement

[june_c21]

i just made an event calendar where user can input their event and store in database.  i am stuck with these select statement where i need to pull the data from the database and show it accoring to the date,month,year in the calendar.

 

$query = "SELECT staff_no, eventdate,event FROM calendars ";
  $result1 = mysql_query($query, $dblink);
  while {
}

[bobinindia]

Loooks like you are using MySQL 5 so:

mysqli_query is what you need:

$query = "SELECT staff_no, eventdate,event FROM calendars ";
  $result1 = mysqli_query($query, $dblink);
  while {
}

[june_c21]

ya, i am using mysql 5

 

$query = "SELECT staff_no, eventdate,event FROM calendars ";
  $result1 = mysqli_query($query, $dblink);
  while {
}

 

i don't know how to write the code in the while loop where it will output the event according to dd,mm,yyyy and link with the calendar i created.

[Jeremysr]

Try this:

 

while ($row = mysqli_fetch_assoc($result1)) {
    ...
}

 

In that while loop you can use $row['staff_no'], $row['eventdate'], and $row['event'] to get those values from the current row in the database you're outputting.

[bobinindia]

$query = "SELECT staff_no, eventdate,event FROM calendars ORDER BY eventdate ";

Add either ASC or DESC after eventdate to get the reverse of what comes from your db.