RE: [PHP-DB] MySQL error...

2004-12-13 Thread Norland, Martin
to cut and paste wherever possible - and if anything must be 'hidden' to obviously hide it and make note of the replacement. Just like Johan K# would do. * K# name has been changed to protect the guilty - in my 'code' it is typed normally. Cheers, - Martin Norland, Database / Web Developer

RE: [PHP-DB] versioning a database

2004-12-10 Thread Norland, Martin
want, so maybe best just to make it an entire 'block' scenario. The alter statements could, of course, also update the version number as their last command. All vanilla SQL. Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email

RE: [PHP-DB] MySQL error...

2004-12-10 Thread Norland, Martin
code that says tablename instead of $tablename. You may want to grep for tablename to try to track that down. Cheers, - 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

RE: [PHP-DB] Insert db values into dropdown box error

2004-12-09 Thread Norland, Martin
-Original Message- From: Edward Dias [mailto:[EMAIL PROTECTED] while($row=mysql_fetch_array($result)({ echo option value=\$row[project_number]\$row[project_number]/option\n; } You have a backwards parenthesis. Try: while($row=mysql_fetch_array($result)) { Cheers, - Martin

RE: [PHP-DB] Splitting Arrays in Half

2004-12-09 Thread Norland, Martin
. *** Also - $sched[] = array( 'teama' = $item[teama], [] is for adding items to an array, just so you're aware. You're using the foreach and that chunk of code in a very peculiar way, but I'm going to hold off on wrapping my head around it until you fix these bits. Cheers, - Martin

RE: [PHP-DB] A language question

2004-12-08 Thread Norland, Martin
definitely want to be going with the first way, hands down. Summary (IMO): Add some metadata rows [last updated, translation notes, etc.] (as applicable) and stick with method 1. - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within

RE: [PHP-DB] Mozilla inserts twice, IE does OK... ?

2004-12-06 Thread Norland, Martin
this problem. I'm a little cloudy on the specifics, it's a big muddled mess :) Cheers, - 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

RE: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Norland, Martin
like bind variables. I can't speak as to whether one would gain performance from using mysqli_query over mysql_query (though I would hope one wouldn't lose it!). Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

RE: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Norland, Martin
to builtin support - but my skills in finding information there may not be as honed as yours. Sorry this got a little toasty, but it sure felt like a blind attack, since the most cursory of checks revealed my statements true. Cheers, - Martin Norland, Database / Web Developer, International Outreach

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
it's probably not a problem] Note: You must use \r\n to separate headers, although some Unix mail transfer agents may work with just a single newline (\n). Then we'll see where you are from there... Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
the result of a mysql_query()? If so, you probably just want to be using: $to = $rsVendorJobs['Conmail']; Also note - the case sensitivity may or may not be a problem (you may need to use 'conmail') Otherwise, let's see some code to flesh this out! Cheers, - Martin Norland, Database / Web Developer

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
-SelectLimit($query_rsVendorJobs)) to see just what result you're getting back, although from your code it should exactly match a dump of $rsVendorJobs. Good luck, happy hunting - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
of those at the bottom of the script, and I suggest enclosing them within pre tags, for legibility. (print_r is a slightly more legible option, but var_dump gives us more information). - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
if you're sane. I really REALLY don't recommend directly digging into a black box like this unless you know it will never change, or have some good documentation area where people will know to look before upgrading. - Martin Norland, Database / Web Developer, International Outreach x3257

RE: [PHP-DB] Concat 3 fields in a query

2004-12-03 Thread Norland, Martin
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] '{$_POST['PO_Year']}-{$_POST['PO_Month']}-{$_POST['PO_Day']}' {$_POST['PO_Year']}-{$_POST['PO_Month']}-{$_POST['PO_Day']} Variables aren't evaluated in single quotes. - Martin Norland, Database / Web Developer

RE: [PHP-DB] Concat 3 fields in a query

2004-12-03 Thread Norland, Martin
recommend validating data before you insert into the db I couldn't agree more. Cheers, - 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

RE: [PHP-DB] Concat 3 fields in a query

2004-12-03 Thread Norland, Martin
will likely strip the extra line feeds - click the little yellow box at the top for legibility. Cheers, - 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] PHP-HTML-select deny

2004-12-01 Thread Norland, Martin
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 Developer, International Outreach x3257 The opinion(s

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

2004-11-29 Thread Norland, Martin
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 Norland, Database / Web Developer, International Outreach x3257 The opinion(s

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

2004-11-29 Thread Norland, Martin
://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 represent those of St. Jude Children's

RE: [PHP-DB] amp; and sessions

2004-11-29 Thread Norland, Martin
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 email do not necessarily represent those of St. Jude

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

2004-11-24 Thread Norland, Martin
foreach ($resultset as $row) { // or ($resultset as $rownum = $row) // ... do stuff } Happy hunting. - 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] Using a loop on a result destroys array??

2004-11-24 Thread Norland, Martin
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 you the information back from. - Martin Norland, Database

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

2004-11-24 Thread Norland, Martin
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 opinion(s) contained within this email do

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 St

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 represent

RE: [PHP-DB] odbc quest

2004-11-16 Thread Norland, Martin
can't speak as to how the odbc_fetch_object function behaves - it seems poorly documented, but it looks like you get back something more fancy than a simple object with named variables). In short, use odbc_fetch_array and refer to the items as $rows[COLUMNNAME] (or use single quotes). - Martin

RE: [PHP-DB] Numeric question

2004-11-16 Thread Norland, Martin
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 Database Mailing List (http://www.php.net

RE: [PHP-DB] Numeric question

2004-11-16 Thread Norland, Martin
'); // now it's on topic ? - 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

RE: [PHP-DB] PHP vs ASP

2004-11-15 Thread Norland, Martin
. - 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] passing both an anchor and a variable

2004-11-12 Thread Norland, Martin
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, International Outreach x3257

RE: [PHP-DB] how to find

2004-11-11 Thread Norland, Martin
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 [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11

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

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 x3257

RE: [PHP-DB] Question

2004-11-09 Thread Norland, Martin
Does your form tag have enctype=multipart/form-data ? e.g. form action=?php echo($_SERVER['REQUEST_URI']) ? method=post enctype=multipart/form-data - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent

RE: [PHP-DB] Forms list from database

2004-11-01 Thread Norland, Martin
{$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 connect to the database/etc. is. - Martin Norland, Database / Web Developer, International

RE: [PHP-DB] MySQL backup software

2004-10-27 Thread Norland, Martin
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 Outreach x3257 The opinion

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

2004-10-27 Thread Norland, Martin
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 email do

RE: [PHP-DB] gdbm locking problem

2004-10-26 Thread Norland, Martin
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 Outreach x3257

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] gdbm locking problem

2004-10-25 Thread Norland, Martin
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. -Original Message- From: Michael Jeung [mailto

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

2004-10-25 Thread Norland, Martin
\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 within this email do not necessarily represent those of St. Jude Children's

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's Research

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

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

2004-10-22 Thread Norland, Martin
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 represent those of St. Jude Children's Research Hospital. -Original Message- From: Bastien Koert

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 do

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

2004-10-21 Thread Norland, Martin
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 opinion(s) contained within this email do not necessarily represent those of St. Jude

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

2004-10-20 Thread Norland, Martin
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 ability to change php's settings? - Martin Norland, Database / Web

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

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

2004-10-18 Thread Norland, Martin
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
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 Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

RE: [PHP-DB] Refreshing Problem

2004-10-18 Thread Norland, Martin
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 those of St. Jude

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

2004-10-18 Thread Norland, Martin
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. -Original Message- From: Juan Stiller [mailto:[EMAIL PROTECTED

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

2004-10-18 Thread Norland, Martin
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 this email do

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

2004-10-18 Thread Norland, Martin
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 access inventory). - Martin Norland, Database / Web

[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

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

[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

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 and

[PHP-DB] Wrong table name - can it be fixed?

2004-05-17 Thread Martin E. Koss
of the table in order to rename it, whatever I try to do I get an error (which is obviously due to the type of name the table has). Is there any way I can fix this without getting too complicated? Cheers. Martin --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http

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

[PHP-DB] Multiple work mySql database search.

2004-04-21 Thread Martin E. Koss
on the search for the user to select 'All Words' or 'Any Word' so that the select query could deal with the search based on the full phrase they entered or any of the words. My problem is how to build the query. Any help would be massively appreciated. Martin --- Outgoing mail is certified

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 implicitly

[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] 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).. I am also aware of need for code

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(): E

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 cannot

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 layer

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 Interface. Not The

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 being

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 felt

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

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

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

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

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 quick example of the wall Im running

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() are

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

Re: [PHP-DB] date function

2003-11-02 Thread Martin Marques
1) Why do you send this to a DB list? 2) Try seeing the Date class of PEAR (PEAR::Date). El Dom 02 Nov 2003 19:13, OpenSource escribió: Hi guys, This might not be the best place for this but here goes. I want to create a dropdown list with a date range of

Re: [PHP-DB] pg_connect() problem with postgresql 7.3.4

2003-10-29 Thread Martin Marques
El Mié 29 Oct 2003 07:14, S.P.Vimala escribió: Hi, I have installed posgresql(serve/libs)-7.3.4 on my linux machine. It has httpd-2.0.40-8 php-4.2.2-8.0.8 php-pgsql-4.2.2-8.0.8 Now pg_connect on my code gives me an error undefined function call. I tried to

Re: [PHP-DB] PostgreSQL, Triggers

2003-10-19 Thread Martin Marques
El Dom 19 Oct 2003 13:54, Ling escribió: Hello there. Can anybody help me with Postgresql triggers? what I need is a trigger which inrements value in field total_rows.rows if I insert new row in table zzz... CAREATE TABLE zzz ( ... ... ); CREATE TABLE total_rows ( table_name

Re: [PHP-DB] SQL File Insert???

2003-10-12 Thread Martin Marques
El Dom 12 Oct 2003 17:36, John Ryan escribió: Ive a file on my server with SQL instructions to create a table and insert stuff. How do I get this to be run on the database? Once againg, somebody that doesn't specify which database server he is using Pleas, be more specific! -- Porqué

Re: [PHP-DB] Confused

2003-10-05 Thread Martin Marques
El Dom 05 Oct 2003 12:44, Robin Kopetzky escribió: I need to setup a user, 'commerce' with a password, that can be accessed from any web server in our farm 'blackmesa-isp.net'. What GRANT statement do I need to make this work? I've tried a bunch of the examples in the manual and can't get it

Re: [PHP-DB] Confused

2003-10-05 Thread Martin Marques
El Dom 05 Oct 2003 13:07, Jason Wong escribió: On Sunday 05 October 2003 23:44, Robin Kopetzky wrote: I need to setup a user, 'commerce' with a password, that can be accessed from any web server in our farm 'blackmesa-isp.net'. What GRANT statement do I need to make this work? I've tried a

Re: [PHP-DB] numeric in plpgsql function

2003-10-02 Thread Martin Marques
El Mié 01 Oct 2003 22:45, Gezeala 'Eyah' Bacuño II escribió: Saw this in the Postgresql manual : Chapter 8. Data Types Some of the operators and functions (e.g., addition and multiplication) do not perform run-time error-checking in the interests of improving execution speed. On some

Re: [PHP-DB] php and MySQL and PostgresSQL at the same time

2003-10-02 Thread Martin Marques
El Jue 02 Oct 2003 08:22, Morten Gulbrandsen escribió: Is it possible to use PHP under one Apache WEB application in order to access MySQL and at the same time PostgreSQL? different databases ? Depends on how the question was made. Yes you can access diferent database engines from the

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-16 Thread Martin Marques
El Lun 15 Sep 2003 17:47, Jonathan Villa escribió: I believe this would need php to installed as a cgi, which I prefer not to do... If you don't want to because of security resons, please install it and don't leave it in the hands of the web server. If you don't want to go through the problem

[PHP-DB] Re: [PHP] MS-SQL 2000 weird problem

2003-09-16 Thread Martin Greco
[en_US] date format = %b %d %Y %I:%M%p language = us_english char set = iso_1 [es_ES] date format = %b %d %Y %I:%M%p language = us_english changed char set = iso_1 - Original Message - From: Dan Anderson [EMAIL PROTECTED] To: Martin Greco [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; PHP

[PHP-DB] Weird MSSQL problem

2003-09-15 Thread Martin Greco
fine. The function mssql_num_fields() shows correctly the number of fields. The strange thing is that it was working a day ago (the same code). Any thoughts? -- ### # Martin Greco

[PHP-DB] Weird MSSQL problem

2003-09-15 Thread Martin Greco
fine. The function mssql_num_fields() shows correctly the number of fields. The strange thing is that it was working a day ago (the same code). Any thoughts? -- ### # Martin Greco

Re: [PHP-DB] Connect to Oracle DB

2003-09-14 Thread Martin Marques
El Vie 12 Sep 2003 18:36, Frederico Madeia escribi: Martin, In some doc that i've read when i compile the php i must put yhe $ORACEL_HOME path, so if oracle isn't instaled on same machine ??? Lets see. I don't use, or ever used Oracle, but I guess my experience with Informix and PostgreSQL

Re: [PHP-DB] Connect to Oracle DB

2003-09-13 Thread Martin Marques
El Sb 13 Sep 2003 03:56, Jack van Zanen escribi: Hi I don't know how this shared library works, but to the best of my knowledge you'll always need oracle client software (SQL*Net) installed on the php server to connect to an oracle database . Please correct me if I'm wrong and point me to

Re: [PHP-DB] Connect to Oracle DB

2003-09-12 Thread Martin Marques
El Vie 12 Sep 2003 15:52, Frederico Madeia escribi: Dear friends, How i connect one server running PHP(linux) to other server running Oracle(linux) ?? when i tryed to connect with ora_logon, the server return me: Call to undefined function: ora_logon(). In php.net describe some functions

Re: [PHP-DB] How to exclude the result of union of two tables from the result of union of other two tables

2003-09-05 Thread Martin Marques
This can be done in one query using subselects. El Vie 05 Sep 2003 15:49, John W. Holmes escribi: Oz wrote: I have a php page where I would like to list a numer of companies as below: 1- retrieve all distinct company names from TableA (SELECT company_name FROM TableA) CREATE

<    1   2   3   4   5   >