[PHP-DB] php db performance, db clusters

We are looking for PHP-database performance comparisons. Can someone point out links? Who has experience with high-traffic sites using - MySQL - MS-SQL, especially in a clustered environment? kind regards, Jens Fisch ([EMAIL PROTECTED]) -- PHP Database Mailing List (http://www.php.net/) To un

[PHP-DB] functions and using vars outside of them

I am wondering how to use a variable that is generated by a function ($query) If you would please look at: http://phpbuilder.net/columns/laflamme20001016.php3?page=5 for an example of what i am trying to do. the function will generate the query... but how do i make use of this? i see that i will

Re: [PHP-DB] Take out one Data and show it in page

Hi, hte first part after WHERE is the column name of your db. if you want to search with name as a criteria you write: selelct name, nickname from table where name=$name; johannes "Naga Sean" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I had a quest

Re: [PHP-DB] help with a parse error

Gee...all I looked at were the semicolons and the braces (those are what I mess up on the most). I guess it's a good thing I mentioned the space in the endif! It turns out that if you use that syntax, you cannot have a space there. Doug At 01:19 PM 3/29/01 +0930, Timothy Aslat wrote: >Petra wr

Re: [PHP-DB] help with a parse error

You didn't mention if the parse error was coming from PHP or from MySQL. The PHP syntax looks okay to me at first glance (that is, a quick look through indicates that there appears to be appropriate numbers of semicolons and closing braces). So perhaps the thing issuing the parse error is MySQL?

Re: [PHP-DB] help with a parse error

Petra wrote: > I just subsribed to this list with the hope you can help me. We can try > echo(" Here are all the products in our database: :); add a " >before the ; here > > // Request the text of all the products > $result = mysql_query( > "select * from products");

[PHP-DB] help with a parse error

hi I just subsribed to this list with the hope you can help me. I am working on this code and I get a parse error in line 52 which is ... I been going through it over and over and can't find a glue. Has anyone out there a solution for me please? I am a beginner in PHP and like to hear about

[PHP-DB] Take out one Data and show it in page

I had a question here. How to pull up one database, and then view that row what I mean here is NO NAME AGE 1 JOHN 12 2 RYAN 23 3 JIM42 I want to take JOHN out from database using URL www.example.com/template.php?name=JOHN here is my coding so far, and I know it's wr

Re: [PHP-DB] how do I connect to MSSQL and mySQL with PHP4 and Linux?

> I see this FreeTDS thing (www.freetds.org), but do I really need that? > I don't even know what it is really? The 'FAQ' is not very informative for a > 'novice'. > It seems like some extra layer of minutiae that I don't want to deal with. > > Isn't there some way to compile PHP "--with-mssql" ju

Re: [PHP-DB] managing large result sets

Addressed to: "houston" <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from "houston" <[EMAIL PROTECTED]> Wed, 28 Mar 2001 12:14:51 -0600 > > I have to deal with displaying result sets that could potentially be quite > large. It would be bad form to drop 10,000 rows into

RE: [PHP-DB] Select Database number & show it

I believe this is what you want: SELECT * FROM mydatabase LIMIT 0,5 --- David Balatero [EMAIL PROTECTED] --- -Original Message- From: Naga Sean [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:06 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Select Database number & show it F

[PHP-DB] Select Database number & show it

Friends, Can you tell me how to select database between 1-5 and then show it to the web. ex : 1 xx 2 xx 3 xx 4 xx 5 xx 6 xx 7 xx 8 xx 9 xx 10 xx I think it's easy, but I'm a beginner here. so I don't know how to do that. Tha

Re: [PHP-DB] auto_increment in mysql

> I use MySQL 3.22.23 but I just had a hunt about on the web and I found > a posting that confirmed your findings - I.E: auto_increment starts at > 1!! > > I stand corrected! The reasoning behind this a colleague of mine recently informed me of.. When an insert occurs, the new record is given th

[PHP-DB] how do I connect to MSSQL and mySQL with PHP4 and Linux?

I run Apache, PHP4, RH Linux, and mySQL currently. Everything is fine. What I need to do is get Microsoft SQL Server in there as well. I see this FreeTDS thing (www.freetds.org), but do I really need that? I don't even know what it is really? The 'FAQ' is not very informative for a 'novice'. It s

RE: [PHP-DB] Copy data from one mysql table to another?

do something like - 1. make a third table indentical to table svt_members. lets call it svt_members_temp. 2. load the svt_members_temp table with the merged values. "Insert into svt_members_temp(key_svt_members, phone, etc,etc,etc) Select phone.key_svt_members, phone.phone, svt_members.etc, svt

Re: [PHP-DB] Copy data from one mysql table to another?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Bob Stone) wrote: > I cannot find any documentation on how to copy the > data from one mysql table to another, i.e. table1, > columnx to table2, columnx. See the mysql documentation of the "insert into" syntax for how to use a trailing "select

[PHP-DB] Copy data from one mysql table to another?

Dear PHP Helpers, I cannot find any documentation on how to copy the data from one mysql table to another, i.e. table1, columnx to table2, columnx. Can you recommend a way? Here is the situation. I have one table called "phone" with two columns. The first column is called "key_svt_members," th

Re: [PHP-DB] global vars

nevermind, sorry it was a stupid comma in my sql query... what i have is very sool tho, so if you would like the script its great! i derived it, almost entirely from Dan LaFlamme's NOT working script at http://phpbuilder.com/columns/laflamme20001016.php3 olinux - Original Message - From:

[PHP-DB] Apostraphe's etc..

Here is the script: I want to insert apostrophe's into my little database. For instance the user enters this in the fields provided: My Title's Name This body text hasn't got nothing. My Name's Cool The resulting SQL string is this: INSERT INTO news ( EDATE, TITLE, BODY, EUSER ) VALUES (

[PHP-DB] global vars

I am working with global variables and functions, specifically calling a function inside another function. I checked the online docs and don't see any problems with what i have... i declare the table_name as global inall functions What I am trying to do is DELETE all entries for a uid before IN

[PHP-DB] managing large result sets

I have to deal with displaying result sets that could potentially be quite large. It would be bad form to drop 10,000 rows into a browser table so I need a strategy for dealing with this possibility. It's obviously not a big deal to limit the output but what is the typical strategy for handling

Re: [PHP-DB] My first question: PHP won't update MySQL

You don't seem to do an insert with the new data. Terry On Wednesday, March 28, 2001, at 11:19 AM, Timothy D. Arnold wrote: > I believe that the problem is in the following batch of code... > > Thanks, > > Tim > [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscr

[PHP-DB] My first question: PHP won't update MySQL

Hello, I am new to PHP as well as this list. I have taken another page that does work and tried to modify it to use a new MySQL table ("story"). I haven't made any major changes, but the new page does not work. Here is the page that works: http://phenon.com/nothing/favorite_color.php Here is

Re: [PHP-DB] post method

just change the FORM action attribute to action="http://www.web.com/comunidad/directorio/directio.php" olinux - Original Message - From: "Gaby" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 28, 2001 5:04 AM Subject: [PHP-DB] post method Hi world , How does PHP re

[PHP-DB] post method

Hi world , How does PHP receive a POST request ? I need receive a page that I call like from a form using post method , For exemple : http://www.web.com/comunidad/directorio/directorio.asp"> Nombre: Is not the same like : http://www.web.com/comunidad/directorio/directorio.asp?botones='Bus

RE: [PHP-DB] Re: Record Numbering - was SELECT MAX(ID) PLUS 1

Thanks Steve, I will go back to using separate tables - Thanks Lisa -Original Message- From: Steve Farmer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 12:12 PM To: Rubanowicz, Lisa; [EMAIL PROTECTED] Subject: [PHP-DB] Re: Record Numbering - was SELECT MAX(ID) PLUS 1 Hi Lis

[PHP-DB] Re: Record Numbering - was SELECT MAX(ID) PLUS 1

Hi Lisa, At 4:40 AM -0600 28/3/01, Rubanowicz, Lisa wrote: >Can anyone help me on this one >Lisa [snip] > > > >> Here is the story. I have a small web site running from mySQL. Initially > >I > > had it all in different tables then an ASP colleague said I should do it >it > > one table and

FW: [PHP-DB] SELECT MAX(ID) PLUS 1

Can anyone help me on this one Lisa -Original Message- From: Walter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 10:55 AM To: Rubanowicz, Lisa Subject: Re: [PHP-DB] SELECT MAX(ID) PLUS 1 Are tables are to differnet, so you don't have anything on my code Sorry - Orig

Re: [PHP-DB] auto_increment in mysql

I use MySQL 3.22.23 but I just had a hunt about on the web and I found a posting that confirmed your findings - I.E: auto_increment starts at 1!! I stand corrected! Russ #---# "Believe nothing - con

Re: [PHP-DB] auto_increment in mysql

The version you use may be lower than 3.23 because auto_increment sequence number begin at 1 for MySQL version up to 3.23. "Russ Michell" <[EMAIL PROTECTED]> ? news:[EMAIL PROTECTED]... > I may be semi-new to this MySQl lark but I'm sure auto_increment starts > at 0. > > Russ > > #---

Re: [PHP-DB] auto_increment in mysql

I may be semi-new to this MySQl lark but I'm sure auto_increment starts at 0. Russ #---# "Believe nothing - consider everything" Russ

[PHP-DB] auto_increment in mysql

In mysql, the auto_increment start at 1 default, But, how can I make the auto_increment start at 0? -- 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

Re: [PHP-DB] Help Export Excel to MySQL database

Hi, you can save it as .csv or as a tab-delimited .txt file. then via "load data infile 'path/to/file' into table YourTable" if you use windwos the "\" has to be escaped by another "\" like this "C:\\path\\to\\file" Johanens ""John"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 99ra37$dj8$[EMAIL

Re: [PHP-DB] checkbox data

olinux: I have some checkboxes that are generated on the fly that represent a person signing up for an activity: "; //On the page this form is submitted to I pick the results up thus: while(list($key) = each($signup)) { //Start off SQL query - inserting available values into

Re: [PHP-DB] fetch array problems.

Felix: Depending on what you're trying to do try either of these: //Check to see if $color is in DB: $connection = mysql_connect("localhost","user","pass") or die("Died at connection."); $sql = "SELECT * FROM user_prefs WHERE u_id='$UserID'"; $result = mysql_db_query($sql, $connection) or die(

Re: [PHP-DB] Update query problem (Oracle)

Hi Francesco, Probably the easiest way is to load the records from table 2 into an array and then lopp through updatign table 1 HTH Steve At 9:37 AM +0200 28/3/01, Francesco D'Inzeo wrote: >Hi everyone. > >The scenario: > >Table1 Table2 >Field_01, <- Same as -> Field_01, >

Re: [PHP-DB] fetch array problems.

On Wed, Mar 28, 2001 at 01:08:35AM -0700, John Starkey wrote: > .. '; > I can't get $color[color_1] to return a value. It's in the db and > color_1 is a valid table containing a hex value. This is my first > attempt at using assoc. arrays. I'm not sure right now, but try $color["color_1

[PHP-DB] SELECT MAX(ID) PLUS 1

Hi All, I have been driven maad with this now for about a week and have looked all around for the answer but seem to get sent off in a tangent any time I get close. My SELECT statement seems to be right when I run it in MySQLFront but to add 1 in PHP .. Here is the story. I have a