The thing is i need the ID to pull out the correct workbook. I suppose i could work arround it by running a query to select IF FROM table WHERE filename = 'filenamevalue'
was just hopinf for somthing all in 1 but will give this a blast.
EDIT: Actually that wont work as when using DISTINCT and putting workbook as a field it select distinct workbook too! which means i cant have multiple workbooks returned where there are...
ukchat
Last Activity: Mar 19 '08, 03:54 PM
Joined: Sep 12 '06
Location:
-
yes----ish.. or a less there is a different filename for the workbook.
Trust me i can understand your difficulty in understanding this as i've had to go through the same process for over 200 workbooks.
the structure is totaly unlogical but unfortunatly i'm not the one that writes the workbooks, so i've had to just put up with it get it in database and now im trying to do this which i thought would be simple as im sure...Leave a comment:
-
No that is a seperate part what im doing is listing the unique filenames referenced by workbook number.
see attached picture
but this show 1 1 which i dont want it to as this is the same filename. How ever i cant list by distinct workbook as there are multiple files to each workbook in parts.
I need to select data where filename is unique. That's the extent of my situation.
...Leave a comment:
-
All i want is a distinct filename and that will leave me with the records i need. of corse ID is different else it couldnt be a Primary Key. The ID is only their so i can pass it to a PHP script to download the correct file without passing the location of the file through GET or POST (all testing of SQL is being done direct in SQL Studio)
Do you understand what im after?
Regards
Liam...Leave a comment:
-
Hi thanks but it's still not working i have posted returned data here: http://www.bksb.co.uk/bksb/data/query3.php
Qorkbook 1 is listed twice yet has the same filename.
regards
Liam...Leave a comment:
-
that wont let me select any extra fields e.g. ID and curric which i'll be needing to do.
So all in all i need a query that will select every field with a distinct filename.
when i added extra fields to your query i got this error.
Regards
Liam...Leave a comment:
-
ID has been added as i have no other unique identifier.
This is why im wanting the distinct on filename as there could be multiple curriculum references to each file.
So all in all i need to do is select by distinct filename and i can sort out the rest.
regards
Liam...Leave a comment:
-
Table data (narrowed down to only 1 assessment)
http://www.bksb.co.uk/bksb/data/tabledata.php
Query 1
http://www.bksb.co.uk/bksb/data/query1.php
Query 2
http://www.bksb.co.uk/bksb/data/query2.php
I have noticed that Microsoft SQL studio automatically take away my brackets from DISTINCT(filena me) Is this normal? As this would select distinct everything which means ID is...Leave a comment:
-
MSSQL DISTINCT multiple fields throws up odd results
I.m creating a dynamic query to pull out workbooks from my database the table structure is below.
Table: curricworkbooks
Columns: ID, curric, assessment, topic, workbook, filename
Example data
...Code:[ID] [curric] [assessment] [topic] [workbook] [filename] 1 N1/E1.1 Numeracy E1 Count 1 workbooks/Num Entry 1/Unit 1/04 N1E1.1-3 Worksheets Num.pdf 10 MSS1/E1.6 Numeracy E1 Capacity 13 workbooks/Num
-
can't edit on this forum.. :@
What you may need to do is instead of dynamicaly creating your form and just creating the checkbox as checkbox[] you may need to use items from a databasde and use checkbox[$id] if you get what i mean then you can see what is and isn't ticked when returned...Leave a comment:
-
well if your pulling in the tick boxes dynamicaly then you can compare when is ticked against your database to work out what isn't ticked.. how come you need to know what isn't ticked?...Leave a comment:
-
not a php issue as PHP is serverside (or a less ur wanting the client to request somthing then your server print off then in which i'm unsure it would be based on command line but if u just want client to start printer try looking at javascript.. somthing like this
function printpage() {
window.print();
}...Leave a comment:
-
you could use
header("Locatio n: address_here");
after a sucessfull add of your dataLeave a comment:
-
Do you have a small example of how this would be done? If not then dont worry i will just have a look when i get home as i virtualy live at work and it's well busy atm.Leave a comment:
-
2 functions on click
Hi there,
I've just started AJAX/PHP and im having an issue trying to get 2 divs to chnage onclick.. I have tryed creating 1 function with a call to 2 functions and using that. i've tryed creating a function and calling the other at the end and many other variations but with no luck!
Has anyone else come across this? and is there a way that will be compatible with IE and firefox?
Regards
Liam
No activity results to display
Leave a comment: