flemingmike

thanks

hello, if i have the following, how would i display it? function minutes_round ($hour = "$signintime", $minutes = '5', $format = "H:i") { $seconds = strtotime($hour); $rounded = round($seconds / ($minutes * 60)) * ($minutes * 60); return date($format, $rounded); }

thanks!

so would it be $result4 = mysql_query("SELECT * FROM schedule WHERE status = 1 OR status = 2 AND eid = '$posteid' ORDER BY date, starttime");

hello, the following is pulling all my records. is it written wrong? $result4 = mysql_query("SELECT * FROM schedule WHERE eid = '$posteid' AND status = 1 OR status = 2 ORDER BY date, starttime");

that should work. thanks

can i use a link to drop a record, or do u need to do a form and use a button to post to a page?

thanks

hello, what is the propper way to write this? echo "<td align='center'>" if("$sstatus" == "1") { } else { echo "<td align='center'><a href='edittimesheet.php?id=".$tid."'>Edit</a>"; } "</td>"; thanks

it is done on the <td> for after the rusults from mysql. <td align='center' nowrap>

hello, lets say i want 3 of the following columns to only display on 1 line always, is there a way to do that? <th align='center'>Date</th> <th align='center'>Supplier</th> <th align='center'>Requested By</th> <th align='center'>Address of Job</th> <th align='center'>Job Number</th> <th align='center'>P.O. Number</th> <th align='center'>Description</th> <th align='center'>Amount</th> <th align='center'>Notes</th> <th align='center'></th>

so can i generate an ical file based on info from mysql?

hi, does anyone have a way to take data from mysql and instert it into outlook or blackberry calendar?

You must change the headers $headers = "From: $from \r\n Content-Type: text/html; charset=ISO_8859-1\r\n Content-Transfer_Encoding: 7bit\r\n\r\n";

hi, how would i go about making my links work in the following? $to = "$pemail"; $subject = "Job Scheduled for $pdate1 - $pjobnumber"; $message = "Hi $pname, \r\n You have been scheduled for $pdate1 at $pstart1. \r\n Job Number: $pjobnumber \r\n Customer: $jcustomer \r\n Address: <a href='$jlocation'>$jlocation</a> \r\n Contact: $jcontact \r\n Contact Number: $jcontactphone \r\n Notes: $pnotes ";

here is a bit more code. i think it may be a bigger issue. if("$sstatus" == "1") { $statusout='<form method="POST"> <input type="hidden" name="id" value="<?php echo $sid; ?>"> <input type="hidden" name="eid" value="<?php echo $seid; ?>"> <input type="hidden" name="jobnumber" value="<?php echo $sjobnumber; ?>"> <input type="submit" value="Sign In" name="signin"> </form>'; } elseif("$sstatus" == "2") { $statusout='<form method="POST"> <input type="submit" value="Sign Out" name="signout"> </form>'; } else { } echo "<tr>"; echo "<td align='center'>" . $sdate1 . "</td>"; echo "<td align='center'>" . $sjobnumber . "</td>"; echo "<td align='center'>" . $sstart1 . "</td>"; echo "<td align='center'>" . $jcustomer . "</td>"; echo "<td align='center'><a target='_blank' href='http://mapof.it/" . $jlocation . "'>" . $jaddress . "</a></td>"; echo "<td align='center'>" . $statusout . "</td>"; echo "</tr>";

i need the $sjobnumber to be submitted in the form. as far as ive learned, the form is done with html, thats why i broke back into php. i never broke out of php though, thats why im so confused. is there a way i can do $jobnumber=?> HTML <?php ;

hello, i cant figure this out, i feel like ive tried every variety. any help is appreciated $statusout='<form method="POST"> <input type="hidden" name="id" value="$sid"> <input type="hidden" name="eid" value="$seid"> <input type="hidden" name="jobnumber" value="<?php echo "$sjobnumber"; ?>"> <input type="submit" value="Sign In" name="signin"> </form>';

thx man

hello, here is what i have. i feel like im close. $result4 = mysql_query("SELECT * FROM schedule WHERE eid = '$posteid' AND status = 1 OR 2");

hello, im running my page on a seperate server than my exchange server. how would i set the smtp server in the following: <?php $to = "mike@domain.com"; $subject = "Test mail"; $message = "Hello! This is a simple email message."; $from = "mike@domain.com"; $headers = "From: $from"; mail($to,$subject,$message,$headers); echo "Mail Sent."; ?>

thanks guys. 45min on google and 45 sec on phpfreaks.

hello, im trying to figure out how to have multiple where's. $result3 = mysql_query("SELECT * FROM customer WHERE customer = '$customer'"); sometimes there are 3 customers with the same $customer. can i add to that line WHERE contact = '$contact?';

fyi. ORDER BY customer, phone, contact

hi, is there a way to sort by column a, then by column b?