Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~3K People Reached
Favorite Tags
Member Avatar for JukesK

i've just given a script to update and maintain by my manager, but its bash and i dont know that much about it.. i currently have a script that looks through .txt files for given serials that then reports to a php webpage. within this script we have around 20 …

Member Avatar for Watael
0
282
Member Avatar for JukesK

firstly I apologise in advance if this has been asked 100 times over.. I've been ambushed by my company i "HAVE" to use an old Mysql 4.1 server something to do with an atiquated system still running that cannot be upgraded for x,y and z reasons. but they want a …

Member Avatar for JukesK
0
202
Member Avatar for JukesK

hope i worded this well enough... :D trouble working out a query Table: weeklyrevenue Week Number||value 25||20 26||40 28||60 Table daily_totals Week Number||quantity 26||10 27||10 28||10 Need week 27 totals to be multiplyed by week 26 revenue not week 28 revenue as the revenue would have been generated by the …

Member Avatar for faroukmuhammad
0
290
Member Avatar for JukesK

how can i show the week number and corresponding dates using the tax year i tried Week(date, 0) but that shows 1-1-2012 as week 0 Eg; qc_data.date holds the date a qc inspection took place. if i want to show that the first full week in April this year (2 …

Member Avatar for pritaeas
0
251
Member Avatar for JukesK

if i have roughly 25 identical tables is it possible to do the following SELECT tm_name, `tablename` as Activity from t1, t2 ,t3 where date = curdate or would it be better to add another column to the table thats hidden from the users and automatically populate with the tablename.

Member Avatar for ndeniche
0
244
Member Avatar for JukesK

Hey got a big issue i need to resolve if i have a table that records two distinct values entered by user.. NC001 OR TE001 Equipment_id | Serial | location -------------------------------- NC001 | if i have a php based form how can i tell it that if a user select …

Member Avatar for smantscheff
0
196
Member Avatar for JukesK

How can i select the latest records from a table for each invidual equipment thats due calibration within 14 Equipment_id | Date_of_last_Calibration | Calibration_Cycle | Calibration_Due_Date test 10/02/2011 Annual 10/02/2012 test 10/02/2010 Annual 10/02/2011 test2 10/10/2011 Annual 10/10/2013 test3 08/02/2010 Annual 08/02/2011 I can select all records for calibration due …

Member Avatar for baig772
0
205
Member Avatar for JukesK

how can i select all records from a table where a future date column is less than 14 days away within a php table. somthing similar to? [CODE]SELECT DISTINCT FROM table WHERE 'Date_Column' <14 days [/CODE] Thanx In Advance KeeF

Member Avatar for JukesK
0
98
Member Avatar for JukesK

bit of a coding dilemma here.. If i have a php page (list.php) that works on its own when browsed to or put in Iframe, why would it not work correctly when the contents are either <?php include("list.php") or the code put directly into the index.php page The iframe version …

Member Avatar for JukesK
0
150
Member Avatar for JukesK

Im using PHPGenerator for mysql to generate some pages at work. Is it possible for me to do a MySQL query like below? Or am i trying something thats impossible?? [code] SELECT training.id, training.Employee_Name, training.Team_Name, training.Date_Requested, training.Course_Information, training.Training_Provided, training.Time_Taken, training.Trainer, training.Critique_Completed, training.Certification, training.Comments, training.file_name, training.file_type, training.file_size, training.Training_Information_Given_Was, training.Training_Course_Structure_Was, training.Training_Instructor_Was, training.Training_Instruction_Aids_Was, …

Member Avatar for smantscheff
0
157
Member Avatar for JukesK

OK sorry if this has already been asked, but i need help with jquery found out a php generator i've been using to develop a website for work actually codes in Jquery... *go figure* i have a data grid that has a column count in the footer of the grid …

0
72
Member Avatar for JukesK

Firstly, Sorry for the long post :) Im currently creating a training database for use within the business (not done many getting used to coding) I used MySQLMaestro to construct the datagrid and have modified it to suit most my needs. however i have one issue that i cant resolve. …

Member Avatar for JukesK
0
268
Member Avatar for JukesK

Im in need of big help... (sorry bout the size of the post :$) Im just getting started in databases and need some magic.... Im running on the server; * Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 * MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $ * …

Member Avatar for d5e5
0
167
Member Avatar for JukesK

Hi, I'm new to coding (anything) and my manager has tasked me with developing a stats page for the IT dept. trouble ticket system (php helpdesk by EXOScripts.com)(MySQL database) I have laid out the table on the page but just need to populate it. the table has the following coloumns …

Member Avatar for PirateTUX
0
113
Member Avatar for JukesK

Hi, okay im new to coding and got thrown in by my manager straight into .php without even looking at basic.. I have included my coding for a standalone webpage that is to be placed onto the IT systems purely to disect the php helpdesk ticket system and display the …

Member Avatar for JukesK
0
164
Member Avatar for JukesK

just to say Hi... maganaged to get myself into first line support without any qualifications.. don't ask me how cus i don't know...lol...

Member Avatar for jbennet
0
44