[PHP] newbie php/mysql need help

2005-03-13 Thread p80
I do a mysql request like this one: SELECT DISTINCT (brand), COUNT( brand )FROM `machines` where category like 'sold' group by brand" I get this from mysql: brand COUNT( brand) brandx4 brandy12 how can I echo this result in php? thanx in advance Pat -- P

Re: [PHP] mysql query update two table in one?

2005-03-10 Thread Christian Heinrich
Tyler Replogle schrieb: Can you update two tables in one mysql query i've got these two queries $db->query("update `dbn_members_counters` set views =(views +1) where id = '$this->id' "); $db->query("update `dbn_members` set lastaction = $conf->site_time, page = '$this->page' where id = '$this->i

[PHP] mysql query update two table in one?

2005-03-10 Thread Tyler Replogle
Can you update two tables in one mysql query i've got these two queries $db->query("update `dbn_members_counters` set views =(views +1) where id = '$this->id' "); $db->query("update `dbn_members` set lastaction = $conf->site_time, page = '$this->page' where id = '$this->id' "); and i was wonder

Re: [PHP] MySQL - PHP - limits...

2005-03-09 Thread Richard Lynch
> Is there a records limit when browsing (a sql SELECT) in PHP from a MySQL > table? Sort of, I think... When MySQL is compiled, there is a buffer limit on how much crap you can squirt through a single connection. You can maybe alter this in my.cnf or be re-compiling MySQL. If you are trying to

Re: [PHP] MySQL - PHP - limits...

2005-03-09 Thread Marek Kilimajer
Alex Ortiz wrote: Hello. Is there a records limit when browsing (a sql SELECT) in PHP from a MySQL table? no limit on php side, perhaps 2^31 if you do calculations. I´m browsing a table with PHP from MySQL, and something is wrong, if the table has more than 5047 records, the browse appears blank.

[PHP] MySQL - PHP - limits...

2005-03-08 Thread Alex Ortiz
Hello. Is there a records limit when browsing (a sql SELECT) in PHP from a MySQL table? I´m browsing a table with PHP from MySQL, and something is wrong, if the table has more than 5047 records, the browse appears blank. Additionaly, if make the browse in a child window (target="_blank"), the

Re: [PHP] mysql problems

2005-03-01 Thread Rory McKinley
Jed R. Brubaker wrote: Hi all - I could use a lead on a problem. I just don't know where to start. I have a PHP script that populates a database table. No big deal. It creates mailing labels. However, a weird things keeps happening - every once in a while, a query is run twice. It is the same que

Re: [PHP] mysql problems

2005-03-01 Thread Richard Lynch
Jed R. Brubaker wrote: > I could use a lead on a problem. I just don't know where to start. > > I have a PHP script that populates a database table. No big deal. It > creates > mailing labels. However, a weird things keeps happening - every once in a > while, a query is run twice. It is the same qu

[PHP] mysql problems

2005-03-01 Thread Jed R. Brubaker
Hi all - I could use a lead on a problem. I just don't know where to start. I have a PHP script that populates a database table. No big deal. It creates mailing labels. However, a weird things keeps happening - every once in a while, a query is run twice. It is the same query, same information,

Re: [PHP] MySQL and MySQLi compiling

2005-02-19 Thread Chris
Thanks for all the help, I managed to get it working, though I'm not quite sure the reasoning behind it. I used some info I got off of http://bugs.php.net/bug.php?id=29860 to do it. I posted my particular resolution to the bug report. It seems to me that *something* isn't right Chris -- PHP G

Re: [PHP] MySQL and MySQLi compiling

2005-02-18 Thread Chris
Richard Lynch wrote: Here's the deal: "configure" needs to find *BOTH* 'mysql.h' files and 'mysql.so'/'mysql.lib' files *UNDER* the directory you feed it. Figure out where your mysql.h files are. Figure out where your mysql.lib/mysql.so files are. . Thanks for the response, in fact I can't find

Re: [PHP] MySQL and MySQLi compiling

2005-02-18 Thread Chris
Chris wrote: ./configure --with-apxs2=/usr/local/apache/bin/apxs --with-mysql=/usr --with-mysql-include-dir=/usr/include/mysql --with-mysql-lib-dir=/usr/lib/mysql --with-mysqli=/usr/bin/mysql_config it might work. I've managed to stave of the need for the mysql extension for a week or two, but

Re: [PHP] MySQL and MySQLi compiling

2005-02-18 Thread Richard Lynch
Chris wrote: > Hi, I've been trying to get these 2 compiled together for a while, and > have had no luck. > > WHere my problem lies, I think, is that I'm not sure what directory > should be specified on the --with-mysql part Here's the deal: "configure" needs to find *BOTH* 'mysql.h' files and 'm

Re: [PHP] mysql query

2005-02-18 Thread Richard Lynch
Sebastian wrote: > Hello, > im working on an article system and looking to avoid running three > queries. > example, i have this query: > > SELECT id,title FROM articles WHERE id=$_GET[id] > > now say $_GET[id] = 5 > > I would like to get the previous id 4 and the next id 6 (if there is one) > so i

Re: [PHP] MySQL and MySQLi compiling

2005-02-18 Thread Marek Kilimajer
Chris wrote: Hi, I've been trying to get these 2 compiled together for a while, and have had no luck. WHere my problem lies, I think, is that I'm not sure what directory should be specified on the --with-mysql part ./configure --with-apxs2=/usr/local/apache/bin/apxs --with-mysql=/usr/include/m

Re: [PHP] MySQL and MySQLi compiling

2005-02-17 Thread Chris
Hans Zaunere wrote: Hi, I've been trying to get these 2 compiled together for a while, and have had no luck. WHere my problem lies, I think, is that I'm not sure what directory should be specified on the --with-mysql part ./configure --with-apxs2=/usr/local/apache/bin/apxs --with-mysql=/usr/include

Re: [PHP] MySQL and MySQLi compiling

2005-02-17 Thread Chris
dan wrote: Chris wrote: Hi, I've been trying to get these 2 compiled together for a while, and have had no luck. WHere my problem lies, I think, is that I'm not sure what directory should be specified on the --with-mysql part ./configure --with-apxs2=/usr/local/apache/bin/apxs --with-mysql=/us

Re: [PHP] mysql query

2005-02-17 Thread Bret Hughes
On Thu, 2005-02-17 at 22:02, Jason Petersen wrote: > On 17 Feb 2005 19:28:18 -0600, Bret Hughes <[EMAIL PROTECTED]> wrote: > > On Thu, 2005-02-17 at 18:24, Sebastian wrote: > > > Hello, > > > im working on an article system and looking to avoid running three > > > queries. > > > example, i have th

Re: [PHP] mysql query

2005-02-17 Thread Jason Petersen
On 17 Feb 2005 19:28:18 -0600, Bret Hughes <[EMAIL PROTECTED]> wrote: > On Thu, 2005-02-17 at 18:24, Sebastian wrote: > > Hello, > > im working on an article system and looking to avoid running three queries. > > example, i have this query: > > > > SELECT id,title FROM articles WHERE id=$_GET[id] >

Re: [PHP] mysql query

2005-02-17 Thread Bret Hughes
On Thu, 2005-02-17 at 18:24, Sebastian wrote: > Hello, > im working on an article system and looking to avoid running three queries. > example, i have this query: > > SELECT id,title FROM articles WHERE id=$_GET[id] > > now say $_GET[id] = 5 > > I would like to get the previous id 4 and the next

Re: [PHP] mysql query

2005-02-17 Thread Stephen Johnson
xt = $j+1; <> http://www.thelonecoder.com [EMAIL PROTECTED] 562.924.4454 (office) 562.924.4075 (fax) continuing the struggle against bad code */ ?> > From: "Sebastian" <[EMAIL PROTECTED]> > Date: Thu, 17 Feb 2005 19:24:50 -0500 > To: > Subject: [PHP] mys

Re: [PHP] mysql query

2005-02-17 Thread dan
Sebastian wrote: Hello, im working on an article system and looking to avoid running three queries. example, i have this query: SELECT id,title FROM articles WHERE id=$_GET[id] now say $_GET[id] = 5 I would like to get the previous id 4 and the next id 6 (if there is one) so i can do something like

RE: [PHP] MySQL and MySQLi compiling

2005-02-17 Thread Hans Zaunere
> Hi, I've been trying to get these 2 compiled together for a while, and > have had no luck. > > WHere my problem lies, I think, is that I'm not sure what directory > should be specified on the --with-mysql part > > ./configure --with-apxs2=/usr/local/apache/bin/apxs > --with-mysql=/usr/include/

[PHP] mysql query

2005-02-17 Thread Sebastian
Hello, im working on an article system and looking to avoid running three queries. example, i have this query: SELECT id,title FROM articles WHERE id=$_GET[id] now say $_GET[id] = 5 I would like to get the previous id 4 and the next id 6 (if there is one) so i can do something like: << Previous

Re: [PHP] MySQL and MySQLi compiling

2005-02-17 Thread dan
Chris wrote: Hi, I've been trying to get these 2 compiled together for a while, and have had no luck. WHere my problem lies, I think, is that I'm not sure what directory should be specified on the --with-mysql part ./configure --with-apxs2=/usr/local/apache/bin/apxs --with-mysql=/usr/include/m

[PHP] MySQL and MySQLi compiling

2005-02-17 Thread Chris
Hi, I've been trying to get these 2 compiled together for a while, and have had no luck. WHere my problem lies, I think, is that I'm not sure what directory should be specified on the --with-mysql part ./configure --with-apxs2=/usr/local/apache/bin/apxs --with-mysql=/usr/include/mysql/ --with-

Re: [PHP] Re: php/mysql url validation methods...

2005-02-14 Thread darren kirby
quoth the Jason Barnett: > Darren Kirby wrote: > > The problem is that after playing around with this a bit, it is clear > > that someone can craft a url with an arbitrary $postid that is not in the > > database yet. Now naively, it would seem that the worst someone could do > > is just create arbi

Re: [PHP] MySQL 4.1 upgrade under PHP4

2005-02-14 Thread Marek Kilimajer
C.F. Scheidecker Antunes wrote: Hello all, Does anyone upgraded from MySQL 4.0 to MySQL 4.1 using PHP 4 code? If so, what are the changes that were required on the code? PHP website says that it is required to install a new MySQL extension. I am doing PHP4 programming under Linux. What do you sugge

Re: [PHP] php/mysql url validation methods...

2005-02-14 Thread Richard Lynch
darren kirby wrote: > On the main page of my website I have written a very simple comments > feature > that allows people to leave a message under my posts, much like a blog. I > have purposely kept this very simple... > > On the main page I have simple text links that someone can click on if > the

[PHP] Re: php/mysql url validation methods...

2005-02-14 Thread Jason Barnett
Darren Kirby wrote: Hello all, On the main page of my website I have written a very simple comments feature that allows people to leave a message under my posts, much like a blog. I have purposely kept this very simple... On the main page I have simple text links that someone can click on if they w

Re: [PHP] MySQL 4.1 upgrade under PHP4

2005-02-14 Thread Burhan Khalid
C.F. Scheidecker Antunes wrote: Hello all, Does anyone upgraded from MySQL 4.0 to MySQL 4.1 using PHP 4 code? If so, what are the changes that were required on the code? PHP website says that it is required to install a new MySQL extension. http://www.php.net/mysqli ^<--- Th

[PHP] MySQL 4.1 upgrade under PHP4

2005-02-13 Thread C.F. Scheidecker Antunes
Hello all, Does anyone upgraded from MySQL 4.0 to MySQL 4.1 using PHP 4 code? If so, what are the changes that were required on the code? PHP website says that it is required to install a new MySQL extension. I am doing PHP4 programming under Linux. What do you suggest that I should be aware while

[PHP] php/mysql url validation methods...

2005-02-13 Thread darren kirby
Hello all, On the main page of my website I have written a very simple comments feature that allows people to leave a message under my posts, much like a blog. I have purposely kept this very simple... On the main page I have simple text links that someone can click on if they want to leave a

[PHP] MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread GH
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary

Re: [PHP] mysql improved extensions affected_rows

2005-01-15 Thread Jochem Maas
Tom wrote: ... It correctly updates 4 rows, but returns 1 as the count. I think that this may actually be a mysql issue - I've put the same php/apache configs onto another similar box, the only difference being that the second box is mysql 5.0.1, whereas the problem is reported against 5.0.0

Re: [PHP] mysql improved extensions affected_rows

2005-01-14 Thread Richard Lynch
Tom wrote: > Richard Lynch wrote: > >>Tom wrote: >> >> >>>I've just started playing with the php5 improved mysqli extensions. >>> >>>I have the following code:- >>> >$mysqlim = new mysqli("localhost", "myUser", "myPassword","myDB"); >>> >>>$updateQuery = "UPDATE client SET status = 'INACTIVE' W

Re: [PHP] mysql improved extensions affected_rows

2005-01-14 Thread Tom
Richard Lynch wrote: Tom wrote: I've just started playing with the php5 improved mysqli extensions. I have the following code:- $updateQuery = "UPDATE client SET status = 'INACTIVE' WHERE clientName = 'Tom'"; if ($mysqli->query($updateQuery)) { $updateCount = $mysqli->affected_rows; echo

Re: [PHP] mysql improved extensions affected_rows

2005-01-13 Thread Richard Lynch
Tom wrote: > I've just started playing with the php5 improved mysqli extensions. > > I have the following code:- > > $mysqlim = new mysqli("localhost", "myUser", "myPassword","myDB"); > > $updateQuery = "UPDATE client SET status = 'INACTIVE' WHERE clientName = > 'Tom'"; > > if ($mysqli->query($upd

[PHP] mysql improved extensions affected_rows

2005-01-13 Thread Tom
I've just started playing with the php5 improved mysqli extensions. I have the following code:- $updateQuery = "UPDATE client SET status = 'INACTIVE' WHERE clientName = 'Tom'"; if ($mysqli->query($updateQuery)) { $updateCount = $mysqli->affected_rows; echo "updateCount = $updateCount"; } e

Re: [PHP] MySQL Database type

2004-12-29 Thread Brent Baisley
It depends on what you are trying to do. If you need full text searching, MyISAM is what you should be using. If you are doing transactions, InnoDB is what you probably want to use. If you write a lot to the database, InnoDB may be better, if you read a lot MyISAM may be better. But that depend

[PHP] MySQL Database type

2004-12-28 Thread The Disguised Jedi
Which type of engine would y'all recommend for a user/customer and session data storage database? I'm currently using MyISAM, but I just was curious to see if you guys could tell me if you know of a better one, or tell me what you use. TIA, -- The Disguised Jedi [EMAIL PROTECTED] PHP rocks! "K

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Greg Donald
On Fri, 17 Dec 2004 09:57:56 -0800 (PST), Richard Lynch <[EMAIL PROTECTED]> wrote: > Yeah, a beginner trying to write an OOP MySQL session based system would > take MONTHS, and still get it all wrong with nasty snarled code. Months? Come on.. it's just six functions and a call to session_set_sa

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Richard Lynch
Robert Cummings wrote: > On Fri, 2004-12-17 at 11:34, Richard Lynch wrote: >> Granted, this assumes you've got a good clean working SQL-based session >> setup in the first place, which is several days, perhaps even weeks of >> work for the beginner, before they really understand all the bits an

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Richard Lynch
Jason Morehouse wrote: > Has anyone had an experience with storing sessions in mysql (or sqlite)? Yes, in MySQL. > If so, what if any are the performance benefits? This depends on *SO* many factors... Is your MySQL database pretty small? Is your site heavy traffic? Are most of your sessions

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Robert Cummings
On Fri, 2004-12-17 at 11:34, Richard Lynch wrote: > Granted, this assumes you've got a good clean working SQL-based session > setup in the first place, which is several days, perhaps even weeks of > work for the beginner, before they really understand all the bits and > pieces and ins and outs of t

Re: [PHP] mysql sessions vs flat file?

2004-12-17 Thread Raditha Dissanayake
Jason Morehouse wrote: Hello all, Has anyone had an experience with storing sessions in mysql (or sqlite)? If so, what if any are the performance benefits? Obviously, there would have to be an extra db query per page... but would that be faster then opening a text file? Speed depends on severa

[PHP] mysql sessions vs flat file?

2004-12-17 Thread Jason Morehouse
Hello all, Has anyone had an experience with storing sessions in mysql (or sqlite)? If so, what if any are the performance benefits? Obviously, there would have to be an extra db query per page... but would that be faster then opening a text file? Also, I was trying to post to the php news se

[PHP] Re: php mysql codes insertion error.

2004-12-14 Thread Jonathan
Found the problem. I set ( default_charset = "iso-8859-1" ) in php.ini and it solve the problem. Just in case anyone want to know. "Jonathan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I have encounter something rather weird. In my development server, > > when I ins

Re: [PHP] How does google index PHP + MySQL (PostgreesSQL) websites?

2004-12-14 Thread Richard Davey
Hello symbulos, Tuesday, December 14, 2004, 4:12:20 PM, you wrote: sp> does anybody know how does google (and other search engines) index websites sp> implemented in PHP + MySQL? For instance, sites which use PHP based CMS sp> (Content Management Systems)? It doesn't. It indexes

[PHP] How does google index PHP + MySQL (PostgreesSQL) websites?

2004-12-14 Thread symbulos partners
Dear friends, does anybody know how does google (and other search engines) index websites implemented in PHP + MySQL? For instance, sites which use PHP based CMS (Content Management Systems)? Someone told us google spiders do call for the pages so they only see the resulting HTML code. Is that

[PHP] php mysql codes insertion error.

2004-12-14 Thread Jonathan
Hi, I have encounter something rather weird. In my development server, when I insert a string contain '&*%$, I got this in my mysql server '&*%$ (i.e. the same) but in my application server, I got this â?T&*%$ in my mysql server (i.e. ' ==> â?T) anyone know how to resolve this? When I use the

[PHP] MySQL Connection problem

2004-12-11 Thread Mike Francis
Hi, I have Apache 2, PHP 5 and MySQL 4.1 installed on an XP pro box. I have created a new database 'ijdb' with a single table 'joke' and have entered data into two of the three fields in the table. I can access the database / tables / data from a command prompt. However, when I try to connect t

Re: [PHP] MYSQL Query question

2004-12-09 Thread Raditha Dissanayake
John Nichel wrote: Raditha Dissanayake wrote: Reinhart Viane wrote: And a last question: I always seem to get stuck on mysql queries when scripting. mysql.com gives me a headache whens earching something. Does someone know a good mysql manual site or a good mysql book? That does not mean mysql q

Re: [PHP] MYSQL Query question

2004-12-09 Thread John Nichel
Raditha Dissanayake wrote: Reinhart Viane wrote: And a last question: I always seem to get stuck on mysql queries when scripting. mysql.com gives me a headache whens earching something. Does someone know a good mysql manual site or a good mysql book? That does not mean mysql questions should be

RE: [PHP] MYSQL Query question

2004-12-09 Thread Reinhart Viane
: [EMAIL PROTECTED] Subject: Re: [PHP] MYSQL Query question >Reinhart Viane wrote: >And a last question: >I always seem to get stuck on mysql queries when scripting. mysql.com >gives me a headache whens earching something. Does someone know a good >mysql manual site or a good mysql bo

Re: [PHP] MYSQL Query question

2004-12-09 Thread Raditha Dissanayake
Reinhart Viane wrote: And a last question: I always seem to get stuck on mysql queries when scripting. mysql.com gives me a headache whens earching something. Does someone know a good mysql manual site or a good mysql book? That does not mean mysql questions should be posted on php mailing lists

[PHP] MYSQL Query question

2004-12-09 Thread Reinhart Viane
Table chat_online: session (varchar) activity (datetime) Table persons persons_region_int(int) Table regions region_id region_name On a page i list all persons which are in the chat_online dbase and within a certain period: $limit_time = time() - 130; // 2 Minutes time out. 60 * 2 = 120 $sql

Re: [PHP] mysql error

2004-12-05 Thread Raditha Dissanayake
Travis Conway wrote: Try: SELECT * FROM listing WHERE listing.state = 'WA' AND listing.type = 'RES' AND listing.county = 'clark' AND (listing.price > 15 OR listing.price <=20) Once again you have posted to the wrong list. Please send this message to the mysql list. This is the php list.

Re: [PHP] mysql error

2004-12-05 Thread Travis Conway
which does not require a tick around the value. I also dont think that the back tick works. HTH Travis - Original Message - From: "Richard Kurth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 05, 2004 3:05 PM Subject: [PHP] mysql error Could

Re: [PHP] mysql error

2004-12-05 Thread Raditha Dissanayake
Richard Kurth wrote: Could somebody tell me way these query gets a error 1064 and does not work. no. wrong list. -- Raditha Dissanayake. -- http://www.radinks.com/print/card-designer/ | Card Designer Applet http://www.radinks.com/up

Re: [PHP] mysql error

2004-12-05 Thread Ligaya Turmelle
> query="SELECT * FROM listing WHERE `state` = 'WA' AND `type` = 'RES' > AND `county` = 'clark' AND (`price` > '15' OR `price` <= '20');"; if that doesn't work - break it down into individual parts and find out where the problem is. Respectfully, Ligaya Turmelle --- Life is a game... so h

[PHP] mysql error

2004-12-05 Thread Richard Kurth
Could somebody tell me way these query gets a error 1064 and does not work. error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SELECT * FROM listing WHERE `state` = 'WA' AND `type` = 'RES' query="SELECT *

RE: [PHP] mysql query with exclude

2004-11-28 Thread Reinhart Viane
Turmelle [mailto:[EMAIL PROTECTED] >>Sent: zondag 28 november 2004 2:25 >>To: [EMAIL PROTECTED] >>Cc: [EMAIL PROTECTED] >>Subject: Re: [PHP] mysql query with exclude >>Sounds like you need a join. Maybe something like: >> >>select * from chat c1, >&g

RE: [PHP] mysql query with exclude

2004-11-28 Thread Reinhart Viane
id if(c1.user2_sessionid = $thisuser)); Can I do something like this? >>-Original Message- >>From: Ligaya Turmelle [mailto:[EMAIL PROTECTED] >>Sent: zondag 28 november 2004 2:25 >>To: [EMAIL PROTECTED] >>Cc: [EMAIL PROTECTED] >>Subject: Re: [PHP] mysql q

Re: [PHP] mysql query with exclude

2004-11-27 Thread Ligaya Turmelle
Sounds like you need a join. Maybe something like: select * from chat c1, chat_online c2 where UNIX_TIMESTAMP(c2.activity)=$limit_time and c2.session_id = $thisuser and ((c1.user1_sessionid = $thisuser) or c1.user2_sessionid = $thisuser));

[PHP] mysql query with exclude

2004-11-27 Thread Reinhart Viane
Hey all, Hope you all have fun this saturday evening :) I'm sure i'm having fun except i'm kinda stuck... Ok here goes... I have 2 tables, one with the people online (chat_online): session_id activity And a second one where i keep the conversations between people(chat): user1_sessionid us

RE: [PHP] Mysql Connect Help

2004-11-21 Thread Manoj Kumar
You should enable php_mysql module in your php.ini file. -- Manoj Kr. Sheoran -Original Message- From: Nathan Mealey [mailto:[EMAIL PROTECTED] Sent: Sunday, November 21, 2004 10:56 PM To: [EMAIL PROTECTED] Subject: [PHP] Mysql Connect Help A seemingly simple problem, still

Re: [PHP] Mysql Connect Help

2004-11-21 Thread John Holmes
Nathan Mealey wrote: The following line of code: mysql_connect('database','user','password'); [with values of course] Generates the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/phptest.php on line 3 My PHP info page says that PHP (4.3) was compiled wi

[PHP] Mysql Connect Help

2004-11-21 Thread Nathan Mealey
A seemingly simple problem, still confounding me. The following line of code: mysql_connect('database','user','password'); [with values of course] Generates the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/phptest.php on line 3 My PHP info page says t

[PHP] Mysql 4.1.7 + PHP 4.3.9

2004-11-14 Thread electroteque
Is this a possible combination ? Work is trying to compile PHP4 against 4.1, I havent even tried it apart from against PHP5. It says in the manual that the mysqli driver is the only one compatible with 4.1, although I have managed to compile both mysql and mysqli in php5, and run my apps ok as

Re: [PHP] MySQL > Excel

2004-11-12 Thread Jennifer Goodie
-- Original message -- From: Sam Smith <[EMAIL PROTECTED]> > > I've got it working writing out a file (fopen) to CSV (comma delimited) and > the "header('Content-Disposition: attachment; filename="myFile.csv"')" > method but it's clumsy for the user to figure out h

[PHP] MySQL > Excel

2004-11-12 Thread Sam Smith
I've got it working writing out a file (fopen) to CSV (comma delimited) and the "header('Content-Disposition: attachment; filename="myFile.csv"')" method but it's clumsy for the user to figure out how to use the file. Is there some totally slick way of spitting out a file that Excel can open righ

Re: [PHP] MySQL

2004-11-09 Thread Klaus Reimer
Octavian Rasnita wrote: Please tell me how to send a null string to be inserted in a MySQL database. If I do something like: $string = null; mysql_query("insert ignore into table(field) values($string)"); This will result in the following SQL query: insert ignore into table(field) values() If you o

RE: [PHP] MySQL

2004-11-09 Thread Murray @ PlanetThoughtful
> If I do something like: > > $string = null; > > mysql_query("insert ignore into table(field) values($string)"); > > It gives me an error. Pass a string value of 'NULL'. Ie INSERT INTO table (field) VALUES (NULL); Or, in your example: $string = 'NULL'; mysql_query("INSERT INTO table (field)

[PHP] MySQL

2004-11-09 Thread Octavian Rasnita
Hi all, Please tell me how to send a null string to be inserted in a MySQL database. If I do something like: $string = null; mysql_query("insert ignore into table(field) values($string)"); It gives me an error. In fact, I have multiple fields to insert, and the error just tell me that was an

Re: [PHP] mysql netwoking??

2004-11-08 Thread Robert Cummings
On Mon, 2004-11-08 at 07:41, John Nichel wrote: > Aalee wrote: > > > Hi guys, > > I have a small home network working with just 4 computers (PC's on WinXP > > Pro) connected through a switch just using the local ip's 192.168.0.1 and so > > on. And the netwok is working fine. I have installed MySQL

[PHP] Re. [PHP] mysql networking ?

2004-11-08 Thread Manoj Kumar
Hi its a php mailing list ? Okey . -- Manoj Kr. Sheoran "Aalee" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi guys, > I have a small home network working with just 4 computers (PC's on WinXP > Pro) connected through a switch just using the local ip's 192.168.0.1 and so >

Re: [PHP] mysql netwoking??

2004-11-08 Thread John Nichel
Aalee wrote: Hi guys, I have a small home network working with just 4 computers (PC's on WinXP Pro) connected through a switch just using the local ip's 192.168.0.1 and so on. And the netwok is working fine. I have installed MySQL on one computer and setup a database and installed MySQL on the othe

[PHP] mysql netwoking??

2004-11-08 Thread Aalee
Hi guys, I have a small home network working with just 4 computers (PC's on WinXP Pro) connected through a switch just using the local ip's 192.168.0.1 and so on. And the netwok is working fine. I have installed MySQL on one computer and setup a database and installed MySQL on the other PCs aswell.

[PHP] mysql networking??

2004-11-08 Thread Aalee
Hi guys, I have a small home network working with just 4 computers (PC's on WinXP Pro) connected through a switch just using the local ip's 192.168.0.1 and so on. And the netwok is working fine. I have installed MySQL on one computer and setup a database and installed MySQL on the other PCs aswell.

[PHP] mysql networking ??

2004-11-08 Thread Aalee
Hi guys, I have a small home network working with just 4 computers (PC's on WinXP Pro) connected through a switch just using the local ip's 192.168.0.1 and so on. And the netwok is working fine. I have installed MySQL on one computer and setup a database and installed MySQL on the other PCs aswell.

Re: [PHP] Help needed on php/mysql {Scanned}

2004-11-02 Thread Garth Hapgood - Strickland
As you can see from my code, I do want to check if all mandatory fields are selected or filled in. As well as the issue of the communicationtyes. SO far I do not have fields or anything for the user to use, to select the different CommunicationTypes he wants. I am not sure how to go about this bec

Re: [PHP] Help needed on php/mysql

2004-11-02 Thread Lists
Hmmm...I'm not sure I'm following you. You just want to know how to deal with multiple drop down lists? Or do you want to be able to check and make sure all the mandatory selections have been chosen? -dg http://www.rexruff.com On Nov 2, 2004, at 4:58 AM, Garth Hapgood - Strickland wrote: Wel

Re: [PHP] Help needed on php/mysql

2004-11-02 Thread Garth Hapgood - Strickland
Well my page doesnt have any of the spoken about elements on it yet, because I am not clear as to go about it. The fields I speak of are things that need to be added extra to my page. Here is my pages code so far... !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

Re: [PHP] Help needed on php/mysql

2004-11-01 Thread Lists
Seeing the page might help. On Nov 1, 2004, at 2:52 AM, Garth Hapgood - Strickland wrote: I have written a registration page in php and have a number of edit boxes and drop-down lists. The lists are pulling data out of their respective tables, whereas the edit boxes are just for saving data. Now

[PHP] Help needed on php/mysql

2004-11-01 Thread Garth Hapgood - Strickland
I have written a registration page in php and have a number of edit boxes and drop-down lists. The lists are pulling data out of their respective tables, whereas the edit boxes are just for saving data. Now my main table where all my data is being saved is called Business. Onto this I have a table

Re: [PHP] MySQL Scalability, part 2

2004-10-25 Thread Curt Zirzow
* Thus wrote Kevin Grigorenko: > "Zareef Ahmed" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > -Original Message- > > From: Kevin Grigorenko [mailto:[EMAIL PROTECTED] > > Sent: Monday, October 25, 2004 12:36 AM > >

RE: [PHP] MySQL Scalability, part 2

2004-10-24 Thread Zareef Ahmed
hmed -Original Message- From: Zareef Ahmed [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 8:41 AM To: 'Kevin Grigorenko'; [EMAIL PROTECTED] Subject: RE: [PHP] MySQL Scalability, part 2 -Original Message- From: Kevin Grigorenko [mailto:[EMAIL PROTECTED] Sent: M

RE: [PHP] MySQL Scalability, part 2

2004-10-24 Thread Zareef Ahmed
-Original Message- From: Kevin Grigorenko [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 8:13 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] MySQL Scalability, part 2 "Zareef Ahmed" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > -Original

Re: [PHP] MySQL Scalability, part 2

2004-10-24 Thread Kevin Grigorenko
> > Sent: Monday, October 25, 2004 12:36 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP] MySQL Scalability, part 2 > > > > Hi, > > > > First, sorry for posting an attachment. Second, I fixed my problem to > > use > > files, but I just had a general

Re: [PHP] MySQL Scalability, part 2

2004-10-24 Thread Kevin Grigorenko
"Zareef Ahmed" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > -Original Message- > From: Kevin Grigorenko [mailto:[EMAIL PROTECTED] > Sent: Monday, October 25, 2004 12:36 AM > To: [EMAIL PROTECTED] > Subject: [PHP] MySQL Scalability, part

RE: [PHP] MySQL Scalability, part 2

2004-10-24 Thread Zareef Ahmed
-Original Message- From: Kevin Grigorenko [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 12:36 AM To: [EMAIL PROTECTED] Subject: [PHP] MySQL Scalability, part 2 Hi, First, sorry for posting an attachment. Second, I fixed my problem to use files, but I just had a general

[PHP] MySQL Scalability, part 2

2004-10-24 Thread Kevin Grigorenko
Hi, First, sorry for posting an attachment. Second, I fixed my problem to use files, but I just had a general question: Is it really scalable to use MySQL on every page hit as compared to writing to files? Is it true that it only has a certain number of connections it can open at a time (20-30?

Re: [PHP] mysql and the PHP transition from 4 to 5.

2004-10-22 Thread Curt Zirzow
* Thus wrote Nick Lane-Smith: > Hello php-list, > > I'm curious to why default mysql support was dropped from PHP 5? It was due to the changes in the mysql license. Due to the changes the PHP Team decided not to enable mysql by default. MySQL had modified there license but it was too late, the

Re: [PHP] MySQL scalability...

2004-10-22 Thread Curt Zirzow
* Thus wrote Kevin Grigorenko: > > > > begin 666 hitcounter.doc Please dont post attatchments, put the file up on weberver instead and just reference it here. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL scalability...

2004-10-22 Thread Kevin Grigorenko
"John Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Kevin Grigorenko wrote: > > > Unfortunately, for some security > > issues, I cannot get to the Apache statistics for the site, so I have to > > create my own solution. > > I recommend you find a better host that gives you a

Re: [PHP] MySQL scalability...

2004-10-22 Thread John Holmes
Kevin Grigorenko wrote: Unfortunately, for some security issues, I cannot get to the Apache statistics for the site, so I have to create my own solution. I recommend you find a better host that gives you access to the raw logs and/or doesn't have safe_mode on. -- ---John Holmes... Amazon Wishli

Re: [PHP] MySQL & PHP database script PLEASE

2004-10-21 Thread Matthew Sims
> > > When GO =< 1000 ), the links to PDF file are shown, > and when GO > 1000, the links to PDF file are not shown (just brank > cells). > > So probably I need to change this part. > ?>.pdf">pdf > But dont know how to do it. > > Please help me anybody, thank you!! My syntax may look different

Re: [PHP] MySQL & PHP database script PLEASE

2004-10-21 Thread Ramil Sagum
> > .pdf">pdf > replace the above block with .pdf">pdf ganbatte! ramil http://ramil.sagum.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] mysql and the PHP transition from 4 to 5.

2004-10-21 Thread raditha dissanayake
Nick Lane-Smith wrote: Hello php-list, I'm curious to why default mysql support was dropped from PHP 5? The separation seems to have been done for license issues with the mysql library. PHP 4.X uses a libmysql with an abandoned copyright for mysql access. Suffice to say it's pretty hard to find pe

<    8   9   10   11   12   13   14   15   16   17   >