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...
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...
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...
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...
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?
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...
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...
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...
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...
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'...
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...
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...
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...
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/
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...
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/
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...
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...
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...
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.