dynamic mysql/php sites i.e. filename.php?id=23

I am sorry but my search skills are weakening, and after rummaging through 20 or 30 threads about this topic, I haven't been able to find or understand what I need.I'm trying to make a dynamic site and want to learn most of it on my own if possible, but I've been using a few tutorials and help on fo ...

jQuery An autocomplete that is able to insert a hidden id based upon the ID of a returned element?

every,I am new from prototype and am trying to change my methods to jQuery.What I want to do is very familiar to me with prototype, but confusesme when trying to do it with jQ :PI have spent the past 3 hours playing around with the autocompleteplugins on the site, and read their documentation as wel ...

How to pass this images "id" on submit?

http://www.fhhsbandhome.com/authalpha/forms.phpWhat I am trying to do should be pretty obvious. I'm in the process of building a new auth system for myself. (don't recommend me to use available ones on the Internet, none of these do what I need it to. I'm about an average PHP coder looking for some ...

Array with id / parent_id relationship

Hi. I got a pretty big issue with an array here. As you can see below (a print_r of an array) they have an id/parent_id relationship. This array I'd like to print as a tree function.The problem is this: I want to remove a "branch" from the array.Let's say I'd like to remove ID 2 (MERCEDES) ...

enumerating DIV id's in PHP

I have a simple HTML document that has a several DIVs... <div id="17">Some content</div><div id="2">Other content</div><div id="23">And so on.</div>As you can see the IDs are not sequentially numbered because they're used by a JavaScr ...

Javascript: Pass Image 'id' onclick

My topic was already posted in the PHP form, but apparently this is no longer a PHP issue. More of a Javascript one now :-/ http://www.fhhsbandhome.com/authalpha/forms.php is my pageOn post by clicking an image:POSTDATA=username=username&password=password&imagename=Image+Name&imageid=00 ...

imploding "OR id="

$sql = "SELECT * FROM ".$dbTable3." WHERE ";//+ is interpreted as a space//$check = $_GET["checkresult0"]." ".$_GET["checkresult1"];$check1 = isset($_GET["checkresult0"]) ? $_GET["checkresult0"] : "";$check2 = isset($_GE ...

Ubuntu Euler Problem 23 in Python

I'm trying to solve Project Euler problem #23 (http://projecteuler.net/index.php?section=problems&id=23). I think the code works, but it is terribly inefficient (I killed it after 10 minutes of number crunching). What is a better way to solve this problem?'''Project Euler - Problem 23"Find ...

Ubuntu [Python] Project Euler problem 23

So I am rather new to Python and programming as a whole, and have been trying to solve problem 23 (http://projecteuler.net/index.php?section=problems&id=23) on project euler;A perfect number is a number for which the sum of its proper divisors is exactly equal to the number. For example, the sum ...

Ubuntu &lt;Python&gt;Project Euler Problem 23

I've been trying this one for hours. I thought it was easy, apparently not. I can't get the correct answer and I can't see what's wrong with the code.Here's the problem: http://projecteuler.net/index.php?section=problems&id=23 Here's my code:#Problem 23#02 August 2002##A perfect number is a numb ...

jQuery My calendar

I want create my own calendar with jQuery, but I have small problem:My source (for now):<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><he ...

jQuery Sortserialize returns nothing

I'm stuck! I have followed the examples there is, but I can't makethis work. My code below just generates an empty alert box:<script>$(document).ready(function(){$("#myList").sortable({        update : function(e, ui)    ...

jQuery Sortserialize returns nothing

I'm trying to serialize, but I'm only getting an empty alert box. I get no error message, it's just empty. Please help!<script>  $(document).ready(function(){    $("#myList").sortable({      update : functio ...

jQuery Bug with AJAX json setting an element to a value and back to 0 when polling

I am using the AJAX class with the dataType set to json and cache off.I am polling with the this class about every 2 minutes.So here what I am doing to get the error and it is reproducible. Ihave everything set really simply right now.Here is the success function I am using:function(data) {alert(dat ...

jQuery Autocomplete results list in another element

I'm using Jörn's autocomplete plugin from bassistance.de.What I'd like to do is do a search, which searches two separatedatabase tables (with different column names) on the same query.The results will be returned (eg. as JSON) with two objects, each withresults from each table.So a resu ...

Internet Explorer not rendering JQuery UI Tabs

all,Thanks so much to anyone who can help me with the following problem.I'm using JQuery tabs on the following page:http://www.georgiasouthern.edu/magazine2/index.php?option=com_content&id=23The tabs show perfectly in FF and Safari but do not render at all inInternet Explorer. Any clues on h ...

jQuery Sorting dates with tablesorter plugin

folks, this one is driving me mad!I have a table of data that I was hoping to sort using the tablesorter plugin but I'm finding that it doesn't work at all on date columns. I wonder if it's because I'm working with UK dates... here's my call to the plugin:<script type="text/javascript"> ...

jQuery Does anyone know the most efficient way to filter a list with another list

Hi,   This is my first post and am new to jquery.   I am trying to work out the best way to filter a list with another list.   The idea being when you click on one or multiple items of the filter options jquery will hide all of the items in the results list except those that contain a ...

jQuery getJSON returning empty array [] from properly formatted nested JSON object

I've been wracking my head on a weird bug for an embarrassingly long amount of time. Google's been of no help so I hope somebody can lend a hand. I have a PHP script that returns a properly formatted JSON object (I've validated it using JSONLint) that looks like the following:{ "ID":"23",  "Las ...

jQuery unable to call click event on adding dynamic html

i have some code as follows[code]$(document).ready(function() {$('a.poplight[href^=#]').click(function() { /do something });});[/code]when i click on a <a> tag with class poplight this works fine. But when i add another anchor tag dynamically to my page (without a page reload, via ajax) like b ...

Problem with Tomcat 6 / Java / Confluence eating all resources and running like a two legged dog.

I set up a server to run Ubuntu Hardy, Apache2 for our marketing site, Zarafa for email, Postfix MTA with SASLAUTHD etc, Tomcat 6 proxied through Apache with mod_proxy, Sun JDK, and confluence.Java seems to eat everything on my 512mb slice and runs at a crawl. I only have three confluence users. To ...

Sphinx Clustering the query results

I want to add a new functionality in results of Sphinx search. I need that when Isearching a query the results will be clustered with a predefined rules. For example:Search string: mp3Results Sphinx:Id = 123, user_rate = 1, section = 2Id = 224, user_rate = 2, section = 8Id = 563, user_rate = 4, sect ...

radio button and javascript

I have a html form with two radio buttonsone of the buttons hides one table but when i select the other buton i would also like it to hide another table field.when the form opens all the field are shown which is okI really would appreciate your help guys:)here is my code:---------------------------- ...

some organization/stucturing questions

I've spent the last week reading up on php so I can redo my current site (www.geocities.com/mistergecko2000/). As the site is mainly static, I mainly want to make it easier to add new information, articles, and pictures, and to be able to easily change the look of the site. I think I can handle the ...

Question about ROUND function in DB2v9.5 LUW

I worte a program to test the ROUND function, However some behaviors confused me much. The following the my program and output:#include <stdio.h>#include <string.h>#include <stdlib.h>#include <sqlca.h>int main(int argc, char* argv[]){EXEC SQL INCLUDE SQLCA;long lRetCode = 0L; ...

Query error question

I am trying to develop a website using Cold Fusion and am currently working on some administrative pages. I've built a page with a textarea in which I can type an SQL statement and a submit button to execute the SQL.This process works fine for any query that contains only numerical criteria. But, if ...

MySQL Need Help with Replication

I'm french and I need some help with replication. I don't know why it doesn't work so please help me to find the probleme. I have two computers : one master and one slave. On the slave : mysql> show processlist \G *************************** 1. row *************************** Id: 20 User: root Ho ...

MySQL Update multiple fields with 'OR'

Is there a better way to do this (more efficient). I have up to 200 items to update per query, the id's are not sequential. Using up 200 (well 199) OR's in a single query doesnt strike me as being the best way to do this. All the fields get set to the same value. # Example UPDATE table SET value=val ...

MySQL How can I determine the offset of a result in an ordered result set?

How can I determine the offset of a result in an ordered result set? I would like to pass the calculated offset into the limit half of and ordered select statement. E.g. I have a table that records a id and datetime for captioned photographs. I'd like to show the five photos that were taken after th ...

MySQL Using Replace function on a Text: why doesn't it work?

Why the query SELECT REPLACE ("Mi piace l\'Italiano e anche l\'Inglese", "\'", "'"); returns Mi piace l'Italiano e anche l'Inglese whilst the query SELECT REPLACE(content, "\'", "'") FROM MyTable WHERE id=23 returns Mi piace l\'Italiano e anche l\'In ...

Drop Down Lists

I'm want to be able to choose(including multiple selections) names from a drop down list that are fetched from the database(from table "Employees") and add them to table "Biotechnology".Employees(ID,FirstName,LastName)Biotechnology(ID,EmployeeID)**assuming that EmployeeID in ...

TurboCert MCDBA2003 - how good is it ???

Has anyone tried the following sql server study package:TurboCert MCDBA2003 - Microsoft Certified Database Administrator (SQL Server 2000 & Windows Server 2003) ??(The website is http://www.turbocert.com/shop/shopexd.asp?id=23)If yes, please share your opinions -- is it worth the money ?? ...

DTD declaration problem for xml file

Please adavice the DTD for the below xml file, inside the comment tag, there is html bold tag. I do not know how to declarat the DTD for it.Please help!!!Thank you very much.Example,<?xml version="1.0" encoding="utf-8"?><!DOCTYPE reviews SYSTEM "reviews.dtd" ...

MySQL Delete from multiple tables

Hey, just a quickie... I've had a quick google and can't find anything to help so i thought i'd ask here. What im tring to do is remove all instances related to post# 23 (for example). Now using the below query it works if there are comments present in the comments table but does not work if there a ...

CSS display:table-magic

I have the code below as output from a php script. While I could mess with a pile of ugly loops and multidimensional arrays, I'd rather just fix it with some CSS (I'm going to add CSS anyways... right?).What I'd really like to do is turn rows into columns. My guess is that the CSS "display:tabl ...

MySQL Ugly query needs optimization

Okay, here's the logic: If a customer refers 5 or more people to the company, they start earning 15% of all payments made by those customers. The query is fired when any customer makes a payment. It returns the valid referring customer's ID if there is one. If customer 23 was not referred or if he w ...

mysql does not work with cp1251 encoding

I installed mysql with utf8 encoding by default. Now I want to change it to cp1251. I've changed it in my config file my.ini: [mysql] default-character-set=cp1251 [mysqld] ... default-character-set=cp1251 ... Now I get an error: Character set 'cp1251' is not a compiled character set and is not speci ...

MySQL Problem with Select Statement !

I have a table with 3 columns. I am using mysql In the SID column are listed the items. The aid column contains the specifications of the items. I don’t know how to syntax the query to give me only the items that share the criteria(= specifications) I selected. For example I need the items where t ...

help! unexplainable db deletion. (msCrawler?)

have BIG trouble with dissapeared database content.in some way all db entries have been deleted.the database is just part of a bigger project and only accessible for administration (and protected via .htaccess)on the main-site all the antries are (were) listed in short-form, below each a link for 'e ...

MySQL Query Syntax issue

I'll start off by saying that I'm not 100% sure where I should put this topic. My issue lies within the following SQL. CREATE TABLE IF NOT EXISTS `site_templates` ( `id` int(11) NOT NULL auto_increment, `client_id` int(11) NOT NULL, `template` varchar(100) NOT NULL, `preview` varchar(100) NOT NULL, ...

include() question

I have these two files:includes.php--------------------------- Contains the database information, and also performs a few queries (such as to retrive forum information, basic site configurations). Also initiates a database connection.functions.php---------------------------Contains the custom functi ...

Cannot connect local database

After restarting the machine, the sql 2000 won't start.- I'm using local (no domain)- administrator account- sql agent is started, but cannot connecta connection could not be establish to (local)please verify the sql server is running and check your...sql log below:2008-02-07 11:34:53.04 server Micr ...

Removing categories in Wordpress via phpmyadmin

Sorry to bother you with a remedial sounding question - I'm currently trying to remove categories and posts from those categories from a Wordpress database.I'm using phpmyadmin to run queries, as Wordpress support suggested running the following:DELETE * FROM wp_post2cat WHERE category_id=2; DELETE ...

Remember Array Contents

I have the following code, that inserts the ID value of a link into an array, upon the link being clicked. See example link below:www.somthing.co.uk/functions.php?id=23 (www.somthing.co.uk/functions.php?id=23)How do I get the array to remember its contents, so if the browsers back button is used, an ...

selecting more than one subset of the result from a mysql result(using limit)

Please consider the following table as an example to explain my problem.. id name 1 a 2 b 4 c 7 d 9 e 11 f 12 g 13 h 15 i 16 j 18 k 21 l 23 m 25 n 26 0 Suppose i want to get 3(count) successive names starting from id = 4(row 3) from table x, i do following methods to obtain it ... method 1 - select ...

Queried Links.......

I want to display the id of a tone from my database, and put it into an automated linkso that every time a record is found from a category its id is printed into a link which is submitted to a different page where the tone is displayed according to the id variable.eg.<a href=tone_display.php?id=2 ...

MySQL Cluster with split brain problems

I'm actually building a MySQL Cluster using 4 Servers. (Ubuntu 08.04.03 / MySQL 5.0.51) Common structure: There are two management nodes (apache2) and two data nodes (kind of nagios / network monitoring). MySQL structure: Both Management nodes are Management, Data and API Nodes. The two data nodes a ...

JDOMP - Dynamic DB access without AJAX

Don’t misunderstand me – I use AJAX, but I think there is a far simpler, elegant alternative that just uses Javascript, the DOM and Php ( hence - JDOMP) for data transfers, and is cross-browser without the need for work arounds. JDOMP works in recent versions of Explorer, Mozilla, Safari ...

Finding an Element's Width

I'm trying to find the width of element use javascript.Right now I have a table that has this external style sheet:table{table-layout: fixed;empty-cells: show;width: 800px;height: 500px;}The XHTML of the table looks like this:<table class="grid" id="gridTable"> <!-- A 3x ...

Syntax Error with SQL Query

I am trying to query my database using ASP...i did a Response.Write to view the query.....UPDATE BatterStats SET H=3,K=0,E=0,AVG=.456 WHERE ID=23It was working fine until i added the AVG part with the decimal and what not. I tried the query in Access and it worked fine. What could the problem possib ...