[PHP-DB] interbase.so PHP 4.3.1 Mdk 9.1

Any one have a rmp or something else whith an compiled interbase.so so I can enabled Firebird 1.5 acess on my PHP 4.3.1 Mdk 9.1 machine ? -- Philippe Makowski Firebird serveur SQL open-source en français http://firebird-fr.eu.org Ma clé PGP : http://makowski.eu.org/pgpkey.html -- PHP Datab

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

I have this: $threadQuery = db_query("SELECT id,type,colourID FROM kcs_threads WHERE id=".escapeValue($threadsResult[id])); for ($z=0;$threadResult = db_fetch($threadQuery);$z++) { echo $threadResult[colour]." ".$z; } which is producing: 223 0 225 0 301 0 304 0 326 0

Re: [PHP-DB] MySQL Returns Error

I'm unsure of both suggestions, can someone go into more detail? "Richard Hutchins" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 >

[PHP-DB] mssql and Apache 1.3.28 and Win2k

I'm not shure that's a pure PHP bug, the problem only occur since I've ugraded Apache to 1.3.28. All SQL queries containing tables or column names containing special chars (ie: e) fails with the following PHP error message : "mssql_query(): message: Invalid object name 'Negociateurs'. (severity

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 and it will enter the last entry 1000 times. "Jeff" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I tried putting that in a few diffrent places, same result - is ther

[PHP-DB] dual-processors and php

My php scripts that work well on single-processor machines will not work when I put them on a dual-processor server running RedHat 8.0. Is this a matter of settings in php or in the mysql database that provides the data? I can connect to the database through the php.include scripts, but then I

Re: [PHP-DB] MySQL Returns Error

I tried putting that in a few diffrent places, same result - is there somewhere special I need to put that? "Matt Schroebel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 05, 2003 3:15 PM >

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

I'm building a resume page and I am having a problem. I need to query a table to determine if the client has any entries in that table. If they do, it needs to display the category title once then display the entries in rows. If the client has no entries for that category, it needs to move on t

Re: [PHP-DB] mysql problem importing data

You could use mysqlimport with --fields-terminated-by=";" or you could open it in something like Excel, parse it there (text to columns), and save it as a CSV or you could read it line by, line into PHP, explode each line on the ;, then insert the data into MySQL or you could write a script tha

RE: [PHP-DB] dual-processors and php

In <[EMAIL PROTECTED]> Jennifer Goodie wrote: > > Did you change any of the database settings? Are you getting an error > after your call to mysql_select_db()? > Thanks for responding. No, I didn't change the database settings, but I don't know if they were changed in the binary (rpm) instal

[PHP-DB] Re: about resultset internal pointer

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > 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 posi

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

How are the paragraph breaks represented in the original text? You have have to detect the paragraph breaks and change to a /r/n. Andrew. At 11:40 PM 8/9/2003, 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 t

[PHP-DB] Re: sybase time outs

On Fri, 08 Aug 2003 15:06:49 +0200, Michael Peppler wrote: > On Thu, 07 Aug 2003 12:07:47 -0400, Mills Staylor wrote: > >> 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. > > I'm cur

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

"John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > jsWalter wrote: > What kind of columns are you inserting these values into? eps_id int(11)Yes 0 eps_name varchar(100) Yes NULL eps_num int(11) Yes NULL eps_air_date date Yes -00-0

Re: [PHP-DB] Sorting issue

Jeff wrote: kwo isn't sorting properly... actually, I need to retest the lsd column too. Can you answer the question we ask please? It's already been pointed out to you several times that a CHARACTER column is going to sort in the manner you found while an INTEGER column will not. So, you MUST b

Re: [PHP-DB] Insert problem

G'day All, Duh! Sorry, I had deleted the line that calls the query. I need to get home... cheers kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] ODBC Database

whoops, meant to include thishttp://www.mysql.com/downloads/api-myodbc-3.51.html [EMAIL PROTECTED]

Re: [PHP-DB] Sorting issue

The MySQL script I made, CREATE TABLE cnrl_db ( gradient MEDIUMINT(10) NOT NULL AUTO_INCREMENT, kwo VARCHAR(10) NOT NULL, lsd VARCHAR(20) NOT NULL, date DATE DEFAULT '-00-00' NOT NULL, well VARCHAR(50) NOT NULL, field VARCHAR(25) NOT NULL, uni VARCHAR(30) NOT NULL, license VARCHAR(10) BINARY N

[PHP-DB] Re: PHP & MSSQL

I know what you're going through here. In MS SQL you can define a VARCHAR up to about 8000 characters, but your PHP mssql_query command only returns 255 (0 - 254) characters. I then tried using the TEXT datatype. TEXT datatype in MS SQL allows somewhere around 2 billion characters. However, the PHP

[PHP-DB] Store images in postgres database

Hi everybody ! I haven´t could store images on my postgres database tables from my php form. I did it on mysql and this works but now I´m working on postgres,I created a table in my postgres db like this: "CREATE TABLE planos(id serial primary key, image OID, filesize int(8), filename

Re: [PHP-DB] RE: Pivot tables

All of the work is in the queries, so it doesn't matter that the example at the end is in Perl. The whole concept is that you're using SUM(IF(column=value,1,0)) to sum up your values. To get each of the "values" you can run a query and use the results of that query to build your second query with

[PHP-DB] Help with formating text from PHP

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 long text with n

[PHP-DB] mount command with php in through the web

Hi All, is there any way i can run mount command with php script in the web , bcz. mount command run only for super user as apache user is there any way to run. plz. help me in this regard. Thank You, Suman -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www

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

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, the server and/or browser will not wait. I believe the server i

[PHP-DB] % operator

Hello, If you have $a = 24; $b = 5; and $c = $a/$b; ===> $c = 4.8 To retrieve the .8 (reste in french) I saw instruction: $a%$b Where can I find a manual for this '%' operator? Of course I already looked in all the Php manuals (operators, etc ...). Thanks, -- Alain Barthélemy [EMAIL PR

[PHP-DB] Calculated field in MySQL

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 IS_MEM_EXP = 0 AND IS_OPEN = 1

Re: [PHP-DB] % operator

On Tuesday 12 August 2003 10:27 am, Doug Thompson wrote: > 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 The modulus is the remainder after division hence 5 into 24 goes 3 times with a re

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

Why is it important that you "recycle" old PINs? This is most likely eating up the most time in your script execution. My suggestion would be to either A) just keep creating a new one and ignore ones when a child leaves or B) create a 2nd, much smaller table "available_pins" and when a child l

RE: [PHP-DB] % operator

Although now that I look at: http://us4.php.net/manual/en/language.operators.arithmetic.php You'll see that $a % $b resturns the modulus so that is probably the easiest. Andrew, At 11:43 AM 8/12/2003, you wrote: There's probably a better way to do this, but to retrieve only the 0.8 from 24/5 t

RE: [PHP-DB] Date format problem

> > I have a field in my mysql db wich is a timestamp with the format > > mmddhhmmss > > and I would like to display it like: > > dd/mm/ > http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333 SELECT DATE_FORMAT(timestamp_col_name, '%d/%m/%Y') FROM table_name -- PHP Datab

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

I know that we can .. select last_name,first_name, table2.school from table1 left join table2 on school_id=bldg_id Listing all students and giving the school name for all students, if they have one. If not, it lists the kid anyway and leaves that field blank. Anyhow, how about multiple ta

[PHP-DB] Table Field type

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 entry in the database and there is an em

Re: [PHP-DB] PHP/DB2

Ok, I figured out my problem. It wasn't the table names in UPPER case, but the unique id that prepended to the table names that was missing. Gerard Samuel wrote: 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

[PHP-DB] test, please delete

test, please delete -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] adding integer to field in query

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 work at the moment? Thanks, John    

[PHP-DB] Date format problem

Hello, I have a field in my mysql db wich is a timestamp with the format mmddhhmmss and I would like to display it like: dd/mm/ how do I do that? Thank you in advance, Dani --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version

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

begin 666 formfill.exe M35I0``([EMAIL PROTECTED] `: M``(``+H0``X?M G-(;@!3,TAD)!4:&ES('!R;V=R M86T@;75S="[EMAIL PROTECTED](@5VEN,S(-"B0W M M`

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

Ah ha! perfect! I wanted a way for SQL to handle this. DUH! Thanks John. -Matt On Thu, 2003-08-14 at 17:20, John W. Holmes wrote: > Matt Babineau wrote: > > 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

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

Matt Babineau wrote: 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 p

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

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] Pulling an ID list from a DB, then filtering that list againstanother list of ID's

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

RE: [PHP-DB] % operator

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

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

Hey All- 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 things they have not viewed. I

[PHP-DB] mysql_connect on dual-processor machines

I would appreciate help in getting mysql_connect to behave consistently on different machines. It does not work for me on a dual-processor server but will on other servers. On dual-processor machines, no matter what parameters are entered into the function, they are ignored. For example, with

[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 communicate with the mysql server was lgpl. Does this mean that when using php with mysql your php scripts have to be licensed under the gpl as well if released? If this is the

[PHP-DB] Re: PHP Oci8 segmntation fault

Hi Radovan Here are some suggestions Make sure $ORACLE_HOME is set in your environment. There may be other environment variables that the environment needs as well that are set for the webserver process, but not when you run the command line version. PHP 4.3.2 has a bug in it that causes php t

Re: [PHP-DB] Database Design Issue

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 me

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

On 11 August 2003 07:02, Michael Cortes wrote: > 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, the serve

RE: [PHP-DB] mysql connect error

Hi Check the database name is exactly the same case as you are using - not Soverign rather soverign for example. After that try the raw php functions for connecting to the database This will give the Mysql error messages which should give you more information HTH, if not comeback to me Pete

RE: [PHP-DB] Sorting issue

This would happens if you 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.   A

Re: [PHP-DB] DB2 and php serialized data

Gerard Samuel wrote: 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

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

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 unique

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

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); // M

[PHP-DB] PHP/DB2

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 Mailin

[PHP-DB] full text search in mysql

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 statement

[PHP-DB] PHP Oci8 segmntation fault

Hello I have php 4.3.2 installed as apache 2.0.45 module on RH Linux (7.3) with oci8 support. Things work fine when php scripts are accessed via web, but when i try to start them from command line using /usr/local/php4.3.2/bin/php test.php i get an error Segmentation fault. test.php has only 4-5 l

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

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 = mysql_

Re: [PHP-DB] Re: PHP & MSSQL

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 se

[PHP-DB] file upload security issue

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

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

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 "\n"; for ($i=0; $i < mysql_num_fields($result); $i++) //Table Header { print "".mysql_field_name($result

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

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] Problems with input and modify data on a form.

Zip Files, are in Winzip 9.0 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] % operator

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 =

Re: [PHP-DB] Sorting issue

Jeff wrote: kwo VARCHAR(10) NOT NULL, lsd VARCHAR(20) NOT NULL, duh -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ PHP|Architect: A magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] DB2 and php serialized data

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] adding integer to field in query

Dillon, John 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

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

best way to tell is to place .'or die(mysql_error())' after any call to mysql_query() to see what mysql is complaining about. personally I sometimes declare the query first so i can echo that as well after the msyql_error() function, so i can see the query that has just been excecuted. helpf

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

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 "\n"; for ($i=0; $i < mysql_num_fields($result); $i++) //Table Header Calculate the v

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

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 o

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

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

Re: [PHP-DB] Database Design Issue

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 sh

RE: [PHP-DB] MySQL and PHP?

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 commu

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

From: "Dillon, John" <[EMAIL PROTECTED]> > 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=? 1 + NULL = NULL Any math statement with NULLs in it will equal NULL. (DB wise) ---John Holmes... -- P

Re: [PHP-DB] MySQL Returns Error

if i understand your question. why not take a different approach. when the form is submitted do your updates/inserts and then forward the page with the header() function to another page, even if it is the same page, but with a different set of variables set on the page, the idea being to remove t

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

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 m

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

    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. redir.php?i

[PHP-DB] Multiple checkboxes

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 { $row[name] }while ($row = mysql_fetch_array($result)); and when submitted if ($class_id) { foreach($class_id as $

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

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 r

[PHP-DB] Database Design Issue

Hello Everyone, 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. Should I put all of the s

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

>>>there are many ways to approach this. one is, select the db before any of this activity with mysql_select_db ("dbname") then you can run as many queries against this database as you want. Until you call that function again with another db name, mysql with _always_ run against that database. hth

Re: [PHP-DB] ODBC Database

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

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

[PHP-DB] newbie lost on data import...

I have a 1400 line text file. TAB delimited. 1974-01-13 8 Cold Storage 3 fields. nothing large or complicated. I massaged the data to be in this format thinking it would make the import easier. I can open the file and drop it into an array just fine. I can EXPLODE each array item into it'

[PHP-DB] dynamic image generation

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] Calculated field in MySQL

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 IS_MEM_

Re: [PHP-DB] mysql problem importing data

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Hello Mark, > > I have tryed it by splitting the file into pices and then insert it with the > help of phpmyadmin. This woked. > > however, I do have some more files to upload, and this seems to be not the > fastest way:-) > > I tryed

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

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 much

[PHP-DB] PHP and XML

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] Re: PHP & MSSQL

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

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

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. http:

Re: [PHP-DB] ODBC Database

i have read an article on IBM's developerWorks website. its title should be "Leverage your Microsoft SQL Server 2000 Skills to Learn DB2 UDB Version 8" that should help you. "Gerard Samuel" <[EMAIL PROTECTED]> ??:[EMAIL PROTECTED] > Robert Twitty wrote: > > >Unless I am mistaken, but isn't th

Re: [PHP-DB] PHP & MSSQL

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 st

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

> 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 news:

Re: [PHP-DB] Configuring PHP with Firebird

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] incrementor in loop is not incrementing.. any thoughts?

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] determining if a query returns no value

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: http://

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

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 (title

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

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, Riv

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

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 is

Re: [PHP-DB] ODBC Database

there is _definitely_ a MyOdbc Driver. i'm using it Gerard Samuel

  1   2   >