Cook

*bump*

Thanks all for the feedback. Keep it coming please. www.bizsox.com I am quite relieved to see that the first impression is good. There's a point where you get so involved in what you're doing that it blinds you and you can't judge for yourself any more. @redbullmarky: Glad you like it better. Re 'Sock it to me!', the comical effect is sought after, to grab attention; same for the slogan, the play on words contributes. I don't think it clashes with the target population. Actually if that target comprises of the (business)men themselves, but also - maybe even more so - their wives (and/or their moms?! ), it might work even better. At least that's the rationale. BTW, from a feature point of view, gift subscriptions will be the next enhancement. @steelmanronald06: Yes, that's the spirit of the site and service, 100%, with the added convenience of the subscription concept.

Hello, Ok, BizSox v2 is here! The last two weeks were spent redesigning it to take into account all the good feedback I got here. What do you think? www.bizsox.com All constructive feedback most welcome. Some comments: 1- Coded by hand, PHP + XHTML + CSS + little JS. 2- JS limited to strict minimum, always degrading nicely. 3- Uses Peterned's csshover.htc to enable css-driven menus in IE - thanks Peter! 4- Tested ok in Opera, FF, IE6, IE7, Safari, in several sizes - I dropped support for IE5.5, it's dead after all! 5- Best viewed in 1024 x 768 and above, not ok any more in 800 x 600, but that resolution is pretty much dead too! Thanks for taking the time. Cook

A few ideas Customer service - responsive - efficient - helpful - friendly - available 24/7 - forums Reliability - redundant infrastructure - raid arrays for account disks Software - PHP, MySQL, PostgreSQL, Perl, etc... - Script libraries - CPanel or other good account mgt GUI -- Cook

Thanks again everyone, it is great to get such useful feedback, really appreciate. A lot is going on right now to incorporate all of it, well, a good 90% of it. I won't part totally with the color scheme, but am adapting it by introducing one more color, much brighter. The little images at the top and bottom are gone. The text is limited to what value the service brings to the customers, in an easier-to-read way. News and good to know are gone, replaced with few words on the concept. The drop shadow around the page is gone. Well, quite a makeover. But these are just teasers, the new version should be online soon, give me a few more days. Thanks again, Cook

Check out ini's error_log, should point you to file where errors are... well, logged.

Thanks a lot for the very useful feedback everybody, I'm taking all of it on board and putting together a new look. Will post project when it's ready.

Good, this is good, that's a lot of feedback I can do something with. Thanks! Keep it coming. Here's the link again, just for convenience: www.bizsox.com

@rcorlew: Thanks! We do ship worldwide, but chose to set our prices are in USD anyway. @448191: That's a fair point and I'll keep it in mind. So far the response is on the positive side accross age groups. Yet I'll monitor according to your comment. Thank you. More critiques welcome: www.bizsox.com

Hello, After much effort indeed, my ebusiness lauched a few months ago. The last weeks have been spent fine-tuning everything, and the site is now quite complete. It needs critique! Positive, negative (constructive), any feedback is welcome. Some comments first though: 1- Entirely coded by hand, a to z, php+xhtml1.0+css+little JS. 2- JS limited to strict minimum, always degrading nicely. 3- Uses Peterned's csshover.htc to enable css-driven menus in IE (thanks Peter!) 4- As far as I could, tested ok in Opera, FF, IE5.5, IE6, IE7, Safari, in several sizes. 5- Best viewed in 1024 x 768 and above, but still ok in 800 x 600. www.bizsox.com Thanks for taking the time. Cook

That's because the script in your book relies on REGISTER_GLOBALS being turned on, when very likely your csetup has it off (default setting of PHP nowadays). Use $_REQUEST['username'] instead of just $username and it should work better. I used $_REQUEST because I don't remember if the default method for a form is GET or POST, so $_REQUEST will work either way. But better would be to specify the method in the <form> tag: print <<<HERE <form name="myform" method="post" action="$_SERVER['PHP_SELF']"> (...) Then you can use $_POST['username'].

A simple version: $query = "the query that hitman6003 gave you"; $result = mysql_query($query); while ($row = mysql_fetch_row($result)) {   list($field1, $field2, $field3) = $row;   // do stuff with data }

At the time I checked, your footer was a the bottom of the page. Problem solved?

Check out PHPlot.php ([url=http://www.phplot.com]http://www.phplot.com[/url]), a GNU-licensed package to plot all kinds of charts, fairly easy to use, helps you concentrate on conveying your message through good-looking charts rather than spending (wasting?) time on re-inventing the wheel.

No, for that you would have to use an if-else construct.

[!--quoteo(post=328422:date=Dec 19 2005, 06:06 AM:name=Kia)--][div class=\'quotetop\']QUOTE(Kia @ Dec 19 2005, 06:06 AM) 328422[/snapback][/div][div class=\'quotemain\'][!--quotec--] $query="INSERT INTO users (uid, username, password, first_name, last_name, country, email, last_paid, signup_date) VALUES ('','$susername', '$spassword', '$sfirst_name', '$slast_name', '$scountry', 'free', '$nowdate')"; mysql_query($query); I see two problems. 1- The number of values does not match the number of fields. 2- If uid is an auto-inc field, you're actually better off leaving it out of the list of fields (then of course you don't provide a value for it) and let MySQL take care of it automatically for you. And a comment: it is a good idea, and actually best practice, to enclose identifiers with backticks in MySQL queries, so that in case you're using a reserved MySQL word as an identifier, MySQL still treats it as an identifier and does not complain: $query = "INSERT INTO `users` (`username`, `password`, `first_name`, `last_name`, `country`, `email`, `last_paid`, `signup_date`) VALUES ('$susername', '$spassword', '$sfirst_name', '$slast_name', '$scountry', '$semail', 'free', '$nowdate')"; mysql_query($query); NB: I assumed email would be stored in $semail...

[!--quoteo(post=327441:date=Dec 14 2005, 11:45 PM:name=rockonxox)--][div class=\'quotetop\']QUOTE(rockonxox @ Dec 14 2005, 11:45 PM) 327441[/snapback][/div][div class=\'quotemain\'][!--quotec--] **Bump** Can anyone help... or do I need to explain myself better? Hopefully it's understandable!!! Your two links give me an HTTP 404...

[!--quoteo(post=325460:date=Dec 8 2005, 07:26 AM:name=android6011)--][div class=\'quotetop\']QUOTE(android6011 @ Dec 8 2005, 07:26 AM) 325460[/snapback][/div][div class=\'quotemain\'][!--quotec--] I have a colum in table memberinfo named emailadd . It is only a VARCHAR(25), how can I change it to be like VARCHAR(35)? [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']ALTER TABLE[/span] `mytable` CHANGE `mycolumn` `mycolumn` VARCHAR(35) [!--sql2--][/div][!--sql3--]

Or this: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] `field`, COUNT(`field`) AS `count` FROM `table` GROUP BY `field` ORDER BY `count` DESC LIMIT 1 [!--sql2--][/div][!--sql3--]

[!--quoteo(post=322999:date=Nov 29 2005, 06:00 PM:name=SemiApocalyptic)--][div class=\'quotetop\']QUOTE(SemiApocalyptic @ Nov 29 2005, 06:00 PM) 322999[/snapback][/div][div class=\'quotemain\'][!--quotec--] Is there a function in MySQL that you can use in a query to find the modal (most common) value. So if I had a column called age, and it held the values 12, 13, 13, 13, 12, 12, 11, 14, 14, 13 - The mode would be '13'. I'm thinking there must be an easy way to achieve this with a MySQL query rather than running all the results through a bunch of loops in PHP... As always, any help is very much appreciated. EDIT: I have just wrote a small function in PHP to work out the mode of an array of numbers, but I would still be interested if someone knows a way to do this with MySQL. Can not test this just now, but would this be a step in the right direction: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] MAX(COUNT(`field`)) FROM `table` GROUP BY `field` [!--sql2--][/div][!--sql3--]

You can do it by adding this to your .htaccess file: RewriteEngine on RewriteCond %{SERVER_PORT} ^80$ RewriteRule (.*) https://www.mydomain.com/$1 [L,R]

[!--quoteo(post=322761:date=Nov 28 2005, 11:56 PM:name=SemiApocalyptic)--][div class=\'quotetop\']QUOTE(SemiApocalyptic @ Nov 28 2005, 11:56 PM) 322761[/snapback][/div][div class=\'quotemain\'][!--quotec--] I'm referencing two tables in one query, but I only want to return distinct rows, heres what I have: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] DISTINCT(p.*) FROM products AS p, product_category AS pc WHERE $subs AND pc.productid=p.id AND p.featured='1' [!--sql2--][/div][!--sql3--]($subs just contains an extra bit of the query) With this query, I'm getting the error: As soon as I take out the DISTINCT(p.*) and replace it with just p.*, it works, but returns some duplicate rows... I'm obviously going wrong in my syntax above, anyone care to set me in the right direction? Hi SA, I think that just removing the brackets around p.* should do: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] DISTINCT `p`.* FROM `products` AS `p`, `product_category` AS `pc` WHERE $subs AND `pc`.`productid` = `p`.`id` AND `p`.`featured` = '1' [!--sql2--][/div][!--sql3--]

SELECT (`table1`.`car` + `table2`.`india`) AS `price_estimation` FROM `table1`, `table2` WHERE (some condition of yours)

SELECT * FROM `mytable` WHERE `mydatefield` > (NOW() - INTERVAL 20 DAY)

Well yes, but knowing a bit more about what exactly it is that you're trying to do would help to help you better. Anyway, try something like this: $query = "SELECT COUNT(*) AS `mycount` FROM `mytable` WHERE (some condition of yours)"; $result = mysql_query($query); $row = mysql_fetch_assoc($result); echo $row['mycount'];