rich11

Hello I have created two div layers. The first layer are going to be populated from a database. 10 People, and when I click on the items the will have information like office hours, phone numbers, and so on. And I want to show a div layer with that information and then they can close the div layer or just click on another person and show that info in the div layer. Not sure how that second div gets populated from the database??? Do I call to the database when I click on the persons name and pass the id of the person??? I am really lost on this one. Rich

Ok cool... so this class I have to install on the server???

I saw where you could download this class.... but I didn't see the code??

Yeah.. I read that one... couldn't make any sense of it though...

Good Morning, I have a php Intranet, and what I would like to do is hit the Active Directory and bring back the Username, FirstName and Lastname from Active Directory and set them to variables, so I can either display them or insert them into a database. A few things to consider, php is installed on the server, but I don't have access to the server to change any settings. This is just a side project and we are blowing up the existing intranet and going with a Content Management System, so the easier the better. Thx, Rich

Hello, I just found out that access doesn't like some reserved letters like ' $ and so on. I was wondering if someone hand some javascript that will remove these reserved symbols from a memo box before inserting into access. THx, Rich

yes.. I just google that error that is what I read.. thank you for your help. It was much appreciated. Rich

I have changed my insert statement to this.... $query = odbc_exec($conn, "INSERT INTO rich(Question1) Values('$answer')") or die (odbc_errormsg()); This is the error msg I get... [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Well that is the problem... I know that the code hits this line... /* error */ echo "Whoops"; Because "Whoops" is displayed in the browser. But I don't get errors. Say like in ASP or Coldfusion displayed on the screen. I have tried using IE, Netscape and Firefox. I wish PHP would kick errors, but is doesn't or do I not ahve the browsers set up right? Rich

Hello, I am having problems with this insert statment and I can't see what I am doing wrong. Thx, Rich <?php // This opens the connection $conn=odbc_connect('eeras','',''); // Checks to see if connection was opened if ($conn) { // Connection was opened echo "yepper"; } else { // Connection Failed echo "Nope!"; } // global variables $answer1 = $_POST["ques1"]; $sql = "INSERT INTO rich(Question1) Values('$answer1')"; $result=odbc_exec($conn, $sql); /* check for errors */ if (!odbc_exec($conn, $sql)) { /* error */ echo "Whoops"; }

For some reason.. it is not picking up the javascript. It just goes to the next page. Here is the code for the start of my form. Do you see any mistakes?? <form method="post" name="form" action="eerasinsert.php" onSubmit="anyCheck(this.form)"> Rich

Do you know of any good Javascript where i can get some code for that?

Ok.. I know that is getting off topic. But if I have 7 check boxes, and I only want them to answer two of them. Is there anyone way of doing that?? Rich

Dude... THat was sweet!!!!!!!!! Worked like a charm. SO what is the significant of the period?? RIch

Hello, I was wondering how I set variable with two variables coming from a form and I would like to seperate them with a comma. I understand how to set a variable. $totaltext = "hello my friend!" ; I want to take these two variables from a form and put them together in one variable seperated by a comma echo $_POST["C1"]; echo $_POST["C2"]; $totaltext = echo $_POST["C1"] "," echo $_POST["C2"]; I know that is not the syntax, but I tried it and it didn;'t work. Thx, Rich

Ok..... maybe i asked the wrong question. I want to take each text box that was checked, add each value of the textbox together in one string varaible seperated by a comma. Once I have that string variable I am going to insert it into a database field. Thx, Rich

I changed the code a bit.. but mostly the code you gave me... but it won't print anything out... the $total variable won't display. did I mess upo the code?? Rich if(isset($_POST["C1"])) { $total + 1; } if(isset($_POST["C2"])) { $total + 1; } if(isset($_POST["C3"])) { $total + 1; } if(isset($_POST["C4"])) { $total + 1; } echo "<br>"; echo "<br>"; echo "<br>"; echo "<br>"; echo "$total";

Hello, I have a survey that i am doing, and one of the questions is pick your top two questions out of six answers. When I submit the form how do I know what check boxes they click and how do I know if they clicked three instead of two?? Thank you... here is my code for the question <tr> <td width="33%"><font face="Arial"> <input type="checkbox" name="C6" value="ON"><font size="2"> Hospital newsletter</font></font></td> </tr> <tr> <td width="33%"><font face="Arial"> <input type="checkbox" name="C7" value="ON"><font size="2"> Posters/Tent Cards</font></font></td> </tr> <tr> <td width="33%"><font face="Arial"> <input type="checkbox" name="C8" value="ON"><font size="2"> Awareness Website</font></font></td> </tr> <tr> <td width="33%"><font face="Arial"> <input type="checkbox" name="C9" value="ON"><font size="2"> Energy Newsletter</font></font></td> </tr> <tr> <td width="33%"><font face="Arial"> <input type="checkbox" name="C10" value="ON"><font size="2"> Displays</font></font></td> </tr> <tr> <td width="33%"><font face="Arial"> <input type="checkbox" name="C11" value="ON"><font size="2"> Intranet</font></font></td> </tr>

is there like an application variable that php will automatically seek out. In coldfusion the application.cfm holds the database connection plus any session variables you are wanting to work with. Rich

Hello... I am new to php and not sure how to get php to work with MS SQL. Do i need to set up a DSN??? And then use this code to contact the database?? $host="localhost"; $username="root"; $password="root"; $dbName="clients"; Thank you, Rich

So when I entered the password, it denied me access

Ok... a few things... Mine isn't located under C:\mysql\bin It is located C:\program files\mysql\mysql server 5.0\bin\ So when I type msql -p it asked for a password and I type it in.... but I noticed it was trying to use the username as ODBC@localhost instead of the username root. Rich

Allright... I went to the C:\ and type mysql -p and got an error 'mysql' is notn reconized as an internal or external command, operable program or batch file. Rich

Ok.. sorry about this.. I just tried to create a table in mysql admin.. and got an error... MySQL Error Number 1289 The "innodb" feature is disabled, you need mysql built with "innoDB" to have it working. Maybe this is part of my problem??

I am running the database from the mysql administrator... I can edit data create tables and everything.. How do you run mysql from the command prompt?? Rich