Re: [PHP-DB] HELP NEEDED! SELECT of Text Fields in MS SQL Server 7.0 Limitatio n
Don't have any suggestions, but have these questions been asked: Presumably your query works just fine at the SQL Server console? What happens - the first 8k display, and then the rest of your page appears? Or do you get an error message? Timeout? What do you get? Are you hitting an array size limit? String size limit? Can you skip over the first 8k and fetch the remaining 8k? No answers, but some of these questions may turn up something. Miles Thompson At 12:47 PM 12/15/2001 -0600, Niko Spyridonos wrote: When trying to extract the contents of a text field in MS SQL Server 7.0 with PHP 4.0, I can only get up to about 8,000 characters of text out of them. Has anyone achieved to pull more data using PHP and if yes how? Thanks in advance. Niko Spyridonos Director of E-Business Services Chamerlik/CompuLogic http://www.designtech1.com/ T: (847) 679-5030 ext. 201 F: (847) 933-9413 C: (847) 980-7799 - Chamerlik/CompuLogic is standing strong against terrorism! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Query Help
Hi people, I have a small problem with a select cause that I need to use. I basically need the following. Select * from table where page =3D=3D page_name The fields in the db are code,description,unit,price,category,minor_category Then the display needs to be something along the lines of Category Name Minor Category Code Description Unit Price Minor Category Code Description Unit Price Category Name Minor Category Code Description Unit Price The number of minor categories differ for each of the categories, as to = do the number of products in each minor_category. I could hard code in the Category Names, however, they are meant to be = dynamic as they will be changing on a monthly basis. Any help would be appreciated. Thanks Shannon ___ Shannon Doyle Web Design Consultant BIGBLUE Internet Pty Ltd 149 Hutt St, Adelaide SA 5000 Ph +61 8 8232 1444 Fax +61 8 8232 8577 http://www.bigblue.net.au -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] phpmyadmin user grants
I have a user xyz. I want xyz to able to see table ccl.main_table I go to user xyz's grants I select the database ccl I select the table main_table what do I grant him so he can see but not change or harm ccl.main_table ? An email post reply is always helpful, Thanks John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Populating a MySQL database
I need a script that will populate a MySQL database with mostly random data (without crashing my box) with fields such as firstname, lastname etc. (i.e., I would want some fields to be just ints and some to have chars). Can someone point me in the right direction? thanks, -p -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Populating a MySQL database
look at the mysql_insert() function and then look at the comments for the function mt_rand() Pjc [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I need a script that will populate a MySQL database with mostly random data (without crashing my box) with fields such as firstname, lastname etc. (i.e., I would want some fields to be just ints and some to have chars). Can someone point me in the right direction? thanks, -p -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] search string in text file
On Monday 17 December 2001 15:11, Sommai Fongnamthip wrote: Hi, How could search string (like full text search) in any text file (even know or not known filename)? One way of doing this if you're using a Linux/Unix system is: $files = `grep -R search_string /path/of/directory/to/search/*`; $files would then contain the list of files in which search_string was found. hth -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Absence is to love what wind is to fire. It extinguishes the small, it enkindles the great. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] search string in text file
On Monday 17 December 2001 15:52, Jason Wong wrote: On Monday 17 December 2001 15:11, Sommai Fongnamthip wrote: Hi, How could search string (like full text search) in any text file (even know or not known filename)? One way of doing this if you're using a Linux/Unix system is: $files = `grep -R search_string /path/of/directory/to/search/*`; $files would then contain the list of files in which search_string was found. Sorry that should be: $files = `grep -r search_string /path/of/directory/to/search/*`; -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Love is the only game that is not called on account of darkness. -- M. Hirschfield */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]