Re: [PHP-DB] fetch array problems.

On Wed, Mar 28, 2001 at 01:08:35AM -0700, John Starkey wrote: table bgcolor="'.$color[color_1].'" class="nav" .. '; 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

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

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] 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

[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] 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 -

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"

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,

[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

[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.

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

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 a

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" just

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 snip echo("P Here are all the products in our database: /P:); add a " before the ; here // Request the text of all the products $result = mysql_query( "select * from products");

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

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

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

[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

[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