| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> i write perl and mysql code as fast as i can type
<1> hmmm well only one big project under my bellt, which is abouut 15,000 lines of coode at about 230 hours of development time
<2> me too but every line i have to go fix my typos (not meant as a joke)
<0> and most of it works first try
<3> what is the general licencing costs?
<2> those are my most complicated database sites
<0> a good technique to use when billing people is to have a rate close to the industry standard and then work out how many hours a job would have taken had you been an expert
<3> it seems weird & inconsistent with the GPL, that I cannot redistribute MySQL, does my application fall into the category of 'extending' mysql?
<1> .I dunno it seems I'd rather code for free if I get to see people use it, tthen get paid as a contractor and not be involved with it at all.
<2> oh i have another site that uses a database calendar and also has a built in forum, but the html is super ugly so the site looks horrible graphically, and you have to be a member and log in to see the real guts of it. I'd say i'm at least worth $75
<0> does not pay the rent though SJr|Tecra :P
<2> i'll try for $100 next project :-)
<4> I need to query for row in a table, the row is identified by a unique field value, how would I do this?
<1> yeah I know which ****s, I end up doing tech support to pay the rent
<5> is there any different between DECLAREd variables in a stored procedure, and standard user-defined variables, apart from not needing to use @ on DECLAREd variables?
<6> infi: so i can create different columns under the same table, but on my website just have it query what i need like clothes, antiques?
<7> tdd1984: yes ..
<6> k
<6> i think im starting to understand the concept
<6> or seeing it
<6> let me read some more :) cuase im kinda confused on how im gonna show a description, id, date for that certain column
<6> hehe no im not
<6> ding ding ding
<6> lol
<6> i can just query the column into the id
<6> like query id, column needed but i can change this column, date submitted
<6> i can store each columns description
<8> tdd1984: slow down and give the Enter key a chance to rest, there, Turbo.
<4> I need to query for a row in a table, the row is identified by a unique field value, how would I do this?
<6> infi: see what im saying thow
<9> aedwards232: select * from table where field='unique' ?
<8> tdd1984: yes, but that should be explained on that page.
<6> infi: what do you mean explained on that page
<8> tdd1984: explained in the normalization article
<6> lol it just clicked in my head after reading that page. I started to put pieces together in my head, and i was like wait thats it.
<6> im gonna read that page again that was to fun, but am i right on the columns thing now, so i'll have to create a **** load of columns lol 60, but each column will hold the description, but then i can apply the timestamp,location to it, but the id will identify the the rows to the description, and city state.
<8> tdd1984: I don't know if you really understood it if you think you're going to need 60 columns for a cl***ifieds site...
<2> tdd1984 i am SURE you are doing it wrong
<2> 60 columns
<2> thats probably 45 more than i've ever put into a table
<6> yea i probaly am
<6> let me work on it thow
<6> well i got 45 categories like antiques, applicaines, cars, and bunch of stuff, so each one is gonna ahve descriptions
<2> ok theres one table with 3 columns
<6> there 45 of them thow
<2> 45 rows
<2> 3 columns
<6> yea
<6> columns is whats at the very top correct?
<2> columns sorta = fields
<6> true
<2> rows are records
<2> entries
<2> into the database
<2> new row, new record
<6> yea i know that
<6> but im gonna store the description into the antique columsn, and so on
<2> if you know that, then why are you making a 45 column table when all you need is 3
<2> id, name, desc
<6> true
<2> 1, antique, antique items
<2> 2,book, books and magazines
<2> GET IT?
<2> oops desc is a really bad name for a column :-)
<6> yea
<2> *that gets me in trouble all the time
<8> and for gods sake, please run your column names and descriptions through a spell checker.
<6> lol
<6> yea, but i don't want antiques, clothes viewing on the same page
<8> seriously, if I was going to pay you to write me an app and it came back riddled with spelling errors, I wouldn't even look at it.
<2> yeah but i write web apps with mysql backends, none of my clients would ever see a column name spelling error
<8> tdd1984: YOU WON'T. you store the item in an items table, set the categoryID in the items table to, e.g., 1, and using GoSox' table definition as an example, it would be an ANTIQUE
<8> GoSox: no, not in the columns, but he keeps saying "cloths" and "applicaines" etc, i.e. the category title itself ;)
<2> tdd1984 i think you need to learn the basics before you try to tackle something as big as what you are trying
<2> oh
<2> but infi
<2> spelling mistakes are the LEAST of his problems
<8> good point.
<10> truly.
<8> tdd1984: go back and read the wikipedia article again.
<8> 5 more times.
<6> it was a typo
<6> k
<6> let me read it again
<6> guys give me a break I'm learning it fast
<2> wait a minute
<2> forget about normalization
<6> why forget about normalization for
<2> he doesn't seem to get simple linear data structures and selects yet
<2> first things first
<6> thats the simple stuff :)
<6> which i've already played around with
<2> you haven't played nearly enough
<6> im gonna read this artice that infi gave me cause it made since i just need to look it over again
<8> tdd1984: up to 3rd normal form is fairly standard. the rest may or may not be appropriate or applicable. but learn and understand *at least* 1-3NF backwards and forwards.
<10> normalization is way over his head
<2> yeah
<2> way
<2> one table at a time
<10> until 2 hours ago he had a database named "antiques" and a table named "antiques" and a script named "antiques.php" that did select *
<10> and a db named "books" and a table named "books" etc
<10> and he might still for all i know
<2> omg
<10> oh you didn't catch that?
<10> yeah, flee.
<10> he's been floating around here for a few weeks
<2> dude the cliche 'biting off more than you can chew' doesn't even begin to describe this situation
<8> heh
<9> sound like a great design *cough*
<10> checkout: http://pastebin.com/746177
<10> that was 1 hour 50 minutes ago
<2> DATE_FORMAT( plandate, '%b %e%d, %Y' )
<2> why does that give me null?
<10> if memory serves he conned someone else in here into getting him that far
<2> ****!
<10> DATE_FORMAT( CURDATE(), '%b %e%d, %Y' ): May 3030, 2006
<2> i pick one of the very few rows that has 0000-00-00 instead of a real date
<2> friggin figures
<10> hehe
<6> nah i made that my self
<6> off a page i learned it from
<2> hmmm elaborate on the "learned" part
<6> aint no one helped me with anything in writing my scripts here, just gave me documatation explaining how to
<2> date format is YYYY-MM-DD right?
<8> yes
<2> why am i getting July 33rd as a date then
<8> magic
<2> me no like this magic
<9> GoSox: it's the secret date shhh!
<0> well maybe the data was entered on july 33 using a curdate() :P
<2> DATE_FORMAT( plandate, '%b %e%D, %Y' ) on "1957-07-03" gives me "Jul 33rd, 1957"
<2> am i missing something
<2> or is this thing totally messed up
<8> probably your format tokens are wrong
<8> oh
<2> oh %D includes the day
<2> GRRRRR
<8> get rid of %e, just %D
<2> php doesn't do it this way :-/
<8> it's putting "3" + "3rd"
<2> i see
<2> at least my code works right though :-)
<8> there's no ISO committee on format tokens ;)
<2> so i have a database with 10,400 records, each record has a street name as a text field. so i'm getting a list of all streets in the town, putting that in a database, then i'm going ot have to go through the entire 10,400 rows of the database, matching up the links
<2> all because they thought it would be a good idea to go from paper systems, to ms access
<0> :|
<0> people still think access is a good idea ? :|
Return to
#mysql
or
Go to some related
logs:
#gentoo
could not init font path element vectorlinux
dapper nvidiafb
#debian
asterisk@home linux noprobe
Composite extension enabled disabling direct rendering
optiplex gx1 sound ubuntu
#css
#bash
acml gentoo fetch
|
|