RE: [PHP-DB] array_diff usage

2001-04-02 Thread Martin
while($sumClosed=mysql_fetch_row($jobresult2)) { $Closed = $sumClosed; // DEBUG print "c" . $Closed[0] . ""; } Which produces: 1 2 3 4 5 c1 c2 So the arrays are correctly set up (I think). Martin S.

[PHP-DB] PEAR DB

2001-11-02 Thread Martin
Pardon an exceedingly dumb question. Where do I find documentation on HOW to use the PEAR DB class? What functions to call and what they do? Martin S -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

[PHP-DB] Re: PEAR DB

2001-11-02 Thread Martin
Martin wrote: > Pardon an exceedingly dumb question. > Where do I find documentation on HOW to use the PEAR DB class? > What functions to call and what they do? > > Martin S Dont bother, found one. (i.e. why didn't I use Google in the first place?). /M. -- PHP Databas

[PHP-DB] Nothing returned

2001-11-03 Thread Martin
Why am I not getting anything returned from this function? I have code doing a if user exists and b if user doesn't exist. I'm not getting any numRows result apparently. The query is OK and returns 1 user for $name=admin. I'm not getting any errors from isError. Martin functi

RE: [PHP-DB] Nothing returned

2001-11-03 Thread Martin
Peter Lovatt wrote: > $sql = "SELECT * FROM users WHERE (name='$name')" > > if you are not getting an error, it is usually worth echoing the query SQL > > echo $sql ; > > and perhaps trying it manually. > > Is it possible the quotes around the $name are giving > > SELECT * FROM users WHERE (

[PHP-DB] Re: Nothing returned

2001-11-04 Thread Martin
Martin wrote: > Why am I not getting anything returned from this function? > I have code doing a if user exists and b if user doesn't exist. I'm not > getting any numRows result apparently. The query is OK and returns 1 user > for $name=admin. I'm not getting any error

Re: [PHP-DB] HELP, MSSQL STORED PROCEDURES

2003-06-14 Thread Martin
You are entirely wrong about ODBC. Linux has several implementations available. On Sat, 14 Jun 2003 14:30:42 +0300 "nabil" <[EMAIL PROTECTED]> wrote: > PLEASE HELP ME PHP PEOPLE, > > I have a stored procedure on a remote Microsoft (stupid) SQL server.. > and I have to connect to it remotely and

[PHP-DB] IB/FB and array field

2003-07-02 Thread Martin
Hi, I need to insert integer values into array field in FireBird/InterBase's table with PHP, but don't know how to do it. Does anyone has a working example please? -- Martin (mailto:[EMAIL PROTECTED]) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

[PHP-DB] Database connection

2003-07-16 Thread Martin
I'm trying to use PHP 4.2.3 in a database application. Unable to connect to database server."); exit(); }else { print "Connected!"; } ?> Gives Connected? Fatal error: Call to undefined function: mysql_connect() in /var/www/html/irm/test.php on line 3 While changing the line to $dbcnx = @mysql

[PHP-DB] Front Base on PHP

2007-11-12 Thread Martin
I've been trying to build PHP with the Front Base interface on a 64 bit system. Can this be done or am I going to have to go back to a 32 bit install? -- http://blameitonlove.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Interbase

2001-03-08 Thread Martin Meca
rland\Interbase\Examples\Databse\employee.gdb', $username, $password); and I am using Apache under Windows NT 4. Does anybody see a mistake? Thank you for your help Martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comm

Re: [PHP-DB] Interbase

2001-03-08 Thread Martin Meca
And which database will I open, using this? First prameter in ibase_connect should be database file name, I think. Martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP-DB] Error prevention

2001-03-13 Thread Martin Skjöldebrand
I'm baffled (again ) In my mql database I'm doing: SELECT cl_login FROM client WHERE cl_login = "xxx"; and if "xxx" exists I get the result xxx while if it doesn't exist I get an empty string. In PHP I'm doing $querytest = "SELECT cl_login FROM client WHERE cl_login = '$txtLogin';"; $testr

RE: [PHP-DB] Error prevention

2001-03-13 Thread Martin Skjöldebrand
Michael Rudel wrote: > Hi Martin, > > ... you forgot to 'mysql_fetch_row' or 'mysql_result'. Read about it in > the PHP-Manual in the MySQL Functions. Thanks Mike (and everyone else who pointed this out), Sometimes you're blind. When you think you pass

Re: [PHP-DB] log in script // php-auth_user php_auth-pw

2001-03-14 Thread Martin Edelius
t matter 8), but it should give you a few pointers. You can turn this into a function to make it easier to maintain and use in multiple pages. Hope it helps. Best regards, Martin Edelius Spirex Digital Design WWW: http://www.spirex.se

[PHP-DB] getting last entry in database table

2001-03-17 Thread Martin Skjöldebrand
I have a table containing steps toward solving a problem. I want to pass the last entry to another database as a solution. How do I do this? What I've tried today is: http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

Re: [PHP-DB] getting last entry in database table

2001-03-17 Thread Martin Skjöldebrand
Martin Skjöldebrand wrote: > I have a table containing steps toward solving a problem. I want to pass > the last entry to another database as a solution. > How do I do this? What I've tried today is: I read a few more pages in my newbie book and decided to try it like this in

Re: [PHP-DB] getting last entry in database table

2001-03-17 Thread Martin Skjöldebrand
t still doesn't add the last entry to the variable like I want it to. I want kb_answer to have the value "entry 2" (in your example) not as happens (even in your example) "entry 1". And, talking to a newbie it would be grate to know why my method produces the wron

[PHP-DB] Line breaks in output

2001-03-19 Thread Martin Skjöldebrand
Newbie here. How do I get line breaks in output from a database? I have a list of things in a file, like: item1``item2``item3 (etc) I want them displyed in a textarea as: item1 item2 item3 Probably very simple, haven't got that far in my book yet. Martin S. -- PHP Database Mailing List

[PHP-DB] Going bonkers again ...

2001-03-23 Thread Martin Skjöldebrand
Going bonkers again ... I have this in a script. Where m_id is passed to the page and connect.inc.php is my database connection script which works nicely with all other pages. Still I get: Warning: Supplied argument is not a valid MySQL-Link resource in /chroot/htdocs/helpdesk/scripts/viewme

Re: [PHP-DB] Going bonkers again ...

2001-03-23 Thread Martin Skjöldebrand
olinux wrote: > You have to escape your "" > >> $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = >> '$m_id'"; > > try this > $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = > \"$m_id\" > "; No that isn't the problem. It is valid to change qu

[PHP-DB] List for SQL questions?

2001-03-23 Thread Martin Skjöldebrand
Anyone knows a list for discussion SQL questions? On the off chance that this *is* an appropriate list here goes: I want to select tickets from two tables that registers support tickets and events related to the ticket. No problem. Tickets go through various stages, REGISTERED, OPEN, CLOSED in

[PHP-DB] Checking for empty string - long

2001-03-27 Thread Martin Skjöldebrand
Thanks for all suggestions to my earlier questions. This time I'm totally stuck though. I've been trying various solutions for over a day now. How do I check for an empty string in PHP/MySQL. Scenario: I have two query returning different results not necessarily of equal length: $queryjobs1 =

Re: [PHP-DB] putenv() doesn't seem to work!! Groan!

2001-03-31 Thread Martin Lustig
I just have similar problem on the Sun Solaris unix... My putenv () command doesn't affect next part of the script. |-)) Martin. ""Scott Fletcher"" <[EMAIL PROTECTED]> pí¹e v diskusním pøíspìvku 99viqu$av6$[EMAIL PROTECTED]">news:99viqu$av6$[EMAIL PROT

[PHP-DB] Oracle8i, PHP4, Apache

2001-03-31 Thread Martin Lustig
Data are returned in US7ASCII. Have you anybody ideas how tu setup such environment? Probably i am not first who need apache, php and oracle operate Regards, Martin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addit

[PHP-DB] array_diff usage

2001-03-31 Thread Martin Skjöldebrand
I'm daft. I don't understand the PHP Manual. I have two arrays: Open[0] contains 1 2 3 4 5 Closed[0] contains 1 2 Now: $test = array_diff($Open, $Closed); $lines = count($test); print $lines; Gives me: 1 I thought it should be 3. While: for ($counter =0; $counter <= $lines -1; $counter++) {

Re: [PHP-DB] RE: select inside a while loop

2003-11-29 Thread Martin Marques
Sorry, just say the message. > Your code looks well. But is the variable $db the name of your database or > your link-identifier. When it is the name of your database i'm not really > surpised your code wouldn't work. mysql_query requires as second argument a > link identifier. Read what Rolf say

Re: [PHP-DB] Re: Very complex query

2003-12-11 Thread Martin Marques
El Jue 11 Dic 2003 05:00, Muhammed Mamedov escribió: > You can also DISTINCT command instead. > UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am > using) UNIQUE is for table creation or index creation. It is relevent for insertion, not selects. DISTINCT and DISTINCT ON() a

Re: [PHP-DB] Re: Very complex query

2003-12-11 Thread Martin Marques
El Jue 11 Dic 2003 05:17, Mike U. Petrov escribió: > No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I > need ONE user_id per one object_id. GROUP BY is your answer. -- 15:51:02 up 15 days, 22:07, 3 users, load average: 0.90, 0.75, 0.61

Re: [PHP-DB] Re: Very complex query

2003-12-11 Thread Martin Marques
El Jue 11 Dic 2003 05:30, Mike U. Petrov escribió: > I tried to use GROUP BY and it worked almost right but i need to return > user_id and mysql generated an error that notes.user_id isn't used in GROUP > BY... Add it to the GROUP BY. -- 16:33:02 up 15 days, 22:49, 4 users, load average: 0.03

Re: [PHP-DB] pg_result_error()

2003-12-12 Thread Martin Marques
El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: > What good is this function? > A quick example of the wall Im running into -> > $sql = 'INSERT INTO .'; > $result = pg_query($conn_id, $sql); > if ($result === false) > { > var_dump( pg_result_error( $result ) ); I would use here this:

Re: [PHP-DB] pg_result_error()

2003-12-12 Thread Martin Marques
El Vie 12 Dic 2003 11:19, Gerard Samuel escribió: > Im going to CC this to the PostgreSQL list also. > > On Friday 12 December 2003 06:44 am, Martin Marques wrote: > > El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: > > > What good is this function? > > > A qui

Re: [PHP-DB] Informix - help!

2003-12-15 Thread Martin Marques
El Dom 14 Dic 2003 19:00, Daniel Crespo escribió: > I have red hat linux with Apache web server and PHP. I want to connect, > using PHP, to an Informix Database remotely. What is all I have to do on my > side? Thanks a lot Install informix client libraries where php will go and compile using --wi

Re: [PHP-DB] Something ease... I guess

2003-12-16 Thread Martin Marques
El Mar 16 Dic 2003 10:44, Nikos Gatsis escribió: > Hello list > > I have 4 variables, $check1, $check2, $check3, $check4 > > How can i use a for loop to echo each one. > > (lets say echo $check($i)...) foreach(list($check1, $check2,...) AS $c){ echo $c; } -- 15:20:02 up 16 days, 21:36,

Re: [PHP-DB] Skipping a row

2003-12-18 Thread Martin Marques
El Jue 18 Dic 2003 18:27, John Greco escribió: > I have a select statement that goes to my mySQL db and selects some data > from there. I thought it was working great BUT it is skipping the first row. > Any ideas? I know it has to be somehting simple I am missing. Depends on how you are fetching y

Re: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Martin Marques
You throw code to the list with no information about what errors or warnings you got. Why do you say it doesn't work? What happens when you run the script? El Mié 31 Dic 2003 12:46, John Greco escribió: > I am trying to build a web site for our inventory. I have a mysql DB that i > connect to. >

Re: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Martin Marques
El Mié 31 Dic 2003 15:28, Dennis Cole escribió: > I think that it has more to do with the type of fields he is putting it > into: > > -- > I am trying to build a web site for our inventory. I have a mysql DB > that I Connect to. The following code is what I use. The array products > wont go p-past

Re: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Martin Marques
El Mié 31 Dic 2003 16:25, escribió: > He surelly has problems with his DB server. > Does the script die? I am outputting mysql_error() nothing is showing up. > > Hows the mysql logs? I don't know where these are. > > is there some kind of high load on the DB server? I am the only one on it right

Re: [PHP-DB] Database abstraction

2004-01-13 Thread Martin Marques
Mensaje citado por Malte Starostik <[EMAIL PROTECTED]>: > Hi, > > I've read several posts touching this subject, but I didn't find one that > asks a simple question I've been wondering about since I first used PHP and > that is also one of the two really really bad things about PHP (the other > b

Re: [PHP-DB] Database abstraction

2004-01-13 Thread Martin Marques
Mensaje citado por Jason Wong <[EMAIL PROTECTED]>: > > Whilst there isn't a builtin database abstraction layer in PHP itself there > are a number of projects which fills the gap. There's the semi-official > PEAR-DB, also ADODB and Metabase. Why is it you say it's semi-official? I have always f

Re: [PHP-DB] Solaris apache 2.0.47 + php 4.3.4 + oracle 9i ( oci8 support in php as shared module )

2004-01-15 Thread Martin Marques
Mensaje citado por Daniel Sand <[EMAIL PROTECTED]>: > Hi Folks, > > I have an generic question. > > first of all. The stuff runs fine. > > But ( the question ? ) > > If i make any DB connections from any Virtual Server that i configured > in apache, PHP always takes the Main Ethernet Interfac

Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Martin Marques
Mensaje citado por Christine Clerc <[EMAIL PROTECTED]>: > Well, I had tried this : > SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin; > But then I have to do this with the selection : > SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget; > but it

Re: [PHP-DB] multi-language site

2004-01-16 Thread Martin Marques
Mensaje citado por Muhammed Mamedov <[EMAIL PROTECTED]>: > Thank you for your comments Ignatius. > (just to note) : I do not agree that all projects SHOULD require CLEAR > sepeartion of code and appearance. Let me disagree with you! :-) I a multi-tiered design yuo have a client layer, a server la

Re: [PHP-DB] Fw: informix problem

2004-01-17 Thread Martin Marques
Mensaje citado por stefan bogdan <[EMAIL PROTECTED]>: > > > i have winnt 4.0 servicepack 6 + apache 2.0.47 + php 430 + informix client > for nt > ilogin demo works fine > sql editor works fine > but when i try to connect to informix via php i'get an error like > > Warning: ifx_connect(

Re: [PHP-DB] multi-language site

2004-01-18 Thread Martin Marques
Mensaje citado por Muhammed Mamedov <[EMAIL PROTECTED]>: > Thank you for your help Martin, > > I am aware of the seperation stuff you are talking. There is a much more > professional term for that 'Design Patterns' use in JAVA (I tell you as a > JAVA professional

[PHP-DB] mssql insert

2004-03-27 Thread Martin Ryan
Got a dumb-ass question for you all. I have got insert queries working with mssql_query($query); except if any of the variables have two or more words. For example: $myVar = "Two or more words"; $query = "INSERT INTO myTable VALUES ('".$myVar."');'; mssql_query($query,$db); The query will only in

[PHP-DB] PHP Arrays

2004-04-04 Thread Martin Oettinger
Does anyone know up to which level arrays in variables are possible? Is there a limit? $foo[1][2][3][4][5][6] ... ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Anybody using PostgreSQL?

2004-04-14 Thread Martin Marques
El Mié 14 Abr 2004 07:39, Tumurbaatar S. escribió: > In PHP5 manual, it says that > when using large objects functions > of PostgreSQL, a program should > manually begin/end transaction. > But what about other query/exec functions? > Do I need to control transactions or every function > call implic

Re: [PHP-DB] From MySQL to PostgreSQL

2004-05-08 Thread Martin Marques
El Vie 07 May 2004 22:49, Marcjon Louwersheimer escribió: > Hi. I developed a forum using php5 and mysql. Right now I'm hosting it on > my computer, for version for myself and another for a school I volunteer > at. I would like to move the forums to the school's server. Apperently > they don't have

Re: [PHP-DB] PostgreSQL lib and character case

2004-04-28 Thread Martin Marques
El Wednesday 28 April 2004 03:21, Tumurbaatar S. escribió: > I use pg_fetch_array() to get a record content. But it seems that > to access elements of the returned associative array, I should > use lowercase field names. Is there any way to use case-insensitive > field names? No. PHP is case-sens

Re: [PHP-DB] Informix and PHP

2004-05-22 Thread Martin Marques
El Vie 21 May 2004 14:48, D. Sandmann escribió: > Any help would be appreciated on this. I have already asked this question > on the regular PHP and Informix news groups and have not had any luck. > Maybe one of you can resolve my problem. > > I have had this problem in the past on another machine

[PHP-DB] Work available

2004-06-12 Thread Todd Martin
Hi I'm looking for a php developer that is familiar with developing code for client login/registration on the web and credit card transactions. (Not a shopping cart model). We're planning to use MySQL or Firebird on a linux server. The requirements will probably extend to accounting system/billing

Re: [PHP-DB] fetch row DISTINCT

2004-07-13 Thread Martin Marques
On Fri, 9 Jul 2004, Peter Westergaard wrote: > > One idea that occurs to me, and it's a tradeoff from Torsten's idea (which > is to read the whole database, and parse out the unique rows), is to first > execute your "SELECT DISTINCT distinct_col FROM table", and then walk > through that, and for ea

Re: [PHP-DB] Mysql and rollbacks

2004-07-13 Thread Martin Marques
On Tue, 13 Jul 2004, Peter Westergaard wrote: > I'm developing a site where I anticipate the need to make several updates to > several forms, and I'll want to "commit" them all at once (i.e. if there's a > failure with any of the transactions, I'd like to be able to back out to > before I started)

[PHP-DB] Good PHP + MySQL Organizer

2004-09-14 Thread Martin Lam
Hi, Like "phpBB" for newsgroups, "phpMyAdmin" for database administration. Is there one for Organizer? Please advise! Thanks, Martin Lam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RFC on how to best submit a bug report

2004-10-18 Thread Norland, Martin
more reasonable :) ** no, it's not infinitely looping. It's dumping patient data, e.g. it dumps a patient, a bunch of related records, and continues. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital.

RE: [PHP-DB] Showing all mysql query results!

2004-10-18 Thread Norland, Martin
just names, instead of names of new clients (e.g. you accidentally paste it elsewhere for use and keep pulling only from the new clients table). Are you perhaps storing clients in that table temporarily, so it rarely has many clients in it? That could explain the behaviour as well. - Martin Norlan

RE: [PHP-DB] Refreshing Problem

2004-10-18 Thread Norland, Martin
database. You can obviously think of a million solutions - tracking sessions/pages etc. - get creative to however will best fit or benefit your app! - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent th

RE: [PHP-DB] Showing all mysql query results!

2004-10-18 Thread Norland, Martin
you're doing - there is certainly a better/preferred way to get this info into flash. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -O

RE: [PHP-DB] how many databases should I create

2004-10-18 Thread Norland, Martin
the benefits of having the data together (generally convenience, though there are reasons along the lines of joins and such) with the costs of any lost security or lax in responsibility. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within th

RE: [PHP-DB] how many databases should I create

2004-10-18 Thread Norland, Martin
tion will need to map its users to databaes users. Come to think, however - I don't know that you can assign privledges per-table in mysql. So, if your 'user levels' aren't strictly hierarchical - you probably need to break things up (e.g. if payroll shouldn't be able to acc

RE: [PHP-DB] Changing this php code to show multiple variables!

2004-10-20 Thread Norland, Martin
a better way to be populating this data. http://actionscript-toolbox.com/samplemx_php.php Seems to be an introductory that may be of some use, found just by googling for 'flash php mysql'. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained w

RE: [PHP-DB] making a query with env varable (but is not working)

2004-10-20 Thread Norland, Martin
stead of "palabras='$var'" ?) - the only other immediate problem I can see is if you have a field named result or row in the frases table that is messing with your script when you do your extract() call. Curiously - why are you explicitly setting $_GET, do you not have the abilit

RE: [PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Norland, Martin
$content = str_replace($crap,$clean,$submitted_text); :) (I hadn't even noted you missed any at first) - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Researc

RE: [PHP-DB] Two session for the same user, possible?

2004-10-21 Thread Norland, Martin
with another address (e.g. www.something.com and app.something.com or equivalent) you will, in effect, get your two sessions. Beyond this, I'd need to know more of what you're intending to be of any help. - Martin Norland, Database / Web Developer, International Outreach x3257 The opini

RE: [PHP-DB] Organizing a query

2004-10-21 Thread Norland, Martin
to true - but not both. (but for a search, I doubt you want it XOR'd - no?) - You might want to be using LIKE instead of = if there should be substrings. http://dev.mysql.com/doc/mysql/en/SELECT.html (assuming mysql, though it should be fairly vanilla SQL anyway) - Martin Norland, Database

RE: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Norland, Martin
ome up with today should definitely scale to 3 or more applications, otherwise you'll just have to rewrite 2 (or more!) solutions later on down the line. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily repre

RE: [PHP-DB] imagecreatefromjpeg()

2004-10-22 Thread Norland, Martin
. If you're using a packaged php, I would assume these to already be enabled - strange. The last comment on http://us2.php.net/function.imagecreatefromjpeg suggests as much. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email d

RE: [PHP-DB] COPY with PostgreSQL

2004-10-22 Thread Norland, Martin
g files either on or created by a Macintosh computer, you might want to enable the auto_detect_line_endings run-time configuration option. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude

RE: [PHP-DB] gdbm locking problem

2004-10-25 Thread Norland, Martin
"wd" for both - but that may not get you anything either. Strange behavior! - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -O

RE: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread Norland, Martin
tput it to the cwd, then you just need to get it going to C:\backup\file.txt - which may, or may not, be as simple as replacing file.txt with that (long time since windows commandline) Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained withi

RE: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread Norland, Martin
Ah, good call. I'm too used to my database user matching my current user from unixland. (no, not root :P) - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children'

RE: [PHP-DB] delete time related data inside a table within 1 hour

2004-10-25 Thread Norland, Martin
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html says that's the right format. Are you sure you're storing the time and not just the date? I'd wager that it will delete immediately if you are only storing the date. - Martin Norland, Database / Web Developer

RE: [PHP-DB] gdbm locking problem

2004-10-26 Thread Norland, Martin
m multiple scripts, but wants to make sure they don't hose his db file. You do bring up a good point though - script 2 has the while loop outside the connection, so it should only print its message once if locking was working properly. - Martin Norland, Database / Web Developer, International

RE: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Norland, Martin
The functions you want exist in php5, if that's an option: http://us2.php.net/manual/en/ref.mysqli.php -> http://us2.php.net/manual/en/function.mysqli-fetch-assoc.php Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this

RE: [PHP-DB] mysqli prepared statement query result sets

2004-10-26 Thread Norland, Martin
Wishful thinking on my part, since it specified no version info because it was likely only in CVS - I thought maybe it was *really new* :). That is unfortunate then, definitely. Perhaps a mysqli_stmt_fetch_assoc() is forthcoming :( - Martin Norland, Database / Web Developer, International

RE: [PHP-DB] MySQL backup software

2004-10-27 Thread Norland, Martin
ou'll find a tool that does exactly what you want that's any more advanced or configurable - there's just no need. That said - who knows, people make all kinds of software to fill what others perceive as unneeded. Cheers, - Martin Norland, Database / Web Developer, International Outrea

RE: [PHP-DB] More help with restore server

2004-10-27 Thread Norland, Martin
ing at the available packages and installing the ones you want, instead of attempting to install php*. (or anything * for that matter) Just my $0.03 (tax is killer these days!) - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this em

RE: [PHP-DB] Forms list from database

2004-11-01 Thread Norland, Martin
print "{$check['LNAME']},{$check['FNAME']}({$check['CID']})"; However - in the future, try to include all relevant code. The surrounding table code isn't important, but the code you're using for your query and to co

RE: [PHP-DB] session_destroy();

2004-11-09 Thread Norland, Martin
session_regenerate_id is what you're looking for http://us2.php.net/manual/en/function.session-regenerate-id.php Note that it keeps the session data, so you still need to session_destroy if you want to purge the data. - Martin Norland, Database / Web Developer, International Outreach x325

RE: [PHP-DB] Question

2004-11-09 Thread Norland, Martin
Does your tag have enctype="multipart/form-data" ? e.g. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -Original Message--

RE: [PHP-DB] how to find

2004-11-11 Thread Norland, Martin
nload-docs.php Keep on plugging, you'll pick it up! - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -Original Message- From: peppe

RE: [PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at

2004-11-11 Thread Norland, Martin
Please note that his solution uses a subselect - and your version of mysql may not support subselects. Subselects were introduced (I believe) in Mysql 4.1 - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily

RE: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain

2004-11-11 Thread Norland, Martin
= You want to do a join on the two tables, and make it conditional upon a known failing value (e.g. if when they DO match up, blackgate_users shouldn't be NULL - make that your condition). That will return just the rows in the first table that don't have a match. cheers, - Martin Norland

RE: [PHP-DB] passing both an anchor and a variable

2004-11-12 Thread Norland, Martin
cks access log Nope - anchor's aren't passed in the request. So, yeah - it's only used by the browser. (That makes sense - the point of anchors is to go to a spot within a page) Neat, ya learn something new every day. Cheers, - Martin Norland, Database / Web Developer, Interna

RE: [PHP-DB] PHP vs ASP

2004-11-15 Thread Norland, Martin
PHP is definitely here to stay and pretty mainstream. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.

RE: [PHP-DB] odbc quest

2004-11-16 Thread Norland, Martin
y and refer to the items as $rows["COLUMNNAME"] (or use single quotes). - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Numeric question

2004-11-16 Thread Norland, Martin
you: http://www.php.net/round for example: echo round(1.95583, 2); // 1.96 - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP

RE: [PHP-DB] Numeric question

2004-11-16 Thread Norland, Martin
certain my statements in the previous email were, in fact, facts - not opinions :). At the very least, they were truthful statements at the time of their writing - and not merely speculative opinions. Also - the round is referring to mathematical approximation, not geometric shape :) But, I

RE: [PHP-DB] I'm less experienced please be gentle :)

2004-11-18 Thread Norland, Martin
Remove the @ in front of the mysql_num_rows function call. The @ symbol supresses errors, so that's likely where your error would be printed. Cheers - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily repr

RE: [PHP-DB] Using a loop on a result destroys array??

2004-11-24 Thread Norland, Martin
it. E.G. $resultset = array(); while (mysql_fetch_array($result) as $row) { $resultset[] = $row; } Then just foreach ($resultset as $row) { // or ($resultset as $rownum => $row) // ... do stuff } Happy hunting. - Martin Norland, Database / Web Developer, International Outreac

RE: [PHP-DB] Using a loop on a result destroys array??

2004-11-24 Thread Norland, Martin
lly fetches a single row (the next one, if available) returned from the mysql query into an associative array. You're being handed the data from mysql, one row at a time as requested, and sticking it into an array. $result is actually the resource id that you give mysql so it knows what query to give y

RE: [PHP-DB] how to implement "pages" of results

2004-11-24 Thread Norland, Martin
ame'$limit"; Then just pass the pagenum around. You'll probably want to pull another query that just gets the count(), and use that and some basic math to make the page range(s) to create hyperlinks. Cheers. - Martin Norland, Database / Web Developer, International Outreach x3257 The

RE: [PHP-DB] how to implement "pages" of results

2004-11-24 Thread Norland, Martin
Correct - LIMIT 30,2 would show 2 records starting with the thirtieth. :) Enjoy the long weekend [and likely, given the day, your Thanksgiving!] Woo, I'm outta here soon too. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this ema

RE: [PHP-DB] how to implement "pages" of results

2004-11-24 Thread Norland, Martin
> Correct - LIMIT 30,2 would show 2 records starting with the thirtieth. thirty-first. Sheesh, I should get outta here too - ^airhead^ - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of

RE: [PHP-DB] Multi-User Update Problem

2004-11-29 Thread Norland, Martin
y, not reload, in case of post/etc.] is something that should at least reduce the chances of massive overwrite errors. Not that I particularly approve of that method :) It is, however, a relatively functional solution - if you're stuck with neither of the above as being options. - Martin Norlan

RE: [PHP-DB] Excel - merging cells with PHP

2004-11-29 Thread Norland, Martin
adsheet Excel Writer: http://pear.php.net/package/Spreadsheet_Excel_Writer I'd wager it allows all the formatting you'll get from html tables. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represen

RE: [PHP-DB] & and sessions

2004-11-29 Thread Norland, Martin
red onto the urls. Of course, I'm probably oversimplifying a problem you've fought hours on, so all I can say is I hope the link and its thread shines some light. Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this

RE: [PHP-DB] & and sessions

2004-11-29 Thread Norland, Martin
ase :) - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Norland, Martin
tively pointless methods which I would be happy to detail to you for the low low cost of 3 easy payments of $29.95 USD. Keep in mind, all of these are just deterrents - nothing that truly prevents anything. For once my email disclaimer *really* applies. Cheers, - Martin Norland, Database / Web Deve

  1   2   3   4   5   >