Re: [PHP-DB] database design question

2003-09-29 Thread olinux
olinux --- John Ryan [EMAIL PROTECTED] wrote: ive a table called 'lyrics' which is the main content on my site, song lyrics. im thinking of introducing rate this lyric and all that kind of stuff into the site. would it be better, from a design point of view, to create a second table for lyrics

Re: [PHP-DB] Compiling 4.2.3 with MySQL ... what does it look for?

2003-07-05 Thread olinux
try --with-mysql=/usr --- -{ Rene Brehmer }- [EMAIL PROTECTED] wrote: X-posted to PHP General, PHP DB, and MySQL Hi gang Attempting to get my Linux test-server working, but ran into a problem when making PHP... System is RedHat 8, Apache 1.3.27 (compiled myself, tested OK), MySQL

Re: [PHP-DB] Re: Authentication Classes

2003-06-10 Thread olinux
-hq.de/liveuser LiveUser Pear page http://pear.php.net/package-info.php?pacid=126 olinux --- Becoming Digital [EMAIL PROTECTED] wrote: Sorry, Manuel, but you must have missed the first paragraph of my post. I was hoping to narrow down the 40 classes from the repository to those that are top

Re: [PHP-DB] Generating view of tree?

2003-03-27 Thread olinux
--- Paul Burney [EMAIL PROTECTED] wrote: on 3/26/03 9:18 PM, Leif K-Brooks at [EMAIL PROTECTED] appended the following bits to my mbox: I have a table with a tree. Thing is, I need to generate a view of it like: Category Sub-category Sub-sub-category Another

Re: [PHP-DB] Generating view of tree?

2003-03-27 Thread olinux
Also just saw a new PEAR package posted that helps you work with nested sets. Haven't tried it yet. http://pear.php.net/package-info.php?package=DB_NestedSet olinux --- Paul Burney [EMAIL PROTECTED] wrote: on 3/26/03 9:18 PM, Leif K-Brooks at [EMAIL PROTECTED] appended the following bits

Re: [PHP-DB] example use of DB class

2003-03-26 Thread olinux
This has been answered 1000's of times. You could have had your answer in 10 seconds. http://www.google.com/search?hl=enlr=ie=ISO-8859-1q=php+pear+db+class+example olinux --- VaX#n8 [EMAIL PROTECTED] wrote: I think my last message failed to post properly. Can anyone show me an example use

Re: [PHP-DB] Making tree menu

2003-03-20 Thread olinux
://searchdatabase.techtarget.com/tip/1,289483,sid13_gci801943,00.html olinux --- Daniel Harik [EMAIL PROTECTED] wrote: Hello guys I make following query: mysql SELECT b.type, a.link AS parent_link, b.link AS child_link FROM bookmarks AS a, bookmarks AS b WHERE a.id = b.parentid order

Re: [PHP-DB] Re: deleting records using a checkbox

2003-03-19 Thread olinux
(this) olinux John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] INPUT TYPE=CHECKBOX NAME=DELETE[?php echo message_id ?] VALUE=Y you will get an array named DELETE. check for every element in array DELETE foreach($_POST['DELETE'] as $message_id

RE: [PHP-DB] Re: deleting records using a checkbox

2003-03-19 Thread olinux
with checkbox elements w/javascript and not how to read the form submission. maybe its in php docs somewhere... i'll try some more searching later. olinux --- John W. Holmes [EMAIL PROTECTED] wrote: Since this is not valid HTML - how would you accomplish this using valid HTML? INPUT

Re: [PHP-DB] Processing Page

2003-02-27 Thread olinux
olinux --- Adam Royle [EMAIL PROTECTED] wrote: I have seen an example using JavaScript where javascript commands are flushed every so often (from PHP) which indicates a status bar process. It was used to monitor mailouts. The javascript commands were simply telling an image to increase it's

Re: [PHP-DB] approaching a relational database

2002-12-16 Thread olinux
|1 |1| white | 4 | 410 3 |1 |1| blue| 5 | 430 olinux --- Doug Parker [EMAIL PROTECTED] wrote: I'm about to embark on a project where I have to enter many, many fields into a MySQL database, and I don't know how to approach the database

RE: [PHP-DB] Accessing data from next row? (mysql)

2002-10-14 Thread olinux
trtd[a href=edit.php?l_id='.$prev_id.'Modify/a] /td/tr trtdnbsp;/td/tr'; $listing = ''; olinux --- Snijders, Mark [EMAIL PROTECTED] wrote: if you want to access stuff from row 3 while being in row 2.. you first have to put it all into an array.. and then you coul do

[PHP-DB] htdig interface class

2002-08-28 Thread olinux
limit_urls_to and restrict) to emulate results in categories. If anyone could point me to potential hangups - I would sure appreciate it. Thanks much, olinux __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- PHP

[PHP-DB] Return Results in Categories - like CNET

2002-08-16 Thread olinux
few - similar to the way cnet does. Thanks much, olinux __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Return Results in Categories - like CNET

2002-08-16 Thread olinux
| coverstory | title | article Thanks much, olinux --- Adam Williams [EMAIL PROTECTED] wrote: If your articles are in an SQL database uses the LIMIT clause on your SQL statement. Adam On Fri, 16 Aug 2002, olinux wrote: I would like to allow articles

Re: [PHP-DB] Return Results in Categories - like CNET

2002-08-16 Thread olinux
I am just trying to return a few results from each category. like this: http://cnet.search.com/search?timeout=3q=php sql query example: SELECT id, article_date, category, region, title FROM articles WHERE MATCH (title,article) AGAINST ('$search_word'); There are 20 possible categories that may

Re: [PHP-DB] How to get data from mysql to .csv?

2002-07-12 Thread olinux
SELECT INTO OUTFILE http://www.mysql.com/doc/S/E/SELECT.html ex: SELECT a,b,a+b INTO OUTFILE /tmp/result.text FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \n FROM test_table; also useful - LOAD DATA INFILE http://www.mysql.com/doc/L/O/LOAD_DATA.html olinux

Re: [PHP-DB] MySQL Indexing Size

2002-06-27 Thread olinux
hmm... index it - and you will know olinux --- [EMAIL PROTECTED] wrote: hi all I want to know storage required for my database. How i can determine size required for indexing a column ? (my column's type that indexed is varchar(15)) Thanks -- PHP Database Mailing List (http

Re: [PHP-DB] Can I be an ASP with PHP?

2002-06-21 Thread olinux
You can connect to remote servers - but i'm guesssing that this will be a much more difficult route. Especially with customers that will be on shared servers (unless you licensed to the hosting companies...) read the manual for mysql_coonect mysql_connect (server, username, password) olinux

Re: [PHP-DB] loop?

2002-05-24 Thread olinux
You can just echo out during your while loop - or build a display block and echo it all at once. Not quite sure how to get this piece of code to loop through the records and echo them back one line per one record... ?php session_start(); if (isset($HTTP_SESSION_VARS['var01']) ||

[PHP-DB] url structure /articles/region/date/id

2002-04-16 Thread olinux
actually only the article id would be used) any suggestions? Thanks much, olinux __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Insert select does not insert all rows.

2002-04-14 Thread olinux
The script is probably timimg out. Default timeout is 30 seconds. Stick this in your script set_time_limit(0); set_time_limit() has no effect when PHP is running in safe mode http://www.php.net/manual/en/function.set-time-limit.php olinux --- andy [EMAIL PROTECTED] wrote: Hi there, I am

Re: [PHP-DB] MySQL to Email and Line Breaks

2002-04-13 Thread olinux
check out nl2br() function [newline to break] http://www.php.net/manual/en/function.nl2br.php olinux Jeff Oien wrote: I have a form where someone enters the body of an email messageinto a part of a form to be sent out to a list. Then a script retrieves the body and sends it via email

[PHP-DB] Re: [PHP] Re: arguments against php / mysql?

2002-04-12 Thread olinux
that the databases will practivally always function separately. olinux --- Mallen Baker [EMAIL PROTECTED] wrote: Thanks to Michael, Barry, Steve, Cal and Rasmus for replies. We have just taken a contract for a dedicated server, and I tried rather hard to get it to be a Linux server. The killer

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

2002-04-09 Thread olinux
header()] to whatever.php or back to login.php if login was unsuccessful. olinux --- John Hughes [EMAIL PROTECTED] wrote: I have the first part of the kids' soccer photo database site up that I mentioned in an earlier post. The site displays nine image thumbnails. You click on the thumbnails

Re: [PHP-DB] grouping by category

2002-04-03 Thread olinux
Here's a start - take a look at the results in phpmyadmin to get an idea of how to loop the result SELECT url, author, name, category FROM hwureviews GROUP BY category olinux --- Alex Behrens [EMAIL PROTECTED] wrote: Hey Guys, I'm trying to get my script to group all my reviews

Re: [PHP-DB] Re: Database search question

2002-04-02 Thread olinux
work for you criticisms and suggestions appreciated :) olinux --- Hugh Bothwell [EMAIL PROTECTED] wrote: How can I accomplish the following? I have a table called search, I have 3 fields, city, country, type I also have an imput box where you can type in a search word. What I

Re: [PHP-DB] using multiple checkboxes to delete from db

2002-03-30 Thread olinux
to make it a little better, make one connection to the db before you loop and then close the connection [connect] foreach loop [close connect] olinux --- wesley grubbs:. [EMAIL PROTECTED] wrote: thanks guys for the aid. in the end, i went with creating a check box that looks like

Re: [PHP-DB] formatting table column to display as a hyperlink using Oracle

2002-03-27 Thread olinux
What are you trying to link to? Most likely you need to pass a few variables in the URL This should give you an idea: echo TDA HREF=whateverpage.php?var1=$var1record=$column_value$column_value/ATD; olinux --- Franden, Craig [EMAIL PROTECTED] wrote: Hi, I am using a small php script

Re: [PHP-DB] Creating a good search engine

2002-03-22 Thread olinux
://www.databaseanswers.com/data_models/search_engine.htm A couple articles I found helpful: http://www.zend.com/zend/spotlight/websearchengine2may.php#Heading2 http://www.phpbuilder.com/columns/clay19990421.php3 olinux --- Mike de Libero [EMAIL PROTECTED] wrote: Hi Guys, I need to create a search engine

Re: [PHP-DB] Searching results of results

2002-03-19 Thread olinux
) { $query .= fname = '$fname' AND ; } $query .= (category = '$category' AND country = '$country' AND type = '$type') ORDER BY city ASC LIMIT $offset, $item_perpage; have fun, olinux --- Chris Payne [EMAIL PROTECTED] wrote: Hi there everyone, Say I do a simple search as follows: $query

[PHP-DB] Indexable DB Driven site on Windows Server

2002-03-19 Thread olinux
, olinux __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] post to a url and return to same page

2002-03-19 Thread olinux
I know that there is a PEAR library [http://pear.php.net] that allows this. I don't know if it requires CURL or not. I ran into the same problem and haven't had time to check out PEAR yet. perhaps someone can enlighten us. olinux --- mailing list [EMAIL PROTECTED] wrote: Hello, I am trying

[PHP-DB] Content Management - best way to store data

2002-03-15 Thread olinux
I'm doing a lot of research on content management systems and wanted to get input on how to store article data. Is it best to store article data in XML - if so how? Thanks much, olinux __ Do You Yahoo!? Yahoo! Sports - live college hoops

[PHP-DB] Hosting - what's needed to handle 650K queries?

2002-03-09 Thread olinux
enough functionality to insert and pull data for what we're doing. We also have a MSSQL database. Which would be a better solution. I am guessing that MySQL would be as 99% of queries would be simple select statements and MySQL handles this well. Thanks much, olinux PS: Hosting providers - feel free

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

2002-03-08 Thread olinux
You must use absolute paths in includes. essentially the include will reference itself as the starting point, rather than the script you are calling it from. olinux --- Jonathan Hilgeman [EMAIL PROTECTED] wrote: I'm on a red hat system, and I've soft-linked two directories: /www/dir1/subdir

Re: [PHP-DB] Pulling record by time of day

2002-03-03 Thread olinux
try this: if (900=$time $time=1500) {$time = 1;} olinux --- [EMAIL PROTECTED] wrote: Hello, I've been working on pulling one or more records from my db by the time of day. Here is what I've tried so far, ? $time = date(Hi); if (900=$time=1500) {$time = 1;} ? I would then use $time

Re: [PHP-DB] debugging?

2002-02-21 Thread olinux
jas, Try this: - Remove the @, it suppresses the error - change die(Could not execute query, please try again later); to die(mysql_error()); $sql = mysql_query(DELETE FROM $table_name WHERE $id = 'id',$dbh) or die(mysql_error()); olinux --- jas [EMAIL PROTECTED] wrote: Can someone tell me

[PHP-DB] Page Expired - Post form

2002-02-16 Thread olinux
use get method because it is a login to account manager. I have tried session_cache_limiter('private'); and it does nothing? I am out of ideas and patience, please help if you can. thanks, olinux __ Do You Yahoo!? Yahoo! Sports - Coverage

Re: [PHP-DB] Flipping through database records

2002-02-12 Thread olinux
Interesting Jason, just to make sure I'm clear: basically, you would query the table and while loop through the query result and create an array and then store that in a session? olinux --- Jason Cox [EMAIL PROTECTED] wrote: Dan, Here's an idea for you: Rather than try to pass the uid

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

2002-02-11 Thread olinux
{ -- $form_id is not set so show the forms -- } olinux -Original Message- From: Marius Ursache [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 11:24 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] multiple forms, one submit button hi is it posibile to have in a php script

[PHP-DB] Creating Directory Search Engine

2002-02-07 Thread olinux
' should return just category 10 Make sense? Please let me know of a good strategy for this - I imagine that it is quite common. Thanks much, olinux __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com

RE: [PHP-DB] arrays and email

2002-01-29 Thread olinux
] olinux --- Gurhan Ozen [EMAIL PROTECTED] wrote: Hi kevin, Seems like in your while loop, you are not populating your list array correctly with all the emails you have. Try to have a count value and populate the array list accordingly such as: $count = 0; while ($row

Re: [PHP-DB] storing and retrieving arrays in mysql

2002-01-28 Thread olinux
there's a better way, but this seems to work OK. I will email code sample later [off-list]. I would be happy to share code with others as well. olinux --- Corey Eiseman [EMAIL PROTECTED] wrote: Hi folks, I've got a question hopefully someone can shed some light on for me. I'm building

Re: [PHP-DB] Save generated page locally

2002-01-25 Thread olinux
Here's an article that may help: Dynamic generation of static webpages http://www.phpbuilder.com/columns/loris20010420.php3 I think what you are referring to would best be accomplished using a macro: You can download AutoMate 4.5 at downloads.com - it's a simple program olinux --- Howard

[PHP-DB] Similar Articles or Customers also bought...

2002-01-21 Thread olinux
for your help. olinux __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP-DB] Storing Credit Card info

2002-01-17 Thread olinux
. Then just display these on SSL so that the client can retrieve the numbers. Any ideas? Thanks much, olinux __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Problem with mail function

2002-01-14 Thread olinux
://www.phpbuilder.com/tips/item.php?id=125 olinux --- [EMAIL PROTECTED] wrote: Hi, Faye. There's a parm in the configuration file (php.ini) cleverly called max_execution_time. Its default setting is 30. There's also a set_time_limit() function that allows massaging this variable. Does this help

[PHP-DB] Optimizing mail()

2002-01-14 Thread olinux
/view.phtml/aid/300/fid/21 Thanks, olinux __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

RE: [PHP-DB] Concept help required

2002-01-09 Thread olinux
Haven't been following and not sure if this is what you're after, but these are some great data models: http://www.databaseanswers.com/data_models/index.htm HTH olinux --- Tim Foster [EMAIL PROTECTED] wrote: You wouldn't happen to have a spare ELH diagram (or two) lying around that one

Re: [PHP-DB] PHP/SQL search engine help (newbie)

2002-01-07 Thread olinux
A couple good sites for tutorials www.hotscripts.com www.devshed.com www.thickbook.com HTH, olinux --- Keith Hughes [EMAIL PROTECTED] wrote: Hi, Completely new at this, so don't be too harsh. I'm trying to create a help file system for a programme (much like the help files that you get

Re: [PHP-DB] database/form help needed

2002-01-06 Thread olinux
Use input type=checkbox name=id[? echo $id ?] Then you'll have an array of the boxes checked with the id as the array key. olinux --- Neil Thomson [EMAIL PROTECTED] wrote: try using the rand function.. eg... $rand=rand(1,10); input type='text' name='id$rand' but that migth get a same

[PHP-DB] How much for a Job Site

2002-01-03 Thread olinux
was unable to find any good matches at hotscripts.com Sorry if this is too far off topic. If it is please reply personally to me. Thanks much, olinux __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- PHP Database

[PHP-DB] Deleting form multiple tables

2002-01-03 Thread olinux
Does mysql not support deletes from multiple tables? [ie] DELETE FROM vendors, billing WHERE vendors.v_id = '1' AND vendors.vb_id = billing.b_id Thanks much, olinux __ Do You Yahoo!? Send your FREE holiday greetings online! http

Re: [PHP-DB] Passing parameter in Paging

2001-12-28 Thread olinux
?keyword=somethingstart_at=31end_at=45;3/A etc. olinux --- Mihail Bota [EMAIL PROTECTED] wrote: Bogdan, in this respect, I have a question: can I pass the values of javascript variables to php variables? if yes, how? Mihai On Fri, 28 Dec 2001, Bogdan Stancescu wrote: I don't

Re: [PHP-DB] Passing parameter in Paging

2001-12-28 Thread olinux
If there are variables you dont want passed in the link, just use sessions. nothing wrong with using both olinux --- Bogdan Stancescu [EMAIL PROTECTED] wrote: So many suggestions, so little time! The URL thing is a great idea if you don't have any problems with users seeing the variables

[PHP-DB] find a value by array key

2001-11-17 Thread olinux
grab that value since there will only be one? thanks, olinux __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] Pulling Zip Codes from USPS

2001-11-10 Thread olinux
I had a tutorial bookmarked at one point on how to pull zip codes from the USPS search or something like this. There are a couple benefits to this - 1. it's always up to date 2. it's complete and 3. it's free. I would like to use something like this now. Does anyone have a link to tutorial or

RE: [PHP-DB] TREE in a database

2001-11-04 Thread olinux
True, but isn't this script a bit database intensive? You shouldn't have to hit the database so many times, or doesn't this query as much as I think? But thank you for the article, It is perfect for my problem too. olinux --- Robert Vukovic [EMAIL PROTECTED] wrote: Thanks, that is exactly

[PHP-DB] $this-TRAIL = $trail

2001-11-02 Thread olinux
Categories where CatID = $CatID; Lines excerted from phpHoo article here: http://www.webreference.com/perl/xhoo/php1/ Thanks, olinux __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- PHP Database Mailing List (http

Re: [PHP-DB] category structure

2001-10-29 Thread olinux
want to recursively hit the database a bunch of times. Thanks, olinux --- DL Neil [EMAIL PROTECTED] wrote: - Original Message - From: olinux [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 29 October 2001 08:16 Subject: [PHP-DB] category structure anyone have any ideas

[PHP-DB] counting categories

2001-10-28 Thread olinux
How would you get the count of each category? Like this - http://www.scriptsearch.com Would you have to run a different select for each one? or would you do something like select category from $table and then count all of the matches for each category perl php asp thanks much, Josh

[PHP-DB] category structure

2001-10-28 Thread olinux
with these like so: $category[$parentid][$id] But now what? trouble is that $msub[2][4] is a sub category of $msub[1][2] so i can't just run thru and print the array - need to manipulate a little. Any ideas? [or even a beeter way to do this?] thanks olinux

[PHP-DB] Category search w/o specified categories

2001-10-23 Thread olinux
much, olinux __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] PHP and ms Access

2001-09-27 Thread olinux
www.phpbuilder.com has a few decent articles on this that will help you. olinux -Original Message- From: Fran├žois PERROT [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:19 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP and ms Access Hi, You need

RE: [PHP-DB] Sending text messages to cell phone with PHP?

2001-09-25 Thread olinux
For sprint it is [EMAIL PROTECTED] -Original Message- From: Eric O'Connell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:45 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Sending text messages to cell phone with PHP?

Re: [PHP-DB] Searching/keywords

2001-09-20 Thread olinux
you could probably use a str_replace() www.php.net $description1 = Episode 1 - Joey eats all of the food in the house; Suppose the search term is food - just go thru and replace food with bfood/b or whatever tags you want to use. olinux --- Matt C [EMAIL PROTECTED] wrote: I have summaries

[PHP-DB] mail() - is there a limit?

2001-09-08 Thread olinux
I am using a script that grabs about 100 emails from a database, loops thru and writes them to $bcc Then I use a single mail() to send a msg to everyone in the $bcc Is there a maximum nuber of emails that i can mail to this way? Thanks, olinux

Re: [PHP-DB] Warning: Page has Expired

2001-09-03 Thread olinux o
I have the same troubles. I believe that the only solution is to use GET rather than POST as your FORM METHOD. There may be another way, but this may work fine, as long as you are not working with passwords/sensitive info. olinux --- Mad Nas [EMAIL PROTECTED] wrote: Hi All I'm using PHP 4

Re: [PHP-DB] PHP and ms Access

2001-09-02 Thread olinux o
www.phpbuilder.com has an article on this olinux --- user [EMAIL PROTECTED] wrote: Hello, I am builing a microsoft access database. Now wants the compagny I created it for me to use it to make dynamic webpages. The problem is that I am new at this. Can somebody please explain

RE: [PHP-DB] checking for results return from mysql

2001-08-05 Thread olinux
try this $result = mysql_query($sql_query); if ($result) { while ($row = mysql_fetch_array($result)) { $var_1 = $row['var_1']; $var_2 = $row['var_2']; } } olinux -Original Message- From: Jon Yaggie [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 05, 2001 1:36 PM To: [EMAIL

[PHP-DB] Clearing all session variables

2001-08-04 Thread olinux
Hi all I am using this to free all session variables but it does not work. session_unset(); session_destroy(); What must I do to do this? olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP

RE: [PHP-DB] Clearing all session variables

2001-08-04 Thread olinux
dang, sorry I wasn't issuing session_start(); before these... -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 10:37 PM To: php-db Subject: [PHP-DB] Clearing all session variables Hi all I am using this to free all session variables

[PHP-DB] PHP Developer's Suggestion !

2001-07-31 Thread olinux
Why don't you make the php.net site Printer Friendly? olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] Storing last access

2001-07-30 Thread olinux o
and Last_Checked I cannot use cookies because this will be checked from different locations. I don't know how to store a session and am not sure that two different locations could share the sessions anyways. Thanks much, olinux __ Do You Yahoo!? Make

[PHP-DB] excellent reference for form info

2001-07-29 Thread olinux
Here's a VERY helpful link to help deal with a number of form situations. http://www.linuxguruz.org/z.php?id=33 Little demo's of each too! olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP

[PHP-DB] Warning: Page has Expired

2001-07-28 Thread olinux o
How can I do away with this error when the BACK button is pushed? Thanks, olinux __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- PHP Database Mailing List (http

[PHP-DB] Warning Page Expired

2001-07-28 Thread olinux o
How do I eliminate this error when the BACK button is used? Warning Page Expired Thanks, olinux __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- PHP Database Mailing List

RE: [PHP-DB] 2 Tables- 1 Insert Problem

2001-07-28 Thread olinux
Not possible. do this $result_1 = mysql_query($sql1) or die('Insert 1 failed'); do this $result_2 = mysql_query($sql2) or die('Insert 2 failed'); olinux -Original Message- From: Steve Fitzgerald [mailto:[EMAIL PROTECTED]] I'm trying to insert data into two separate tables using 1

[PHP-DB] Checking radio buttons for multiple records/Updating multiple records...

2001-07-28 Thread olinux
understand that I will have to execute a number of update statements ... But how can I create these statements that tie the correct username and AUTHORIZE value together? thanks much, olinux _ Do You Yahoo!? Get your free @yahoo.com

RE: [PHP-DB] search form

2001-07-24 Thread olinux
Build the keywords for the static pages into the existing db table. a lot of work so you will have to remember to delete changed/delete url's olinux -Original Message- From: J- E- N [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 2:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB

[PHP-DB] parsing checkbox array without [] and selecting all boxes

2001-07-09 Thread olinux
anyone have a jscript that will work with the [] characters? Thanks olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] testing ODBC + MSSQL connection locally

2001-07-08 Thread olinux
I would like to begin learning ODBC. Will I be able to set this up on my single local machine? Also, What about connecting to MS SQL server remotely? Will i simply need an IP Port and user/pass? Thank you olinux _ Do You Yahoo!? Get

[PHP-DB] win2k - apache - php files open as text

2001-07-07 Thread olinux
it displays the script as text. Please help if you can - i have wasted the entire day ... thanks much olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] win2k - apache - php files open as text

2001-07-07 Thread olinux
Nevermind - i have solved it. I don't know what it was - but a few more reinstalls did it... olinux -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 07, 2001 1:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] win2k - apache - php files open as text hey all

[PHP-DB] PHP , MSSQL and ODBC

2001-07-05 Thread olinux
, olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] login twice

2001-07-05 Thread olinux
could you set up a STATUS field to hold 0 for not logged in and 1 for logged in? Then Login script would update the STATUS field. likewise the logoff would as well. [You would need a way to timeout a user as well]. I am sure this is not the best way, but seems simple. -Original Message-

[PHP-DB] pricing info

2001-07-02 Thread olinux
rate is for such work in the US. thanks much, olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] IIS - going live

2001-07-02 Thread olinux
on remote servers. [i.e. the only trouble would be establishing a connection between the IIS and SQL server?] TIA olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http

RE: [PHP-DB] RE: Storing Code in a db?

2001-07-01 Thread olinux
Couldn't you just store the php commands as a txt file and then use a SSI [server side include]? olinux It would be very convenient to be able to store PHP (or any other server side code) in a database, then retrieve and execute it. I store a lot of website content with embedded HTML

[PHP-DB] ereg_replace

2001-06-30 Thread olinux o
] however it does not seem to be working... TIA olinux __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] Grabbing string between two other strings.

2001-06-30 Thread olinux o
() looks most promising, however i have not had any luck as yet. thanks much, olinux --- Jesse S. Williams [EMAIL PROTECTED] wrote: Hello- Try looking at the info for regular expressions on http://www.php.net. You should be able to write something from that. Will the beginning and end always

Re: [PHP-DB] Passing XML

2001-06-30 Thread olinux o
Is this what you have in mind? $url = 'http://website.com/document.xml'; $str = implode('', file($url)); $str = contains the xml doc and retains formatting [spaces, newlines] $url could be a doc on the local server as well. --- Hugh Bothwell [EMAIL PROTECTED] wrote: I'm not sure how you

[PHP-DB] Grabbing string between two other strings.

2001-06-29 Thread olinux
($name_of_result_between_two_strings, $first_string, $second_string) Is there such a function? Thank you, olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net

[PHP-DB] ereg and first occurence

2001-06-29 Thread olinux o
on how I could extract 'NAME' from the following and not CITY? FONT face=VerdanaNAME/FONT FONT face=ArialCITY/FONT TIA olinux __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database

[PHP-DB] preg_match

2001-06-29 Thread olinux o
k I have no idea on this. My code: 8 $begin = Property Type; 9 $end = BR; 10 preg_match($begin . (.*) . $end, $str, $data); The error: Warning: Delimiter must not be alphanumeric or backslash in c:\apache\htdocs\index.php on line 10

[PHP-DB] Using regexps to clean up html files

2001-06-28 Thread olinux o
. If you would like some sample files, please contact me off list. Thank you so much. olinux __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] static or dynamic printer-friendly webpages?

2001-06-28 Thread olinux
I'm sure. I would try doing something with CSS... then you may even decide to change the other template. :) olinux -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 3:13 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] static or dynamic

[PHP-DB] Extracting data from html files into csv

2001-06-26 Thread olinux
, or delimited file. 1. All entries have the same basic format 2. Not all fields are present for each Does anyone know of a program to strip this type of data into a xls or cvs file? thanks much, olinux _ Do You Yahoo!? Get your free

RE: [PHP-DB] session_end()

2001-06-23 Thread olinux
try session_destroy() olinux -Original Message- From: Chadwick Rolfs [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 23, 2001 12:39 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] session_end() dear list I have attempted to use session end to no avail. I have a self-referencing form

  1   2   >