Re: [PHP-DB] Re-using a result set

2001-01-11 Thread joe
Sure, just do: mysql_data_seek($sql_result,0); before you get to your while() the second time. Hope this helps, Joe TopFive wrote: > Hello, everyone -- I'm new to the list, and to PHP. > > I own a very large, very active original humor website which > currently consists

[PHP-DB] oci8

2004-11-21 Thread Joe
I am facing problem in connecting to Oracle from php. I followed the instructions listed in www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.h tml. However, when I run phpinfo(), it show that oci8 is not loaded and eventually the ocilogon() is not working. I'd really a

[PHP-DB] 2 problems with phpmyadmin since upgrade

2007-09-24 Thread Joe
x27;t browse, add or edit records through phpmyadmin which is a real pain. Any help would be greatly appreciated. If someone can just fix it for me please let me know a cost. Thanks Joe [EMAIL PROTECTED] -BEGIN GEEK CODE BLOCK- Version: 3.1 GB/CM/CC/E/H/IT/MC/MU/P/SS [EMAIL PROTECT

Re: [PHP-DB] running php script daily at fixed time

2001-01-09 Thread Joe Lloyd
Try putting this in your crontab, to access the webserver in order to execute the script. lynx --dump http://www.yourserver.com/my_script.php --Joe farhat daud wrote: > i have prepared a php script which takes input from a database and sends it > to certain email addresses. > this

Re: [PHP-DB] problems with require...

2001-02-15 Thread Joe Brown
nd add it to the path for includes you use in all projects. Then you might set your include_path="d:\inetpub\php\incude;." Best wishes, -joe "shmengie" - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: php.db Sent: Tuesday, February 13, 2001 7:30 PM Subject

Re: [PHP-DB] Dynamil Links

2001-02-16 Thread Joe Lloyd
he one page and in articleload.php do $h=urldecode($h); --Joe Sridhar Ranganathan wrote: > > Hi, > > I have a search engine. It finds articles and displays the headings. When I > click on the heading, I wanna load the article using a single page on the > fly. > > I did a

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

2001-02-22 Thread Joe Brown
ogram lying around my linux box. A couple of distributions later, I find none.. vi works well though.. $ vi tnsnames.ora :set ff=unix :w! Did the trick for me, HTH. -Joe ""Peter J. Krawetzky"" <[EMAIL PROTECTED]> wrote in message 001801c09cce$8c530160$[EMAIL PROTECT

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

2001-02-22 Thread Joe Brown
now how to do it with emacs... ;-) Didn't take long to figure it out with vi, so I went that route. (BTW who's the joker at Microsoft that thinks ctrl-p should print things?) -Joe ""Peter J. Krawetzky"" <[EMAIL PROTECTED]> wrote in message 000c01c09cf2$c00a8ef0

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-23 Thread Joe Brown
I suppose the authors never concieved a replacement parameter for select specification. try: > $sql = "select foo, bar, rid from masterdata WHERE rid=:rid" You need to loose the colon ":" or place it to the right of a where clause. <[EMAIL PROTECTED]> wrote in message F114C0EF28F3D211B7E8400061

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-24 Thread Joe Brown
e and how you are using rowid, I cannot guess what are trying to do. It is a good idea to avoid using rowid for updating records. Instead, use a primary key column containing a sequence generated value for record identification. Good luck, -Joe "Sven Voigt" <[EMAIL PROTECTED]

Re: [PHP-DB] deleting carts

2001-02-24 Thread Joe Brown
impler to create and maintain: $ mysql --execute "delete from carts where timestamp > now() + 36000" -- Have fun, -Joe ""Jorge Santos"" <[EMAIL PROTECTED]> wrote in message 002e01c09ee4$f1754360$[EMAIL PROTECTED]">news:002e01c09ee4$f1754360$[EMAI

Re: [PHP-DB] Server side or client side?

2001-02-24 Thread Joe Brown
Don't complicate it... Just enclose your list entries in ${entry} and use another page if you want... Or loop back to the same page and check if(empty($id)) {show the first list... ${entry} ...} else { show the second list} ""Sridhar Ranganathan"" <[EMAIL PROTECTED]> wrote in message [EMAIL P

Re: [PHP-DB] Oracle 8i questions

2001-02-26 Thread Joe Brown
":body" in sql isn't the same as ":bodytext" in the bindbyname statement, after that, you're in deeper than myself... HTH, -Joe ""Chris Murtland"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... &

Re: [PHP-DB] Fatal error: Call to undefined function: () in add2.php on line 11

2001-02-26 Thread Joe Brown
back to the drawing board... Re-compile php --with-mysql ""jim and lois flaherty"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > help , I have this problem > >I have redhat 7.0 >mysql 3.23 >and php-mysql rpm installed > > my code > > > >

Re: [PHP-DB] md5

2001-02-27 Thread Joe Brown
You are aware that md5() generates a 32 byte character string? Working on the 10 digit password request, have you alotted enough space in your database columns to cater to a 32 byte string (64 for multibyte)? BTW: md5 has eaten everything I've thrown at it ;-) ""bryan"" <[EMAIL PROTECTED]> wrot

Re: [PHP-DB] Resolution detect and redirect

2001-02-27 Thread Joe Brown
This feat will require a java script (not appropriate for php/db). I saw something on a javascript site, perhaps www.webreference.com gl ""Matthew Cothier"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > >Why not just create a table that will resize to any r

Re: [PHP-DB] MySQL join problem

2001-02-27 Thread Joe Brown
I doubt that a few thousand records would be more than mysql is capable of handeling. However my ignorance of Mysql is abundant. Does it use the /tmp directory and is your /tmp or root partition small? (guessing linux here). Does mysql use the /tmp directory for temporary tables? (Answer in Read

Re: [PHP-DB] Can't connect to local MySQL server error

2001-02-27 Thread Joe Brown
Heh, hate this gotcha... The file permissions are good... ok, now check each directory up to mysql.loc /var /var/lib /var/lib/mysql Does the world have read and execute perms on all of the above (hehe made a funny)? Without read and execute perms on the parent directories, the world cannot see t

Re: [PHP-DB] How would you have liked to have invested in Yahoo when it was still a year old?

2001-03-01 Thread Joe Brown
Excuse me for my lack of understanding, but what does this have to do with php or databases? "Jess Ragaza" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > or eBay? Well, I missed it too. Now we all have the > great opportunity not only to relive it but also to

Re: [PHP-DB] php 3 vs. 4

2001-03-02 Thread Joe Brown
Nope, session management was added in php4. The phplib project among other things, provides a session management mechanisim. ""Free Beachler"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > is there any support for session mgmt in php3? > > my client is tryin

[PHP-DB] Javascript diabled? (was Re: [PHP-DB] onMouseOver & onMouseOut)

2001-03-02 Thread Joe Brown
Curious. I disabled javascript in IE 5.5 Out of the limited scripting I use on my site, the navigate to first entry field nolonger works, but the onchange() event seems to be firing still... Go figure. "Ron Brogden" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]

Re: [PHP-DB] Oracle Function Calls

2001-03-07 Thread Joe Brown
this chunk of code comes out of http://www.php.net/manual/en/function.ocinewcursor.php Hope that helps, I havn't gone there (yet). ""Richard S. Crawford"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ah! My bad! I sent this question out with the wrong s

Re: [PHP-DB] Oracle connection

2001-03-12 Thread Joe Brown
You need to acquire the oracle network drivers for linux, from Oracle. I'm only aware of the ones that come with Oracle for linux, though they may have them bundled seperately. Fight your way through the inconcievably difficult installation process. After defining some environment variables (th

[PHP-DB] Re: [PHP] Bug or what?

2001-03-12 Thread Joe Stump
estroys it without setting it. --Joe On Mon, Mar 12, 2001 at 01:08:37PM -0600, Fabio Ottolini (EDB) wrote: > First File - index.php > > header("Pragma: no-cache"); > header("Cache-Control: no-cache, must-revalidate"); > if(empty($check)) { > $page

Re: [PHP-DB] broken page

2001-03-12 Thread Joe Brown
I've experienced this behaviour also. My first guess is that there are broken connections to oracle server. Cleaning up the code so that all resources are properly freed seems to have helped. Restart apache to clear the defunct OCIPLogin(s). If it happens again, you're probably not freeing a $s

Re: [PHP-DB] Connecting to Oracle

2001-03-13 Thread Joe Brown
I'm not looking forward to this... Due to circumstances beyond my control, I will be forced into a similar configuration soon. Try putenv("ORACLE_SID=WKDS.world"); If your sqlnet.ora does does not specify .world as the default domain, then that may be the problem. Was your TNSNAMES.ORA file ftp

Re: [PHP-DB] Re: Connecting to Oracle

2001-03-13 Thread Joe Brown
Brian, Thanks for the solution, that is a good one. I imagine you can set the environment variable oracle_sid this way also. ORACLE_SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.68.10.1)(PORT=1521) )(CONNECT_DATA=(SID=TEST))) re: TNSNAMES.ORA It seems to be a fairly common occurence where

Re: [PHP-DB] Javascript and PHP

2001-03-14 Thread Joe Brown
Well, No and Yes. If the form is posted, whichever page that it was posted too will have $HTTP_POST_VARS["text1"] set to whatever was in the textbox. $text1 may also be a global variable, depending on your php.ini settings for register_globals and also variable_order. It took me a while to feel

Re: [PHP-DB] Variable variables ! - help

2001-03-14 Thread Joe Brown
Seems like you need to try curly braces. ${art_nr}_${i} ""Keith Whyman"" <[EMAIL PROTECTED]> wrote in message 024d01c0ac8f$1a6373c0$0b64a8c0@server">news:024d01c0ac8f$1a6373c0$0b64a8c0@server... > > driving me up the bloody wall ! > I'm sure it's something simple ! > This works fine > > > for ($i

Re: [PHP-DB] PHP how to compare?

2001-03-15 Thread Joe Brown
No, two is a more accurate comparison. !== Although for most cases != is sufficient. ""Richard S. Crawford"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > use just one = sign. So, > > if ($PASS != $PASSNOG) {... > > > At 01:41 AM 3/15/01 +0100, Duky wrote: >

Re: [PHP-DB] Retrieving names from second table from id number

2001-03-16 Thread Joe Brown
AND s.ref3_id=r3.id I sure it would work in Oracle, a little curious about it working in mysql. Good Luck, -Joe ""Brett"" <[EMAIL PROTECTED]> wrote in message 01a701c0ae6e$fcacea00$e1214ed8@bcnu">news:01a701c0ae6e$fcacea00$e1214ed8@bcnu... > I am retrie

Re: [PHP-DB] metabase documentation or samples

2001-03-17 Thread Joe Brown
http://phpclasses.upperdesign.com/browse.html/package/20 To my knowledge, this is the home page for metabase. Manuel has done a wonderful job putting together a documentation and a tutorial. ""Dean Hall"" <[EMAIL PROTECTED]> wrote in message 98usbh$li8$[EMAIL PROTECTED]">news:98usbh$li8$[EMAIL

Re: [PHP-DB] problem with num_rows (OCIRowCount)

2001-03-19 Thread Joe Brown
I believe OICrowcount() only returns the number of affected DML affected rows, ones affected by insert or update. Use two seperate queries, one for the count, then another for the data. "SELECT COUNT(*) FROM yourTable WHERE yourWhereClause" Or read all the records into an array and count 'em as

[PHP-DB] Problem with Interbase/Character Set

2001-03-19 Thread Joe Blocher
ic overflow, or string truncation Cannot transliterate character between character sets" What's the problem? It doesn't work on Windows, the same on Linux. It's the same with other charactersets (ASCII, WIN1252...). many thanks for an answer Joe -- PHP Database Mailing List (htt

Re: [PHP-DB] How to display HTML code?

2001-03-19 Thread Joe Brown
try: Home"); ?> ""Osman Omar"" <[EMAIL PROTECTED]> wrote in message 00f901c0b0cf$c99e7da0$da604a2b@sony">news:00f901c0b0cf$c99e7da0$da604a2b@sony... > Hi, > > Suppose I want to display HTML code eg "Home" > > How can I do that in php? > > > -- > PHP Database Mailing List (http://www.php.net/) > To

Re: [PHP-DB] Line breaks in output

2001-03-19 Thread Joe Brown
Better yet, use "" for browsers. Or use Jeff's method but use nl2br function to convert new line to echo nl2br($result); ""JJeffman"" <[EMAIL PROTECTED]> wrote in message 007f01c0b0d8$212e97a0$5bd4d7c8@jjeffman">news:007f01c0b0d8$212e97a0$5bd4d7c8@jjeffman... > Create a variable to concatenate

Re: [PHP-DB] mail() headers

2001-03-19 Thread Joe Brown
I believe mail works completely different on unix. It probably doesn't suffer the same problems, because it's a direct call to an external process. Lookup "sendmail" ""Free Beachler"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Someone else has tested thi

Re: [PHP-DB] Transmitting Arrays

2001-03-21 Thread Joe Brown
o two steps in one. $holder=urlencode(seralize($var_name)); $var_name=unseralize(urldecode($holder)); Might also want to use htmlentities(): echo "next"; gl, -Joe ""Mark Collin"" <[EMAIL PROTECTED]> wrote in message 01f501c0b186$f82da990$4134fea9@effigia&quo

Re: [PHP-DB] Indexing help

2001-03-27 Thread Joe Brown
what the computer has to do. The computer (dbms) picks which index to use based on whats column in the where clause. Order By clauses can also benifit from an index. -Joe ""Steve Brett"" <[EMAIL PROTECTED]> wrote in message 99pjr2$20s$[EMAIL PROTECTED]">news

Re: [PHP-DB] get_browser()

2001-03-27 Thread Joe Brown
Is it easier to update every web page you code with get_env("HTTP_USER_AGENT") ; or easier to grab a new browser.ini file? ""Simon R Jones"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > hi all > how does everyone feel about the get_browser function?? Is the

[PHP-DB] PHP 5 mysql_fetch_array problems

2004-08-25 Thread Joe Smith
I'm hoping someone can help me with this. I am having problems with the mysql_fetch_array function in PHP 5.0.1 - the code listed below works fine with PHP 4.3.2. Here is my setup: A DB class file that has the following for the mysql_fetch_array (I know this function is OK because its working wh

[PHP-DB] Extending the MySQLi_Result object?

2004-11-08 Thread Joe Bandenburg
n is, how do I alter the "query" method to return my new MySQLi_result object instead of the base object? Or, is there another/better way of achieving what I'm looking for? Am I missing something very obvious here? :) Thanks, Joe Bandenburg -- PHP Database Mailing List (http://

[PHP-DB] Extending MySQLi_Result object

2004-11-16 Thread Joe Bandenburg
n is, how do I alter the "query" method to return my new MySQLi_result object instead of the base object? Or, is there another/better way of achieving what I'm looking for? Am I missing something very obvious here? :) Thanks, Joe Bandenburg -- PHP Database Mailing List (http://

Re: [PHP-DB] metabase support

2001-04-02 Thread Joe Brown
on Windows and it's not nearly as mature as Metabase. -Joe - Original Message - From: ""Dean Hall"" <[EMAIL PROTECTED]> Newsgroups: php.db Sent: Monday, April 02, 2001 1:36 AM Subject: Re: [PHP-DB] metabase support > > ""Manuel Lemos"

Re: [PHP-DB] Validating forms

2001-04-03 Thread Joe Brown
Do both, javascript and server side validation. Javascript can cut down on unnessary page refreshes. Serverside is the only way to guarentee the results, because of the reasons outlined here. Yes, it's more work, but it will provide a better experience for the end surfer. No? -Joe &qu

Re: [PHP-DB] Oracle vs MS SQL vs MySQL

2001-04-04 Thread Joe Brown
acle, not for a long time to come ;-) -Joe ""Brian.J.Mauter"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hey, > > Has anyone tried out all three of these DBMS packages and evaluated them? > I was wonderin

Re: [PHP-DB] Is Sybase supported on Windows?

2001-04-04 Thread Joe Brown
Does anyone else find this question quite funny? MS SQL Server is based on Sybase code purchased from Sybase. Kinda explains why Sybase and MS SQL server use the same extension. - ""Javier Boluda"" <[EMAIL PROTECTED]> wrote in message 00f801c0bcf8$c2cd0020$[EMAIL PROTECTED]">news:00f801c0bcf8$c2

Re: [PHP-DB] ocibindbyname: ORA-01008: not all variables bound

2001-04-05 Thread Joe Brown
Don't have a whole lot of practice with the OCIBindByName function, but I seem to be having success within a recursive select statement. I'm not useing the & operator in my implementation. Don't know if that's a good or a bad thing (yet), but it seems to be functioning properly. The third param

Re: [PHP-DB] Still not - Display data begin with "A"

2001-04-07 Thread Joe Brown
Put the percent symbol inside of the single quotes: $result = mysql_query("SELECT * FROM mydata WHERE name like '$begin%' ",$db); "Naga Sean" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > It still not working > I want to get the result of people with the fir

Re: [PHP-DB] date_format for Oracle

2001-04-11 Thread Joe Brown
Also consider the oracle sql ALTER SESSION SET NLS_DATE_FORMAT='-MM-DD HH24:MI:SS' or whichever format you prefer. This sets the default format returned when selecting a date column. -Joe "Steve Farmer" <[EMAIL PROTECTED]> wrote in message news:p04320402b6

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Joe Brown
My solution was almost as elegent... $query="select * from customers"; $queryand=false; if(!empty($f_Account)) { $query.=" WHERE upper(P.Account) like upper('$f_Account')"; $queryand=true; } if(!empty($f_First_Name)) { $query.=($queryand?" AND ":" WHERE ")."upper(p.First_Nam

Re: [PHP-DB] Intialize PHP Module on Windows98

2001-04-30 Thread Joe Brown
Looks like you've got different versions for php and your modules. Since php is the oldest, make sure you have the newer php4isapi.dll and php4ts.dll in the system directory, or wherever you installed them. ""Benny"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED].

Re: [PHP-DB] Executing a PL/SQL Function

2001-04-30 Thread Joe Brown
Does the database user your logging in as have execute permissions for that procedure? "Marcelo Dias de Toledo" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Here is the code: > > $stmt = OCIParse($conn,"BEGIN prontolog.pc_int.pedido(:p_cgc_lweb, > :p_id_clie

Re: [PHP-DB] PHP5 is NOT out yet, but 4.0.5 IS!

2001-05-01 Thread Joe Brown
4.0.5 went through many release candidates. As the bugs were found and corrected new ones and new features were added also. In order to cut a stable 4.0.5 version for general consumption, development was halted at one point, notes continued to be added, to document stuff. If it makes you feel a

Re: [PHP-DB] undefined index

2001-05-01 Thread Joe Brown
I don't think dropping the quotes is the best solution. One might consider dropping the warning level in php.ini, if it is a problem, or use numbered array like mysql_fetch_row() returns. -Joe ""Henning Kilset Pedersen"" <[EMAIL PROTECTED]> wrote in message

Re: [PHP-DB] Sessions ???

2001-05-02 Thread Joe Brown
he need for the client to keep sending the same information over and over again. In either event, I recommend useing a different session variable name than the put variable's name, unless you use $HTTP_GET_VARS/$HTTP_SESSION_VARS accordingly. -Joe ""DC"" <[EMAIL PRO

Re: [PHP-DB] Sessions ???

2001-05-02 Thread Joe Brown
Doh! I meant there is "NO dire need" ""Joe Brown"" <[EMAIL PROTECTED]> wrote in message 9cp3kv$3hj$[EMAIL PROTECTED]">news:9cp3kv$3hj$[EMAIL PROTECTED]... > For this operation there is dire need for session management. > > And remember the

Re: [PHP-DB] Passing Objects

2001-05-10 Thread Joe Brown
Nope. something like this may get you where you want to go though include("myObjectClassDeclaration"); $myInstance=new myObject; echo "http://blahblah.com/?passedClass=".urlencode(serialize($myInstance)); Then in subsequent pages this should work: include("myObjectClassDeclaration");

[PHP-DB] Re: ORA-12541: TNS:no listener error

2001-08-22 Thread Joe Casey
.0.6 against Oracle 9i and everything went smoothly. However, when I > attempt to execute my PHP code, I get the following error: > > ORA-12541: TNS:no listener > > My database admin says that the connection information is accurate. Is > there something new I have to do with

[PHP-DB] Re: ORA-12541: TNS:no listener error

2001-08-23 Thread Joe Casey
om Tsongas wrote: > Joe, > > I built PHP with oracle and oci8 extensions. I built it as a static module for > Apache 1.3.20. > If you are getting errors from running 'configure' (something like it can't > locate the Oracle libraries) its because the Oracl

Re: [PHP-DB] Accessing fields with the same name in MySQL

2001-09-04 Thread Joe Strano
abase. Instead of using ID for your primary key fields, have TABLE_NAME_id instead. That eliminates this type of problem. New here so sorry if this has been answered earlier, and I missed the message. Joe "Rick Emery" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]&q

Re: [PHP-DB] html generated web pages

2001-09-04 Thread Joe Strano
iable league_id. If $league_id was equal to 10, the HTML code you would see when you viewed the source is: HTH Joe "Rick Emery" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I don't understand the phrase "html generate

[PHP-DB] parse/fatal errors

2001-11-14 Thread Joe . Warner
ns. So, if your extensions are .php, you can change them to .html, .php3 or even .phtml When I convert everything to .phtml and point a browser at the BBS directory, it lists the file contents of the directory. Can anybody help? Thanks Joe Joe Warner | Sr. Operations Technical Analyst

RE: [PHP-DB] parse/fatal errors

2001-11-14 Thread Joe . Warner
>Unless you show us the offending source code indicated by the error message, >we can't help OK, what should I post? Do you want me to post the contents of all the files referenced by the error messages? e.g.- config_inc.php3, sql_inc.php3 and index.php ? Thanks Joe Joe

[PHP-DB] Configure with Postgres/MySQL of different machine

2001-11-27 Thread Joe Nelson
w to do it when it's all on one machine. This is what I ran: ./configure \ --enable-track-vars \ --with-gd \ --with-mysql \ --with-pgsql \ --with-apxs=/usr/sbin/apxs --with-config-file-path=/etc Any help or pointers would be appreciated. Thanks. Joe -- PHP Database Mailing List (http://w

[PHP-DB] Strange PgExec() Error

2001-12-14 Thread Joe Koenig
I got a PgExec() error that said: Warning: PostgreSQL query failed: PQexec: you gotta get out of a COPY state yourself. What in the world does that mean? Thanks, Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

[PHP-DB] PostgreSQL and Regular Expressions

2001-12-17 Thread Joe Koenig
I've been digging through the postgres docs and haven't found a way to use reg ex's in a query. Is there a simple way? Something similar to MySQL's RLIKE? I'm trying to select all records that start with a number [0-9]. Thanks, Joe -- PHP Database Mailing List

RE: [PHP-DB] Starting to hate MySql... thinking about using MS Sql Server instead...... :-(((((((((

2003-03-30 Thread Joe Keenan
Hi; You could try mysqlimport with the following syntax: mysqlimport -h localhost -u username -p -L dbname pathtofile where' file' is tab delimited text held on local machine. All the best, Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Function Name available within function?

2003-07-24 Thread Joe Penn
Yes - __FUNCTION__ would hold ( string )[function name] "Peter Beckman" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is there some sort of master variable which will tell you which function > you are currently in? > > Like __FUNCTION__ like there is for __FILE__ and __LINE__... So

[PHP-DB] Re: Session Clean up?

2003-07-25 Thread Joe Penn
directive from 0 - 100. If you set it to 0, the gc will never run and the expired sessions will hange around, if you set it to 100, the gc will run every time the session engine starts up ( every call to session_start() ). ~ Joe Penn "Allens" <[EMAIL PROTECTED]> wrote in mes

RE: [PHP-DB] [SPAM?] [PHP-DB] Re: That movie

2003-08-19 Thread Joe Walker
/html/[EMAIL PROTECTED] html http://securityresponse.symantec.com/avcenter/venc/data/w32.hllw.kickin. [EMAIL PROTECTED] Joe > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 19, 2003 8:23 AM > To: [EMAIL PROTECTED] > Subject: [PHP

[PHP-DB] It\'s wierd when I\'ve used forms...

2003-08-22 Thread Joe Walker
type: What's it's problem? I've got flippin' issues! In the message box, it comes in e-mail as: What\'s it\'s problem? I\'ve got flippin\' issues! Escaping every apostrophe. How do I have this not happen? Thanks in advance. Joe

RE: [PHP-DB] It\'s wierd when I\'ve used forms...

2003-08-23 Thread Joe Walker
Thanks, the stripslashes() function worked perfectly! > -Original Message- > From: Jacob A. van Zanen [mailto:[EMAIL PROTECTED] > Sent: Friday, August 22, 2003 5:48 PM > To: [EMAIL PROTECTED] > Cc: Joe Walker; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] It\'s wier

[PHP-DB] ADO Connection Problems

2003-09-16 Thread Joe Mack
t = $cmd->Execute(); Any assistance anyone can offer would be greatly appreciated. Thank you. Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Cannot open any more tables error

2003-09-17 Thread Joe Mack
I am gettting this error using ADO to work on a MS Access 2000 DB using PHP. My code is attached. The thing that is confusing me --> I am getting the error on the very first recordset I try to open (line 13). Any assistance would be greatly appreciated. Thanks in advance. Joe begin

[PHP-DB] MySQL SQL CACHE

2005-04-13 Thread Joe Harman
Hello, First time on this list, I generally use the general PHP list... but I was curious if alot of people are using SQL CACHE with MySQL and PHP and does it seem to increase the performance... or lighten the load on mysql for you? Thanks Joe

Re: [PHP-DB] full text search

2005-08-11 Thread Joe Harman
"There is more then one record with that name or record > does not exist!"; > } > } > }//end function file_read > }// end of class seek > if ($pattern){ > //print("$pattern "); > $obj1 = new seek(); > $obj1->file_read($pattern); > exit; > } &

[PHP-DB] Re: [PHP] MYSQL_CONNECT vs MYSQL_PCONNECT

2006-06-20 Thread Joe Wollard
If you're not sure you should probably stick with mysql_connect() - otherwise you could end up bogging down mysql with way more connections than you need if you're not careful. On Jun 20, 2006, at 12:34 PM, Juanjo Pascual wrote: How can i know which of both is better to use each time? --

[PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
doing to ensure that the result set from the query persists though the change in pagination from the first page of results to the second page. In both cases the search scripts are includes in other php pages. I think I need to understand how the result set is carried through or reacquired in

Re: [PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
in this context is beyond me. Thanks Joe. On 23 Jan 2010, at 19:46, Bastien Koert wrote: The easiest thing to do is either A) store the author name in a session for the duration of the searches B) add the name to the pagination url so that its passed along withe the page number On 1/23/10, Joe Ke

Re: [PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
. For some reason I do not understand the result set does not carry through to the succeeding links in the pagination sequence. Thanks, Joe On 23 Jan 2010, at 19:16, Edward Brookhouse wrote: Isn't there a matching select later that sets up the number of pages? I start with: $offset = ($pa

Re: [PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
Manual, or any tutorial or anything at all on the web about sustaining a result set through pagination links when the SELECT clause of the query is modified by a WHERE clause containing a variable. As it stands I am unable to construct a search engine query to cover the matter. Thanks J

Re: [PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
ch to everyone who took the trouble to reply to my cry for help. It is all very much appreciated. Joe. On 23 Jan 2010, at 21:32, Phpster wrote: If you change the $_POST to &_REQUEST in this piece of code $author_name = $_POST["author_name"];' To make it $author_name

[PHP-DB] Re: renaming uploaded files

2002-02-02 Thread Joe Van Meer
Hi there, you could grab the whole file name from db, form, etc... strip it down to the '.jpg' , concatenate $IDNUMBER . $NUMBER OF PICTURE , then rename it using the combination of $IDNUMBER . $NUMBER OF PICTURE . Jose Maria Sala <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:

[PHP-DB] Re: Image resize from DB?

2002-02-02 Thread Joe Van Meer
hi there. check out the image functions : 'imagecreatefromjpeg', 'imagecopyresized', 'imagecreatefromgif', and 'imagecreate' in the php manual http://www.php.net hth joe ;0 Chris Payne <[EMAIL PROTECTED]> wrote in message 000c01c1ac43$5ca04

[PHP-DB] Re: Automating Date in mySQL

2002-02-02 Thread Joe Van Meer
hi there. if you are unable to set it on the db end why not insert/update the current date along with your insert and update queries? hth joe :) Todd Williamsen <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I want the date to automaticall

[PHP-DB] Re: MySQL Update help needed

2002-02-02 Thread Joe Van Meer
did test to see if $id was actual the value you were expecting? is $id an auto increment field? Chris Payne <[EMAIL PROTECTED]> wrote in message 000c01c1a23a$ef779900$0200a8c0@chris">news:000c01c1a23a$ef779900$0200a8c0@chris... Hi there, Can anyone see what is wrong with this query? I am trying

[PHP-DB] Re: Sessions

2002-02-05 Thread Joe Van Meer
ion_start(); is at the top of every page with no space before. These should help you out a little. Joe :) Álvaro muñoz sánchez <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, all > > First of all, I apologize if this is a dump quest

[PHP-DB] Re: Session management

2002-02-07 Thread Joe Van Meer
irect them to the appropriate page. If they don't have the cookie, prompt for a login action. Hope this helps, Joe :) Danny Kelly <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > I am trying to set up a session management syst

Re: [PHP-DB] addslashes()

2002-02-07 Thread Joe Van Meer
Hi. addslashes() going in to db, stripslashes() coming out :) HTH Joe :) Todd Williamsen <[EMAIL PROTECTED]> wrote in message 002601c1b033$382a4700$f6b2d83f@goofy1">news:002601c1b033$382a4700$f6b2d83f@goofy1... > Paul, > > It is being inserted into a database &g

[PHP-DB] Re: Resource link errors

2002-02-07 Thread Joe Van Meer
$connectionid); //if the query fails if (!$result) { die("problemo: Your query failed"); } //now loop through the rows :) while ($row = msql_fetch_array($result)) { echo $row["0"]; } Hope this helps you out :) Joe :) Ken Thompson <[EMAIL PROTECTED]> wrote in message

[PHP-DB] Re: duplicate entries in db

2002-02-07 Thread Joe Van Meer
Hi. Post up some code so the ng can help you out. :) Justin Hall <[EMAIL PROTECTED]> wrote in message 01c1b015$54445250$fdd80918@CT41311A">news:01c1b015$54445250$fdd80918@CT41311A... > I have a script that calls a function to perform a query using the > arguments sent to the function vi

Re: [PHP-DB] Need to delete charcters from a string

2002-02-07 Thread Joe Van Meer
Why couldn't you use something like this: $mystr = substr($mystr, -3); Joe Jeroen Timmers <[EMAIL PROTECTED]> wrote in message 003001c1b026$97373cb0$7f6440d4@jeroen">news:003001c1b026$97373cb0$7f6440d4@jeroen... > you can take the function substr from php in combinati

[PHP-DB] Re: File deletion

2002-02-07 Thread Joe Van Meer
Try looking at the unlink() function. It removes files off of the web server. HTH Joe :) Todd Williamsen <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I created a couple of forms where one inserts new contact data with a file, > in th

[PHP-DB] Re: File deletion

2002-02-07 Thread Joe Van Meer
ammendment: use the unlink() function once you have confirmation of a successful update :) HTH Joe :) Todd Williamsen <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I created a couple of forms where one inserts new contact data with a fil

[PHP-DB] Re: Table Relationships

2002-02-08 Thread Joe Van Meer
it as the primary key. Here's a link to the mysql website: http://www.mysql.com/doc/C/R/CREATE_TABLE.html Notice the primary option beside the auto_increment option, you'll no doubt need to use that as well to ensure you create the proper relationships between entities. Hope this helps you o

[PHP-DB] Re: Time Question

2002-02-15 Thread Joe Van Meer
Thx Jakob, appreciate the help Cheers Joe :) Lerp <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a > mssql7.0 backend. The snag is this, I have a 'startti

[PHP-DB] Re: can't insert into MS-access

2002-02-16 Thread Joe Van Meer
Hi there, sounds like you do not have the proper read/write permissions on that file. HTH Joe :) Penockio <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I can't use sql command "insert into " but I can use "select"

Re: [PHP-DB] Re: A good tutorial

2002-02-19 Thread Joe Van Meer
for > online users to view." ; > } > else > { > print " color='#663399'>Error encountered during resume upload process."; > } > > $patharola = "tempimages/". $userfile_name; > > // insert path into database here > # connect to db >

Re: [PHP-DB] Re: A good tutorial

2002-02-19 Thread Joe Van Meer
Hi again JD...I got to thinkin':) Just out of curiosity...how many images were you bringing back from the db when your script timed out? I store the path of my image in the db and echo it out when I need to. Cheers Joe:) Jd Daniels <[EMAIL PROTECTED]> wrote in message [EMAI

  1   2   >