TreeView

how can i create a tree View From a mysql table? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

generating numbers from other fields

how can i join three fields Values into one field? so in three select boxes i have date : Projects type 1 - 7 and project type 1 - 6 so the third Filed would be 116200824 generated by the other three fields? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

csv to mysql

hi all : i,m looking for a solution for my PDA that Doesn't have a DB Solution installed on it : so im having to write to CSV Files for my Forms , i'm needing a way that when i sink my PDA with my wireless network it Moves the Entire CSV File into a MySQL database :any Suggestions :? -- M

Confused on Query's

lets say u have a table called Parts and another called Projects ,,, how can u associate the Parts Table with the Projects table so lets say u wanna add a Specific Part to a project maybe even add three parts from the parts table and associate it with a specific project ??? so maybe u would

Betatest Project

i have a Database called Betatest in MySQL i have three tables : Projects ProjBom Inventory i wanna enter into projects the project name and date and later on i wanna be able to add the Projectbom("bill of material

Extensive Project help

hi all i have a pretty extensive Project Going on and it would be nice to get some input on my tables and joins schema, i'd like to send someone my SQL as for them to help me thru the rough spots if they could, or i could post the enitre SQL here for u to use, please someone respond as i woul

Path information into database

so how would i get the Actual file path to the folder into the database, i know ill have to use a file selector in asp / php but i wanna select the folder not the Files, it would be really great if u could help me with these issues, i'm not asking u to Code anything for me , just links of exampl

Path information to a database

i have a question: i have a Projects folder on my D: drive under this folder is folder by the name of the Customer then Subfolders that Corespond to the Project Ex, d:\projects .. Jobs LSRW -- Rsview --RSLogix

leading the technological bandwagon

I recently last week Had and experience with an Very small Company, where as they had around 15 Machines all hooked "Star topology" and a central iis ASP Web server that only showed the date, and a few small utilities when addressed To it, now there entire Operation was based upon Excel, everythin

path Stored in MySQL

Can someone help me with getting a path stored in MySQL, Links ? Snips would be great thanks a lot -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.20/588 - Release Date: 12/15/2006

recursing Folders adding to mysql

Im needing to Rescurse thru a directory listing and ONLY add Directory Names / Path / and Filename, NOT the actual file itself, how can I do this in MySQL, -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.16/582 - Release Da

Summing rows and colums in mysql 5.0 heeelllppp!!

How can I keep a running sum of the values in rows as well as columns in a > mysql database and display them,, > Can someone show examples of this thanks > > > Value1 12 14 34 Sum > -- > Value2 14 23 45 Sum> -- > > Sum > -- -- -- -- No virus

Huge undertaking is overwhelming me,,

HI all , i have a huge Undertaking here at our office, ("intranet / MySQL / php / asp") and i've gotten alot of the Frontend written and 60% of the backend, i,m realy needing A Individual or Individuals to Aid me in Alot of the Table Querys and Procedures, i am going to open a forum on our

Changing engines, MyISAM to InnoDB Heelp

most of my Storage enines is MyISAM i wanna change them all to|InnoDB how do i do this >?thanks | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

1 to many relationships

hey guys ; it's not Customers Per issue it's the other way around "issues per customer" i enter in Customer 1 and then down the road i wanna add a issue associated with that customer, so goto that customer and Click "Add issue" the a form Comes up and i add the issue and Click Add issue, i ne

1 to many relationship

how do i do 1 to many relationship?? i have this SQL syntax " i may need to add many issues per customer" so this is what i have Please help SELECT * FROM mcsdata.customers INNER JOIN mcsdata.issues ON (mcsdata.customers.id = mcsdata.issues.id) WHERE (mcsdata.cus

refrenceing information thru seperate tables

HI all ; i wanna be able to link tables bu either id or Customer , and i also want to have a seperate table for Software information on that Customer, so in one table it would be Customer name : and another table would be products, linked to product id, so when i do a Queru it shows both t

PHP code for Record Table Cell color

My Record Display Code : id Projectid Date Company Location Issue Status Notes class="style1"> class="style1">?> class="style1">$row_issues['Projectid']; ?> class="style1">?> class="style1">$row_issues['Company']; ?> class=

cell colors PHP/MySQL

i'm needing assistance in table Cell color thru MySQL i have a project were im listing a projects in a table either Complete / Active / Pending / now im needing these refrances cells to change Color whenver its lists them out on a page, [Complete] = green[Active] = Blue[Pending] = ye

inner outer joins

hi all Can someone provide a small project using inner and outter joins with querys thanks alot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replication maybe?

hey i have a question ; if i have a MySQL database on our local intranet server, but i wanna be able to replicate that database to our internet site thats also a MySQL database so whenver something changes on our intranet it also changes on our Internet Database,,how do i do this ?

yes or no checkbox

know this is probably a simple question but if im going to setup a yes or no checkbox on a table feild on MySQL thru phpmyadmin, how do i do that ?? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL P

Synro MySQL databases

HI all i have a question, I have A server MySQL database in our office location that stores Contact information / inventory etc... and also we have a Internet Site NOw what id like to perform is Whenver Someone changes something in the office to our Database, it also changes on our website ,,

Individual Row Addition ((!!!help!!)

well i have this $sql2="SELECT ordernumber,Elecrem, CtrlProjrem, OthrProjrem SUM(Elecrem+CtrlProjrem+OthrProjrem) AS btstotal9 FROM orders GROUP BY ordernumber ORDER BY ordernumber"; only add's up the first row it hits and adds it to the remaining rows ,, I need individual Row

totalizing of Rows please help!!

i have three Values in each row of my MySQL database, im needing to sum them in the table as they are displayed per Row ?? how do i do this ? Projectname Elecremain Controlremainotherremain Project1 2300 1600 250

Form value editing

can someone please just send me or post a example of editing feilds of a mysql database within an html form and then updating the values thanks alot here is a small database u can use i can expand on your example as needed /***

i have the sums now i need to sum the Final 4 Sums together, i'll be done Finally !! geesh

o.k o.k ive thrown together this code Inwich DOES work but i have 4 Colombs i need to get this value for and then Sum the bstotals in a sum right now i have this SAME routine but just changing the name of (" btstotal ") to bstotal1 , bstotal2 , bstotal3 so my code in diffrent area's looks like

arrg need help summing Colum's

why cant i get this to sum > ??? $link = mysql_connect("localhost","root","goobers") or die(mysql_error()); mysql_select_db("workorder", $link); $result = mysql_query("SELECT SUM(`ElecRem`) AS total FROM orders", $link);

Summing Collums

HI all ; i wanna be able to sum a colum in a mysql database and display the sum on the page field name <"Bondrem"> so if someone adds to the database the bondremaining colom would add together and show the total on the page record1 - ["bondrem"]=100 record2 - ["bondrem"]=450 total bondr

Wont insert into database

i have two php Forms to insert data into a Mysql 4.0.20d Database, one is just a simple form to test if it works the other is the Actual application, here is the test form and works Perfectly >> NOW , / here is the Form data submitter that doesn't Work Ive checked and checked a

Error on T_echo ?? what is this ?

i,m getting the following error on my MySQL Code inserting data into a database, .? *Parse error*: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30 LINE 30 is echo "Query Finished";

Summing tables and fields Please help,,,

can someone post a snippit on Summing tables together of a feild of the entire Database ? why does everyone Have such a problem with this question? everyone i ask says the same thing,, let me show what i'm needing by Visual representation MySQL database >> workorders

MySQL5

I've Installed - uninstalled - reinstalled Mysql-5 Three Times on a extra machine I had laying around , and I have a few questions because of trouble's I've had and here they are I had trouble with phpmyadmin,("just wont Login or work at all") it's says to upgrade my Client's "Were are the

BLOB Source

Can someone please post some asp or php working with BLOB Files, and how to Get files into a Mysql Database,, in working woth PDF Files thanks

Folder recursion

I.m needing assistance in get a problem Solved , What im attempting to do is have MySQL thru asp or PHP look thru Folders and add to a Mysql database the path and folder name and file located within that directory into the database, can anyone help me ?? or give me hints -- No virus fou