Hello, im having trouble with this code, i have a page where u can reserve driver to do some tasks, i need to implement a new feature that lets the user see what task is the driver scheduled for.

i want to get the type of the task and display it so that the user can see what he is doing at that time right now im trying with this. this driver has 3 reservations for the same day, each with three different task. task1 = dc_run task2 = removal task3 = dressing so when i eco this it only shows dc_run which is from 8am to 11 am. how can i display it the 3 different tasks hes scheduled for? i would the output to be like this
8am - 11am : dc_run. 12pm - 3pm : removal 4pm - 6pm : dressing.
here it only shows the first record and not the other two..

thanks for your help

PHP Code:

$sqltype ="SELECT res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=1 ORDER BY res_startTime";
  $rstype1 = mysql_fetch_array(mysql_query($sqltype));
  
 echo $rstype1['res_startTime'] . " - " . $rstype1['res_endTime'] . " : " . $rstype1['type']; 


http://www.tizag.com/mysqlTutorial/mysqlfetcharray.php

PHP Code:

$sqltype ="SELECT res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=1 ORDER BY res_startTime"; 
$result = mysql_query($sqltype);
     
    while($rstype1 = mysql_fetch_assoc($result)) {
        echo $rstype1['res_startTime'] . " - " . $rstype1['res_endTime'] . " : " . $rstype1['type'];
    } 


Originally Posted by miki86

PHP Code:

$sqltype ="SELECT res_startTime,res_endTime,type FROM reservation WHERE res_date='$actDate' AND res_driver_id=1 ORDER BY res_startTime"; 
$result = mysql_query($sqltype);
     
    while($rstype1 = mysql_fetch_assoc($result)) {
        echo $rstype1['res_startTime'] . " - " . $rstype1['res_endTime'] . " : " . $rstype1['type'];
    } 


THANK YOU SO MUCH!! this works perfect!!!

i tried showing the results as a link so i did this

PHP Code:

while($rstype1 = mysql_fetch_assoc($result)) { 
            echo '<a href="edit_misa.php?resid='.$rstype1['res_id'].'" >'.format_time($rstype1['res_startTime']) . ' - ' . format_time($rstype1['res_endTime']) . ' : ' . $rstype1['type'] . '</a> '; 
            } 


but it doesnt show as a link for the first record only for the last two..

i dont get why this is happening? if it is a loop isnt it supposed to be the same for all of them?

Originally Posted by stivens

i dont get why this is happening? if it is a loop isnt it supposed to be the same for all of them?

Yes.
I don't know what type of data you have stored in your db, but maybe you should try to url encode it:

PHP Code:

while($rstype1 = mysql_fetch_assoc($result)) {  
     echo '<a href="edit_misa.php?resid='.urlencode($rstype1['res_id']).'" >'.format_time($rstype1['res_startTime']) . ' - ' . format_time($rstype1['res_endTime']) . ' : ' . $rstype1['type'] . '</a> ';  
} 


Thanks miki86,

the urlencode didn't work. the type of field is an int(11) auto-increment.. i just dont get why it works for the last two but it doesn't work for the first one..

Try adding a var_dump() to see what is actually returned from the database.

PHP Code:

while ($rstype1 = mysql_fetch_assoc($result)) {
    echo '<pre>';
    var_dump($rstype1);
    echo '</pre>';

    echo '<a href="edit_misa.php?resid='.urlencode($rstype1['res_id']).'" >'.format_time($rstype1['res_startTime']) . ' - ' . format_time($rstype1['res_endTime']) . ' : ' . $rstype1['type'] . '</a> ';   
}