DarkxPunk

Phpmyadmin import function.

Hey everyone, Please correct me if I should not be posting these sort of issues, I notice most posts are related to syntax. Anyway lets get started. I have a fairly large database (approximately 65000 rows with 10 columns), it has been provided to me in a CSV format. At first I attempted to upload this database and kept having MySQL disappear (gone), I figured later that was related to my max packet size was too low, resolved that. Now I attempted to import it again, but I am always missing about 20/30 thousand rows (not in any particular location either), one instance I actually incurred an extra 60 thousand rows (which does not make sense so it must have been duplicating data). I am at this point where I am completely lost as to why this won't upload. In the past I have uploaded CSV files with maybe 6/7 columns and 1000/2000 rows, and never had or have issues, I know it is dramatically smaller in comparison, but I don't understand why MySQL can't handle it. Thanks for any help anyone can provide.

It was order… I got confused because I tried putting: $pageTitle = $illustration["cinematic"]["full_name"]; echo $pageTitle; at the end, but there was still no result. This time I placed it after my preloaded php code and before the head loaded (rather than before both) and it functions. I should have clued into that before. Thanks for the nudge

That's the thing, I have it echoing in the title of the head of the page. I even tried for the ###### of it to echo again within the body. It comes up blank. I am totally confused...

So I got this code: $pageTitle = $illustration["cinematic"]["full_name"]; For some reason it is not showing the proper content However if I do this: echo $illustration["cinematic"]["full_name"]; it gives me the result... What am I doing wrong?

Hello everyone! The following is my first attempt at managing a cookie. I am simply looking for what you think of it, and how you think I can improve. I made this with a tutorial online and made the buttons myself. Thanks for any help!

When I said "under the header" I mean within the header tags... Sorry.

Text without an associated wrapping tag... I feel dirty. Thanks for the info.

So should I use span then?

You can check my beta site, http://www.beta.sunburstrarediamonds.com to see its usage with the logo and logotype. I am currently using h1/h2 but in my head span makes more sense. I just worry about SEO...

Hi there, Check it: http://www.beta.sunburstrarediamonds.com I will post on here when I do updates to get further feed back. For this post I am looking for input about how the header and navigation is coded. Is there any improvements I can make? Thanks for any input!

Yeah, that is the way I have been doing it… I just feel weird using h1 when its not exactly a title of a specific body of text… Is there any SEO benefit to using h1 over span in this case?

Hi everyone... So I have been wondering what is the best way to wrap some text. From my understanding the usage for each tag is the following: <p> = Paragraphs / Blocks of text <h1> - <h6> = Headers for blocks of text <span> = To style specific text within either a <p> or <h1> - <h6> Now my situation is this… I am attempting to do a logo with its logo type using text rather than an image, the problem is I don't know which tag fits… It it defiantly not a paragraph or block of text, it is kinda a header, but it's not for any specific block of text, and I am also not styling specific text within either of the first two tags… So yeah, I am not sure what to use. In my head <span> is the correct one to use as it does not apply any specific styling allowing me to style as needed, while <p> and <h1> - <h6> have already some predefined styles. What also matters is SEO, will using a <span> make the seo invalid? Thanks for any input.

*squint in confusion* I wanna center this with as little over head as possible. I know nothing of emcascript, but that sounds like extra over head when all I wanna do is optimise my design...

I am using divs... I just styled the elements using display table/table-cell. The only issue I see with absolute positioning is you need to know the exact dimensions of the box, which I don't want...

Hey everyone, http://www.beta.sunburstrarediamonds.com <- If you check there you can see all the css/html Currently I am aligning the elements under the header by using table/table-cell with CSS. Is there a superior way to do this or is this the best way? Thanks for the input.

Because the styles of the button are associated to the anchor you need to set the hight to the anchor tags… You can simply add a class to all the anchors if you want the height changed uniformly. Hope that helped.

Though we can download it, in the future (and if you are willing to edit your post), post just the code.

Okay so… I found what is causing it… The background image having the following properties: img.bg { position: fixed; z-index: -999; } How the H E DOUBLE HOCKEY STICKS does this effect the thickness of the text? I have tested it through and through and it is the cause… HOW??? I am so blood confused... You can test it by simply removing the img from the main site… It thickens… You put it back, it thins out. If you go deeper and just remove either the z-index or the position fixed it thickens… What? Hope someone has an idea... [EDIT] So http://css-tricks.com/forums/topic/position-fixed-font-weight-is-thinner-new-safari-6-1/ yeah, this is a pain. Now to test outside of Mac OS X Lion… But why iOS too? Will keep y'all updated. [EDIT 2] So it is a bug in iOS too, or just how Apple wants it to display. Position absolute fixes it kinda, idk about how to apply it yet. If anyone has a fix I am all ears. [EDIT 3] So the fix appears to be the following: -webkit-font-smoothing: subpixel-antialiased; This seems to help all my fonts display consistently across browsers, except iOS which seems to actually thin ALL web font. So I guess I found a fix… but still a huge pain...

I completely understand they are not the same line by line, but I know the fonts are the same because I decided to copy and paste the exact fonts over and limit it to just fonts that are on the main site, as you can see.The real kicker is this: Even more oddities: http://www.sunburstr...om/index232.php displays different. It is exactly the same the styling and almost the code! I am so confused, my brain hurts.It may not be the complete site, but it consists of the main elements. Still displays differently. Please not that is on the main site just in a different file, linking to the main sites css files and fonts. I will do a exact duplicate and test, but there is no reason that link displays differently.

So to compound the confusion I decided to redo it from scratch, and no results. Then I decided to take the exact font from the original page (not converted or anything), and apply it to the beta page. It displays differently. ITS THE EXACT SAME FILE… Now I am really getting confused and annoyed… Any ideas are appreciated. You can check the beta and non beta pages as I have updated the beta page. Even more oddities: http://www.sunburstrarediamonds.com/index232.php displays different. It is exactly the same the styling and almost the code! I am so confused, my brain hurts.

Well as mentioned before the only discrepancy is between the beta / non beta on safari and iOS devices. They are also on the exact same server, and the server is a Linux and the mime types are set. Now the reason why the code differes is I used the font squirrel system to give me all the web formats. The reason I renamed it was simply my own preference to how I want it to look cleaner (I know I shouldn't but meh...) So in summary, the problem must be a styling somewhere or some other oddity. I am probably gonna start from scratch again and redo the font squirrel stuff and hope for the best. (this is such a pain).

I understand there may be two different fonts available on the web, but what I am trying to say is both the beta font and non beta are the same. They came from the exact same ttf that I have (the ttf that I have is not a suitcase with different styles, it's one singular font), the sole difference is changed the name. I know this cause I did it. Even to make things simpler I even did a test (locally) by copying the non beta ttf form the site, renaming it accordingly and placing it on the beta page with the exact same results. Please understand I am not trying to be difficult, I just know what I did... One last thing, when testing the display issue on all other browsers beside safari and iOS, the fonts display the same, meaning it's a styling issue (I have not found) that affects safari...

Okay I am still confused. Let me re-explain what I see on my end. I will preface with I am using Safari on a Mac, this could be why we are not seeing eye to eye, this issue also persists on iOS devices. Regardless the issues you are bringing up are not really issues. First off regardless of being "inherit" or not on the anchor displayed on the non beta site, the font still loads, the font also loads on the beta site too, but it does not display the same. The non beta site displays thinner while the beta site remains kinda fat. Now using whichever tool you wish if you go style by style they are nearly identical to each other both the h2 and anchor on the beta site and the anchor on the non beta site. So with why the inconsistency? In regards to the concern over being a different font, it is not. The only difference actually is the name. I have the original TTF from the non beta site and just converted it using font squirrel to give me all the different web formats, in turn the fonts were also renamed. So they are the same font to be clear. From all my playing, following all your guys tips and pointers, they have no effect on how the font is displaying on my end. I hope someone has something cause this issue is really starting to annoy me. (The reason for all this is I am recording the site to help speed it up and such, but if I can't even get the stuff to display the same, it is useless.) Thanks again for any further help.

How come then the anchor does not look the same… As mentioned also I did apply the font-weight normal... Okay thats a good bit of info, but how does it solve the problem… Does font-face require javascript? The non beta page should show the font as well, it does on my end and every other computer/browser I have tested on. So why the inconsistency?