Craked it took me a while but done it now i have broken $stime and $ftime in to shour and $smin i can get an accurate display see code below
$id = $newArray['DeliveryId'];
$Supplier = $newArray['Supplier'];
$Lines = $newArray['Num_of_lines'];
$stime = $newArray['Check_Start_Time']...
I am trying to now work out total time but it does not pass the total time in time foramat see code below how do i get the correct time returned??
$sql = "SELECT * FROM delivery WHERE Check_Employee_id ='$_POST[checkemployee]' AND Check_Date = '$date'";
$result = mysql_query($sql,$conn);
while...
Cool thanks for that although i needed to move the counter line so that it would not be one sum behind as shown below $sql = "SELECT * FROM delivery WHERE Check_Employee_id ='$_POST[checkemployee]' AND Check_Date = '$date'";
$result = mysql_query($sql,$conn);
while ($newArray =...
No each delivery has a number of lines i need the total number of lines from each delivery i.e Delivery 1 has 32 lines and delivery 2 has 5 lines need to see the result 37 lines altogether Think that explains it a little clearer thanks for your time though
Please can anyone help
See code below i am wanting to add up the number of lines as it works through the while loop any ideas would be greatly appreciated
$sql = "SELECT * FROM delivery WHERE Check_Employee_id ='$_POST[checkemployee]' AND Check_Date = '$date'";
$result =...
I'm a little stuck trying to insert some data to a record using UPDATE delivery SET ('Locater_ID=$_POST[delnum]', 'Locate_Date=$date'); but will not work for some reason have i got the syntax wrong?
Please help
I had the session.save_handler = "files" where as it should have been
session.save_handler = files
and also with windows you must specify
the session path as c:/path unlike linux etc. see below.
quick and simple really.
session.save_path = c:/tmp
I am trying use sessions yet keep getting the following error messages
Warning: session_start(): open(/tmp\sess_e75dfd4ede5aacd02e44387985af8a44, O_RDWR) failed: No such file or directory (2) in C:\Program Files\Apache Group\Apache2\htdocs\test.php on line 2
Warning: session_start(): Cannot...
Excellent all works great now many thanks for you help you will be mentioned(if you dont mind) as this is college assignment.
many thanks for your help.
Hi Wishdiak
iI am using xp pro sp2, Mysql 1.4 and php 4.3.3
can I use another header in here $db = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("Login Failed");
or is there another way of rediecting back to loginretry.html if the mysql_connect fails.
sorry im a bit of a newbie
See below my code now i can get the redirection to work using the header(location: url)
<?php
$user = addslashes($_POST['username']);
$pass = $_POST['password'];
$dbHost = "localhost";
$dbUser = "$user";
$dbPass = "$pass";
$dbDatabase = "goodsin";
if (empty($user) || empty($pass)) {...
I oresume you are talking about this snipet in the conf file
#
# AddType allows you to add to or override the MIME configuration
# file mime.types for specific file types.
#
AddType application/x-httpd-php .php .phtml .html
AddType application/x-tar .tgz
AddType image/x-icon .ico
this is the...
Basically im using windows xp with no-ip as my dns host which i believe is in directives right but keep getting access denied message everything works for local host including mysql and php.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.