RE: [PHP-DB] % operator

2003-08-14 Thread Matthew Moldvan
Well, it looks like your previous response was correct, but $a%$b in this case returns 4, not the 0.8 as intended ... fmod($a, $b) (I have php 4.1.2, so I can't test fmod()) will probably return 0.8 though. As a side note, this message seems a little off-topic ... though it is PHP, it has nothing

Re: [PHP-DB] Extracting result - unknown number of fields

2003-08-14 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] While doing a cross tabulation, I've got a query which gives me a variable number of fields: Maybe mysql_num_fields() and mysql_field_name() will be of use, here? Check the manual.. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] Functions - scope of returned result

2003-08-14 Thread Dillon, John
To answer my own question again, I didn't assign the returned value from the function call to a variable: $piv_result=queries(); All OK. -Original Message- From: Dillon, John [mailto:[EMAIL PROTECTED] Sent: 14 August 2003 17:54 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Functions -

Re: [PHP-DB] Functions - scope of returned result

2003-08-14 Thread John W. Holmes
Dillon, John wrote: One more bite on this code. function queries(){ //code.. $piv_result=mysql_db_query($db, $query, $connection) or die (Query9 failed: $query); return $piv_result; } function print(){ global $piv_result;

[PHP-DB] DBX or PEAR::DB?

2003-08-14 Thread Juliano
Hi! Can somebody explain me what's the difference between PEAR::DB and the DBX extension included in PHP? Thanks Juliano

RE: [PHP-DB] adding integer to field in query

2003-08-14 Thread Dillon, John
Thanks to both responses. In fact, it decided to work once I put 0 in the cell that 1 was to be added to! It seems it got it started.. 1+NULL=? -Original Message- From: Matt Schroebel [mailto:[EMAIL PROTECTED] Sent: 13 August 2003 15:48 To: Dillon, John; [EMAIL PROTECTED] Subject: RE:

[PHP-DB] using PHP to find out Windows user name?

2003-08-14 Thread Chen, Mao
Hi Everyone, I'm just wondering whether we can use PHP to find out the name of user who is currently logging on to local Windows computer and accessing a particular .php web page. Thanks in advance.

[PHP-DB] PostgreSQL connection

2003-08-14 Thread Joe Nilson Zegarra Galvez
Hi all, i have a question, i have a php file with all my class to connect into a postgresql db and i'm using the pg_connect in this form: pg_connect(192.168.1.100$dbase); but when i have 8 or 10 users inserting data the db response is very slow, is problem in the pg_connect?, all ppl use the

Re: [PHP-DB] using PHP to find out Windows user name?

2003-08-14 Thread John W. Holmes
Chen, Mao wrote: I'm just wondering whether we can use PHP to find out the name of user who is currently logging on to local Windows computer and accessing a particular .php web page. Turn off anonymous browsing in IIS and you can use $_SERVER['LOGON_USER'] -- ---John Holmes... Amazon Wishlist:

[PHP-DB] Conection to MS SQL 2000 from PHP in Linux

2003-08-14 Thread Jean Fernando Ortiz
Hi all! I need to know how I must connect to MS SQL Server 2000 in a Win 2000 Server from my Internet Server with Linux, PHP 4.0.4 + Apache 1.3.19. Thanks for your help. -- PEM Jean Fernando Ortiz Arana Coordinador de TI Centro Escolar El Roble APDE - Guatemala -- PHP Database Mailing List

Re: [PHP-DB] Maximum execution time of 30 seconds exceeded

2003-08-14 Thread Michael Cortes
Duhhh. me mike. me like cumputors. This is where the honest geek admits his mistakes. I had a do while loop such as do { mysql_query ($qupdate, $link); $rslterror=mysql_error($link); $number++ } while ($rslterror!=null); I was trying to insert a new record with

Re: [PHP-DB] Sorting issue

2003-08-14 Thread David T-G
Jeff -- ...and then Jeff said... % % One last question. % % I changed all the DB values where numbers are used - (varchar - int) Well, you should only change for those where the numbers are numbers... % % But for the well locations, there are dashes in them, I.E. 10-15-065-22 Exactly. %

RE: [PHP-DB] file upload security issue

2003-08-14 Thread Jennifer Goodie
I try to learn file uploading in PHP. I've successfully uploaded a file onto my server. I use move_uploaded_file(tmp_dir/tmp_filename, destination_dir/filename) to move the temp file. The thing is that I have to do a chmod 777 destination_dir in order to move the file. Is this bad for

Re: [PHP-DB] sql or php?

2003-08-14 Thread otherguy
On Tuesday, August 5, 2003, at 05:56 PM, Merlin wrote: Hi there, I am wondering if this could be done with mysql and without php, just with sql. I do have a table with text and another one with pictures. Now I would like to print out all titles and mark those tests containing a picture with a

RE: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Matt Schroebel
-Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:52 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Oops, my mistake, it's not a blank entry - it re enters the last entry. I can hit F5 or click refresh 1000 times

Re: [PHP-DB] Sybase Query- Problems with Pound Sign

2003-08-14 Thread Tiberiu Ardeleanu
Try: $sql = select * from item where \bib#\ = 300; - Original Message - From: Jeremy Peterson [EMAIL PROTECTED] To: PHP DB [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 4:34 AM Subject: [PHP-DB] Sybase Query- Problems with Pound Sign I am having a problem with a query that has

Re: [PHP-DB] Sorting issue

2003-08-14 Thread Jeff
Yes duh... I didn't realize numbers weren't considered characters. What's the sql entry for numeric characters? I'm new at this, and figure I'm not doing to bad so far. . John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Jeff wrote: kwo VARCHAR(10) NOT NULL, lsd

RE: [PHP-DB] Don't know why query works this way

2003-08-14 Thread Aaron Wolski
Here's some functions I use in my development which save on connect and query calls for me. //General Purpose Utilities. //db_connect connects to the database server and selects the proper database. //Arguments: None //Returns: Nothing function db_connect() {

[PHP-DB] Re: PHP MSSQL

2003-08-14 Thread Adam Presley
Ok. Special thanks to Robert Twitty for the answer. I started using the TEXT datatype to achieve long texts of data. However, PHP.INI is configured by default to limit TEXT datatype retrievals to 4K. Change the mssql.textlimit in the INI file to suit your purposes, and use the TEXT datatype.

[PHP-DB] Re: Interbase queries

2003-08-14 Thread Wil van Lierop
Dear Evan, It depends what you send in your SQL statement ($sqlstmt), as far as i know Interbase need only commit-statements depending on your I-Base server setting AUTO-COMMIT=Tue/False. And only then when you send UPDATE queries. For SELECT statements you dont need a COMMIT. But beware that you

[PHP-DB] URGENT BUSINESS RELATIONSHIP

2003-08-14 Thread PRINCESS GRACE ABONIME
The Palace of King of Ogoni Kingdom, Ogoni Oil producing community, Rivers State Nigeria. Dear Sir, I am Princess Grace , daughter of HRH King Solomon Abonime, the king of Ogoni Kingdom. I am 25 years old and a graduate of Mass Communication. My father was the king of Ogoni Kingdom

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

2003-08-14 Thread Larry E . Ullman
As of Version 4.0.1, MySQL can also perform boolean full-text searches I am running Mysql 3.x . This sounds like a simple task to me. Is it not implemented in 3.x? It does not have to be OR, NOR or anything, just AND I've never tried it, but you might be able to get away with SELECT columns FROM

Re: [PHP-DB] Sorting issue

2003-08-14 Thread John W. Holmes
Jeff wrote: Yes duh... I didn't realize numbers weren't considered characters. What's the sql entry for numeric characters? I'm new at this, and figure I'm not doing to bad so far. . Make them an INT column. It'll hold numbers up to 2 billion+. Or you can use TINYINT which will hold numbers up

[PHP-DB] Sybase Query- Problems with Pound Sign

2003-08-14 Thread Jeremy Peterson
I am having a problem with a query that has a pound sign in it. The results are quite puzzling, it seems like the page doesn't load if the query is present. I have tested this on other tables without the pound sign and they work beautifully, seems like the pound sign is the troublemaker to

[PHP-DB] Re: MySQL and PHP?

2003-08-14 Thread Chris Berlioz
Read: http://www.mysql.com/products/licensing-examples.html === Richard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello I hope this is a rumour but I heard that MySQL is now fully GPL which it wasn't earlier. I think the part used to communicate with the mysql

RE: [PHP-DB] Breaking down a table field....

2003-08-14 Thread Duane Lakoduk
I think you may already have this, but just another 20 pesos SELECT Unit, COUNT(Unit) [Quantity] FROM table GROUP BY Unit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 8:52 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:

[PHP-DB] Free PHP Editor

2003-08-14 Thread Norma Ramirez - TECNOSOFT
Hi all, after look and evaluate the options that all you kindly recommended, I decide to use the free version of Maguma, it has several capabilities that makes good, with a bit disadvantages but I think is pretty good. Another option is php edit, but unfortunately is not yet available a formal

Re: [PHP-DB] Left Join with more than two tables......

2003-08-14 Thread Brent Baisley
The left join works the same for two or more tables. select * from table1 left join table2 on table1.id=table2.id left join table3 on table1.id=table3.id ... Just specify the table you want to join and what to use to join them. On Tuesday, August 12, 2003, at 03:16 PM, Michael Cortes wrote: I

RE: [PHP-DB] Renaming .htm pages to .php

2003-08-14 Thread Dennis Cole
I would recommend changing them all to .php files. If you ever change hosts, or servers you might not be able to change them, also it could be less secure too == Dennis Cole @ Sanford Weather - Sanford, MI, USA -

[PHP-DB] SET data type and check boxes on form

2003-08-14 Thread Keith Wilkinson
I'm looking for an example of how to: (1) From data entry form, store selected check boxes as MySQL SET (bit) data, (2) In Modify data entry form, display previously-entered data (from database) as checkbox form defaults, (3) When SEND is clicked on form, display text labels of

Re: [PHP-DB] Help with formating text from PHP

2003-08-14 Thread Andrew D. Luebke
Well, as one of the last posts said, if you are displaying in a web browser, via HTML, you need to insert br tags where you want the text to go to the next line. HTML doesn't respond to /r/n pairs. So if that is how the user types them in (with a enter key at the end of lines) you need to

[PHP-DB] Problems with input and modify data on a form.

2003-08-14 Thread José Luis Palacios Vergara
I have a problem with some programs, I am using 4 frames, 3 of them are for input data, the top frame is using for input information (right now only alow show existing information), in the middle frame appear information and with the bottom frame it's possible navigate through the records, I

[PHP-DB] Problems with input and modify data on a form.

2003-08-14 Thread José Luis Palacios Vergara
begin 666 empresa01.zip [EMAIL PROTECTED])[EMAIL PROTECTED]'[EMAIL PROTECTED]F5S83 Q+G-Q;.1= MZ8[.)+^;Z#?@@!UC903NL^9K _F!)3R;(DJBDIW948H+OKNDUX*-1MAN8 M)^KG\1MM!(,Z\K!=M1=06L,V,RF64AGG%P=9?V'5O]J?RF;VP_O/['\\[O? MF;*?WCT%_C+MA\^?OHK\QQG%3HKUPM6;A RQO+K3]?_N/YX\U=V\^[WVYN/ [EMAIL

Re: [PHP-DB] ODBC Database

2003-08-14 Thread Gerard Samuel
Robert Twitty wrote: Unless I am mistaken, but isn't there an ODBC driver available for MySQL called MyODBC? -- bob I haven't a clue. Ill look, maybe it will help me create drivers for my DB layer, as I already know MySQL. Last night I successfully connected to IBM's DB2, but I didnt get far

Re: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Jason Wong
On Wednesday 06 August 2003 01:14, Jeff wrote: Well I did what you said, and now I get Parse error: parse error, unexpected T_ECHO in C:\FoxServ\www\encana_db.php on line 44 Try: $result = mysql_query($query, $link_id) OR die(mysql_error()); -- Jason Wong - Gremlins Associates -

[PHP-DB] Help needed with variable scoping? or mysql problem

2003-08-14 Thread Mike Klein
I've been using JSP for some time now, and thought I'd write a couple of rdbms explorers (flat tables, simple master/detail paradigm) using other technologies, like PHP, Cocoon, etc. Well...it's been fun. I have more working than not. But now I am hung up. I am getting wierd results in a php

Re: [PHP-DB] Help with formating text from PHP

2003-08-14 Thread Budelak
You guys thanks for the encouragement. I finally solved it with this: ?php $text= preg_replace(/(\015\012)|(\015)|(\012)/,nbsp;br /, $rsDailynewsDetail-Fields('newsfull')); echo $text; ? Help came of course from the link Holmes gave. Thanks. Budelak wrote: Yes. Itis with enter key. It will not

Re: [PHP-DB] Breaking down a table field....

2003-08-14 Thread jeffrey_n_Dyke
SELECT DISTINCT(Unit) from TABLE_NAME; [EMAIL PROTECTED]

[PHP-DB] RE: Pivot tables

2003-08-14 Thread Dillon, John
Darn, here's the link: http://www.mysql.com/articles/wizard/print_version.html -Original Message- From: Dillon, John Sent: 11 August 2003 19:09 To: [EMAIL PROTECTED] Subject: Pivot tables Here is the worth-reading mysql answer to my question below. Pity it's implemented on perl not

RE: [PHP-DB] % operator

2003-08-14 Thread Matthew Moldvan
There's probably a better way to do this, but to retrieve only the 0.8 from 24/5 try this: ($a/$b)-floor($a/$b) Regards, Matt. -Original Message- From: Alain Barthélemy [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 5:05 AM To: php-db Subject: [PHP-DB] % operator Hello, If

RE: [PHP-DB] Extracting result - unknown number of fields

2003-08-14 Thread Dillon, John
..but even if I can get the names and number of fields during 'run-time', how do I make the following statement applicable to a variable number of fields: while(list($a,$b...)= mysql_fetch_array($result)) or is there another way to extract which would work? John -Original Message-

Re: [PHP-DB] Table Field type

2003-08-14 Thread CPT John W. Holmes
From: Michelle Whelan [EMAIL PROTECTED] Does anyone know what field type to use for inserting a webpage name into a database? Example pagename.html When I fill in the form information everything seems to insert fine, then I do a search to see the result and nothing is there, so I check the

[PHP-DB] Re: Maximum execution time of 30 seconds exceeded

2003-08-14 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... I am using the Konqueror browser and browing to http://localhost/my.php Howerver, the script I wrote, doing various queries and lookups, inserts, etc.. takes a while to complete. That is fine with me. I'll wait. However,

[PHP-DB] Re: newbie lost on data import... part 2

2003-08-14 Thread jsWalter
This SQL is generated by my script... INSERT INTO cbs_eps ( eps_id , eps_name , eps_num , eps_air_date ) VALUES ( '5','No Hiding Place','5','1974-01-10'); 'eps_id' is generated from the index ($x) of the array loop the others are retrieved from the tab delimted text file When run from

Re: [PHP-DB] % operator

2003-08-14 Thread Phil Driscoll
On Tuesday 12 August 2003 10:39 am, Phil Driscoll wrote: The modulus is the remainder after division hence 5 into 24 goes 3 times with a remainder of 4, oops - 4 times with a remainder of 4 :( -- Phil Driscoll -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] sybase time outs

2003-08-14 Thread Mills Staylor
Hi Guys. Is it possible to specify a sybase timeout with the current stable version of php? I am using --with-sybase (dblib) compiled against sybase OCS. Thanks Mills -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] ODBC Database

2003-08-14 Thread jeffrey_n_Dyke
there is _definitely_ a MyOdbc Driver. i'm using it Gerard Samuel

[PHP-DB] Breaking down a table field....

2003-08-14 Thread Tristan . Pretty
I have a table, wth many entries. Each entry has been asigned a unit to belong to. I want to list all the units dynamically. How can I display all the units, without displaying each instance of the unit? EG: Unititem breakfast cereal breakfast

RE: [PHP-DB] determining if a query returns no value

2003-08-14 Thread Matt Schroebel
Wendall Williams wrote: If the client has no entries for that category, it needs to move on to the next category. Yes, see mysql_num_row($result). That function will return the number of rows in the result set. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

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

2003-08-14 Thread Larry E . Ullman
I do get results for islands in greece as well. How can I specify in my statement, that both words have to be present? From the MySQL manual: As of Version 4.0.1, MySQL can also perform boolean full-text searches using the IN BOOLEAN MODE modifier. mysql SELECT * FROM articles WHERE MATCH

RE: [PHP-DB] incrementor in loop is not incrementing.. any thoughts?

2003-08-14 Thread Aaron Wolski
Hi There, Yeah.. it was a copy paste Trying again: $threadQuery = db_query(SELECT id,type,colourID FROM kcs_threads WHERE id=.escapeValue($typeResult[id])); for ($i=0;$threadResult = db_fetch($threadQuery);$i++) { echo $threadResult[colourID]. .$i; } Output: 223 0 225 0 301 0

Re: [PHP-DB] Configuring PHP with Firebird

2003-08-14 Thread Jason Wong
On Wednesday 06 August 2003 13:41, Evan Morris wrote: Basically, I want to know if it is possible to make PHP aware of Interbase/Firebird *without* recompiling PHP. It depends on how you've installed PHP. If it was installed from a distro's RPM then maybe there's no need to recompile -- ask

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

2003-08-14 Thread Merlin
As of Version 4.0.1, MySQL can also perform boolean full-text searches I am running Mysql 3.x . This sounds like a simple task to me. Is it not implemented in 3.x? It does not have to be OR, NOR or anything, just AND merlin Larry E . Ullman [EMAIL PROTECTED] schrieb im Newsbeitrag

Re: [PHP-DB] PHP MSSQL

2003-08-14 Thread Matthew McNicol
Shaun, the MySQL manual suggests that you have hit your limit using the VARCHAR field type (255 characters). To store 6,000 characters have you not considered using the TEXT field type? 6.2.3.1 The CHAR and VARCHAR Types The CHAR and VARCHAR types are similar, but differ in the way they are

Re: [PHP-DB] Re: PHP MSSQL

2003-08-14 Thread jeffrey_n_Dyke
personally, i had luck with the statement below, but have sent it to others in the past and they had varying results. but give this a shot at the top of your page that your PHP code is running on. mssql_query(set textsize 65536); hth Jeff

[PHP-DB] PHP and XML

2003-08-14 Thread Rick Dahl
What is the best way to parse through a non-repeting XML output using php? - Rick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] displaying result across 3 cells - where did I go wrong?

2003-08-14 Thread Aaron Wolski
Hey John, Thanks for spotting that. So.. do I need to use 2 different incrementors? $z and say $x for each part? I basically pieced this code together from several examples I found so forgive forgive the fact I don't know a whole lot about the code even though I've tried to understand it as

Re: [PHP-DB] Calculated field in MySQL

2003-08-14 Thread John W. Holmes
Morten Twellmann wrote: Hello, I got the following error message from MySQL: --- Query failed. MySQL said: Unknown column 'AGE' in 'where clause' query = SELECT *, (Year(Now()) - Year(BDAY)) + ((DAYOFYEAR(Now())-DAYOFYEAR(BDAY))/365) as AGE FROM Katalog WHERE AGE = 31 AND AGE = 50 AND

[PHP-DB] dynamic image generation

2003-08-14 Thread Matthew Horn
Hello, I want to generate information graphics on the fly using MySQL and PHP. I've played with the GD package and been able to generate images, but my problem going forward is that the amount of text in each graphic will be variable (some have 10 lines, some have 5), which affects the size of

Re: [PHP-DB] ODBC Database

2003-08-14 Thread Gerard Samuel
Larry E.Ullman wrote: Im looking at venturing into working with PHP's ODBC extention. Does anyone have any recommendations as to a Database, that is easy to understand/get into from a novice point of view, that installs on windows 2k, and is free? MySQL is kind of free, installs on W2K and is

RE: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Matt Schroebel
-Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:15 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Every time I access or refresh the page, it adds one blank entry to the DB. Maybe I have the insert query in the

[PHP-DB] Multiple checkboxes

2003-08-14 Thread Mike Baerwolf
Hello, I'm trying to get the values from a form post with multiple checkboxes checked . Here is what I have, if ($row = mysql_fetch_array($result)); do { input type=checkbox name=class_id[] value=$row[class_id] $row[name] }while ($row = mysql_fetch_array($result));

[PHP-DB] problem with some functions MYSQL in LINUX

2003-08-14 Thread Nilashis
HI I'm having a problem using some php functions in LINUX machines. I'm trying the "header" function to redirect my visitiors to a specific page i want to generate the pages dynamically , using arguments (For ex.

[PHP-DB] Query Cache not Working? MySQL 4.0.14-standard

2003-08-14 Thread Matt Babineau
For some reason my MySQL doesn't seem to be caching queries! Is there a manual config change that needs to be made or do I need to rebuild mysql some special way? I couldn't find anythign in the docs about this, but it would greatly help my PHP pages if it were caching properly! Thanks, Matt

RE: [PHP-DB] MySQL and PHP?

2003-08-14 Thread Natividad Castro
posgreSQL -Original Message- From: Richard [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 1:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL and PHP? Hello I hope this is a rumour but I heard that MySQL is now fully GPL which it wasn't earlier. I think the part used to

[PHP-DB] [SPAM?] [PHP-DB] URGENT BUSINESS RELATIONSHIP

2003-08-14 Thread PRINCESS GRACE ABONIME
This mail is probably spam. The original message has been attached along with this report, so you can recognize or block similar unwanted mail in future. See http://spamassassin.org/tag/ for more details. Content preview: The Palace of King of Ogoni Kingdom, Ogoni Oil producing community,

RE: Re: [PHP-DB] Breaking down a table field....

2003-08-14 Thread usban
SELECT Unit,COUNT(Unit) as quantity FROM TABLE GROUP BY Unit -- Oscar Satorre Pérez [EMAIL PROTECTED] -- - Mensaje Original - Remitente: [EMAIL PROTECTED] Destinatario: [EMAIL PROTECTED] Fecha: Jueves, Agosto 7, 2003 3:52pm Asunto: Re: [PHP-DB] Breaking down a table field

Re: [PHP-DB] Maximum execution time of 30 seconds exceeded

2003-08-14 Thread Michael Cortes
This worked great. I am keeping a table of available PINs for each of my groups of students. I rewrote the code to get a random number from the table and if if it updates the student successfully, it deletes the number from the availables table. Thanks a lot! On Monday 11 August 2003 03:09

Re: [PHP-DB] adding integer to field in query

2003-08-14 Thread Ignatius Reilly
Your SQL looks legal (at least for MySQL). Probably a PHP error then. Do a die( $query ) to see if the query is well-formed and $thisID correctly interpolated. Personnally I would rather write: $query= UPDATE Choice SET visits = visits + 1 WHERE ID = {$thisID} ; [if ID is of

Re: [PHP-DB] Extracting result - unknown number of fields

2003-08-14 Thread John W. Holmes
Dillon, John wrote: OK, please ignore, I believe I've found the answer in the manual notes: $query=your SQL; $result=mysql_query($query) or die(Query ($query) sucks!); $fields=mysql_num_fields($result); echo table\ntr; for ($i=0; $i mysql_num_fields($result); $i++) //Table Header Calculate the

RE: [PHP-DB] adding integer to field in query

2003-08-14 Thread Matt Schroebel
Dillon, John mailto:[EMAIL PROTECTED] wrote on Wednesday, August 13, 2003 10:24 AM: How do you add a number to a field within the query, ie without having to extract? Eg $query=UPDATE Choice SET visits=(visits+1) WHERE ID='$thisID'; is the above visits=(visits+1) legal, cos it doesn't

[PHP-DB] DB2 and php serialized data

2003-08-14 Thread Gerard Samuel
Most likely its not a PHP issue, but looking to see if anyone has run into this. I've inserted a serialized string, into a CLOB column. Trying to retrieve the column returns no results. If anyone has any DB2 experience, I'd be grateful if I can bounce a few questions to you offlist. Thanks for

Re: [PHP-DB] Left Join with more than two tables......

2003-08-14 Thread Michael Cortes
Thanks. I couldn't find the correct syntax in my resources. I tried at one point to use commas like: select * from table1 left join table2,table3 on table1.id=table2.id,table1.id=table3.id Thanks again for the correct syntax. On Tuesday 12 August 2003 04:00 pm, Brent Baisley wrote: The left

[PHP-DB] file upload security issue

2003-08-14 Thread Chen, Mao
Hi everyone, I try to learn file uploading in PHP. I've successfully uploaded a file onto my server. I use move_uploaded_file(tmp_dir/tmp_filename, destination_dir/filename) to move the temp file. The thing is that I have to do a chmod 777 destination_dir in order to move the file. Is

Re: [PHP-DB] Re: PHP MSSQL

2003-08-14 Thread Robert Twitty
I believe this is only applicable to fields of type text. It may have no effect on varchar(255) fields. The purpose of this statement is to limit the amount of memory allocated by the driver for text data. If it is not specified, the driver will try to allocate 2GB of memory. The extension sets

[PHP-DB] full text search in mysql

2003-08-14 Thread Merlin
Hi fellowes, I am working on a full text search in php and mysql. It workes pretty good, with one exception. If two words are entered, I do get results for each words in seperate as well. Examle: carribean islands I do get results for islands in greece as well. How can I specify in my

[PHP-DB] PHP/DB2

2003-08-14 Thread Gerard Samuel
I started playing with DB2 earlier this week. And come to find out that it creates table names/columns in UPPER case. Does anyone have any experience using DB2 in a cross platform manner, with other dbs such as MySQL? Just looking for ideas, as I've run out of them... Thanks -- PHP Database

[PHP-DB] Re: newbie lost on data import... part 3

2003-08-14 Thread jsWalter
OK, now I am really sure it has to do with the vars I defined from my text file... Once I have the text file open, I'm looping through it... // pull RETURN off the end $trimmed = rtrim($lines[$x]); // Pull apart array element list($strDate,$strNum,$strName) = explode (\t, $trimmed); //

Re: [PHP-DB] Maximum execution time of 30 seconds exceeded

2003-08-14 Thread Michael Cortes
I do have an auto_increment for the record id. But that is just a way for me to uniquely id the record. Student numbers, barcodes, etc can change. The reason I am using the do/while loop is: Every student is getting a 4digit pin for library, cafeteria and network access. It has to be

RE: [PHP-DB] Sorting issue

2003-08-14 Thread Fernando Soto
This would happens ifyou have defined the data type of the columns as char or varchar. ---Original Message--- From: Aaron Wolski Date: Viernes, 08 de Agosto de 2003 08:51:04 a.m. To: 'Jeff'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Sorting issue Seeing code might help us. Aaron

Re: [PHP-DB] Database Design Issue

2003-08-14 Thread Jason Lange
Yes, songs do span shows. However, the list of songs for each weeks show starts out as a *.asc (same a *.txt) space-separated file. This gets uploaded via a PHP file that formats each row and inserts it into the database. That's why even though I know there will be duplication it appears (to

RE: [PHP-DB] % operator

2003-08-14 Thread Andrew D. Luebke
The easiest way would probably be to use the fmod function. http://us3.php.net/manual/en/function.fmod.php Andrew. At 11:43 AM 8/12/2003, Matthew Moldvan wrote: There's probably a better way to do this, but to retrieve only the 0.8 from 24/5 try this: ($a/$b)-floor($a/$b) Regards, Matt.

[PHP-DB] Re: Don't know why query works this way

2003-08-14 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... I have been writing my queries like this... $link = mysql_connect ($host, $username, $password); $query = insert into $table ('joe', 15); if ( mysql_db_query($dbname, $query, $link)) { } But then I was reading

[PHP-DB] Making PHP aware of Firebird 1.5

2003-08-14 Thread Philippe Makowski
I'm trying (Firebird 1.5 RC4 PHP 4.3.1 Mdk 9.1.) Get the PHP source from http://www.php.net/downloads.php untar it: tar xvfz php-*.tar.gz cd to the untared base dir: cd php-4* according to http://bugs.php.net/bug.php?id=23928 add #define ISC_FAR in php_interbase.h export LIBS=-lstdc++ -lcrypt

[PHP-DB] Problems with input and modify data on a form.

2003-08-14 Thread José Luis Palacios Vergara
begin 666 formfill.zip [EMAIL PROTECTED])`-*!R\H$P'/[EMAIL PROTECTED]0!```49F]R;69I;PO86-E'1A MBYG:69S]W2SL$PT8^!E.,+ \/___R^7.SZ=;7A_K/SM_OQ7.]*;6YXNJG^ MQ:XIZM'R_Q?3#7Y=XTF]O]QC[M*\U*EVIEKI4J7Q1/!\+N9-(9_C$P, M('B3Q96$091!AT0!V0G`^M#A0*7D,QY:O6K94;=BHQ'CI7L#%.RL=ETUN

Re: [PHP-DB] Database Design Issue

2003-08-14 Thread CPT John W. Holmes
From: Jason Lange [EMAIL PROTECTED] Here's my question. I'm creating a website for a weekly radio show. One of the items I would like to store in the database is the list of songs played in each show (there's normally between 20-25 songs per show), and the songs will be displayed by show.

Re: [PHP-DB] Help with formating text from PHP

2003-08-14 Thread Budelak
Yes. Itis with enter key. It will not be possible to pre-determine the length as this field is supposed to be a news field. I'm lost as to how to go about this as the enter key does not generate chr(13) when saving. I'm really lost. Holmes directed me to http://us2.php.net/nl2br. I'm

[PHP-DB] Extracting result - unknown number of fields

2003-08-14 Thread Dillon, John
While doing a cross tabulation, I've got a query which gives me a variable number of fields: $query=SELECT Dept; $count=count($piv_cos); for($x=0;$x$count;$x++){ $query.=, SUM(IF(Co='$piv_cos[$x]',Exps175,0)) AS '$piv_cos[$x]'; } $query.= FROM $tbl1 GROUP BY Dept;

[PHP-DB] Don't know why query works this way

2003-08-14 Thread Michael Cortes
I have been writing my queries like this... $link = mysql_connect ($host, $username, $password); $query = insert into $table ('joe', 15); if ( mysql_db_query($dbname, $query, $link)){ } But then I was reading that I should use mysl_query instead of mysql_db_query. But I

[PHP-DB] about resultset internal pointer

2003-08-14 Thread Peng Cheng
in php,mysql_seek can move the pointer, but you have no way to know where the pointer locates currently. i think some function should be added in the future version, like mysql_getPointerPosition($rs) which returns a int as the position in resultset. so it's would be easy to implements some

RE: [PHP-DB] Functions - scope of returned result

2003-08-14 Thread Dillon, John
One more bite on this code. function queries(){ //code.. $piv_result=mysql_db_query($db, $query, $connection) or die (Query9 failed: $query); return $piv_result; } function print(){ global $piv_result; $count_fields=mysql_num_fields($piv_result);

Re: [PHP-DB] Help with formating text from PHP

2003-08-14 Thread John W. Holmes
Budelak wrote: Hello, Can someone help with this problem I've been trying to solve but don't how to. I have a field of type longtext that contains text with paragraphs at the time of entry. But when I display this text content, the paragraphs are not shown. Everything will just appear in one

Re: [PHP-DB] Query Cache not Working? MySQL 4.0.14-standard

2003-08-14 Thread CPT John W. Holmes
From: Matt Babineau [EMAIL PROTECTED] For some reason my MySQL doesn't seem to be caching queries! And you expect PHP to solve this how? Do you want PHP to cache the queries? You must say please... You need to set the four variables mentioned at the following URL in your my.cnf file.

Re: [PHP-DB] Breaking down a table field....

2003-08-14 Thread Tristan . Pretty
My word, easy when you know how...! Cheers mate!!! [EMAIL PROTECTED] 07/08/2003 14:42 To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:Re: [PHP-DB] Breaking down a table field SELECT DISTINCT(Unit) from TABLE_NAME;

Re: [PHP-DB] Pulling an ID list from a DB, then filtering that list againstanother list of ID's

2003-08-14 Thread CPT John W. Holmes
From: Matt Babineau [EMAIL PROTECTED] Got an interesting problem! I have a list of ID's, basically things people have viewed on my website. When I pull the viewable items from my database, I need to be able to filter out all the ID's people have already viewed, so that they only get a list of

Re: [PHP-DB] % operator

2003-08-14 Thread Doug Thompson
The % is called the Modulus operator. It is very briefly explained in the PHP manual in table 11-2. In your example, $mod = $a % $b == $mod = 0.8 It is a very easy operator to use. Doug On Tue, 12 Aug 2003 11:04:39 +0200, Alain Barthélemy wrote: Hello, If you have $a = 24; $b = 5; and

Re: [PHP-DB] Pulling an ID list from a DB, then filtering thatlist againstanother list of ID's

2003-08-14 Thread Matt Babineau
Here is what I have for a layout: thing_id - it is a hash value (md5()) I have a user session variable that is an array thing_id's that were viewed. So each time the user click a like to view a thing_id, I note that in a session variable, so when they go back to the home page, all the things

Re: [PHP-DB] Sybase Query- Problems with Pound Sign

2003-08-14 Thread John W. Holmes
Jeremy Peterson wrote: I am having a problem with a query that has a pound sign in it. The results are quite puzzling, it seems like the page doesn't load if the query is present. I have tested this on other tables without the pound sign and they work beautifully, seems like the pound sign

RE: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Hutchins, Richard
So create a hidden input field on the page called cur_id and set its value to the id of the record being displayed. If no record is currently being displayed, set it to -1. When you get ready to handle the form data, check the $_POST['cur_id'] variable. If it's set to -1, perform an INSERT. If

Re: [PHP-DB] Extracting result - unknown number of fields

2003-08-14 Thread John W. Holmes
Dillon, John wrote: ..but even if I can get the names and number of fields during 'run-time', how do I make the following statement applicable to a variable number of fields: while(list($a,$b...)= mysql_fetch_array($result)) or is there another way to extract which would work? $num_fields =

  1   2   >