Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: shamrox
  • Content: Threads
  • Order by date
  1. shamrox

    Animated gif using createfromgif command

    We are using a script to show images by use of @createfromgif, I am wondering if there is a way to also create animated gif's using this same method?
  2. shamrox

    Not sure how to write the query

    Ok, I've got three tables Cust Tbl -------- CustNumber (ID) Name Address City State List Tbl --------- CustNumber (linked to Cust) PubNo Quantity Pub Tbl -------- PubId PubNo (linked to List tbl) Title Now...the final output i need is a mailing list that would give me the name and the...
  3. shamrox

    Multipart Question

    I have a webpage that I'd like to use to create a query on the fly with. I'm using php/mysql, but figure i need to some javascript to make this part happen. 1. I need something to create various number of dropdown boxes, the number would be defined each time by the user. 2. Once those drops...
  4. shamrox

    PHP or Javascript Question?!?!?

    Ok. Not sure where this belongs, so hopefully someone will assist. I have 3 dropdown lists on a webpage. All 3 are populated via php to a mysql database. I'd like to have the 2 drops DISABLED Or even invisible unless a certain item is selected from dropdown #1. How do I do this? Example. If...
  5. shamrox

    PHP or Javascript question?!?

    Ok. Not sure where this belongs, so hopefully someone will assist. I have 3 dropdown lists on a webpage. All 3 are populated via php to a mysql database. I'd like to have the 2 drops DISABLED Or even invisible unless a certain item is selected from dropdown #1. How do I do this? Example. If...
  6. shamrox

    Query output to csv file

    I'm using php/mysql for a website. One page the user can create a query to pull data from the database, but I want it to automatically save the data to a csv file. Is this possible, and how?
  7. shamrox

    php.ini .....read only

    I'm trying to make a change to the php.ini file. Mac OS X installation. I have found the file through Terminal, opened it in text edit and go to save, but it says file is READ-ONLY. How do I change it so I can save the file??? Also, being a newbie to TERMINAL and Mac's...how do I use the FINDER...
  8. shamrox

    Newbie needs Terminal help..

    Ok, first time using Terminal on my Mac OS X. I have installed mySQL and I need to set up the root password. Instructions say to use Terminal and type the command in the bin directory of the MySQL installation. Ok, how do I get to the bin directory after the Terminal window opens?!?! I know...
  9. shamrox

    So simple...field type

    Ok, i know this is a simple one, but can someone tell me what the field type should be set to so that if a user keys .5 into a field it will get saved into the database as .5 and not 0, because that's what is happening now. I had it set to integer, and all of those that where keyed as a decimal...
  10. shamrox

    proper syntax?? HELP

    I keep getting a syntax error. Can you someone tell me what's wrong here. SELECT employee_time.eid, ids_oa.oa_name, employee_time.req_num, employee_time.num_hrs, ids_worktype.worktype, employee_time.`date`, employee_time.num_of_changes, employee_time.comments FROM employee_time WHERE...
  11. shamrox

    syntax for date query

    I am creating a search form that would give a list of records based on a start and end date. What would be the syntax for the query? This is what I thought it might be...but doesn't seem to work. SELECT * FROM employee_time WHERE `date` >= 'starttime' and 'date' <= 'endtime' and eid = 'analyst'...
  12. shamrox

    writing a query

    I have a web page that I want to display alot of info on from several different tables. they will all be linked by various "id's" back to the main table. I'm not really sure how to get it all to display. I assume I need to do LEFT JOINS on the main table, but where do i go from there? I hope...
  13. shamrox

    Date format issue

    I have a standard form on a webpage that has a field for the date. I'm using php/mysql. I want my users to be able to key in the date in the format of MM/DD/YYYY. If they do it now, it gets submitted into the database as YYYY-MM-DD, but the numbers don't get transposed properly so if they had...
  14. shamrox

    date changes format when submitted...HELP

    Got a form in Dreamweaver for date. User needs to be able to key in the date as MM-DD-YYYY, but it gets inserted into the MySQL table as YYYY-MM-DD, but the numbers are all messed up. meaning it doesn't just turn them around... What am I doing wrong? Is there some sort of code i need to use to...
  15. shamrox

    Two submit buttons??

    Is it possible to have a form with 2 submit buttons? One just sends the data via an email script, the other redirects to a page for printing the data entered. www.metrodesignworks.com www.nowthatsodd.com/deadpool/
  16. shamrox

    JOIN needed??

    I'm not to versed with using joins, so I don't know if it's what i need to use here. I have several tables in my db. main table is related to other tables by id. for example, i have a table that lists company names, and a unique id for each company. in the main table, there is a field for the...
  17. shamrox

    What's wrong here?

    Can someone tell me what's wrong with this line of code. It's giving me a parse error of T_CONSTANT_ENCAPSED_STRING $query_rs_username = "SELECT employees.name FROM employees WHERE employees.username = ".$_SESSION['MM_Username']""; www.metrodesignworks.com www.nowthatsodd.com/deadpool/
  18. shamrox

    truncating text

    Ok, I'm blanking here. What is the code that shortens a line of text from a database record if it's to long. example: record is "This is what the text actually is." output to screen would be "This is what..." so I tell it I only want the first 20 characters or so...I know it's simple, I just...
  19. shamrox

    Passing login username into a form field

    I created a login page using DW MX. It connects to a database table to verify the username and password and then redirects to a page inside. That page has a form on it, and one field will be employee name. I'd like to pass the username they just logged in with into that form field so that it...
  20. shamrox

    MySql size limit?

    Does anyone know if there is a record limit to mysql? I've heard it described as a toy database and I'm about to rebuild an application for work, where they have an oracle database right now. Will I run into any limitations as far as the number of records that mysql can handle? thanks...

Part and Inventory Search

Back
Top