benW

Use MySQL\'s built in random function $sql = mysql_query("SELECT col1, col2, col3, col4 FROM table WHERE col2 = \'$a\' or col3 = \'$b\' or col4 = \'$ip\' ORDER BY rand() limit 0,6") or die(mysql_error())

Not sure what you\'re trying to do but here you go. [php:1:06593fc386]<?php SELECT TOTAL(points) AS Total FROM table; ?>[/php:1:06593fc386] OR [php:1:06593fc386]<?php //Choose year range $year_range = \'2001, 2002\'; SELECT TOTAL(points) AS Total FROM table WHERE (year IN (\".$year_range.\")); ?>[/php:1:06593fc386]

I am so tierd of seeing people get ripped off by cheap, buggy, crap code writers. One of my clients purchased a script similar to the one you did. He paid $199USD for the dating site scripts. $50 USD for a search by zipcode function and $99 USD for a chat module plugin. Not one thing worked correctally the scripts were poorly designed full of code errors and incomplete MySQL statments. The search by zip code function is completely useless(did\'nt work without rewriting the code). And finally the chat script which was not programed by the same rip-off artist that wrote the original buggy code did not work either. All together the gentalmen paid about $350USD to a kid in New York for a complete junky, defective codebase. I have a big heart and felt really bad for the guy so I only charged him 1/2 my rate and 1/2 the hours I worked. I figured he already learned his lesson. And for all who decide to buy code from greedy programers buyer beware! Make sure you research before you buy. Also remember to search for open source software before you buy it. http://sourceforge.net/projects/mycommunity/ 3 minutes on sourceforge.net and I found an all-in-one dating, chatting, polling, etc sytem. http://www.webscribble.com is the place with all the bad buggy scripts. http://www.webscribble.com/forum/viewtopic.php?t=149 There\'s plenty more of the above thread.

Hi there most shared hosts will let you have acces to phpmyadmin. This is the most common way to get there via shared hosting accounts. http://www.yourdomain.com/phpMyAdmin/index.php If it works try your user and pass that you signed up your shared hosting account. note the capital M & A this is default don\'t use myadmin. If this does\'nt work send your hosting co an email and ask them what to do

Try using BLOB or TEXT instead of VARCHAR

I would use something like: [php:1:97f8fee0cf]<?php $unique = microtime(); $randstr = md5($unique); $randstr = substr(\"$randstr\", 0,10); print \"\".$randstr.\"<br />\"; $randpass = md5($randstr); $randpass = substr(\"$randpass\", 0,10); print $randpass; ?>[/php:1:97f8fee0cf]

Why would you want to reuse a deleted key? Your request can not be done. There is no reason to delete a key and re create it. When you create an auto increment table it\'s use 99% of the time it\'s used as an easy way to do DELETE and UPDATE, SORT BY, (ASC, DESC) etc. SQL statements. Try to re think if you you really need to do these things. I\'ll bet not

No MySQL server would crash displaying song lyrics. MySQL could probably hold all the lyrics to all the songs for the past 10 years and still have room for more info! I think your problem goes far beyond any DB probs, your code must be keeping conns open or opening too many. Request what you\'re trying to do more clear and me, or the people here and you get the help you need. http://www.mysql.com/doc/en/ http://www.php.net/manual/en/ref.mysql.php

Here you go! http://forums.phpfreaks.com/viewtopic.php?p=6429#6429