[PHP-DB] retrieving all information from a single table

2002-06-21 Thread Jonathan
table has 4 fields, the primary key, "location," "organization," and "charge." Any suggestions? A million thanks. Here is the code: "; echo $row[i["location"].""; echo $row[i]["charge"]; } } ?> -

[PHP-DB] A challenge

2002-07-03 Thread jonathan
an html form. Any suggestions?? Deeply appreciated. Thanks. [EMAIL PROTECTED] -- Jonathan

[PHP-DB] "resource ID #3"

2002-07-11 Thread Jonathan
7; command to the mysql que. Then, I have a second database which matches each abbreviation with the proper name. When I try to run any query on the second database, the only output I recieve is "resource id #3" Any suggestions? Jonathan -- PHP Database Mailing List (htt

[PHP-DB] CREATE TABLE QUERY PHP/MySQL

2002-12-06 Thread Jonathan
t whether the table has been created or not. I know I could probably do some sort of mysql_list_tables and look for it or whatever but I was looking for something similar to If (mysql_affected_rows() == -1) Because that is very easy. And ideas as to why the table is not being created. ==

RE: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

2002-12-06 Thread Jonathan
onvenient. Ignatius - Original Message - From: "Jonathan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 10:00 PM Subject: [PHP-DB] CREATE TABLE QUERY PHP/MySQL > This is the first time I am trying to create a tabl

RE: [PHP-DB] passing variables

2002-12-09 Thread Jonathan
One of many possible things. Dependent on the version of PHP you are using, you might have register_globals set to off in your php.ini file, which is preferable. In which case you'll have to use If($_REQUEST['variable']) Or If(isset($_REQUEST['variable'])) Second possible is: I've never reall

[PHP-DB] what is the value of session_register

2005-09-22 Thread jonathan
Is there any values to this function? I'm looking over some code where this is a done a bunch of time and I don't see any value to it. Maybe I'm naive about the internals but... -jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] format of mysqli returned array

2005-09-23 Thread jonathan
Is there any documentation about how mysqli returns a result set? i use fetch_assoc on it and would like to write a result to a text file in the same format so that it could be opened at a later point and run through a while phrase. thanks, jonathan -- PHP Database Mailing List (http

[PHP-DB] passing DOMDocument Object to another function

2005-09-28 Thread jonathan
I am accessing information in my database. If the format is set to be html, I echo out the variables just fine. If the format is set to be xml, I create a DOMDocument. The problem is that in processing the result set, it calls several other functions. How do I pass the DOMDocument Object to t

[PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7)

2001-01-12 Thread Jonathan Kazmierczak
Hi! I've problem with print long texts. I have DB on MS SQL 7 and I use ODBC to connect with DB. I have one row, in which long text field takes about 5100 bytes. PHP can't print page with this text, but don't give me any error messages (other texts, < 4096, are printed correctly). Printing this ro

Re: [PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7)

2001-01-12 Thread Jonathan Kazmierczak
Andreas Karajannis wrote: > > I change config value uodbc.defaultrl from 4096 to 8192, but it don't > > give any effect. > > Please make shure that PHP really "sees" your change. > You can verify the value that PHP uses by writing a file with just a call to > phpinfo(), this prints out a page w

Re: [PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7)

2001-01-12 Thread Jonathan Kazmierczak
"Sanders, Nicholas" wrote: > php.ini needs to be in c:\winnt > it is there. Johny. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] RE: [PHP] connection id

2001-03-24 Thread Jonathan Sharp
drop the connection when the script ends. Cheers, -Jonathan Sharp js_AT_imprev.com > -Original Message- > From: andrie [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 23, 2001 3:38 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [PHP] connection id > >

Re: [PHP-DB] Combining 2 queries into 1?

2004-05-30 Thread Jonathan Hadddad
How about select count(*) from online Jon On May 30, 2004, at 1:23 PM, Kim Steinhaug wrote: I have theese two queries : select count(*) as online from online where uid=''; select count(*) as online from online where uid!=''; Each online user has a uid (UserID), so if their logged inn this field wil

Re: [PHP-DB] Re: datetime update

2004-06-10 Thread Jonathan Haddad
[EMAIL PROTECTED] wrote: Hi all, i have a datetime field in a mysql database and it's defined with a default of '-00-00 00:00:00:' now, when i add a record to the database, i want to fill that field with >the date and current time. can anyone point me ? Via PHP: $dateTime = date('Y-m-d H:

Re: [PHP-DB] problem....

2004-06-23 Thread Jonathan Haddad
Please post the table definition to the mailing list so we can help you more quickly. Also, is there a table called RuneRunner_1 or are you meaning to use RuneRunner_1 as an alias? Odds are, your problem is not PHP related, it's an error in your SQL syntax. Jon water_foul wrote: i fixed those t

Re: [PHP-DB] mysql auto increment

2004-07-13 Thread Jonathan Haddad
There might be some system that requires a 4 digit number and the PK is being used directly. Also, this same system might need to be exported to Excel, which trims leading zeros and is generally a pain in the ass. Peter Westergaard wrote: I've done exactly this for a really cheap-and-dirty ins

[PHP-DB] Security Issues

2004-07-13 Thread Jonathan Haddad
meone from writing to that folder? Jonathan Haddad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Reducing Strings to a certain length

2004-07-18 Thread Jonathan Hadddad
substr On Jul 18, 2004, at 9:48 PM, Cole Ashcraft wrote: How would you reduce a string to a specified length? Say reduce 600 to 60 or abc to ab? Is there a PHP function for this? Will I have to write my own code? Cole -- This message has been scanned for viruses and dangerous content by MailScanner

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

2004-07-19 Thread Jonathan Haddad
if you have shell access, please do the following describe users; select * from users; also, why are you using LIKE instead of =? use this instead: $query = "SELECT * FROM users WHERE email = '".$username."'"; i would also suggest turning off register globals and using $_POST['username'] and not $

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

2004-07-19 Thread Jonathan Haddad
ugging. I do have it set to = on a normal basis. I am a little unsure what you mean at the end of your reply about register globals. Are you saying that everywhere I use $username to refer to the users inputed username I should use $_POST['username'] instead? Or are you suggesting

Re: [PHP-DB] Timeout problem

2004-08-06 Thread Jonathan Haddad
can you just use a cron job and mysqlbackup instead? it does what you want and is already written. Jon Mauro Chojrin wrote: Hi: I'm developing a db application with php and I have this problem: I have a script for backup making which is very simple, it just goes through the entire database cre

Re: [PHP-DB] Inserting a ' into mySQL

2004-08-23 Thread Jonathan Haddad
use mysql_escape_string. http://us3.php.net/manual/en/function.mysql-escape-string.php Jon Ron Piggott wrote: I have begun to create a Christian Ministry Directory. It is on the ministry web site I am building at http://www.actsministries.org/ministrydirectory/ . One of the problems I am now havin

Re: [PHP-DB] Space requirements (with respect to foriegn languages)

2004-08-26 Thread Jonathan Haddad
On Aug 26, 2004, at 12:27 PM, Gerard Samuel wrote: > My site/code/database is developed primarily for the english language. > I've had people from "The Far East" add content to my site using their > native language, and it is displaying properly in the site. > But Im a bit concer

Re: [PHP-DB] HTML stored in a text field

2004-10-06 Thread Jonathan Haddad
Gabe Covert wrote: I have a database which has a BLOB field storing text... It should probably be in a text field, but I don't think that's the problem... The field has HTML control codes, such as , , and . When I echo them from the database, a la: echo "" . $row['textfield'] . "" I get the conte

[PHP-DB] super define...

2004-11-01 Thread Jonathan Haddad
Is there a way to use define so it replaces the constant even if it's inside quotes? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Cannot load module php_mysql.dl!!

2004-11-11 Thread Jonathan Charette
I've got php5, apache2 and mysql4 installed. I've got some stardocks products installed and some registry tweaks too. My php.ini in C:\windows\ is I think correctly configured and I removed the ; before the mysql extension. I configured Apache2 httpd.conf for php5, from some forum on the net. It

[PHP-DB] Cannot load module php_mysql.dll!!

2004-11-11 Thread Jonathan Charette
I've got php5, apache2 and mysql4 installed. I've got some stardocks products installed and some registry tweaks too. My php.ini in C:\windows\ is I think correctly configured and I removed the ; before the mysql extension. I configured Apache2 httpd.conf for php5, from some forum on the net. It w

[PHP-DB] NLP to SQL queries

2005-02-07 Thread Jonathan Trepczyk
hiya guys, just trying to find the best way of translating natural language queries to sql queries to put in a website, i will be glad if you can help or point me towards the right direction Thanks for your help Jonathan -- Jonathan Trepczyk -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] Query with numbers like 1, 3, 5..........

2002-02-07 Thread Jonathan Hilgeman
Yes, Even Numbers: SELECT * FROM table WHERE MOD(id,2) = 0; Odd Numbers: SELECT * FROM table WHERE MOD(id,2) != 0; - Jonathan -Original Message- From: Jeremy Peterson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:59 AM To: Raymond Lilleodegard; [EMAIL PROTECTED

[PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jonathan Underfoot
ult resource in /home/ufr2/underfoot-www/admin/dupeshows.html on line 51 Can you not reselect in another while while selecting? Does that make any sense to anyone but me? I shouldent have to open another DB connection? Anyhow... your I would appreciate any help. -Jonathan

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jonathan Underfoot
What does bool(false) mean? Thats off the vardump -J - Original Message - From: "Jeroen Timmers" <[EMAIL PROTECTED]> To: "Jonathan Underfoot" <[EMAIL PROTECTED]> Cc: "[PHP-DB]" <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 8:

[PHP-DB] Re: How To Upload

2002-02-08 Thread Jonathan Underfoot
Heres a form and the PHP behind it I use: <---FORM---> Add Pic Pic to Upload(Only .jpg and .gif files) <---PHP FILE---> http://www.underfoot.cc/";); ?> I do much more with it (resize and edit images etc etc) but thats the basic layout... -Jonathan

Re: [PHP-DB] Re: [PHP] help - to get client IP

2002-02-11 Thread Jonathan Underfoot
MOTE_ADDR"]; $host = @gethostbyaddr($HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"]);} else {$IP = $HTTP_SERVER_VARS["REMOTE_ADDR"]; $host = @gethostbyaddr($HTTP_SERVER_VARS["REMOTE_ADDR"]);} -Jonathan - Original Message - From: "Jeroen Timmers" <[EMAIL

Re: [PHP-DB] mySQL dB copy

2002-02-11 Thread Jonathan Underfoot
with this. -Jonathan PS: I use this utility to run daily backups. - Original Message - From: "mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 11, 2002 7:50 PM Subject: [PHP-DB] mySQL dB copy > Hello all, > > I am a relatively new php

Re: [PHP-DB] Re: multiple forms, one submit button

2002-02-12 Thread Jonathan Underfoot
that made sense and worked out for you. This is simmilar to somethign I do where when someone submits a date and activity it is automatically checked for duplicity and accuracy before posting to the database (3 scripts.) -Jonathan - Original Message - From: "Alecs" <[EM

Re: [PHP-DB] Required pages...

2002-02-12 Thread Jonathan Underfoot
ted.) You'd have to track down the javascript commands on the netscape site, I don't know them offhand. If theres a PHP way to do it, I'm unsure of it. Regards, -Jonathan - Original Message - From: "jas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> S

[PHP-DB] Re: How To Upload

2002-02-14 Thread Jonathan Underfoot
s one) Perhaps the forum has another idea? (Returned copy.) -Jonathan - Original Message - From: "Luke Thomas" <[EMAIL PROTECTED]> To: "Jonathan Underfoot" <[EMAIL PROTECTED]> Sent: Sunday, October 14, 2001 5:10 AM Subject: Re: How To Upload > Hi

[PHP-DB] SQL

2002-02-19 Thread Jonathan Underfoot
the where clause? Thanx -Jonathan

Re: [PHP-DB] SQL

2002-02-19 Thread Jonathan Underfoot
up... (I might be completely off base here..) Thanx, -Jonathan - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Jonathan Underfoot'" <[EMAIL PROTECTED]>; "[PHP-DB]" <[EMAIL PROTECTED]> Sent: Tuesday, Febru

Re: [PHP-DB] SQL

2002-02-20 Thread Jonathan Underfoot
Actually, I'm running MS SQL which should allow me to sub-select Usually I work in MySQL -J - Original Message - From: "Frank Flynn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 19, 2002 11:59 PM Subje

[PHP-DB] Secure Encrypt/Decrypt Functions

2002-02-21 Thread Jonathan Hilgeman
Does anyone know of a fairly simple, but secure technique for encrypting and decrypting text? - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] "The" Debacle

2002-02-24 Thread Jonathan Underfoot
n 2 - "Distillers, The" Or a bit of PHP programming every time I list them (seems more difficult.) Either way, does anyone have the propper PHP function I should use? Thanks much... -Jonathan

php-db@lists.php.net

2002-02-25 Thread Jonathan Underfoot
In my experience PHPMyAdmin DOES NOT change anything. It never changes & for me, and it dosen't addslashes(), which makes it a complete pain in the ass to use, but better than changing things without your knowledge I suppose. Maybe I'm using an old version? -Jonathan - Or

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Jonathan Hilgeman
t to click only once and to be patient, and if something goes wrong, here's how to contact us. - Jonathan -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 10:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Tutorial? Hi all, Can anyone

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Jonathan Hilgeman
il in another browser, which is why I suggested my PHP, server-side method, which cannot be turned off based on a client's browser. - Jonathan -Original Message- From: Richard Black [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 8:47 AM To: Jonathan Hilgeman; 'Jennifer

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Jonathan Hilgeman
order is processed. On subsequent clicks, the unique ID would not be found in that database table so the query would fail with a message ("You have clicked more than once") or something like that, and the person could check the status of an order identified by that unique ID.

[PHP-DB] Soft-Linking and includes

2002-03-07 Thread Jonathan Hilgeman
have messed it up, and instead of running dir2's info.php, it seems to think it is in dir1, and instead includes dir1's info.php file. Has anyone run into this and/or know a fix for it? Thanks! - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Soft-Linking and includes

2002-03-08 Thread Jonathan Hilgeman
However, on a different, FreeBSD platform, this is not the case. A linked file can call an include and have the desired file be called instead of the source one. That's where I'm getting confused. - Jonathan -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: Fri

RE: [PHP-DB] RE: [PHP-WIN] Stange 'page-loading' effect

2002-03-18 Thread Jonathan Hilgeman
temporary debugging file (whatever you want to call it), so you can determine where the script failed if you don't get any help from the logfiles). - Jonathan -Original Message- From: alain samoun [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 9:19 AM To: George Pitcher;

RE: [PHP-DB] include() statement hell!

2002-03-27 Thread Jonathan Hilgeman
il on the errors you're getting (any specific messages would be nice). - Jonathan -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 3:42 PM To: 'Brad Melendy'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] include() statement hell! di

RE: [PHP-DB] include() statement hell!

2002-03-28 Thread Jonathan Hilgeman
hs rather than trying to screw with your php.ini or httpd.conf file - otherwise you'll have a script that might not work if you ever have to move your scripts or copy them to a development server or something. - Jonathan -Original Message- From: Brad Melendy [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] MySQL, PHPand cron

2002-03-28 Thread Jonathan Hilgeman
d the table gets emptied: wget http://www.yourdomain.com/EmptyTable.php ------ - Jonathan -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL, PHPand cron Hi all, Wonderin

RE: [PHP-DB] include() statement hell!

2002-03-28 Thread Jonathan Hilgeman
This might be your problem: mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:06 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] include() statement hell! Thanks Jonathan, Your suggestions were very helpful, especially turning on the error logging. Here is where I'm at now: Fil

RE: [PHP-DB] include() statement hell!

2002-03-28 Thread Jonathan Hilgeman
who has run into this problem before). - Jonathan -Original Message- From: Brad Melendy [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:06 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] include() statement hell! Thanks Jonathan, Your suggestions were very helpful, especiall

RE: [PHP-DB] include() statement hell!

2002-03-28 Thread Jonathan Hilgeman
No problem. I wonder if there's a web-based syntax checker for PHP... - Jonathan -Original Message- From: Brad Melendy [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:23 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] include() statement hell! Man, this means I ha

RE: [PHP-DB] https post via php

2002-03-28 Thread Jonathan Hilgeman
way that I know of. - Jonathan -Original Message- From: mailing list [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 6:39 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] https post via php Hello, I am attempting to POST to a https://whatever.url.com server and return the result from

RE: [PHP-DB] Unknown column 'Test' in 'field list'

2002-03-29 Thread Jonathan Hilgeman
ut matching up the number of columns to values, or the order of the fields (the above example could have age or lastname as the first value without changing the output). Not to mention this method is a little easier to read and easier to construct. - Jonathan -Original Message- From: Jenni

RE: [PHP-DB] Insert into command - PHP

2002-03-29 Thread Jonathan Hilgeman
You can check to see if there were any insert errors by: print mysql_error(); ...after you have run the query. Give us the output and your query and we can help a bit more. - Jonathan -Original Message- From: Ethan J. Mings [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6

RE: [PHP-DB] Re: displaying info in a form

2002-03-29 Thread Jonathan Hilgeman
to: I've heard that you can leave off the semi-colon, but I just consider it good coding habit to always end statements with semi-colons. - Jonathan -Original Message- From: Luis R. Sales Glez. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:30 AM To: Natividad Cast

RE: Re[2]: [PHP-DB] Insert into command - PHP

2002-03-29 Thread Jonathan Hilgeman
x27;value', field2='value'; "; mysql_query($sql) or die(msql_error()); ... will work fine. No need for special characters - PHP will recognize values and strings that are on multiple lines AS LONG AS the value starts and ends with quotes (and the semicolon at the end).

RE: [PHP-DB] help with preg_replace for http://

2002-03-29 Thread Jonathan Hilgeman
Just convert it and save the converted version for viewing. - Jonathan -Original Message- From: Kevin Won [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:46 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] help with preg_replace for http:// I'm writing a knowledgebase (basically

RE: [PHP-DB] int or tinyint

2002-04-01 Thread Jonathan Hilgeman
to 5 digits). An int(6) could hold 6-digit numbers up to 999,999, etc... - Jonathan -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 31, 2002 10:06 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] int or tinyint Hi all, Just a simple question (I think)

RE: [PHP-DB] Table structure and displaying certain thing

2002-04-01 Thread Jonathan Hilgeman
will post a field called ItemID containing the ID number (in this case, 1) to buyitem.php. Now you just code buyitem.php to add the product to the user's "basket". There are several ways of doing that, but this should be the proper stepping stone. - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Jonathan Hilgeman
like hiring an ex-thief to help you move - you can never be SURE that everything's going to be there in the end. - Jonathan -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 12:45 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Pop up are y

RE: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Jonathan Hilgeman
I was close. :) -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 10:53 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Pop up are you sure... On Tuesday 02 April 2002 01:30, Jonathan Hilgeman wrote: > You're so negative, Jason. :)

RE: [PHP-DB] need some help...

2002-04-02 Thread Jonathan Hilgeman
Thank you. Someone else exists who has the sense of mind to use single quotes. I hate looking at other people's code that has tons of \"s in it. - Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 5:00 PM To: [EMAIL

RE: [PHP-DB] Re: autoincrement

2002-04-03 Thread Jonathan Hilgeman
To add to that, yes, the column must be numeric and it must also be your PRIMARY KEY column to be able to have the autoincrement attribute, not just a regular index. - J -Original Message- From: Glenn Holden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 6:12 PM To: [EMAIL PROT

RE: [PHP-DB] grouping by category

2002-04-04 Thread Jonathan Hilgeman
he database, and you wanted to display the value in the listings, all you would need to do is to add "rating" to your beginning SELECT statement. At that point, it would instantly be available in the bottom $ReviewDetails array as $ReviewDetails["rating"]. The multi-dimensional ar

RE: [PHP-DB] Editing/Updating Data with Forms

2002-04-04 Thread Jonathan Hilgeman
Just look at your basic PHP tutorials like Devshed's PHP 101: http://www.devshed.com/Server_Side/PHP/PHP101 - Jonathan -Original Message- From: Evans, Josh [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 7:31 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Editing/Updating

RE: [PHP-DB] How to avoid: Warning: Page has Expired

2002-04-09 Thread Jonathan Hilgeman
I've addressed this problem here: http://php.sitecreative.com/faq.php - Jonathan -Original Message- From: John Hughes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 12:30 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to avoid: Warning: Page has Expired I have the

RE: [PHP-DB] Saving DB Resuts to a file

2002-04-12 Thread Jonathan Hilgeman
r not, and if there are other people that could get on the server). Then try running the script again. - Jonathan -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 1:52 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Saving DB Resuts to a file Hi

[PHP-DB] PHP to Fax

2002-04-16 Thread Jonathan Hilgeman
work well with scripting? #2 Does anyone know about fax servers or how to obtain one? - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] appending new entry to old entries

2002-04-18 Thread Jonathan Hilgeman
= 5, and append "Appended Text" to the end of MyField without a query to get the previous values. For numeric fields, you can also increment them like this: UPDATE table SET MyNumericField = MyNumericField + 1; That would update all rows in table, incrementing every row's MyNumeri

RE: [PHP-DB] page expires

2002-04-18 Thread Jonathan Hilgeman
http://php.sitecreative.com/faq.php -Original Message- From: Natividad Castro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:12 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] page expires Hi to all, I have form that users fill out and submit. What I'm trying to do is not to

[PHP-DB] Are running sessions using a MySQL handler faster?

2002-08-21 Thread Jonathan Thomas
Good afternoon! Quick performance question - I'm currently preparing the release of a new website running on a Linux box written in PHP and MySQL with sessions throughout. I've read a bit about changing the PHP session handler to use a database vs. the flat file method. Does anyone have experie

[PHP-DB] Multi-Dimensional Arrays

2002-10-09 Thread Jonathan Duncan
;"; $brand="Brand2"; $itemnumber="123456"; $itemname="Another Item Name"; $itemqty=9; array_push($cartArray, array($itemnumber=>"$brand", "$itemqty", "$itemname")); print_r($cartArray).""; echo $cartArray[0][0].""; Thank you, Jonathan Duncan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Multi-Dimensional Arrays

2002-10-10 Thread Jonathan Duncan
gt; $cartArray[1]["Quantity"] = $itemqty; > $cartArray[1]["ItemName"] = $itemname; > > Note that $cartArray[] = $val is just a short hand way of doing > array_push($cartArray, $val); > > Cheers, > > Owen Prime > http://www.noggin.com.au > > > > J

[PHP-DB] RE: Displaying a single picture...

2002-11-12 Thread Jonathan Narong
not sure i understand why you would need to use a php script for this? why not just use a static html tag, if all you're doing is opening the picture in a new window? -jon -Original Message- From: Brett Lathrope [mailto:brett@;lathrope.com] Sent: Tuesday, November 12, 2002 1:44 PM To: [E

[PHP-DB] RE: date questions in mySql

2002-11-12 Thread Jonathan Narong
yes, you need to insert the date as -mm-dd. you can go around this and still have the user see a form field with mm/dd/ but you need to break each part down, and play with the string functions so the final mysql query is in -mm-dd. -jon -Original Message- From: Paul Ihrig [mai

[PHP-DB] checking for 0 results?

2002-11-15 Thread Jonathan Narong
maybe i'm totally not thinking straight right now, but is there a way in php to check if 0 results are returned in a mysql query? for example, i have a definition database, that has a list of letters the user clicks on (click on the letter, and all the terms for that letter pop up).. but for some

[PHP-DB] creating a new mysql automatically every day?

2002-11-18 Thread Jonathan Narong
i'm currently building a traffic analysis application for a website. it is my first time working on such a project, so i'm not even sure if this would be the best way to do it all, but here it goes. what i would like to do is count the number of hits that go to different sections of the site. i ca

RE: [PHP-DB] creating a new mysql automatically every day?

2002-11-18 Thread Jonathan Narong
John, That is good advice. I wasn't aware of indexes/keys slowing down inserts. Whats the best way to copy a table over to another table though? -jon -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 5:36 PM To: 'Jonathan Naron

[PHP-DB] regarding multiple joins

2002-11-22 Thread Jonathan Narong
this is a problem i've been struggling with for a little while. any attempt to find help online has not produced any useful information. this is regarding joins, which i'm not an expert in, but hopefully one of you can help me out. i have an table 'articles' which has multiple fields, such as auth

[PHP-DB] RE: inserting html into mysql tables

2002-11-22 Thread Jonathan Narong
5k of data is way too much for varchar, so i would use a field of type TEXT. i do this as well (storing html data in mysql) and it works great. some say to use addslashes() although, on my setup (3.23/4.1) it seems to addslashes automatically - not sure exactly why that is though. -Original Me

[PHP-DB] RE: regarding multiple joins

2002-11-22 Thread Jonathan Narong
ther complex JOIN but i'm not sure how it looks exactly. any help would be appreciated. thank you very much. -jon -Original Message- From: David Elliott [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 2:18 AM To: Jonathan Narong on PHP-DB Subject: Re: regarding multiple

RE: [PHP-DB] RE: regarding multiple joins

2002-11-22 Thread Jonathan Narong
that worked perfectly! thank you so much! -jon -Original Message- From: Rick Widmer [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 6:08 PM To: Jonathan Narong; David Elliott; Jonathan Narong on PHP-DB Subject: Re: [PHP-DB] RE: regarding multiple joins At 05:26 PM 11/22/02

[PHP-DB] PHP & MySql

2001-04-08 Thread Jonathan Underfoot
m=$com_num"; $result = mysql_query ($sql_query) or die ("Invalid query / error"); This is all directly from a form. The variables are all valid. I've tried making the query something like "UPDATE commentary SET com_release=test WHERE com_num=8" and even that dosen'

[PHP-DB] Limiting Return from DB

2001-04-09 Thread Jonathan Underfoot
PHP command I'm unaware of. Thanx, -Jonathan

[PHP-DB] A Real PHP problem for a change...

2001-04-10 Thread Jonathan Underfoot
ore, does thje function of the ' and " change in other commands? I could really use a complete description on this. Perhaps a link to some long overdue resource I should have read months ago before I designed my current project? The Happy Columnist, -Jonathan Underfoot Underf

Re: [PHP-DB] I want to remove my e_mail address from the mail list

2001-04-10 Thread Jonathan Underfoot
To unsubscribe, e-mail: [EMAIL PROTECTED] - Original Message - From: "kevin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 10, 2001 6:41 PM Subject: [PHP-DB] I want to remove my e_mail address from the mail list > I want to remove my e_mail address( [EMAIL PROTECTED]

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

2001-04-20 Thread Jonathan Hilgeman
I actually created an array of different conditions like: $ConditionsArray = array("Var1 > 500","Var2 < 1800","ID=43"); and then: $Conditions = join(" AND ", $ConditionsArray); This constructs: $Conditions = "Var1 > 500 AND Var2 <

[PHP-DB] POST / Page Expired

2001-04-23 Thread Jonathan Hilgeman
l load the page fine again. But this happens every time and I don't want that message to appear at all. Any suggestions or ideas? It happens on every page that is POSTed to. Thanks! Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For ad

RE: [PHP-DB] Variable passing

2001-04-24 Thread Jonathan Hilgeman
our tag, put in: or if you don't have short-open tags on: This will recreate all the previously-POSTed fields as hidden inputs that will get posted to the next page as well. Just put that line (print PassHidden...) before each of your tags, and it should work fine. -- Jonathan Hilgema

RE: [PHP-DB] Querying 2 databases...???

2001-04-24 Thread Jonathan Hilgeman
Why not just JOIN the tables using new columns in the sportDB? For instance, if your user names in the sportDB database and the user names in the mysql database match up, just do a JOIN ... ON sportdb.table_name.username_field = mysql.user.User You don't need two connections. Jon

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

2001-05-01 Thread Jonathan Hilgeman
1) Check out the new 4.0.5 version of PHP. 2) Some of the functions in the documentation now say "Feature added in 4.0.6" but I don't see that version available yet, since 4.0.5 was just released. Does that just mean they are enticing us or something? -Original Message- From: B. van Ouw

[PHP-DB] PHP accessing MySQL

2001-05-18 Thread Jonathan Duncan
[$db_num] = mysql_tablename($dbs, $db_num); $db_list .= "$db_names[$db_num]"; if (($db_names[$db_num] != "mysql") && ($db_names[$db_num] != "tempdata")) { $tables = mysql_list_dbs($db_names[$db_num]) or die("Couldn't list databases."); Any Ideas? Than

RE: [PHP-DB] Merge two arrays into associative arrays?

2001-05-21 Thread Jonathan Hilgeman
try: $a=array(1,2,3,4,5); $b=array("a","b","c","d","e"); $c = array(); foreach($a as $a_key => $a_value) { $c[$a_value] = $b[$a_key]; } that should give you what you want. Jonathan -Original Message- From: Shahmat Dahlan [mailto:[

[PHP-DB] RE: [PHP-INST] Instalation Problems /w Win98 + Apache 1.3.19

2001-05-21 Thread Jonathan Hilgeman
is about 11 megs, but is extremely easy-to-install and configurable later if you want to fine-tune the settings, etc... Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 10:08 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re

[PHP-DB] RE: [PHP-INST] PHP4 Works but Sessions Don't!!

2001-05-21 Thread Jonathan Hilgeman
1) Do you get any errors back (check your error log if you can)? 2) Maybe your host/machine does not have the correct permissions set on their /tmp directory to allow you to write the session file. 3) Probably a stupid idea, but just in case, do you have cookies enabled on your browser? -Orig

  1   2   3   >