[How to use GROUP BY or other solution to MySQL list]

Please provide only relevant code.

 

You are probably looking for a DISTINCT query...

 

http://www.mysql.com/distinct

 

But I am too lazy / don't care enough to dig through all the code to find where your query is.

[Delete oldest information, to keep database small]

You may be able to use something like this:

 

DELETE FROM discuss
WHERE dtime < (SELECT dtime FROM discuss ORDER BY dtime DESC LIMIT 30, 1)

 

 

[[SOLVED] Get last modified time of remote file during upload]

cURL is basically a command line web client.  It has some other functionality, but unless the client files are actually files on another web server, then it won't work.

[[SOLVED] Seeding Random "rand()" function]

As the php manual states:

 

Note: As of PHP 4.2.0, there is no need to seed the random number generator with srand() or mt_srand() as this is now done automatically.

 

http://www.php.net/srand

[Please help]

Those are data (*.MYD) and index (*.MYI) files for a mysql table.  if you delete them, it will delete the mysql table (and probably screw with the database as well).  If you need to shrink them, remove some data from the table.

 

If the table is no longer inserted into (i.e. it's read only) you can use myisampack to compress it.

 

You can try and OPTIMIZE the table, but you probably won't get much improvement.

 

http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html

[varbinary handling]

try casting the varbinary variable to varbinary in the sql query...

 

SELECT * FROM tablename WHERE varbinary_column = CAST('$varbinary_php_var' AS varbinary)

[Export to Excel]

Straight from the MySQL manual:

 

 SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM test_table;

 

Creates a csv file that is readable by Excel.

 

http://www.mysql.com/select#id1949480

[AddType error with php installation]

Is mod_mime enabled?

[error creating table]

you could enclose the "order" in backticks ( ` ... not a single quote ), but as fenway suggested, choosing column names that are not reserved words is by far the best choice.

 

http://www.mysql.com/identifiers

[phpMyAdmin help please]

Worth a try:

 

SELECT DATABASE() AS project_id, name
FROM db1.assertion, db2.assertion

[[SOLVED] mysql complete syntax]

see http://www.mysql.com/identifiers

[select where best possible match]

Fulltext indexing.

 

http://www.mysql.com/fulltext

[file() command problem]

what error does it give when it fails?

[searching for ' ']

if ($search_string == "" || str_replace(' ', '', $search_string) == "") {
  echo 'You must enter a search term';
}

[Creating a search function?]

He doesn't need a FULLTEXT for his "basic search".  I use FULLTEXT for most of my searches, but this one is so simple that it's almost complete overkill.

 

He never stated it was a "simple search".  If all content on the site is considered "news", then search becomes vital.  Inaccurate search is worse than no search in most cases, so fulltext indexing may be the best solution.

[Creating a search function?]

What storage engine are you using?  MyISAM (and Falcon and Maria) all have builtin full text indexing, which is a VAST improvement over the 'WHERE column LIKE "%word%"' SQL queries.

 

Aside from using one of the above storage engines (Falcon and Maria are MySQL 6 only at the moment, so it's MyISAM or bust) you can use an external full text indexer...Lucene, sphinx, etc.

[[SOLVED] Code Snippet To List Directory Contents -- Need Help Displaying Data]

add a "<br />" at the end of each file link...

 

 $thelist .= '<a href="'.$file.'">'.$file.'</a><br />';

[Grab index of array result easily?]

Why not return the element you want?

 

function doSomething( $element = null ){
  $arr[] = 'something';
  $arr[] = 'something_else';

  // return the entire array if no element is specified
  // else return the specified element
  return (is_null($element) ? $arr : $arr[$element]);
}

echo doSomething( 0 );

 

You could also make an object out of it and address it that way...

[[SOLVED] Get last modified time of remote file during upload]

Your server, and consequentially PHP, doesn't have access to the remote file until it's uploaded.  Your only hope is javascript (or some other client side script...vbscript, etc), and I'm pretty sure it's sandboxed so that what you are asking won't work (I could be wrong though).

[[SOLVED] fclose not releasing write lock on Fedora?]

It's probably not a "write lock" on the file, but a permission issue. 

 

Whenever a file is on the desktop that you don't have permissions on, it shows up with a lock (su to root, set the umask to 077 and create a file on the logged in user's desktop...you'll see the same lock on the icon).  Add yourself to the same group as the apache user and make sure the group has read/write permissions.  Or chmod the file (as root) to 777, then see if the lock goes away.

[Count number of words in a field]

There is a bit of a workaround...

 

-- essentially we are determining the number of spaces in the string (by subtracting the length
-- of the string without spaces from the length with) and dividing the number of spaces into the 
-- total number of characters 
SELECT LENGTH(column_name) / (LENGTH(column_name) - LENGTH(REPLACE(column_name, ' ', ''))) AS num_of_words
FROM table_name

 

It's not 100% accurate, but it'll pass.

[echo not displaying and updating database not working]

Then you probably have a syntax error somewhere in your script.

 

Make sure display_startup_errors is turned on.

[Extract .tar.bz2]

http://en.wikipedia.org/wiki/Secure_Shell

[how to invite ALL of contacts from Google, Yahoo & MSN]

http://www.google.com/search?hl=en&q=gmail+buddies+list+api

http://www.google.com/search?hl=en&q=yahoo+messenger+api

[echo not displaying and updating database not working]

http://www.phpfreaks.com/forums/index.php/topic,194542.msg876099.html#msg876099