agr8lemon

I have a very basic 3 column page that I would like to have centered. In every other browser that I've tested, it works fine, however, in IE it gets aligned to the left. Can someone take a quick glance and see what I'm missing? Thank you! [CODE] /* CSS …

I'm a bit of a SQL newbie so I'm wondering if you can help me. I've looked on Google it for some time, but maybe I'm not using the proper terms. Here is my question: I have TableA that has the following columns: ID(PK), location, departA, departB. I would like …

Hello, I'm trying to do a very basic page that allows me to edit a single column in a MSSQL database. For whatever reason I can't figure it out and am hoping that you can help. Here is my front page (sorry about the silly names) [CODE]$ninja_conn = odbc_connect('XXXXX','XXXX','XXXX', SQL_CUR_USE_ODBC); …

I've used this many times and it's always worked, however for some reason I'm missing something. [CODE]$ddType_query="SELECT DISTINCT Type from dbo.LTN_HARDWARE"; $ddType_result=odbc_exec($conn, $ddType_query); while ($ddTypeOptionsRows = odbc_fetch_array($ddType_result)) { //echo $ddTypeOptionsRows['Type'], "\n"; $ddTypeOptions = $ddTypeOptionsRows['Type'] ; } odbc_close($conn);[/CODE] I'm trying to get the $ddTypeOptions to contain all the distinct results of …

Hello everyone! I'm trying to get a date from SQL without the year. Every code I've seen has included the year. Here is what I have now. [CODE]SELECT * , convert(CHAR, \"date\", 10) AS ndate from dbo.MYDB where 35 > DATEDIFF(d,\"date\", GETDATE())";[/CODE] I would like ndate to be show like …

Hello everyone! I'm wondering if there is a way to assign the values of a column in SQL as the key name in a multidimensional array. Here is what I have, my database looks like this: Table Name = SJCFPCB date | totalin | cdulep | icu | ----------------------------------- 2011-01-27 …

Hello everyone, I hoping you can help me. I've got a table that I want to be able to show/hide rows based on what check box is checked. By default, I don't want anything displayed, then if you check a or some of the check boxes you'll see the data. …

Hello! As the title says, I'm trying to toggle a <tr> element of form based on the selected value of a drop down box. Here is my current code for the dop down: [CODE]<tr> <td><img src="require.gif" align="center" width="7" height="5"> Employee Type</td><td colspan="3"><select name="type"> <option value="Please Select an employee type:">Please Select …

Hello everyone, I have a temp/humidity/light sensor in a server room that produces a web page with just raw data like this: [CODE]uN703610TF: 79.9HU:36.4%IL: 0.7 [/CODE] That is the only thing on the page, it's wrapped in HTML and BODY tags, but that is it. What I want to do …

I would like to show a Div based on the URL. I'm using PHP to update a database and the page just refreshes when it's done. I'd like to set the URL to something like [url]http://www.whatever.com/update.php?id=5&ud=y[/url] So if the URL had ud=y in it, it would show a div with …

I think this one is simple. I've checked Google but could not find the exact answer so I thought maybe someone here could help. I have a Div that I would like to float 3 other elements in. So let's say [CODE]<style type="text/css"> .alignleft { float: left; } .alignright { …

Hello! I'm hoping that you can help me Alter a SQL table to provide a unique constraint over 2 columns. For instance let's say I have a departments table called Dpt_tbl with two columns that I want to be unique Name Location So I want to make sure that you …

Hello everyone, I'm not sure the title fits my question, but I didn't know how to word it correctly. Here is my question. I'm working on a forum that pulls data from a SQL database via PHP. It's data on employee data (name, job title, what programs they have access …

Hello everyone, This one has got me stumped so I figured I'd see if all the smart people that hang out here have any suggestions. Here is what I am trying to do: I have php site that pulls data from a SQL DB. based on results from the DB …

hi everybody. am a newbie to web design and I was wondering how to add the google map to a webpage. the same way some web site do it to situate a shop and so on, as if it is in an iframe. help me please!

Hello every! I'm having some issues trying to pull data from a table. I need to pull data under the following constraints: The PRINTNAME column can not be NULL and can not be empty, plus the DISABLED field needs to be 0. This is what I have now, but I …