Search results for query: *

Jose, I'm trying to do the same thing you describe above. Could you possibly show me your entire Javascript with any sensative code removed? I would like to especially see the code on your buttons. Thanks, Scott

Once again, you are the man. Thanks so much for your help.

Something is off with the math. Today's date in my system is 39380 so my starting date needs to be 1900-01-01 (39380/365=107.89). When I use that date to calc $start my result is 13812. If I make the starting year 1903 my result is 38284 which is on the right track. Could it be a data overflow...

Thanks JPADIE I was hoping you would answer this. Since I have to convert the dates both ways could you show me a function that had one parm for conversion type and one for the date? function convertd(1,10-26-2007) returning (39380) function convertd(2,39380) returning (10/26/2007) Thanks...

I have to search a database where all dates are stored in 'hundred year' format (10/27/2007 = 39380). I've looked all over but have not seen a function or any PHP code to do this. Thanks in advance for any help.

I couldn't agree more. I've been in IT for 28 years and it's amazing how the people making the decisions don't know what questions to ask or know if they are being BS'd. My company is currently installing Compudigm/Terradata and no one really knows what we've bought. Thanks again for your help.

Got it. Thanks again. If this is your hobby you must be one hell of a lawyer.

I added it just after my submit button and while it may clear the checked array it didn't redisplay the form so the boxes still appear checked. <input type="submit" name="submit" value="Next" /> <input type="reset" name="reset" value="Reset" />

I was given the following code by the great JPADIE. It loads column names in an array then displays a checkbox and column name on the form for each occurance. I would like to add a 'reset' button that will remove any check in a box and redisplay the column names and empty boxes. As always...

I've spent 2 hours searching for an answer to what seems to be a simple function so I need the help of experts. I have a mySql table of students in a school. I have a page where I list all students (by default) in the school. In the heading, I have a dropdown which allows the user to select a...

The only problem now is when the page calls itself no value is being placed in the URL. Here's the latest code: $where="ssmemberlist.php?where="; - previously defined <td width="43%" align="left" size="15" valign="baseline">for Choir <select size="1" name="selchoir" tabindex="1"...

I have a table containing members of a boy's choir. There are 4 types of claases within the choir. My PHP script lists the members fine. I have a field that I want to use to filter the list by whatever choir type the user selects. I fill the dropdown dynamically from a table of choir types...

Thanks. That's what I'm after. From reading other threads it looks like I should pass all the fields as an array and use something like this in the receiving script: $clause_array=array(); if(($v_dd1)<>'') {$clause_array[] = "field1=$v_dd1";} if(($v_dd2)<>'') {$clause_array[] =...

I didn't explain this very well so let me try again. I have a function where I pass file name, key, description and order by. This gives me a drop down list of the descriptions in the table and it works great. What I don't understand is what the code looks like on my form to show the text...

I have created a function (works fine) that will display a dropdown list of a columns values in a table. I want to create a dynamic sql WHERE clause based on the fields on a form and the values in them. When I place this statement in an empty script the text box works fine...

Everything works beautifully. My next step is to allow data selection from my employee file like fulltime/parttime, departments, etc.. You have given me a great platform to work with and I really appreciate your help.

Beautiful. If I'm not pushing my luck could you demonstrate a button to select/deselect all the checkboxes. If I've taken up too much of your time I understand and thanks again for everything.

The select works great. The script it is in actually opens an excel spreadsheet. Now my users can dynamically run their own SQL into the spreadsheet which is exciting. Best yet, I now understand what it does. I was not able to get the check boxes to go across the screen though. I have pasted...

Great! I need to put the array values in a string to use in my SQL select statement but I'll figure that out. What I meant in question1 was I would like to see the database fields (and the check box)displayed across the page so they didn't take up so much room on the screen. I could probably...

That is brilliant. I'm pretty new at this so could you possibly show me 2 modifications to your code? 1) Can you display the database fields as a table with a few columns per row? 2) What would the form action look like if I want to pass the $validfield array to another script and how does...