[PHP-DB] Searching everything?

Is there any way to search *every*thing in my database (using mysql)? I am thinking of a query somethng like "select * from * where * LIKE '%putsearchhere%'". This would help a lot when searching for inappropriate language. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] loop?

You can just echo out during your while loop - or build a display block and echo it all at once. > Not quite sure how to get this piece of code to loop > through the records and > echo them back one line per one record... > session_start(); > if (isset($HTTP_SESSION_VARS['var01']) || > isset($HT

[PHP-DB] loop?

Not quite sure how to get this piece of code to loop through the records and echo them back one line per one record... Echo record set... Any help would be great! thanks Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php.ini Question

On Friday 24 May 2002 20:35, Daz wrote: > Hi > > could anyone point me in the right direction please?? Yes, but there's no need to post twice. > I needed to use php to upload some large files into mysql and reading > through previous posts saw that the php.ini file has a default entry > limit o

Re: [PHP-DB] php.ini Question

First, I would recommend that you not try to load files directly into MySQL. rather, upload the file to a directory with full permissions and just insert the link to the file into your database. I do this for several clients and have found it to work very efficiently, even to uploading huge gr

[PHP-DB] Sub queries in MySQL

I want to run a query to fetch out a navigation menu on a site I am working on. I always have paranoia of destroying the db with ineffecient queries... Now, as I understand it, sub-queries is a bad thing. They are very slow in MySQL?? This menu I am making will be displayed on each page the user

RE: [PHP-DB] Weird Distinct bug?

Hi Chris, Try SELECT COUNT(DISTINCT(property_name)) . Gurhan -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 6:28 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Weird Distinct bug? Hi there everyone, On my linux server I am using: MySQL 3

[PHP-DB] php.ini Question

Hi could anyone point me in the right direction please?? I needed to use php to upload some large files into mysql and reading through previous posts saw that the php.ini file has a default entry limit of 2M... this explained why small files were ok but not large ones... OK.. but I didnt hav

[PHP-DB] php.ini Question

Hi could anyone point me in the right direction please?? I needed to use php to upload some large files into mysql and reading through previous posts saw that the php.ini file has a default entry limit of 2M... this explained why small files were ok but not large ones... OK.. but I didnt hav

[PHP-DB] Sub queries...

I want to run a query to fetch out a navigation menu on a site I am working on. I always have paranoia of destroying the db with ineffecient queries... Now, as I understand it, sub-queries is a bad thing. They are very slow in MySQL?? This menu I am making will be displayed on each page the user

Re: [PHP-DB] Re: how can i get field-informationof a table?

On Friday 24 May 2002 17:09, Stephen Rhodes wrote: > use the function mysql_list_fields in url > http://www.php.net/manual/en/function.mysql-list-fields.php I'm sure you meant: mssql_fetch_field() > "Hermann Otteneder" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROT

[PHP-DB] Re: how can i get field-informationof a table?

use the function mysql_list_fields in url http://www.php.net/manual/en/function.mysql-list-fields.php Cheers Steve "Hermann Otteneder" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > hi, > i'm using a mssql-database. now i want update a record with the informa

[PHP-DB] how can i get field-informationof a table?

hi, i'm using a mssql-database. now i want update a record with the information given in a form. i want use the following sql statement: $SQL = "update set '' = 'HTTP_POST_VARS[$index]' WHERE PKID = 'HTTP_POST_VARS[0]'"; mssql_query($SQL); my problem is i cannot find a function which gives me an

Re: [PHP-DB] Retrieving a date from Oracle. Please help!

Thank you ALL! It turned out that setting NLS_DATE_FORMAT environment variable is enough to solve the problem. It's possible to get it worked right from PHP code, for instance: putenv("NLS_DATE_FORMAT=HH24:MI:SS DD.MM."); PS> TO_DATE function didn't help I didn't try to ALTER SESSION

[PHP-DB] Weird Distinct bug?

Hi there everyone, On my linux server I am using: MySQL 3.22.32 Whereas on my Local server I am using MySQL 3.23.42 (Or 43.don't remember). Anyway, I am having a wierd but major problem, if I do the code like the following locally it WORKS, if I do it on the server with the slightly old MySQL