[PHP-DB] Re: UDF's in sqlite via PDO

2007-11-15 Thread Justin Adie
Oops... I was being rather dim. It's all in the manual... Apologies to all. --- On 15/11/2007 10:10, in article [EMAIL PROTECTED], "Justin Adie" <[EMAIL PROTECTED]> wrote: Is there a way to define UDF's for sqlite queries via the PDO interface? E.g. An equivalent

[PHP-DB] UDF's in sqlite via PDO

2007-11-15 Thread Justin Adie
Is there a way to define UDF's for sqlite queries via the PDO interface? E.g. An equivalent to sqlite_create_function()? Thanks Justin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
ou're messing with a production system, you could always just try out simple stuff like this on your own and see what happens. More fun that way anyhow. Rich -Original Message----- From: Justin Turner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 5:04 PM To: Bastien Koert

Re: [PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
How can I do this? Bastien Koert wrote: yes From: Justin Turner <[EMAIL PROTECTED]> To: [email protected] Subject: [PHP-DB] adding to the current value Date: Thu, 29 Sep 2005 16:26:00 -0400 I would like to increment the current value of a field X without having to retrieve f

[PHP-DB] adding to the current value

2005-09-29 Thread Justin Turner
I would like to increment the current value of a field X without having to retrieve field X beforehand. Can I do this? Example: UPDATE my_table set field_1 = (current_field_value -1) WHERE...blah, blah, blah == A. Justin Turner -- PHP

[PHP-DB] Re: DataObject feature request

2005-09-14 Thread Justin Patrin
to the PEAR-general list. I am also not a DB_DataObject developer, although I know a lot about it. -- Justin Patrin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Lock Tables Privileges

2005-08-15 Thread Justin Turner
42000): Access denied for user 'thisUser'@'localhost' to database 'registration' What am I doing wrong? Justin Version: MySQL 4.1 (rpm) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] That crazy IF command!

2005-04-03 Thread Justin Gruenberg
On Apr 2, 2005 3:52 PM, Ron Piggott <[EMAIL PROTECTED]> wrote: > Hey guys ... I am wondering if you have a varable named > > $query_holder="the big fat cow made lots of milk today"; > > are you able to use the if command to see if the words "big fat" are part of > that phrase? > > What would the

RE: [PHP-DB] Zip Code Fields

2004-09-08 Thread Justin Palmer
Are you only accepting US zip codes? Justin -Original Message- From: Aaron Todd [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 8:36 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Zip Code Fields Just curious, but what kind of field is everyone using to store a Zip Code. I

Re: [PHP-DB] Pear DB and DB_DataObject : recommended?

2004-08-31 Thread Justin Patrin
ngertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Array

2004-08-26 Thread Justin Patrin
-|---| > > How do I declare Duch an array like this??, let's call it Parts. > > Miguel Guirao > Servicios Datacard > www.SIASA.com.mx > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub

Re: [PHP-DB] E-mail as HTML

2004-08-25 Thread Justin Patrin
ips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] letting a table name be a constant

2004-08-23 Thread Justin Patrin
('INSERT INTO `'.TABLE.'` (`id`,`name`) VALUES ("","'.$name.'")'); > or >$mysql_query("INSERT INTO 'TABLE' (`id`,`name`) VALUES ('','$name')"); > has no effect. > > I also tried to >define("TABLE", "`mytable`"); > which, too, didn't work. > > Would appreciate any advice, > Ben > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-21 Thread Justin Patrin
l) should be shown in Spreadshee (Calc) of Open Office. > Pls. tell how it can be done. > > balwant > Perhaps try making a CSV and have the user download it. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder pape

Re: [PHP-DB] mysql query

2004-08-13 Thread Justin Patrin
On Fri, 13 Aug 2004 19:39:59 +0200, Torsten Roehr <[EMAIL PROTECTED]> wrote: > "Justin Patrin" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > On Fri, 13 Aug 2004 15:20:36 +0200, Quentin Cotillard > > <[EMAIL PROTECTED]> wrote: &

Re: [PHP-DB] mysql query

2004-08-13 Thread Justin Patrin
gt; > > How could I construct my query to the mysql? > This is an SQL question, not a PHP question. order by rand limit 5 -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Datab

[PHP-DB] Re: [SPAM] [PHP-DB] Deleting older record

2004-08-13 Thread Justin Patrin
es me an error anybody help me out on this? > > MySQL 4.0.16 > You need to give us an error. Perhaps: DELETE * FROM `tblDownloadTrack` WHERE `timestamp` < DATE_SUB(NOW( ), INTERVAL 1 HOUR) -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_D

Re: [PHP-DB] How to do an update with arithmetic from a user input

2004-08-12 Thread Justin Patrin
input To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], PHP DB <[EMAIL PROTECTED]> Justin Patrin <[EMAIL PROTECTED]> wrote on 08/12/2004 01:37:35 PM: > Unless $part_number is a number, you're going to want to put quotes > around it. Well, actually, you want to run mysql_rea

Re: [PHP-DB] How to do an update with arithmetic from a user input

2004-08-12 Thread Justin Patrin
- Original Message - From: Chip Wiegand <[EMAIL PROTECTED]> Date: Thu, 12 Aug 2004 13:24:05 -0700 Subject: Re: [PHP-DB] How to do an update with arithmetic from a user input To: [EMAIL PROTECTED] Cc: PHP DB <[EMAIL PROTECTED]> Justin Patrin <[EMAIL PROTECTED]> wrote on 08/12/2

Re: [PHP-DB] How to do an update with arithmetic from a user input

2004-08-12 Thread Justin Patrin
;#ffcc33'); > $I = 0; > > while ( $row = mysql_fetch_array($result)) > { > printf("%s\n\n", $row["part_number"]); > printf("%s\n\n", $row["description"]); > printf("%s\n\n", $row["qty"]); > printf("%s\n\n",

Re: [PHP-DB] RE: [SPAM] Re: [PHP-DB] Intellectual property rights

2004-08-09 Thread Justin Patrin
They > > > will not install PHP ( too many hacker problems they say). > > > > > > Did I just screw myself? Do I have any protection of my design? Can > I do > > > anything? > > > > > > > > > Thanks, > > > > > > Vinny > > > > > > > > > > > > > > > -- > > Michael Gale > > Network Administrator > > Utilitran Corporation > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > !DSPAM:41180b0a313921571316053! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

2004-08-05 Thread Justin Patrin
ow['total_number_of_beans']) > 100) > print "\n\t {$data} "; > print "\n"; > } > > Thanks ahead of time for your thoughts and recipes :) > Grant > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Justin Patrin
be dropping records on the server side so that it doesn't have to be sent to your PHP app. My $0.02. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Urgent JOIN help needed

2004-07-30 Thread Justin Patrin
; twice, you only need / should have it in the WHERE clause. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php mysql dates

2004-07-28 Thread Justin Patrin
in such a format that I can > > insert the information into a DATE column in a mySQL database. > > > > Dates are a bit of a mystery to me as PHP and MySQL handle them > > differently. Your help is appreciated. > > > > Y-m-d > > -- > DB_DataObject_F

[PHP-DB] Re: Unable to parse message

2004-07-26 Thread Justin Patrin
FROM members LEFT JOIN country ON members.country = country.id >WHERE MATCH(firstname, middlename, familyname, fathername) AGAINST > ('$keywords' IN BOOLEAN MODE) ORDER BY score DESC"; > And do the same kind of thing for region3. -- DB_DataObject_FormBuil

Re: [PHP-DB] Query returns duplicate rows

2004-07-21 Thread Justin Patrin
hen all selected scores, then loop through them individually. Doing a join without an ON clause is IMHO not a good choice. > > -Original Message- > From: Justin Patrin > To: Brock Jimmy D Contr 74 MDSS/SGSI > Cc: [EMAIL PROTECTED] > Sent: 7/21/2004 5:02 PM > Subject: Re: [PH

Re: [PHP-DB] Query returns duplicate rows

2004-07-21 Thread Justin Patrin
join on. Also, doing a distinct on that many fields at once could be very expensive. Better tp refine your query or data model. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Fwd: IMPORTANT: Please Verify Your Message

2004-07-19 Thread Justin Patrin
-- > Marcjon > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > !DSPAM:40fc0683162762080714991! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_Dat

Re: [PHP-DB] Begining PHP...Have Questions

2004-07-19 Thread Justin Patrin
; //USERNAME/EMAIL ADDRESS IN DATABASE > > > if (!$num_rows){ > > >$error = "Username was not found. Please Register."; > > >echo "$error"; > > >die(mysql_error()); > > > } else { > > >//ENTERED PASSWORD IN DATABASE > > >if (!$passw = mysql_result($result,0,"pass")){ > > > $error = "Invalid Password."; > > > echo "$error"; > > >} else { > > > printf("Password is %s\n", mysql_result($result,0,"pass")); > > >} > > > } > > >} > > > } > > >} else { > > > > > > ?> > > > > > > > > > > > > User Name: > > > > > > Password: > > > > > > > > > > > > > > > > > > > > > > >} // end if > > > > > > > > >?> > > > > > > > > > > > > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > !DSPAM:40fc074a164631045595694! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: REG_BADRPT error

2004-07-19 Thread Justin Patrin
know why I > > might be getting this? > > > > Thanks, > > > > Aaron > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > !DSPAM:40fbe26957361384218867! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Bogus List Messages

2004-07-19 Thread Justin Patrin
e database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php, javascript and db - your help is needed

2004-07-18 Thread Justin Patrin
y be done when the browser sends a new request. You have to refresh *some* page to get new data. It is possible to use a hidden iframe to send a request, then parse it with JS and display it in the main page, but this isn't trivial. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Rewrite value from form data

2004-07-17 Thread Justin Patrin
string to use for this > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > !DSPAM:40f9556c159931176717192! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Easy reg expression problem

2004-07-15 Thread Justin Patrin
oing/need to do? > > If you're simply trying to get '@email.com' then use strstr(). > Of courseI'm just so used to pregs... -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Easy reg expression problem

2004-07-15 Thread Justin Patrin
DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LAST_INSERT_ID?????

2004-07-15 Thread Justin Patrin
window. > > Please help!!! I would attach code to this, but I am not sure what to > > attach. > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LAST_INSERT_ID?????

2004-07-15 Thread Justin Patrin
ndow. > Please help!!! I would attach code to this, but I am not sure what to > attach. > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: Hold System

2004-07-15 Thread Justin Palmer
Hi, Thank you, Peter and all. This has been of great help. Regards, Justin Palmer -Original Message- From: Peter Westergaard [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 6:48 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Hold System > In the example of Bob, M

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Justin Palmer
h the others holding the student(Mary and Barbara), and set Mary's date_held to now, and Barabara's date_held to a minute after (a time which has most likely has not occurred yet) Mary's. Hope this makes sense. Kind regards, Justin Palmer -Original Message- From: Peter

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Justin Palmer
1 position and can place the student. If Bob places the student then Mary and Barbara's holds are not valid any longer. I think that this is a good example. If you have any further questions please ask. Thanks again for your attention and help. Regards, Justin Palmer -Original Me

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Justin Palmer
esents the Coordinator. The STUDENT_ID represents the Student. There is no need to worry about Host Families at all. I hope this helps. Let me know if it makes more sense. Justin Palmer -Original Message- From: Peter Westergaard [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 1

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Justin Palmer
the rest worked out. I just don't feel right about this hold table. Justin Palmer -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 12:42 PM To: 'Peter Westergaard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: Hold System Hol

[PHP-DB] Hold System

2004-07-14 Thread Justin Palmer
else built a hold system before that might be able to help me out with some pointers? I hope this makes sense. If not please ask for clarification. As always I appreciate any assistance. Thank you, Justin Palmer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Conditional explode?

2004-07-01 Thread Justin Patrin
{ $fields[$l] = $strictFields[$sl]; $numQuotes = 0; while(fmod($numQuotes += substr_count($strictFields[$sl], $quote), 2) == 1) { ++$sl; $fields[$l] .= $delim.$strictFields[$sl]; } ++$l; } return $fields; } -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] More problems with searching

2004-07-01 Thread Justin Patrin
0b265025655517531! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] [slightly OT] OOP syntax

2004-06-30 Thread Justin Patrin
s looks like DB abstraction data. Have you looked into PEAR DB, MDB, DB_DataObject, etc? > How would this need to be defined at the top of a class to taken on as a > class variable/array. Am i thinking of this wrong? > > I can add them all as scalar variables, but i'd rather work

Re: [PHP-DB] How to define array variable while accessing it ???

2004-06-29 Thread Justin Patrin
gt; > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > __ > Do you Yahoo!? > Yahoo! Mail is new and improved - Check it out! > http://promotions.yahoo.com/new_mail > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > !DSPAM:40e112fd156793833020386! > > -- paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Date help needed

2004-06-24 Thread Justin Patrin
is? I would really appreciate any > help, I'd send my sample code only I'm not at my home/work computer ATM. > > Chris > > !DSPAM:40db40cb34094233914063! > -- paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: content managment systems

2004-06-16 Thread Justin Patrin
Pete M wrote: I use www.tikiwiki.org love it I just started using it and it's very nice. Here's a quick hint to those who are new, though. You can click the :: to expand the menu. If I'd only known this when I started pete Lisi wrote: I am looking for open source CMSs that: 1) use PHP/Mysql

[PHP-DB] delete a record not working

2004-06-15 Thread Justin
Hello, I have a simple script to retrieve and then delete a selected script, but it does not work. When I hit the button I get: 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 'id' at line 11064" Any help woul

[PHP-DB] Re: MySQL executes several times the same request

2004-06-14 Thread Justin Patrin
Loïc moisy wrote: Hi Everyone ! I've coded a php site for a musical store. At the end of every page, before closing the connection, I send an UPDATE request to increment a statistical tool. Recently I saw weird results, so I tried to understand. Looking in my logs, I saw that this request could be

[PHP-DB] Re: PHP/MySQL learning project

2004-06-11 Thread Justin Patrin
Alexey Kupershtokh wrote: Hi. In trying to learn PHP and MySQL, I'm trying to create a web-based database application that will keep track of my movies. I have five tables (shown in the graphic). I'm trying to be able to display the results of the tables with one movie title, all of the actors a

[PHP-DB] Retrieve data from a table, edit/add it and enter it in a new table

2004-06-10 Thread Justin
Hi, I am trying to do the following: Retrieve some information from a table, edit it by appending some further information to it (a few more fields) and then enter the new data record into a new table, and delete the old data in the original table. Sounds confusing I know. The code is below (I

[PHP-DB] Re: Anyone using MSQL Server with PHP?

2004-06-10 Thread Justin Patrin
Miguel Guirao wrote: Hi!! Anybody here using PHP with SQL Server? I would like to use a similar function to password () from MySQL under SQL Server. Anybody knows of a similar function under SQL Server? Kind Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx If it's for your app

[PHP-DB] Re: PHP/MySQL learning project

2004-06-10 Thread Justin Patrin
News.Php.Net wrote: Hi everyone! In trying to learn PHP and MySQL, I'm trying to create a web-based database application that will keep track of my movies. I have five tables (shown in the graphic). I'm trying to be able to display the results of the tables with one movie title, all of the actors

[PHP-DB] Re: HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread Justin Patrin
Leo G. Divinagracia III wrote: project i'm working with, his host died or something. but, the phpMyadmin (on that host) can NOT do a backup of 200mb table without running out of memory or something weird. so what is the best way to text dump the table? i thought i would (pseudo-code): open DB do

[PHP-DB] Re: automatic call reference creation

2004-06-10 Thread Justin Patrin
Gawie Marais wrote: thanx for the replys guys... basically i need a PHP formula to generate a 'call refenrence code' that is unique to give out to clients whenever they log a call. this unique 'call reference code should be inserted into a mysql field within a table. all i need is a formula to get

[PHP-DB] Re: Extremely Urgent: Problem with PHP and Oracle

2004-06-09 Thread Justin Patrin
Charles Morris wrote: Hello all, I have recently been working with OCI and when I use OCILogon [wethere with example scripts or my own code] I get a "PAge cannot be displayed" (like DNS error) when I naviagte to the page. When I comment out the OCILogon part it works great exept for the oracle part

[PHP-DB] Re: About retrieving auto increment value

2004-06-07 Thread Justin Patrin
Marc Soler wrote: Hi I have the typical problem with retrieving auto increment value in php-mysql environment. I have search info in mysql page and I have found LAST_INSERT_ID() funtion but I don't know how to use correctly. I have one script that insert a row. And another script that must retrieve

[PHP-DB] Re: Dynamic Data

2004-06-07 Thread Justin Patrin
Christopher J. Crane wrote: What is the best way to produce a report listing the fieldname and then the data in that field. It is a report containing only one row from a table, but I don't want to hard code the fields since they change often. I can get the field names dynamically like this: $fields

[PHP-DB] Re: $_Session vs $_Cookie

2004-06-01 Thread Justin Patrin
Ng Hwee Hwee wrote: Hi all, I have a problem: my $_SESSION variables and $_COOKIE variables get destroyed very often, even though my clients are actively browsing the site (that means, the variables should not be garbage collected). Our guess is that the network connections are weak. My server is

[PHP-DB] Re: How to select records if any of it's fields match the requirement?

2004-05-21 Thread Justin Patrin
Amanda wrote: I would like to select the records where any of the fields LIKE '%abc%' Can I do that without knowing the table's column names? If table column names are required, how can I retrieve the column names from the table? Regards Amanda Many database engines will give them to you i

[PHP-DB] Re: Forum Software

2004-05-20 Thread Justin Patrin
Room 11 Designs wrote: Hi there everyone, I was wondering how hard it is to write your own forum, maybe even as complicated as PhpBB... Any help out there? To completely write something that complicated and featureful takes a long time. Why not just use PHPBB? -- paperCrane -- PHP Database Mail

[PHP-DB] Re: Am I missing something? Why doesn't php have a 'date' variable

2004-05-20 Thread Justin Patrin
Ross Honniball wrote: Hello. I've been using php for about 5 months now. One of the first things I noticed it was missing was a standard in-built manner of handling dates. I assumed that, being inexperienced, I was probably missing something and in time all would become clear. It's a while late

[PHP-DB] Re: mail() function and AOL users

2004-05-19 Thread Justin Patrin
Matt Perry wrote: I use the following php mail function in an online applicaiton program: mail($email, "application submitted", $message, "From: [EMAIL PROTECTED]"); This function does not always work when I modify $message. I have checked for null values for $message already but this does not

[PHP-DB] Re: Load balancing and SQLite

2004-05-15 Thread Justin Patrin
Andy Ladouceur wrote: Hey everyone, Currently planning out the databases for a large project, and have decided to use separate SQLite database files for each users hit statistics. The problem is, there are two webservers, with a load balancer. I'm wondering what suggestions people might have on

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-12 Thread Justin Patrin
rself. paperCrane David T-G wrote: Justin, et al -- ...and then Justin Patrin said... % % David T-G wrote: % % >...and then Justin Patrin said... % >% ... % >% Of course, this leaves the result handle open. It's best to store the % >% result handle and free it with mysql_free_r

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread Justin Patrin
David T-G wrote: Justin, et al -- ...and then Justin Patrin said... % % David T-G wrote: % % >...and then [EMAIL PROTECTED] said... % >% ... % >% How about: % >% $i = mysql_result(mysql_query($q,$dbro),0); % > % >Oooh! Cool! Just right. ... % % Of course, this

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread Justin Patrin
David T-G wrote: Jeff (and John) -- ...and then [EMAIL PROTECTED] said... % ... % > $r = mysql_query($q,$dbro) ; % > $row = mysql_fetch_array($r) ; % > $i = $row[0] ; ... % >this one row (not looping), could I just % > % > $i = mysql_fetch_array($r)[0] ; % % Hi David Hi! %

Re: [PHP-DB] supernoob strikes again

2004-05-08 Thread Justin Gruenberg
Dan Bowkley wrote: Yeah, I'm back... I'm revamping my own site, finally...going for the same sort of dynamic system I was using for my last creation. Currently, I have index.php returning lots of different pages from a mysql database; what I'd like to do is have a somewhat more elegant solution

[PHP-DB] Re: Procedure for submitting an order via email

2004-05-01 Thread Justin Patrin
Ruprecht Helms wrote: Hi, I'm looking for an simple example how to send an order (content of the basket) via email. Does someone have such a good ans simple example. Regards, Ruprecht You're not giving nearly enough information. If you want to send an e-mail you can use the mail() function or us

Re: [PHP-DB] Scrolling drop down menu

2004-04-27 Thread Justin Patrin
John W. Holmes wrote: matthew perry wrote: When my users choose an option in the drop down menu, they sometimes accidentally change what they have chosen when the move the center scrolling button of their mouse. I was giving a presentation in front of my company's owner and did this myself. 5

Re: [PHP-DB] Cursor in text box.

2004-04-27 Thread Justin Patrin
John W. Holmes wrote: matthew perry wrote: My users complain about everything. The most common is "Why do I have to move the mouse over to this box every time? Wh!" How do I get the cursor to que into the first input area of my form? JavaScript, not PHP. document.yourform.yourtextbox.foc

[PHP-DB] Re: URL Problem

2004-04-21 Thread Justin Patrin
Chris Payne wrote: Hi there everyone, I have a problem. Basically this is what I need to do: Request behind the scenes (PHP) an ASP Url on a different website with the value pid=1 (Where 1 is an identifying number). Then I need PHP to listen to the response from that request as A

[PHP-DB] Displaying Date from Value in MySQL DB

2004-04-20 Thread Justin @ Dreaming in TO
is being displayed as 2004-05-12. I would like the date to be displayed as, Wednesday, May 12th, 2004. How do I do this with PHP. I looked at some of the date functions, and I'm a bit confused. Thanks, Justin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: lamer noob question

2004-04-15 Thread Justin Patrin
Dan Bowkley wrote: So I'm building this website; the first I've tried to build using a mostly dynamic structure. What I've done is create a mysql table, with two fields: id and page_val. The idea is you call the page like http://www.someplace.com/page.php?id=404 and it'll spit back (in this case

[PHP-DB] Re: PHP OO Problem

2004-04-14 Thread Justin Patrin
Andre Matos wrote: Hi List, Two months ago I developed a project using PHP and MySQL without problem. Now, I am developing using PHP and MySQL, but using PHP Object Oriented. My problem is that the access is become slowly after few accesses or if I perform a reload some times. The unique way t

[PHP-DB] Re: Dynamic Form?

2004-04-13 Thread Justin Patrin
Aaron Wolski wrote: Hi All, I've been given the task of developing a dynamic form for a client. When I say dynamic, I mean dynamic in that the client can use an administrative interface (back-end) to create the various form fields (and types) that get displayed on the front-end. Before I start b

Re: [PHP-DB] Mail() - Preposterous Accusation

2004-04-09 Thread Justin Patrin
Jochem Maas wrote: Justin Patrin wrote: accurate. If it is, why hasn't the mail function been modified in the more recent builds? I've been using PHP since it was invented & never had a problem with mail. "Also note that your form page is currently using the PHP mail

Re: [PHP-DB] Mail() - Preposterous Accusation

2004-04-08 Thread Justin Patrin
Ryan Jameson wrote: He says later in his email that: "The reason I mention this is because any email delivery failures will not be sent back to you, but to our servers (due to the way that PHP writes the email headers when using the mail() command)." ... Is there a way to get the bounces to go to

[PHP-DB] Re: Mail() - Preposterous Accusation

2004-04-07 Thread Justin Patrin
Ryan Jameson wrote: I know this isn't technically DB related but this is the list that I use. I'd just like to know if anyone else thinks the below statement is accurate. If it is, why hasn't the mail function been modified in the more recent builds? I've been using PHP since it was invented & nev

[PHP-DB] Re: ocilogon error

2004-03-31 Thread Justin Patrin
Adam Williams wrote: Hi, I have oracle and PHP working together on a remote server called zed that runs redhat linux. I have another computer called accessserver that runs win2k pro with PHP that I am trying to connect to oracle on zed. Both computers have the oracle client libraries installed.

[PHP-DB] Re: how to work with www.ups.com.mx???

2004-03-22 Thread Justin Patrin
Desi wrote: I need a module in PHP to get the rates from this service, the tools are in XML but I need the module in PHP, to give the size and the weight and get the rate from this module. If you have work with this, please help me, or tell me if you can made it, how much will cost, and the time y

[PHP-DB] Re: Looking for simpler way to do this...

2004-03-22 Thread Justin Patrin
-{ Rene Brehmer }- wrote: I'm working with PHP 4.3.0 w. MySQL 4.0.14b on Windows XP I've written my own (pretty advanced actually - or it will be once I get the code completed) forum system (why? because I wanted to learn how to handle relational databases with PHP/MySQL, and then I just decided

[PHP-DB] Re: ?DHTML Layers with PHP?

2004-03-19 Thread Justin Patrin
Mark A Galbreath wrote: I've been sitting here all morning wracking my brains for a way to code a hierarchical menu tree with JavaScript from database data retrieved by PHP, so that the child menus appear on a mouse click. Can PHP do this without JS? The only JS examples I can find use static me

[PHP-DB] Re: How to simplify DB creation?

2004-03-19 Thread Justin Patrin
Michal Masa wrote: Hi, We plan to write a simple DB with app. 10 tables. Are there any tools that simplify and automatize the creation of PHP scripts for the database? Like automatic generation of PHP scripts that produce HTML input forms, generation of value lists, validation, sorting and searchi

[PHP-DB] Re: cant insert into specific column in specific row...help?

2004-03-19 Thread Justin Patrin
Aj Seelund wrote: im trying to insert, or more or less, add to the number in a column called (comNum) in one a specific row in one table(dm_blog), and add other values to another table(comments). i have the comments table working fine, everything insert correctly, but im trying to add to the c

Re: [PHP-DB] Processing a fetched external page

2004-03-18 Thread Justin Patrin
Donovan Hutchinson wrote: Thanks for the fast replies. I understand about stripping tags and identifying areas using regular expressions, however my intention is to display the page intact, with only the content changed. An example being http://www.pootpoot.com/poot/pootify/ Thanks, Don If you'r

[PHP-DB] Re: Processing a fetched external page

2004-03-18 Thread Justin Patrin
Donovan Hutchinson wrote: Hi, I'm working on a project that takes the content of a URL and does stuff with the content. I've managed to extract the target url's html, and am using str_replace to fix links, stylesheets etc. However, i'm stumped when it comes to processing the text content. Would

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Justin Patrin
Operator wrote: On 18 Mar 2004 at 14:24, Ricardo Lopes wrote: in your php.ini you have mysql.default_host, mysql.default_user and mysql.default_password which are used if: a) you are not in safe mode b) you supply no string for those parameters. But i guess this is not your case, i think this do

[PHP-DB] Re: An old dog, with a new trick..

2004-03-18 Thread Justin Patrin
If you're just starting out, this is a great time to learn PEAR DB as it can help you a lot in the future. In fact, PEAR is a great place to look for lots of code to do all sorts of things. http://pear.php.net http://pear.php.net/package/DB Felipe eduardo ortiz lópez wrote: Bueno, héme aquí, un

[PHP-DB] Re: need to select one cell from one row in one table...?

2004-03-16 Thread Justin Patrin
Aj Seelund wrote: ok, this might be difficult to explain, but this is what im trying to do... i have a table in my db call db_blog. in it i have an auto_increment column called entryNum. i use that strictly for order when i view the blog. i also have a column called comNum. each row in the t

[PHP-DB] Re: Inserting Data in Multiple Tables.. again

2004-03-16 Thread Justin Patrin
Craig Hoffman wrote: Here is the problem I am experiencing: I have a form that collects data and I would like it to send it to three tables in a MySQL DB. One table is called TRAININGLOG , other is called CORE and the third is USERS. The USER table is the main table that contains the prima

[PHP-DB] Re: Inserting Data in Multiple Tables - MySQL

2004-03-16 Thread Justin Patrin
Craig Hoffman wrote: Is it possible to write one INSERT statement to populate multiple tables? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ Nope. One record, one inse

[PHP-DB] Re: MySQL Backups

2004-03-11 Thread Justin Patrin
Jai Jones wrote: Hi Everyone. I have MySQL databases on various servers, I'd like to know how people automate backups. I imagine there would be lots of scripts and products that do this, I've tried a few, but I guess I'll have to write something myself to do it. I'd be very interested in learn

[PHP-DB] Re: Creating query with multi-dimensional array

2004-02-26 Thread Justin Patrin
Lisi wrote: I have a form that allows users to edit an entry in a database. It displays the current values in a textbox/select box/textarea depending on the type of data (text, enum, etc). The same form is used for different tables, so no values are hard coded. Field names are retrieved with a

Re: Fw: [PHP-DB] Re: help w/ multidementional array in mysql

2004-02-25 Thread Justin Patrin
;-) foreach ($returned_rows as $key => $value) { echo "". $value['lastname'].", ".$value[firstname].""; } ?> -- paperCrane -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.n

[PHP-DB] Re: Storing a php variable in MySQL

2004-02-25 Thread Justin Patrin
Daniel Crespo wrote: Hi there. I want to save a variable (its structure and data) in MySQL. I know the function "serialize(mixed value)", wich generates a storable representation of a value. This storable representation has characters like "{" and ":" (when talking about arrays). So, how can I st

[PHP-DB] Re: help w/ multidementional array in mysql

2004-02-25 Thread Justin Patrin
Scott Phelps wrote: Thanks in advance for reading this: I am trying to take a query based on user input and selectively output fields to a table. Heres the query code: <<< snip - snip>>> $query_result = mysql_query($query); while ($field = mysql_fetch_array($query_result)) { $retur

  1   2   >