niche

It's an array that gives you a place to put data that a user generates during their session. It's an important concept. http://www.w3schools.com/php/php_sessions.asp

We need to see more code. Else, look into the css box model, divs, and float

Understood. I haven't encountered many limitations with mysql. Obviously this is one of them. Thanks for the reinforcement jsg.

I think I'm hitting a limit that looks like a time limit, but it's probably something else. What I don't know. Here's my script : UPDATE du_raw2, cris4 SET du_raw2.sn2 = cris4.sn WHERE du_raw2.key1 LIKE CONCAT('% ',cris4.sn,' %') My localhost is a wampserver with mysql 5.6.17, php 5.5.12, and apache 2.4.9. My code parses mailing addresses. It targets the key1 column in the table du_raw2. The key1 column contains addresses (all the address components on a single line). cris4 contains all the street name possibilities for a specific city. There are 2000 of them. The script scans each address in the target file (when it has less than 2000 rows) and returns the street name if it's found (from the 2000 street name possibilities). It successfully updates 1000 target rows in a second. The query log says the connections are opened and closed.It successfully updates 2000 target rows in three seconds. The query log says the connections are opened and closed.It times-out somewhere between 2000 and 3000 target rows. The query log says the connections are opened, but never closed. When I reduce the number of street name possibilities from 2000 to 50, my script successfully processes 3000 target rows in 26 seconds. The query log says the connections are opened and closed. I expected it to take less than 26 seconds (causing me to think it's the way I designed the code, but then I'd need know what concept I'm violating). My script isn't in a loop (yet). I have 100,000 rows to process. I'm just peeling it back to figure-out where it chokes. It's not the data. It's the number of rows and or the way I'm applying the code. I'm using it with php, but I doubt php is the problem, I've already played with set_time_limit(). I suppose I could work around the problem in a while loop. It would only run 50 times. I'd rather know what the true problem is. What do you think? Where else can I look?

Do you have any code so far?

Here's the tutorial that will tell you how to find your css. Even if someone just gave you the correction you probably need, you'd still have to know how to find your css to make the change. This willl show you how to find it: http://www.w3schools.com/css/css_howto.asp

http://php.net/manual/en/function.isset.php

Yes. Parens short for parenthesis.

Sure. Also, you'll need to use parens around the ORs WHERE (show=1 AND deleted=0 AND id=1) OR (id=2)

Got it. Thank-you jsg.

need your css.

Post the relevant code please.

Turns out this is the solution: UPDATE addr, dir SET addr.dir = dir.dir WHERE addr.addr LIKE CONCAT('% ',dir.dir,' %') But, I can't find a ref that would've of prompted me to expect to treat the argument as a string. Is it in the manual?

my ultimate objective is to parse street addresses using only queries. my current tables are partial tables so I can learn dynamic likes.

The addr table has two cols: addr & dir the addr col contains the address and the dir col is empty (its the col I want to update) The dir table has a single col called dir (short for direction).

I have 4 street addresses in a table called addr:123 MAIN ST123 N MAIN ST123 S MAIN ST123 E MAIN ST I have 4 street directions in a table called dir:NSEW I could write 4 separate queries based on:UPDATE addr SET dir='N' WHERE addr LIKE '% N %' Is there a way to do it in one query? If so how? I tried: UPDATE addr, dir SET addr.dir = dir.dir WHERE addr.addr LIKE '% dir.dir %' But, no joy (though it didn't cause any errors).

Viola!

Reformat how? I don't understand where you're going?

That saved me another hour of fruitless search. My hats off to you as always JSG. What do you think of a php while loop with a query in it? You don't seem sold on the stored procedure route.

I have a totally flat text file (nondelimited) with a record length of 120. How do I finish this query to send every 120 characters to the row named raw which is a varchar with a width of 120? LOAD DATA LOCAL INFILE'e:/usps/crs1508b/685.txt'INTO TABLE crisSET raw =

If you're calling them quirks, you probably resolve them. What ever is left, I'd call features.

Do you have a specific question about your code?

They're everywhere. Try this one: http://www.hongkiat.com/blog/css3-button-tutorials/ EDIT: Why are you linking php & buttons in your question?

Bookmark it.

You might have the "don't print background" box checked.