Putting Mysql rows into arrays

music_man

I have a table on my database for orders. Among such things as first name and last name there is a date and time row for each order.

What I am trying to do is select the times and dates from all the orders and put them into associative arrays.

I don't know how to corrolate duplicate entries too. So a situation could be:

"There are two orders on the 24/06/2006 and one is at 7.30 and the other at 9.00".

Here is the code I have so far (it just gets the entries):


<?php 
include("inc/conn.php");
$query = "SELECT * FROM orders";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){

echo $row['date'] . "<br />";
echo $row['time'] . "<br />";
echo "<br /><br />";
}


?>

bodzan

//first query to find out each date
$query1 = "SELECT * FROM orders GROUP BY date"; 
$result1 = mysql_query($query1) or die(mysql_error());
while($row1 = mysql_fetch_array($result1)){
     $date = $row1['date'];
     //then for each date find out how many are there orders in your database
     $query2 = "SELECT COUNT(*) FROM orders WHERE date = '$date'"; 
     $result2 = mysql_query($query2) or die(mysql_error());
     $n = mysql_result($result2,0);
     echo $date . " - ";
     echo  $n." times <br />";
     echo "<br /><br />";
}

music_man

Thanks so much!

Do you know how to have it so that it gets the times for each date? I presume you remove the COUNT from the mysql?

bradgrafelman

What do you mean, the times? It looks correct as it is... what is it saying?

music_man

So that it shows all the times that are within that date.

bodzan

$query2 = "SELECT * FROM orders WHERE date = '$date'";
$result2 = mysql_query($query2) or die(mysql_error()); 
if(mysql_num_rows($result2)>0){
     while($row2 = mysql_fetch_assoc($result2)){
          echo $row2['time'].", ";
     }
}

This will show the comma separated list of all the times within a date...

music_man

Cheers! It works a treat. Now I am trying to work this into a javascript...

I have this drop down menu script for the date and I am trying to get it so that:

The script looks up the database and finds all the times for each order. There are 8 time variables. If all the times are taken, then that date gets disabled in the drop down menu, otherwise it shows the available times (by disabling the taken times) in the time menu.

I was thinking I would have to use AJAX to look up the available times - that is, have it so that when they select a date, they can click "Get available times" - as I am not sure about loading all the time variables into the javascript.

Any thoughts?

music_man

Any ideas?