Jump to content

vchris

Members
  • Posts

    1,529
  • Joined

  • Last visited

Everything posted by vchris

  1. vchris

    explode()

    How can I explode every character in a string? I want to add dashes in a phone number if there aren't any. If I get something like 1231231234, I want it to become 123-123-1234. I figured exploding the string would be one way but I can't find out how to explode everything. If there is a better let me know.
  2. vchris

    DB Design help

    That would be one way of doing it. I was thinking of a way to get a feed from UPS or some other company to get the cost for the shipping.edit: On another note. When checking out, I ask the customer to enter his shipping name/address and also his billing name/address. The problem is that this database doesn't support that or it would be complicated. Should it just be 1 name but 2 addresses (shipping/billing)?
  3. vchris

    DB Design help

    What is the best way to get an automated shipping quote?
  4. vchris

    My first site :)

    The colour scheme is great but I think the banner and footer could use a bit more work.
  5. vchris

    DB Design help

    Yes very much, thanks!
  6. vchris

    DB Design help

    Ok so then if I use your method with 2 address lines then I wouldn't need the city, zip code, country field right? What should the 2 line hold? Line1: 1 Test Street, Line2: ?
  7. vchris

    DB Design help

    I'm almost seeing the end of this project but have 2 questions.In my oe_product_attribute table I added pra_special_flag, pra_special_start_date, pra_special_end_date. Then if I want to display products on special, I simple check the pra_special_flag. The problem is how can I have the pra_special_flag change to 0 when the pra_special_end_date is passed?skemcin: you know how I have the cu_address table with adr_line1 and adr_line2. Wouldn't it be better to have one field for each line information (street number, street name, apartment, province/state...)?
  8. Most, if not all, sites I create are bilingual. My system is for example English language pages will be index_e.html and French would be index_f.html all in the root folder. Same for images and more... Works great.
  9. For the time you spend discussing, planning, creating the website it's not worth it. It'll take you what maybe 3-5 hours from start to end. Which is as low as $6/hour. Hmmm no thanks I'll stick with my $30/h.
  10. tr:hover will highlight the whole row not just a single cell like td:hover will do.
  11. Are you saying you plan on taking over the interweb in 2009? That's terrorist talk!
  12. Document size is 320kb, at least get it under 50kb.
  13. http://css.maxdesign.com.au/listamatic/pretty basic but you elaborate.
  14. hmmm yes but some of those were at my old work place where this guy was helping me and he didn't even know what he was doing :)Some others are not interested in paying for a site so they try to do it themselves.
  15. lolI'm just saying I've met a lot of people who wanted changes done to a page but didn't even know what html was. DW would be the tool I would recommend for them to use. But if you're into programming then I wouldn't recommend any wysiwyg editors unless you don't want to get better at what you do.
  16. Use a popular forum: phpbb, vbulletin, IPB...
  17. That's all true for programmers but for someone who simply wants to modify content (text, images...) dreamweaver does a great job (most of the time).
  18. vchris

    DB Design help

    How would I then insert a new product? I know I have to do my insert in the products table first so I can then query for the new product id which I will then enter in the media and attribute table. But can I have a select statement in my insert statement?
  19. Tried to view it at work but no flash installed so couldn't view anything except the navigation bar...
  20. vchris

    DB Design help

    Not sure if php can do this but I managed to do an if statement in my while loop. If the category name is the same as the previous category name then don't display it. Works but there is probably a better way to do this...
  21. vchris

    DB Design help

    How would I display this:category 1item 1item 2category 2item 1...Here's what I have: $getAcc = "SELECT prd_id, prd_name_e, cat_name_eFROM oe_product, oe_product_category, oe_product_x_categoryWHERE prd_id = pxc_prd_idAND pxc_cat_id = cat_idGROUP BY cat_idORDER BY cat_name_e"; also: $getAcc = "SELECT prd_id, prd_name_e, cat_name_eFROM oe_productJOIN oe_product_x_category ON prd_id = pxc_prd_idJOIN oe_product_category ON cat_id = pxc_cat_idGROUP BY cat_name_eORDER BY cat_name_e";
  22. I'm in the Ottawa area. I don't care if I lose my job, I know I can find one within hours. I always have agencies call me all the time for jobs. They're not great jobs but still I know I'll always have money coming in. That doesn't include my side projects for clients.
  23. vchris

    DB Design help

    I would think that when deleting a category it should delete all products. That doesn't mean you can't then move those products to another category. I could probably have an option to move all products in category being deleted to a new category or something, I don't know. Do you have a better idea?
  24. If you have some experience should take no more than 1 week. An easy way, over here anyway, is to apply with an agency and they get you a job in the private or public sector whatever suits you.
×
×
  • Create New...