[PHP-DB] Fw: search question

Hi, Is there any other efficient way (--except using LIKE)of searching a keyword in mysql ... thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting a list of MSSQL databases

Thanks That will work for me Dan Ryan Jameson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... I believe you'll have to do this: select * from master.sysdatabases :-) Ryan -Original Message- From: Dan Healy [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 15, 2002

RE: [PHP-DB] search question

it depends on how you design your database. When I know I will have this situation, I design a table named keyWords. Put one work per record and assign each word an ID number. Then I create a join table between keyWords and whatever table they relate to. The join table only contains 2 fields,

RE: [PHP-DB] search question

You could check out the FULLTEXT searching in MySQL, too. It's in the manual. It has some quirks, but works well on a large database. ---John Holmes... -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 8:04 AM To: Meltem Demirkus; [EMAIL

Re: [PHP-DB] Trying to speed up php output from mysql

Does your process hang or simply is too long? Perhaps the limiting factor is not the writing speed, but a memory requirement problem. Try to compute how long it should take: - do your row processing after a SELECT ... LIMIT 1000 clause - time how long it takes, and extrapolate Then you will

Re: [PHP-DB] to determine how much server space left on the webserver?

?php exec(df -h); ? On Tue, 17 Sep 2002, Bo wrote: Any ideas of how to write a php script to determine the disk space left in my account at my web server? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] to determine how much server space left on the webserver?

?php echo `quota -v`; ? this works here. On Tue, 17 Sep 2002, Bo wrote: Any ideas of how to write a php script to determine the disk space left in my account at my web server? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] to determine how much server space left on the webserver?

actually make that system(df -h); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] input 's id and name -- question...

does the id attribute of an input tag override the name attribute when trying to pull these vales on a subsequent php page? Does it make any difference? I ask cause I'm now PHP-ifing a form I designed in Dreamweaver and it added ids attributes all over the place. Wonder if I should edit them,

[PHP-DB] onnecting to MSSQL database from Linux?

I have PHP4 and freetds installed and I am trying to connect to a mssql server. The problem I am having is that the mssql_connect() call generates the following error: Fatal error: Call to undefined function: mssql_connect() Is there something I need to require? Thanks, Avi -- Avi Schwartz

[PHP-DB] Re: Fw: search question

http://www.mysql.com/doc/en/Fulltext_Search.html On Tue, 17 Sep 2002 20:34:37 +1200, Meltem Demirkus wrote: Hi, Is there any other efficient way (--except using LIKE)of searching a keyword in mysql ... thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] PHP and Mail under Apache Windows?

Hi there everyone, I've just setup Apache 2.0 under Windows XP and LOVE it, PHP and MySQL work fine and people are saying how fast the server is. However, I am stumped on one thing - how the heck does I set it up so Mail will work? With my old server (Linux) it was already configured, but

[PHP-DB] Re: onnecting to MSSQL database from Linux?

It means you haven't compiled mysql support into php. Recompile it using --with-mysql -- Jason Morehouse (jm[@]netconcepts[.]com) Auckland, New Zealand Linux: Because rebooting is for adding hardware. On Tue, 17 Sep 2002 15:30:29 +, Avi Schwartz wrote: I have PHP4 and freetds installed

Re: [PHP-DB] Re: onnecting to MSSQL database from Linux?

He's using microsoft sql server, not mysql. try --with-mssql maybe? Adam On Wed, 18 Sep 2002, Jason Morehouse wrote: It means you haven't compiled mysql support into php. Recompile it using --with-mysql -- Jason Morehouse (jm[@]netconcepts[.]com) Auckland, New

Re: [PHP-DB] Re: onnecting to MSSQL database from Linux?

I did build it with --with-sybase, but then I forgot to install the new version. Face turning red... Sorry for the false alarm. It now works like a charm. Avi Adam Williams wrote: He's using microsoft sql server, not mysql. try --with-mssql On Wed, 18 Sep 2002, Jason Morehouse

[PHP-DB] Read Receipts

Just a small suggestion guys, but when posting messages to a mailling list, it's always a *good* idea to turn off the Read Request option!!! Thanks, -gav. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Selecting one random column from MySQL

Hi all, How can I select one random column from a MySQL table? Thanks, Taj -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] input 's id and name -- question...

nope - an id is used for other things (like javascript, style sheets, DHTML etc). They shouldn't affect your variable names. HTH Beau // -Original Message- // From: Michael Zornek [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 18 September 2002 6:41 AM // To: [EMAIL PROTECTED] //

[PHP-DB] Resubmit on page refresh.

I have a page that maintains a very simple list of items. The page shows the current items on the list and provides an input field for the user to add new items to the list. Everything works great. The only problem I'm having is that each time the user clicks the Refresh button on the browser, I

RE: [PHP-DB] Selecting one random column from MySQL

How can I select one random column from a MySQL table? You can't, in one query. You can use the MySQL_ function to get a list of all the columns, though, and then use PHP to select a random column and construct an SQL statement. If you need to do something like this, though, there is

RE: [PHP-DB] Resubmit on page refresh.

I really hope you just subscribed, because this question already been asked today...and yesterday... You should search the archive before you post. Anyhow, the solution to your problem can be solved by using a processing page that does the insert into the database and then redirects to the main

[PHP-DB] Re: oscommerce

Yes, it is an amazing project. The main team of developers are very talented and there are new contributions made daily. Checkout the snapshot release, it's extremely feature packed. It is by far the best shop system I have ever dealt with, let alone being open source, good stuff.

RE: [PHP-DB] question regarding date format

Jim, Mike : thanks for reply. getting desire result with strtotime. John, yess u r right. sometimes in my script date is coming from database. in that case, use of DATE_FORMAT() is the best option. thanks smita. From: Ford, Mike [LSS] [EMAIL PROTECTED] To: 'Smita Manohar'