[PHP-DB] Re: finding out if a user left our website ?

2010-08-27 Thread Martin Zvarík
it for administration and it worked in 80% of cases - sometimes the request is just not sent. Martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Dynamic Prepared Statements

2009-07-24 Thread Martin Kuckert
Warning*: call_user_func_array() [function.call-user-func-arrayhttp://localhost/mbpa/function.call-user-func-array]: First argument is expected to be a valid callback, 'Array' was given in * C:\xampp\htdocs\mbpa\classes\db.php* on line *45* *Fatal error*: Call to a member function execute()

[PHP-DB] Re: How to fix config mysql?

2009-07-24 Thread Martin Kuckert
I have uncommented php_mysql.dll and set the right ext_dir in the php.ini, and made certain that the actural dll does in the ext_dir, You propably got the wrong php.ini. Under windows are severals of them. Take that one mentioned in the apache configurations or that one in the bin directory of

[PHP-DB] MySQL - LIMIT 1 on primary KEY - makes sense?

2009-06-03 Thread Martin Zvarík
SELECT * FROM xxx WHERE primary_id=123 LIMIT 1 Is it useless (LIMIT 1) ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL - LIMIT 1 on primary KEY - makes sense?

2009-06-03 Thread Martin Zvarík
Bastien Koert napsal(a): 2009/6/3 Martin Zvarík mzva...@gmail.com: SELECT * FROM xxx WHERE primary_id=123 LIMIT 1 Is it useless (LIMIT 1) ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php It doesn't do anything...you are already

[PHP-DB] SQL for counting comments - is this smart?

2009-03-16 Thread Martin Zvarík
Is it smart to use all of this on one page? Or should I rather do one SQL and let PHP count it? $q = $DB-q(SELECT COUNT(*) FROM comments); $int_total = $DB-frow($q); $q = $DB-q(SELECT COUNT(*) FROM comments WHERE approved IS NULL); $int_waiting = $DB-frow($q); $q = $DB-q(SELECT COUNT(*) FROM

[PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Martin Zvarík
This will work: $sql = SELECT admin.AdminID, workorders.WHAT_YOU_WANT FROM admin INNER JOIN workorders ON admin.AdminID=workorders.AdminID HAVING admin.username='.$_SESSION['user'].' ; Terion Miller napsal(a): Hi Everyone! I am having problems getting an INNER JOIN to work and need some tips

Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Martin Zvarík
What I wrote with HAVING doesn't do any difference - replace back to WHERE. Your query is OK. Try: echo mysql_error(); And try to remove the condition WHERE admin.user... if that outputs anything. Martin Terion Miller napsal(a): Thanks Martin, oddly enough that still doesn't pull any

Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Martin Zvarík
believe this is proving so hard.. Thanks for helping! Terion On Thu, Jan 29, 2009 at 12:55 PM, Martin Zvarík mzva...@gmail.com mailto:mzva...@gmail.com wrote: What I wrote with HAVING doesn't do any difference - replace back to WHERE. Your query is OK. Try: echo mysql_error

Re: [PHP-DB] Re: Problems with INNER JOIN

2009-01-29 Thread Martin Zvarík
and have tried all manners of different ways to tell mySql if admin ID = session user then get workorders where orderID = admin ID On Thu, Jan 29, 2009 at 1:28 PM, Martin Zvarík mzva...@gmail.com mailto:mzva...@gmail.com wrote: Are you sure you have MORE than ONE [order + admin

[PHP-DB] Re: question about Zend PHP Studio ...Zend gave useless answer

2008-12-02 Thread Martin Zvarík
Can you explain what does it have to do with Zend PHP Studio (the PHP editor) ? Fred Silsbee napsal(a): I have Fedora 9/Apache 2/PHP 5.2.6 Everything is great but I cannot add the libraries for oci8 1.3.4 I have in a directory. The entries are grayed out. I was getting an error

RE: [PHP-DB] Value of $_POST['submit']

2008-11-27 Thread Martin, Steve (MAN-Corporate)
When I'm developing a number of pages and don't keep track of every variable or form name (etc), I plant a print_r($_POST); at the top of the page, so there's no guessing what gets sent to the page . . . If you have an empty $_POST array, then the form isn't using action=post, or you didn't code

Re: [PHP-DB] creating mysql functions using php

2008-10-09 Thread Andrew Martin
putting the delimiter call in it's own query() call, but no luck so far. Thanks, Andy 2008/10/8 Chris [EMAIL PROTECTED]: Andrew Martin wrote: Hello, Is it possible to create a mysql function from php, or is it command line only? $db = get_db(); $a = $db-query( DELIMITER $$ ); echo $db

Re: [PHP-DB] creating mysql functions using php

2008-10-09 Thread Andrew Martin
Right, problem's obvious really: There's never any need to use delimiter in an API call, as delimiters aren't used - separate calls are made instead. So the following code works just fine: $link = mysql_connect('localhost', 'root', 'pass'); mysql_select_db( 'test' ); $ret = mysql_query( 'DROP

[PHP-DB] creating mysql functions using php

2008-10-08 Thread Andrew Martin
Hello, Is it possible to create a mysql function from php, or is it command line only? $db = get_db(); $a = $db-query( DELIMITER $$ ); echo $db-error; // You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

Re: [PHP-DB] Performance (lots of tables / databases...)

2008-09-28 Thread Martin Zvarík
Thanks Tim, this helped me a lot. Martin Tim Hawkins napsal(a): If you are looking at future expansion then the separate DB per blog is defiantly the way to go. Some notes: 1) Avoid joins like the plague, in fact most operations on a blog application would consist of getting primary

[PHP-DB] Re: Could not run query

2008-09-28 Thread Martin Zvarík
Have you tested this SQL query? Insert it into phpmyadmin, does it work? If it does = php error. If it doesn't = mysql error. boclair napsal(a): I need help to track down the cause of the error,Could not run query A typical query is $laterrecords = mysql_query(SELECT * FROM messages WHERE

Re: [PHP-DB] Could not run query

2008-09-28 Thread Martin Zvarík
The quotes are OK. Tested - works. danaketh napsal(a): Well, seems to me like a problem with quotes you're using in query... The ` quotes you're using doesn't work, when I tried to use them in PHP called query. Maybe you should try use single quotes and if they works. boclair napsal(a): I

[PHP-DB] Performance (lots of tables / databases...)

2008-09-27 Thread Martin Zvarík
- in this case, won't this be an issue when SELECTing like this: [db_comments].testblog, [db_posts].testblog ? Is that a controversial topic? :-/ Thanks for ideas, Martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Performance (lots of tables / databases...)

2008-09-27 Thread Martin Zvarík
to the system - trying to imagine 1000 folders... is it a problem? I supposed that on the third solution is based the optimized wordpress (wordpress.com) - it does seem complicated, but better than having it all in one database. Martin danaketh napsal(a): Hi, the first choice is probably

Re: [PHP-DB] Performance (lots of tables / databases...)

2008-09-27 Thread Martin Zvarík
Lester Caine: danaketh wrote: Hi, the first choice is probably the best for you. When you think about second solution, it will be a nightmare when you have 1000+ databases and have to administrate them from one central system (if you're about to do it like this). The third solution looks

Fwd: [PHP-DB] Reading excel files

2008-09-17 Thread Andrew Martin
Subject: Re: [PHP-DB] Reading excel files To: Andrew Martin [EMAIL PROTECTED] Are your Excel files nicely organized by columns with column names? On 9/16/08, Andrew Martin [EMAIL PROTECTED] wrote: Hello, Does anybody have experience with excel spreadsheet reader packages, either free

[PHP-DB] Reading excel files

2008-09-16 Thread Andrew Martin
Hello, Does anybody have experience with excel spreadsheet reader packages, either free or commercial? The old PEAR class is no longer maintained and the current sourceforge-hosted reader fails to read files above a certain size - I have attempted to debug it but to no avail. I have a commercial

[PHP-DB] CMS-Blog system

2008-09-03 Thread Martin Zvarík
with some individual settings. Is there better idea? I appreciate your discussion on this topic. Martin Zvarik -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Separate or 1 database ?

2008-09-03 Thread Martin Zvarík
articles = too many rows, but easy to search and maintain I appreciate your discussion on this topic. Martin Zvarik -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mathematical discrepancies

2008-08-14 Thread Andrew Martin
Hello, Can anybody shed any light on this behaviour please? PHP Version 5.2.5 on XP $a = 1754.00 ; $b = 1754.03 ; $diff = abs($b) - abs($a); echo $diffbr/; //output: 0.03 $a = 1754.00 ; $b = 1754.09 ; $diff = abs($b) - abs($a); echo $diffbr/; //output :0.08999 $a = 1754.01

[PHP-DB] MySQL circular buffer

2008-06-20 Thread Andrew Martin
Hello, I'm looking at implementing a database-level stack for a (multi stack) mail merge queue (able to queue up to 1 million messages per stack). Current workflow: server 1 (containing main db) transmits data sets (used to populate mail merge template) to server 2 server 2 web-facing script

[PHP-DB] Serializing mySQLi result resource

2008-06-08 Thread Andrew Martin
Hello, Is it possible to serialize a MySQL(i) result resource? I am looking to insert results into the eAccelerator cache but the returned resource does not appear to be recognised by mysqli_fetch_assoc. Thanks, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[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] Re: [PHP] the opposite of a join?

2007-10-03 Thread Martin Marques
[EMAIL PROTECTED] wrote: I have a company table and a contacts table. In the contacts table, there is a field called companyID which is a link to a row in the company table. What is the easiest way to query the company table for all the company rows whose ID is NOT linked to in the contact

Re: [PHP-DB] csv problem.. read csv from var

2007-02-16 Thread Martin Alterisio
2007/2/16, bedul [EMAIL PROTECTED]: i have problem with reading csv.. for i know the example script i get was BASIC SCRIPT= $handle = fopen(hasillab.csv, r); $data2=$handle; while($data = fgetcsv($handle, 1000, ,)){ foreach($data as $str) $data2.=br=

Re: [PHP-DB] mysqli auto rollback on script termination

2006-10-10 Thread Martin Koch Andersen
transations. Thanks. -- Martin - http://925.dk Shoot for the moon, even if you miss, you'll land among the stars. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysqli auto rollback on script termination

2006-10-09 Thread Martin Koch Andersen
in a script (using FOR UPDATE and LOCK IN SHARE MODE), that looks like they are caused by transactions not being rolled back (releasing locks) correctly. -- Martin - http://925.dk Shoot for the moon, even if you miss, you'll land among the stars. -- PHP Database Mailing List (http://www.php.net

[PHP-DB] mysqli auto rollback on script termination

2006-10-08 Thread Martin Koch Andersen
Hi, In case the PHP script dies (from fatal error, die() or similar), is any started transaction (BEGIN TRANSACTION) automatically rolled back (ROLLBACK) by PHP then? I can't find any documentation about this. Thanks in advance for hints, links etc. -- Martin - http://925.dk Shoot

Re: [PHP-DB] Select distinct field won't return distinct value

2006-06-07 Thread Martin Alterisio
I have a friend called GROUP_CONCAT, he may know what you want but he's only available since MySQL 4.1 2006/6/7, Blanton, Bob [EMAIL PROTECTED]: It is a Sybase vendor function but I was wondering if mysql had something comparable. I don't see anything in the manual. Maybe the subquery is the

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread Martin Alterisio
2006/5/12, JupiterHost.Net [EMAIL PROTECTED]: Dwight Altman wrote: Right after rebuilding php and apache and breaking PHP funtionality for everyone, just so you can send a semi complex MIME message? That is the epitome of PHP's lameness and why I can't sit quietly by and not recommend

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread Martin Alterisio
2006/5/12, Martin Alterisio [EMAIL PROTECTED]: ... I hate not having a proper application framework, ... Sorry, there is a mistake there. I meant to say that I hate not having an application server, although I also think currently available framework are just not the way to go

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread Martin Alterisio
2006/5/12, JupiterHost.Net [EMAIL PROTECTED]: It's a fact that I can't deny any of the bad points you have exposed about PHP. I even agree with you that most of this problems are really awful and it's pointless to hide them. But the fact that PHP is by preference the language for

Re: [PHP-DB] preg_replace help!

2006-05-04 Thread Martin Alterisio
2006/5/3, Nathan Heaps [EMAIL PROTECTED]: Ok, scratch that, new problem. what can I replace (.*?) with in order for php to recognise a multi-line quote/bold/italic/code/whatever? By default the . pattern matches anything except a line break you can either use ((?:.|\n)*) or add a modifier to

Re: [PHP-DB] preg_replace help!

2006-05-04 Thread Martin Alterisio
2006/5/4, Martin Alterisio [EMAIL PROTECTED]: 2006/5/3, Nathan Heaps [EMAIL PROTECTED]: Ok, scratch that, new problem. what can I replace (.*?) with in order for php to recognise a multi-line quote/bold/italic/code/whatever? By default the . pattern matches anything except a line break

Re: [PHP-DB] Bad picture colors

2006-04-27 Thread Martin Alterisio
2006/4/27, nikos [EMAIL PROTECTED]: Hello list I use the following code to shrink some photos. $directory='/var/www/html/offroads/tmp/'; $dir=opendir($directory); while($file=readdir($dir)) { $dirfile=$directory.$file; if(is_file($dirfile))

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-26 Thread Martin Alterisio
2006/4/26, [EMAIL PROTECTED] [EMAIL PROTECTED]: Skip Evans wrote: Hello all, I'm brand spanking new to the list and have a quick question. I was under the impression that addslashes() would handle single quote marks in INSERT statements, but when I execute the following:

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread Martin Alterisio
1) Check that the string is not being truncated because of the column length 2) If you're seeing this data being truncated in the html output of your site, check if it isn't being caused by outputing the data without properly encoding special html characters. 3) . dunno 2006/4/25, Skip

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread Martin Alterisio
2006/4/25, Skip Evans [EMAIL PROTECTED]: Martin Alterisio wrote: 1) Check that the string is not being truncated because of the column length This was not it. I was sure it wasn't but the first rule of debugging says never discard a possible cause, no mather how dumb it may seem 2

RE: [PHP-DB] help with file downloads from MySQL

2006-03-28 Thread Mickey Martin
from the queries and it put a newline at the end of the output data. Thanks everyone for the help with this. -Original Message- From: Oskar [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 1:59 AM To: Mickey Martin; PHP db Subject: Re: [PHP-DB] help with file downloads from MySQL

RE: [PHP-DB] help with file downloads from MySQL

2006-03-24 Thread Mickey Martin
line: echo TEST TEXT, $data; When the file is saved, it begins with 0a followed by TEST TEXT and then the start of the file without another instance of 0a. Mickey -Original Message- From: Oskar [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 1:59 AM To: Mickey Martin; PHP db

RE: [PHP-DB] help with file downloads from MySQL

2006-03-22 Thread Mickey Martin
it is configured today. Thanks, Mickey -Original Message- From: Giff Hammar [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 3:50 PM To: 'Mickey Martin'; 'Bastien Koert'; php-db@lists.php.net Subject: RE: [PHP-DB] help with file downloads from MySQL Can you use something like this (I haven't

[PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
Every time I try to download a file from MySQL it cannot be opened. Using HexEdit, I noticed that all of the files are getting 0a added to the beginning of them (happens with all browsers). I can look at the files with MySQL Query Browser and they don't have the 0a. Using php 4.3.11, Solaris 8,

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
@lists.php.net Subject: RE: [PHP-DB] help with file downloads from MySQL If you load the data into the field with addslashes, have you tried stripslashes on the way out? Bastien From: Mickey Martin [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] help with file downloads from MySQL Date

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
with file downloads from MySQL If you load the data into the field with addslashes, have you tried stripslashes on the way out? Bastien From: Mickey Martin [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] help with file downloads from MySQL Date: Tue, 21 Mar 2006 12:55:56 -0600 Every time I

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
, March 21, 2006 2:07 PM To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] help with file downloads from MySQL If you load the data into the field with addslashes, have you tried stripslashes on the way out? Bastien From: Mickey Martin [EMAIL PROTECTED] To: php-db@lists.php.net Subject

Re: [PHP-DB] Data split: web local machine

2006-02-21 Thread Martin Alsinet
, emailing it to the client, then merging it with the cc_file to ¿emailing a file with cc numbers? I would never use a service if I knew that my cc number would go in an excel file via email, but thats just me. Check the thread for some sobering remarks about cc security. Martin -- PHP Database

RE: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field?. .

2005-12-06 Thread Norland, Martin
readable MSSQL option being passed in the SQL. cheers, - Martin Norland, Sys Admin / 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: Alex

[PHP-DB] transactions

2005-11-07 Thread martin lutsch
ideas? please help, cheers, martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: Need help with delete and modify functions on a form.

2005-10-18 Thread Norland, Martin
=check[1] value=someValue2nbsp;Some Value 2 input type=checkbox name=check[2] value=someValue3nbsp;Some Value 3 (although a little more unique would be clearer :) ) cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email

RE: [PHP-DB] Limited connections to the database. .

2005-10-17 Thread Norland, Martin
/etc. that change once a month, cache them globally somewhere and don't keep requesting them so often) - there may not be any such data, but then again, there may be. cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within

RE: [PHP-DB] Search Replace within PHP

2005-10-06 Thread Norland, Martin
I think he's looking for str_replace() / preg_replace() or sprintf() or similar http://www.php.net/str_replace http://www.php.net/preg_replace http://www.php.net/sprintf cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained

RE: [PHP-DB] Convert String to Array

2005-09-30 Thread Norland, Martin
more effort than the separate columns method. cheers, - Martin Norland, Sys Admin / 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: Ng

RE: [PHP-DB] PHP Forms - upload VS text

2005-09-30 Thread Norland, Martin
form action=?php tpl($_SERVER['REQUEST_URI']) ? method=post enctype=multipart/form-data Beyond that it's just the $_FILES array and $_POST array. cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

RE: [PHP-DB] PHP Forms - upload VS text

2005-09-30 Thread Norland, Martin
. :) cheers, - Martin Norland, Sys Admin / 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: Rui Cruz [mailto:[EMAIL PROTECTED] Sent: Friday

RE: [PHP-DB] what is the value of session_register

2005-09-22 Thread Norland, Martin
enabled. (which is defaulted to off since php 4.2.0). Hit up http://www.php.net/ 's documentation for more on this. cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St

RE: [PHP-DB] insert error for mysql

2005-09-19 Thread Norland, Martin
' - insert into foo (bar) values ('this isn't going to work.'); might I suggest starting with addslashes() Cheers, - Martin Norland, Sys Admin / 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] Re: Inserting same text into HTML files. .

2005-09-13 Thread Norland, Martin
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; xml:lang=en lang=en dir=ltr ... Not necessarily. cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach

RE: [PHP-DB] Help with

2005-08-31 Thread Norland, Martin
Don't mix mysql_ functions with mysqli_ functions, and you'll have much greater successes. $dbcon = mysql_connect( 'localhost', 'root', 'password', 'database_name' ); should be $dbcon = mysqli_connect( 'localhost', 'root', 'password', 'database_name' ); Cheers, - Martin Norland, Sys

RE: [PHP-DB] Re: HTML layout and arrays (WAS : Brain not working, helpneeded :-). .

2005-08-29 Thread Norland, Martin
: ); print_r($video); } I have 6 items on the page so I can hardcode ?=$id1? for item 1 and Instead, use ?=$videos[0][video_description]? and so on. And use ?php instead of ? just to be safe :) cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257

RE: [PHP-DB] Brain not working, help needed :-). .

2005-08-29 Thread Norland, Martin
. It's in the docs in the variables section.. I couldn't have suggested a better place to get sorted out on all this - Chris: browse the docs some, best way to wrap your head around things - and the comments at the bottom tend to have useful real-world examples. cheers, - Martin Norland, Sys Admin

Re: [PHP-DB] mysql not valid resource. .

2005-08-09 Thread Martin Norland
to get the rows. cheers, -- - Martin Norland, Sys Admin / 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. Hutchins, Richard wrote: Marco, Have you tried echoing out

[PHP-DB] PHP PostgreSQL UTF-8 issue

2005-08-03 Thread Martin Edlman
such bytes into insert command. But prints full variable. Is there some way to make it working? Use multibyte? I tried to use mb_ functions but without efect. For now I made it working by increasing the size of the name and the surname columns in the DB. Regards, Martin Edlman -- PHP Database

Re: [PHP-DB] Re: printing errors. .

2005-08-02 Thread Martin Norland
Incidentally - I *think* in some of these he's actually answering questions, but they must be fairly old, I archive every two months or so and I don't see any matches in my current. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained

RE: [PHP-DB] Duplicate record

2005-07-30 Thread Martin B. Nielsen
Would'nt the simplest just setting one of the rows as UNIQUE? Or you can add one query that checks if one of the values already exists in the database. Best regards, Martin -Original Message- From: Hallvard [mailto:[EMAIL PROTECTED] Sent: 30. juli 2005 12:17 To: php-db@lists.php.net

Re: [PHP-DB] Finding duplicate contacts..

2005-07-26 Thread Martin Norland
, -- - Martin Norland, Sys Admin / 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. [EMAIL PROTECTED] wrote: We have a table with contacts and we need to determine if someone's

Re: [PHP-DB] Help. I am losing the plot.. .

2005-07-05 Thread Martin Norland
sometimes, unfortunately. cheers, -- - Martin Norland, Sys Admin / 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] Re: list test subject. .

2005-06-26 Thread Martin Norland
) O/S machine, a box. it's just OS - it's an abbreviation, not O/S like O/S 2. cheers, -- - Martin Norland, Sys Admin / 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] RE: php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992. .

2005-06-22 Thread Martin Norland
, it's possible it's something else entirely - but something should be logged when the pages bail out like that. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St

Re: [PHP-DB] Shrinking gifs.. .

2005-06-22 Thread Martin Norland
nikos wrote: Thank you Martin I install new gd, reconfigure php and now is running OK. But, it was a mass to realize that shortening gifs results to loss transparency(!). [snip] imagecolortransparent() That function will set the transparent color in an image (only one per image). If you

Re: [PHP-DB] Shrinking gifs. .

2005-06-21 Thread Martin Norland
. * funny, since gd stood for 'gif draw' originally. cheers, -- - Martin Norland, Sys Admin / 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

Re: [PHP-DB] Strange MySQL Problem. .

2005-06-14 Thread Martin Norland
with: mysql -u root -p -S/var/lib/mysql/mysql.sock chances are you need to tell php where your mysql socket is (through php.ini). cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those

Re: [PHP-DB] mysqldump but exclude one table. .

2005-06-14 Thread Martin Norland
, -- - Martin Norland, Sys Admin / 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] mysqldump but exclude one table. .. .

2005-06-14 Thread Martin Norland
[EMAIL PROTECTED] wrote: C:\mysqldump --version mysqldump Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32) [snip] Ummm. What version are you using, Martin? David fairly fresh I'm afraid. mysqldump Ver 10.9 Distrib 4.1.9, for pc-linux-gnu (i686) your grep generates... interesting

Re: [PHP-DB] Page refresh question. .

2005-06-09 Thread Martin Norland
always differs from their initial) earlier rather than later. Bottom line is this is probably a new request, but you may have to eat it depending on your situation / relationship / contract. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257

Re: [PHP-DB] Missing mysql.so?. .

2005-05-31 Thread Martin Norland
to re-remove everything. When all is said and done check your php.ini, in case it has remaining lines pointing at wrong libs/etc. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily

Re: [PHP-DB] Multiselect List. .

2005-05-18 Thread Martin Norland
for. The only solution is to use different names for the javascript variables describing/referring to your form/other elements. h8_ie_nothing = MM_findObj(nothing); cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

Re: [PHP-DB] php line error. .

2005-05-17 Thread martin . norland
)? no. (but the line with the include() call counts normally 3. are d parts of the file that are not in php (i mean that are not contained within the php delimeters) also counted? yes. in short, it's the line number of the script as if it were a plain text file. cheers, -- - Martin Norland

Re: [PHP-DB] problems with a script. .

2005-05-17 Thread martin . norland
John R. Sims, Jr. wrote: Martin; I have taken your advice and read both of the articles, but unfortunately I have not been able to find what needs to be changed. As I mentioned, I am very new at this. Could you possibly look at the script and point me in the right direction? [snip] /head

Re: [PHP-DB] problems with a script. .

2005-05-16 Thread Martin Norland
John R. Sims, Jr. wrote: Martin; I have taken your advice and read both of the articles, but unfortunately I have not been able to find what needs to be changed. As I mentioned, I am very new at this. Could you possibly look at the script and point me in the right direction? [snip] /head ?php

Re: [PHP-DB] php line error. .

2005-05-16 Thread Martin Norland
)? no. (but the line with the include() call counts normally 3. are d parts of the file that are not in php (i mean that are not contained within the php delimeters) also counted? yes. in short, it's the line number of the script as if it were a plain text file. cheers, -- - Martin Norland, Sys Admin

Re: [PHP-DB] database synchronization. .

2005-05-12 Thread Martin Norland
or not the servers can always be on. Is it possible to have a delay on the updating of information - to have a master server for the writes, and local slave servers at each site for just reads - or are writes too common a change? Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer

Re: [PHP-DB] problems with a script. .

2005-05-12 Thread Martin Norland
, and might be better off looking for a new host or setting up php5 on your current host (either you or them installing it, more likely you'll have to if it's even allowed). cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within

Re: [PHP-DB] Transfering post data to a series of pages. .

2005-05-04 Thread Martin Norland
be turned into function calls or classes and called from Page4.php. You don't need to separate logic and display in separate scripts that you push everything at, just separate your logic out into function calls. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International

Re: [PHP-DB] Transfering post data to a series of pages. .. .

2005-05-04 Thread Martin Norland
Martin Norland wrote: include() :P seriously though, Page1.php and Page4.php are the only two pages that should exist, if any. Page2 and Page3 should pretty much guaranteed be turned into function calls or classes and called from Page4.php. You don't need to separate logic and display

Re: [PHP-DB] URL question. .

2005-05-02 Thread Martin Norland
could also just alias it / etc. cheers, -- - Martin Norland, Sys Admin / 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] Problems with a script. .

2005-05-02 Thread Martin Norland
. Once that's all fixed, go to step 5. 5) rewrite all the database accesses to prevent people from doing sql injection attacks and ruining everything. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email

Re: [PHP-DB] Headers sent error msg on one server but not the other ...... .

2005-04-29 Thread Martin Norland
(and how your backend is written) could throw someone or something into a state of confusion. cheers, -- - Martin Norland, Sys Admin / 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] php3 and oracle9i client libraries doesn't compile. .

2005-04-28 Thread Martin Norland
, -- - Martin Norland, Sys Admin / 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

Re: [PHP-DB] php3 and oracle9i client libraries doesn't compile.... . .

2005-04-28 Thread Martin Norland
, it's happened before. Incidentally, why does PHP need: Professional Services Automation Personal Security Advisor Public Safety Announcement Python Software Activity Port Scan Attack ( 3 letter abbreviations are way too crowded :P ) cheers, -- - Martin

Re: [PHP-DB] Headers sent error msg on one server but not the other.... .

2005-04-28 Thread Martin Norland
kind of header, wrapper, server-side include, or anything around the script - or perhaps you're making use of output buffering and the server isn't allowing its use? cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within

Re: FW: [PHP-DB] mime-type related to extension?. .

2005-04-27 Thread Martin Norland
, -- - Martin Norland, Sys Admin / 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

Re: [PHP-DB] Memory. .

2005-04-27 Thread Martin Norland
then have two copies of your entire data. If you need to pull your whole set of results out into an array, you can immediately use pg_free_result() or mysql_free_result() afterwards to free up the copy using memory in the database. cheers, -- - Martin Norland, Sys Admin / Database / Web

Re: [PHP-DB] Counting HTML Lines

2005-04-15 Thread Martin Norland
you cater your output more to be predictable. Also, remember to account for htmlentities if that's an issue, = amp;, etc. Really not a fun solution to entertain, IMO. Good luck! cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s

Re: [PHP-DB] using POST data for a readfile

2005-04-13 Thread Martin Norland
mel list_php wrote: Thank you very much! [snip] I didn't get the base tag though, what does that mean? It was merely a cautionary warning about sites that force a base href for relative URIs (including, of course, URLs) See: http://www.w3.org/TR/html4/struct/links.html#h-12.4 cheers, -- - Martin

  1   2   3   4   5   >