- Strength to Increase Rep
- +4
- Strength to Decrease Rep
- -1
- Upvotes Received
- 6
- Posts with Upvotes
- 6
- Upvoting Members
- 5
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
- PC Specs
- Windows XP, Vista
 | I would like to capture the modification date from a log file on the client machine in order to warn users (technical on an internal website) that they have not run updates for a given subsystem. Is there a way to do this? I've done this sort of thing before, …  |
| | I'm converting some old work to mysqli, and having a bit of trouble with Prepared Statements. In the stripped down code sample below, I'm able to confirm that the code below pulls the records; line 8 echoes the string as expected and if I replace the id parameter with something …  |
| | I'm converting old MySQL code to MySQLi, and running into some questions. When selecting data from the database, is it necessary or strongly advised to use prepared statements, or can I safely escape my user-derived parameters like the sample below? In a perfect world I'd have all the time I … |
| | Sorry in advance if this is the wrong place for this, it's the closest I could find. I need to create a macro for an Excel 2010 spreadsheet so that the active cell will cycle through three choices: "Y", "N" or "" - the last being simply an empty string … |
| | I have a table that shows tabular data across 7-8 columns, which works very well on a standard monitor. However, on a smartphone or even a tablet, it's a little less functional. Is there a way to automatically condense the data into fewer columns when the page is being view …  |
| | I have a lab management webapp that lists servers on my network. With a click in IE I can open a terminal services session to that server. The code - shown below - works in IE, but not in chrome or firefox. Can anyone suggest how I can make this … |
| | I have a series of user records in the form "`Lname, Fname (ABCD)`" where `ABCD` is the division the user works in. I need to be able to extract that substring so I can sort on it, count etc to I can see what divisions are using resources. In MySQL … |
 | Still drives me nuts that the title bar is gone. |
| | I have a form to edit a table record, and am having trouble with it in Chrome. In IE7 it works fine, in Chrome it does nothing. It uses javascript because there is a sprite to change the button on hover. Any ideas? I'm stumped and would appreciate any help …  |
| | Line 1 suggests you are using shorttags, which can easily break a site if you move servers. It may be that this has nothing at all to do with the database. Replace <? with <?php and see if that helps. May take some hunting to do it, but worthwhile. I … |
| | I'm dipping my toe in the water of salted passwords by upgrading an older webapp, and would like to present the rough outline of how my system would work in the hope that those with more experience than I might tell me if I'm going in the right direction; In … |
| | I'm new to MSSQL though I have some grounding in MySQL. At the moment, I'm trying to use a variable. Reduced to simpler form, my query to search people with 'and' in their name is: DECLARE @MyVar nchar; SET @MyVar = '%and%'; SELECT name,email FROM db.dbo.users WHERE name LIKE @MyVar; … |
| | My users arrive on the page, optionally with a query string. The query string data - if present - goes into a textarea element in a form, where it may be edited, then POSTed back to the page with the submit button. Now I have a bit of a mess … |
| | Sounds more like you have a characterset problem. If everything along the line is using Unicode, including the database. I don't have a lot of experience with this sort of issue, but I would think that current databases and browsers should have no problem with this. I'd try echoing things … |
| | Possibly PHP is configured differently or is a different version on the two websites. In any case, that "Can not modify headers information - header already sent" stuff is very sensitive. Even a blank line in your source can result in a single carriage return being sent to the browser, …  |
| | I have a configuration table with one row per configuration item (id,category,name,value,description,comment). My objective is to create a single edit page that shows all, or a subset, of these values and allows me to edit them. I could probably create a page with a separate form and submit button for … |
| | Assembling a query dynamically can be unpredictable. When I have problems like this I usually introduce a new line to assemble the SQL statement in a variable, then print the variable to screen to let me see what I'm sending to the db server. $sql = "SELECT $myval1,".function('foo').",myval2 FROM mytable;"; … |
| | The first thing to to when you're having display or behaviour problems on a site it to validate your code. I usually put a link like the one below at the bottom of every page on my site. The middot part means that all that will show on your site … |
| | I'm new to triggers, but have been working with MySQL for quite a while. Now I need to implement a trigger. I want to create a trigger on my 'persons' table so that after an update, ***if the attribute clubid is changed***, attribute clubname should be changed. I have a … |
| | I have a lab management webapp that lists servers on my network. With a click in IE I can open a terminal services session to that server. The code works in IE, but not in chrome or firefox. Can anyone suggest how I can make this work in Chrome (Firefox … |
| | The exclamation point indicates a negative, [B]continue[/B] breaks you out of the FOR loop, and [B]$row = mysql_fetch_assoc($result)[/B] reads another row from the dataset you're processing with the FOR loop. So if I'm not misreading it, the code I've copied below is saying: - read the next row from the … |
| | This may help. I sometimes use this in a WHILE loop, processed for each row of a result set. It's perhaps slightly less efficient, but can make code easier to read when I use the variables. With this code [B]$row['name'][/B] becomes [B]$name[/B], and so on for each attribute in the … |
| | Working in Word 2010, I have a long document with many formatting changes to be made. To start with, throughout the document I'd like to replace "Click OK" with "Click [B]OK[/B]", so the OK will be bold but not "Click". I also need it to be case insensitive, as some … |
| | I don't mean to sound discouraging, but what you're talking about sounds like a massive undertaking. Established travel companies with teams of experienced programmers spend years and probably hundreds of thousands of dollars to do this sort of thing. I doubt that you could do all these things in Joomla. … |
| | By far the easiest and fastest way to do this would be by installing WAMP Server for a Windows machine. This installs Apache Web Server, PHP and MySQL and configures most settings for you. I used to do this the hard way, no more. WAMPServer is the way to go. … |
| | I'm trying to create a Google-style bar across the top of my page, but when I hover over the elements, the link text jumps to the top. Can anyone tell me how to keep it on the bottom? My current code is below. [CODE]<html xmlns="[url="http://www.w3.org/1999/xhtml"]http://www.w3.org/1999/xhtml[/url]"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" … |
| | I'm trying to create a WordPress.com header for rotary7040pr.wordpress.com. I have a layer for the background colour, and have created another layer for text and graphics. So far so good. Now I have a graphic ([url]http://www.rotary7040.com/images/RotaryLogoDropShadow300x288.jpg[/url]) that I want to place on the layer with the text, but I don't …  |
 | |
| | I always keep my connect string in a separate include file so it is used universally. I can use it in hundreds of scripts, but only need to modify it in one place. Ultimately it has to be there in clear text. Would be interested if the Security gurus have … |
| | Without having a chance to run the code, here are my impressions. The line [ICODE]$j=0;[/ICODE] should be above the for loop - as it is it will never move past the first element of the array because it is reset to zero at the start of each iteration of the … |