[PHP-DB] MSSQL 6.5 IIS6 PHP 5

gets a MSSQL Connect Failed message. The SQL Server is running SQL authentication only, not mixed or NT. It doesn't make any sense to me. Both environments are running PHP 5.1.6 Thanks for your help Larry Wickham [EMAIL PROTECTED] Systems Operations Specialist Eastern New Mexico University 1

[PHP-DB] mysql rereading result set (fetch_assoc)

I'm running thru a result set using fetch_assoc. Now I want to run through it again. How? TIA, Larry Woods -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsu

[PHP-DB] MSSQL 6.5 IIS6 PHP 5

gets a MSSQL Connect Failed message. The SQL Server is running SQL authentication only, not mixed or NT. It doesn't make any sense to me. Both environments are running PHP 5.1.6 Thanks for your help Larry Wickham [EMAIL PROTECTED] Systems Operations Specialist Eastern New Mexico University 1

Re: [PHP-DB] Displaying data in different languages

Functions like CONVERT(), and there is a MySQL equivalent, will change the character set of some text. It WILL NOT change text from English to Japanese. As another person noted, you'll need to stored the string in both languages. There is no translator available. Larry On May 14, 200

Re: [PHP-DB] Passwords

something. Just so it is not in plain text. Of course. Check out any of MySQL's encryption functions. Make sure that you use the same function and parameters for both the registration and the login or else the login will never work. Larry -- PHP Database Mailing List (http://www.ph

[PHP-DB] Bit(1) datatype from mySQL

Member in the SQL select, but this is a bit of a pain. Any thoughts? Thanks Larry Bradley Orleans (Ottawa), Ontario, CANADA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connecting to two MySQL databases

omitted, then PHP will do exactly what you are describing. If set, then PHP will create a new connection, even if the same username/ password/host combination is being used. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connecting to two MySQL databases

ught. Also, just to be safe, you could use the new link argument in mysql_connect() (the 4th argument) to insure a new, separate connection. Hope that helps, Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] oracle complex type and oci_new_collection

Seriously, how many times are you going to send this email to the list? I've seen it at least 5 times now in the past day, all the same email under slightly different FROM and subjects. Send an email once. If someone can answer, they will. On Sep 28, 2005, at 10:18 AM, Hal McFarlane wrote:

Re: [PHP-DB] URL Forwarding in PHP...

How can I automatically forward to an external URL using PHP? header('Location: http://espn.go.com'); exit; Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] what is the value of session_register

elieve (possibly 4.2), session_register() is how one added elements to the session. This is before the $_SESSION variable existed. So the "value" of the function is storing session data, although that method is deprecated. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscr

[PHP-DB] group by day

M mgrtft 2005-06-21 07:46:00 M Larry Sandwick Sarreid, Ltd. www.sarreid.com Network/System Administrator P:(252) 291-1414 223 F:(252) 237-1592 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Batch queries in the same mysql_query()

rk using mysql_query() ? Because the mysql client and PHP's mysql_query() functions are two different things that behave somewhat differently. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] group by date only

hultz 2005-06-21 08:07:00 M mgrtft 2005-06-21 07:46:00 M Larry Sandwick Sarreid, Ltd. www.sarreid.com Network/System Administrator P:(252) 291-1414 223 F:(252) 237-1592

Re: [PHP-DB] Why not ?

Why does this NOT work? UPDATE tipping SET score = 3 WHERE round1.game1 = H AND tipping.username = jerry; For starters, you should quote strings in a query. There may also be a problem with the round1 reference. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] MySQL - Query within a query

$LeagueList ON Drivers.DriverID = $Result1.DriverID WHERE $Result1.DriverID) Is Null ORDER BY Drivers.DriverID"); If you're using MySQL 4.1, which supports subqueries, you might be able to write this all up as one nice query (using a sub-select). Larry -- PHP Database Mailing List (http://www

[PHP-DB] Bad Search Results from Query

name, phone, email, csr, line, picture, notes, id from address where MATCH(notes) AGAINST ('\"$terr\"') " ); Any help would be appreciated. DB = MySql version 3.23.47 Code = PHP 4.2.0 OS = RedHat Larry Sandwick Sarreid, Ltd. Network/

Re: [PHP-DB] '

When I submit my forms, if any textfield contains a ' the result comes back with /' Is there anyway of stopping this? Yes, either: - turn off Magic Quotes GPC or - use stripslashes() Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] auto_increment

in your auto increment sequence shouldn't be a problem. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mac and mysql

ess? OS 9 does NOT have a command prompt but OS X does, accessible through Applications > Utilities > Terminal. Hope that helps, Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] No Cookies file created on Client

uot;); setcookie("account", $account, time()+300, "/"); setcookie("dealer", $dealer, time()+300, "/"); Any comments or suggestions would be appreciated ! Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414

Re: [PHP-DB] What's wrong with this QUERY??

u don't really need to select the email value since you should already have it. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] howto get PK id after INSERT??

ncode to pull cust record? Use the appropriately named mysql_insert_id() function. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP use in Federal Govt

I've taught a number of courses on PHP to members of the National Forest service (under the USDA). They use it to interact with Oracle databases for both Internet and Intranet pages. Hope that helps, Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

Re: [PHP-DB] Random select -- Where am I going wrong?

music"; } This is because you're printing $music--which is the resource ID--when you should be working with $row. Also, you're going to need to actually print $row[0] or $row['column'], not just $row. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql_fetch_object

I'm using $row = mysql_fetch_object and I can reference column names by $row->name but how do I reference a pseudo column (that I make, like substring( name from 1 ))? Use an alias in your query: SELECT column, DATE_FORMAT('%m', date_column) AS d FROM table ... $row->d

Re: [PHP-DB] Call to undefined function mysql_connect()

But i received "Call to undefined function mysql_connect() on line 5" Can anyone help me? Your PHP installation apparently does not support MySQL. You can confirm this by running a phpinfo() script. You may need to reinstall/recompile PHP. Larry -- PHP Database Mailing List (http://w

Re: [PHP-DB] Auto increament

keys, unsigned, not null integers. For MySQL, in particular, you define a field as auto increment by using AUTO_INCREMENT. Again, you can see the manual for more. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] regular expression help

die ("You must have a number between 2 letters in your password ... 0-9"); // Larry -Original Message- From: Matt Matijevich [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] regular expression hel

[PHP-DB] regular expression help

You must have a number between 2 letters in your password ... 0-9"); } Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592 _ My Inbox is protected by SPAMfighter 2224 spam mails have been blocked s

Re: [PHP-DB] Mysql not receiving the data

works on a new install, I can only assume that your code was written with the assumption that register_globals was turned on and it's not on in your current configuration. If that is the case, see the PHP manual or search the Web for the solution ($_POST, $_GET, etc.). Larry -- PHP Dat

Re: [PHP-DB] password () function.

Is this function, password() available at PHP Ander Windows? I get an undefinied function error message! There is no PASSWORD() function in PHP. There is, however, a PASSWORD() function in MySQL and other database applications. Larry PS It looks like you hijacked someone else's thread, whic

Re: [PHP-DB] SQL question!

not be exactly right but that's the basic idea. Adding a user ID foreign key to the comments table is the important part. Hope that helps, Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] ODD results - help please

select a.name, b.category_id cat, b.name category, e.category_id jcncat, b.typecattype from tblCompany a, tblCategory b,jcnCategoryCompany e where ((e.company_id = a.company_id and b.category_id = e.category_id and b.type <> 'NONE')         or b.type = 'NONE') and a.company_id <> 1 group

Re: [PHP-DB] Rounding

6.11 --> 6.2 6.15 --> 6.2 6.19 --> 6.2 6.20 --> 6.2 i know there is a ceil() function but that rounds up to the nearest integer.. i need one decimal place still.. If my math is right, you could multiply the number by ten, take the CEILING(), then divide that by 10. Larry --

RE: [PHP-DB] How to redirect after a valid login

Here is the error I get when I use the include below: include "MainMenu.php"; Fatal error: Cannot redeclare class db in /tmp/disk/home/webmaster/Files/WWW/pearDB/DB.php on line 211 // Larry -Original Message- From: Benjamin [mailto:[EMAIL PROTECTED] Sent: Saturday, Marc

RE: [PHP-DB] How to redirect after a valid login

What is considered to be the headers() information When I use the header() functions, I get an error stating that I have already sent the headers information? // Larry -Original Message- From: Larry E. Ullman [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:04 PM To

Re: [PHP-DB] How to redirect after a valid login

Is there a way that after a execution of a Login script and validation of login from a MySql database to automatically redirected to run another script ? Use PHP's header() function. See the manual for syntax. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] How to redirect after a valid login

gt;http://www.example.com/InVoice/MainMenu.php?r=$a);"; /* Redirect browser */ Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592

[PHP-DB] Community Site for HELP and IDEAS

I am putting up a community site to help the php-db community.   The site is http://lampware.org/   It has links, forums, news, and an assortment of other things all related to Linux Apache MySQL and PHP  (for short LAMP).   If we all contribute even a little I am sure the site will grow into a

[PHP-DB] Drop down box NOT populated

o "\n"; echo "\n";   while ($row = mysql_fetch_array($sql))   {   echo ' '.$row["account"]."\n";     } echo "\n";   ?>   [end snip]     Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax  : (252) 237-1592  

Re: [PHP-DB] breaking apart data

t> $str = "asdf asdf sadl jf lsakdjf a \r\n asdfierw aweiufasd asiuwr \r\nasdhfauiweuhrahsd \r\n";</tt><br> <br> <tt> array_walk( explode( "\r\n", $str ), 'bulletElements' );</tt><br> <br> <tt> That should do the tr

Re: [PHP-DB] breaking apart data

duh (me) okay... I am wanting to wrap the lines of text in bullets and perform some text formatting on it (highlight, bold, underling, etc..) using css classes At 11:12 AM 1/20/2004, you wrote: From: "Larry R. Sieting" <[EMAIL PROTECTED]> > what would be the most effi

[PHP-DB] breaking apart data

to highlight parts of the above. Larry R. Sieting -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] file date upload

the upload information.Jan 5, 2004 ? Any help would be appreciated ! Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592

[PHP-DB] Query Problem

ate from table where number = 100 I need to be able to pull the $$ amount totals by company name for status equal to HELD and OPEN . Result Company A OPEN HELD 1233100.0050.00 Any suggestion would be appreciated. Larry S

[PHP-DB] Query Sum problem

sult Company A OPEN HELD 1233100.0050.00 Any suggestion would be appreciated. Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592

Re: [PHP-DB] anyone trickier than 'LIKE' ?

can break up the search terms into words and do ...data LIKE '%$keyword[0]%' OR data LIKE '%$keyword[1]%'... This will be slow though. You could also do full text searches if you are using MySQL. Have good indexes for whichever route you go. Larry -- PHP Database Ma

[PHP-DB] Query Case In-sensitive

Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data being stored is "m1234" Query Select item number from item where item_code = "M1234" ; The query above should return the data above. TIA Larry Sa

[PHP-DB] Page counter from a query ?

you click on 2 you get 21 - 40. I believe I can use the limit command for the query, I just do not understand how to put the query on the number. Any help would greatly be appreciated!!! TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax

Re: [PHP-DB] date function

weeks once, then monthly going back a year) so I can't offer specifics. The answer will probably be found using a for loop and the date function. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] removing space ?

ly do this and should do this in the query. Most database applications have a TRIM() function or something like it. You don't mention what database application you're using so I can't be more specific but just check the manual for your database. Larry -- PHP Database Mailing List

[PHP-DB] removing space ?

one in the query? Any help would be appreciated. Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592

[PHP-DB] Re: [PHP] php|cruise - do unto others...

rning money for the cause, no? Not trying to be cranky, just worried that the 16 emails I've already seen in the past hour may not be the end of it! Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Create table

point me in the right direction ? Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592

Re: [PHP-DB] full text search in mysql

TCH (title,body) AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE); Use + to indicate required words. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] full text search in mysql

FROM table WHERE MATCH (column) AGAINST ('caribbean') AND MATCH (column) AGAINST ('island'); I don't know if it'll work and it will probably be slow but... For more information, try reading http://www.mysql.com/doc/en/Fulltext_Search.html Larry -- PHP Database Ma

Re: [PHP-DB] ODBC Database

y to use but it doesn't require PHP's ODBC extension since PHP already has a good MySQL extension. If you really want to use ODBC and you have MS Office, you could try Access. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL

, ...) VALUES ('$var1', '$var2', '$var3', ...) But you'll need to connect to MySQL first, then select the database. Check out the PHP and MySQL manuals for more information. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mySQL help on win xp

nd users or win xps firewall??? Larry R. Sieting -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Connect User from website does not work.

ny suggestions ? I am using php 4.2.2 apache 2.0 and mysql 3.23.52 on Redhat 8 The script is trying to connect to the database and create a table. TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592

Re: [PHP-DB] Right-click

you can get the value of what you clicked on into the PHP file? If you make any element on a Web page a url, and make the url something like page.php?clickedon=this, then the PHP page that the user goes to would have a $clickedon ($_GET['clickedon']) variable. Larry -- PHP Database Ma

Re: [PHP-DB] mysl_connect question

First, please don't cross-post. The PHP-DB list is the proper one for this question. If you can connect via the mysql monitor but not with PHP, I expect the problem has to do with your host. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.ph

Re: [PHP-DB] What about MySQL

help. Why don't you head over to www.mysql.com to get a better feel for it? Best wishes, Larry PS There are many books on MySQL available, should you be interested, as well as numerous mailing lists dedicated to MySQL. You can find out more about these at (you guessed it) www.mysql.com.

Re: [PHP-DB] elseif with header

some reason all the elseifs are going to the if header. any input as to how i can correct this is greatly appreciated. You are using the assignment operator (=) instead of the equals comparison operator (==) which makes your if condition always true. Larry -- PHP Database Mailing List (htt

Re: [PHP-DB] SELECT problem

been giving to me these days. Thank you very much!!! Could you show us what code you're using? That'd be more helpful. Also do consider using the mysql_error() function to see what MySQL thinks the problem is. Larry PS Could you turn off the HTML formatting in your email? The

Re: [PHP-DB] db connect probs

. If you just added these permissions, be sure to reload the permissions before logging in. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php-mysql connect

obals problem (the values from the form which are to be inserted into the database aren't being passed to the script as you'd expected). I'd echo the generated SQL to the browser to see what PHP thinks the query is. Then, if necessary, change which variables you use accordingly. Lar

[PHP-DB] SELECTING a sentence from a text field?

know that I could select the whole field then use a regex to chop the string at the first '.' but I would rather have a SQL statement that only grabs the text I need. So how do I write a SQL statement that will grab the first 30 words without chopping the last word? Thanks for your tim

Re: [PHP-DB] session.save_path

as to the first point I have no idea, but on sessions, they are server side. The Session information is stored on the webserver or server accessible directory, so the location should match your setup not the client, the only information shared there is cookie. At 04:28 PM 11/28/2001 -0700, Jon

Re: [PHP-DB] array from html form

the subarrays contain variable data and I tried to express that by showing the array structure that way if I access $needed_data[0] it would be an array of two pieces of data ( both variable) $needed_data[1] would also be an array of two variable pieces of data, etc if I loop through them all

[PHP-DB] array from html form

Hi I'm just a PHP "hobbiest" trying to build a points calculating system for another hobby, please bear with me. I need to build a multidimensional array from a html form, the array would look like: $needed_data = array ( array (id = $member_id, points = $position ),

[PHP-DB] old news SQL help needed

I have a MySql table for news on the site the date the news is inserted goes in column news_date the text of the news itself, goes in columnleague_news I want to DELETE all news older than 7 days I looked in the MySql documentation at the date functions and tried the following but it p

[PHP-DB] URL checking

I have a database with lots of urls stored I would like to build a script the retrieves them ... then somehow checks each one to see if the link produces a "error 404" and is no longer good, then ideally write a file of "bad links" for me this seems like it would be possible with PHP, could so

[PHP-DB] PHP / MySql / catalogs / carts

I bet there are some shopping carts and or "catalogs" using PHP and MySql out there that I can use for my project rather than start from scratch links please thanks in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional command

RE: [PHP-DB] Parsing Error

I don't see why you are using printf there try print instead or echo ;)0 -Original Message- From: Jeff Grossman [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 07, 2001 6:56 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Parsing Error Thanks Larry. Now I am getting a printf to

RE: [PHP-DB] Parsing Error

After a brief look it appears that your call to mysql_query is incorrect " after the query then "," then the link resource -Original Message- From: Jeff Grossman [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 07, 2001 6:23 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Parsing Error I keep

Re: [PHP-DB] Limiting # of connections to remote Oracle

thanks john! this will be a big help --Larry ""John Lim"" <[EMAIL PROTECTED]> wrote in message 9efl78$2kc$[EMAIL PROTECTED]">news:9efl78$2kc$[EMAIL PROTECTED]... > Hi Larry, > > See > http://marc.theaimsgroup.com/?l=php-dev&m=98193543028899&

[PHP-DB] Limiting # of connections to remote Oracle

. We have simple select and update queries using non-persistent connections. Im not too sure what other information I would need to provide, Im just a webdeveloper, not a sysadmin, so please bear that in mind :) Thanks for any help you can give me. Larry Osborn Web Developer Napster, Inc

RE: [PHP-DB] export

What do you mean by unique for a specified date? If you mean to not duplicate data, you can timestamp you entries or use your favorite other method then pull a date range and be done with it. -Original Message- From: bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 12:33 PM

RE: [PHP-DB] Call php function from javascript

Well about the only thing i think you can do since the page has been sent(javascript is client side) is call a window open js functin then write the variables in the url to open ie ?id=32&blah=blahblah -Original Message- From: Marko Lesnik [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 0

RE: [PHP-DB] interbase (?) field contents does not show

Beacuse u are using an object structure, Check OOP in PHP, the pointer $variable->name is for objects that why its used in the fetch object and not fetch row fetch row would be $rs["rowname"] or $rs[0]. Check the documentation for more detailed info -Original Message- From: GMansky [mailt

RE: [PHP-DB] How to autoincrement an autoincrementing field (MySQL)?

What i do is eith not specify the id column or use null as in "" or actually '' in php, this will enter null which the database then just increments the field as it should. Later! -Original Message- From: Alan Hale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 10:29 AM To: [EM

Re: [PHP-DB] Can't connect to local MySQL server through socket '/tmp/mysql.sock'

st (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] -- Larry Hotchkiss Universal Capital 612-551-9309 http://www.unicap.com/ -- PHP Database Mailing

Re: [PHP-DB] PHP On Linux

tributions will have hardware compatability lists as well. Larry H Ben Cairns wrote: > > I have nearly 18 Months devel on Windows, but we are now moving to Linux, > > I have never installed PHP On Linux before, so could someone pls give me an > 'Installation Guide' to fol

Re: [PHP-DB] mysql --> Commercial DBs, When will I need to upgrade?

andle unbelieveable amounts of trafficof course non of it is intel based :) If an Intel box can no longer handle the load, you can split your servers so you have one running a web server and another handling the DB, or simply move to some real hardware. (ie HP/Sun/IBM unix boxes). Larry H. Doug Schasteen

[PHP-DB] mysql and LIKE

urned data. Anyways, I am just looking for some ideas on a good compromise between allowing users flexability without sacrificing performance. All input welcome -- Larry Hotchkiss http://www.unicap.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] Back up database - UNIX-docs

t often contain some good starter information. Larry H. "Bart A. Verbeek" wrote: > > Hello, > > Interesting discussion... > I've been fiddling with cron for a while now, but can't get it to work as I > would. > > Do you know a good website where Unix is

RE: [PHP-DB] count function?

try mysql_num_rows function -Original Message- From: DC [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 9:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] count function? Hi All I cant quite work out how to count the number of rows in my mysql db that match a certain critieria and

RE: [PHP-DB] count function?

I think you have to run multiple queries, ie run some loop after finding out what topics you wil count from e==> run a select distinct to get the topics run a while or for loop then run queries again like count(*) where topic='$topic' etc then echo the result to each line -Original Messa

RE: [PHP-DB] A question - ($file_exists)

oops $x should start with "0" -Original Message----- From: Larry Rivera [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 11:04 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] A question - ($file_exists) or you can put yuou r values into an array the

RE: [PHP-DB] A question - ($file_exists)

or you can put yuou r values into an array then for(loop) thru the thing checking as you go. Example $img[] = "episodeID_a.jpg"; $img[] = "episodeID_b.jpg"; $img[] = "episodeID_c.jpg"; for ($x=1; $x mailto:[EMAIL PROTECTED]]On Behalf Of Russ Michell Sent: Tuesday, March 27, 2001 10:46

RE: [PHP-DB] dynamic columns

Are the fields always the same? Ive used something similar, I usually fill an array with selection ids when while loop them into querys-> To get the table I ussualy create a container table(one cell) and generate tables inside the container one for each item. -Original Message- From: o

Re: [PHP-DB] Windoze crashes on this simple logon script.

;Phil Driscoll" <[EMAIL PROTECTED]> To: "Larry Rivera" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 1:17 AM Subject: Re: [PHP-DB] Windoze crashes on this simple logon script. > I suspect that what is going on is that your code is just go

[PHP-DB] Windoze crashes on this simple logon script.

Anyone have similar exp on why this would crash on Win32 is IIS if (isset($it)){ // Check Entered User Credentials if(($logon == "SuperUser") && ($pass == "Pass")){ session_start(); session_register('logon'); header("Location:$PHP_SELF"); exit(); }else{ etc . . . . - Original Message -

Re: [PHP-DB] Access 2000 to PostgreSQL

I belive that Acceess can export to a comma delimited file, so you can do that then dump it into you new database ;) - Original Message - From: "Julio Cuz, Jr." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 3:33 PM Subject: [PHP-DB] Acce