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 o

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

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 > reposi

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] appende

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 > > Ano

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

2003-03-26 Thread olinux
Wow, that's helpful :( Here's a prior post that should set you in the right direction: http://marc.theaimsgroup.com/?l=php-general&m=104815166325490&w=2 olinux --- Blain <[EMAIL PROTECTED]> wrote: > If you can sort it and give all entrys a > indent number

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=en&lr=&ie=ISO-8859-1&q=php+pear+db+class+example olinux --- VaX#n8 <[EMAIL PROTECTED]> wrote: > I think my last message failed to post properl

Re: [PHP-DB] Making tree menu

2003-03-20 Thread olinux
0,00.html -> http://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 &

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

2003-03-19 Thread olinux
is how to work 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 woul

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

2003-03-19 Thread olinux
Since this is not valid HTML - how would you accomplish this using valid HTML? > VALUE="Y"> i.e. Yahoo mail does checkboxes like this: olinux > "John W. Holmes" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] > > > > VAL

Re: [PHP-DB] Processing Page

2003-02-27 Thread olinux
ry http://javascript.faqts.com 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 javas

Re: [PHP-DB] approaching a relational database

2002-12-16 Thread olinux
| red | 4 | 400 2 |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 databas

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

2002-10-14 Thread olinux
7; Description: '.$row[l_description].' Categories: - '.$row[category].''; } Then after the while loop I do this to finish off the list and provide the edit link $content .= $listing.' [M

[PHP-DB] htdig interface class

2002-08-28 Thread olinux
ecifically 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.co

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=3&q=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] Return Results in Categories - like CNET

2002-08-16 Thread olinux
| 20020815 | 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:

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

2002-08-16 Thread olinux
irst 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] How to get data from mysql to .csv?

2002-07-11 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:/

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 > > >

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) o

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... > session_start(); > if (isset($HTTP_SESSION_VARS['var01']) || > isset($HT

[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: >

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
t 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

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

2002-04-09 Thread olinux
'password' and redirects [via 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. >

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

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

2002-04-02 Thread olinux
AND category_id IN ($category_matches); category_id could be anything really - maybe hotel_id would work for you criticisms and suggestions appreciated :) olinux --- Hugh Bothwell <[EMAIL PROTECTED]> wrote: > > How can I accomplish the following? > > > > I have a t

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 ch

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 "$column_value"; olinux --- "Franden, Craig" <[EMAIL PROTECTED]> wrote: > Hi, > > I am using a small php script to return records

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

2002-03-22 Thread olinux
pful: http://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, > >

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: &g

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

2002-03-19 Thread olinux
ormat. thanks much, 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] Searching results of results

2002-03-19 Thread olinux
($city) { $query .= "city = '$city' AND "; } if ($fname) { $query .= "fname = '$fname' AND "; } $query .= "(category = '$category' AND country = '$country' AND type = '$type') ORDER BY city ASC LIMIT $offset, $item_p

[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

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

2002-03-09 Thread olinux
than 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 -

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 > di

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&q

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

[PHP-DB] Page Expired - Post form

2002-02-16 Thread olinux
can't 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

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: >

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

2002-02-11 Thread olinux
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 multiple forms and only one submit button? if

Re: [PHP-DB] count from the results

2002-02-09 Thread olinux
In \"B\":  "; echo mysql_num_rows($result); echo ""; if (mysql_num_rows($result)) { echo ""; echo "Artists"; while ($qry = mysql_fetch_array($result)){ echo ""; echo ""; echo "$qry[artist] ($howmany)"; }}?> o

[PHP-DB] Creating Directory Search Engine

2002-02-07 Thread olinux
hile a search for 'auto repair' 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 Yaho

RE: [PHP-DB] arrays and email

2002-01-29 Thread olinux
st feature] 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: >

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

2002-01-28 Thread olinux
x27;m sure 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

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

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

2002-01-21 Thread olinux
n you could look up the current url_id for url_id's of similar articles? Thanks 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

[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

[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] 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 all

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

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

2002-01-07 Thread olinux
ay19990421.php3 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 > pro

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

2002-01-06 Thread olinux
Use 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); > > > > but that migth get a same number more then

[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 on

[PHP-DB] How much for a Job Site

2002-01-03 Thread olinux
ion (I 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 -- PH

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 w

Re: [PHP-DB] Passing parameter in Paging

2001-12-28 Thread olinux
om/search.php?keyword=something&start_at=31&end_at=45";>3 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 >

[PHP-DB] find a value by array key

2001-11-17 Thread olinux
ust 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 kn

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: >

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

2001-11-02 Thread olinux
D,CatParent,CatName from 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 -- PH

Re: [PHP-DB] category structure

2001-10-29 Thread olinux
S][] the unset removes a category once it's been printed Any ideas? I don't want to recursively hit the database a bunch of times. Thanks, olinux --- DL Neil <[EMAIL PROTECTED]> wrote: > > - Original Message - > From: "olinux" <[EMAIL PROTECTED]>

[PHP-DB] category structure

2001-10-28 Thread olinux
th 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?]

[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 search w/o specified categories

2001-10-23 Thread olinux
synonyms ? Thanks 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-ma

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? http://www.nextel.com/support/faq/textnumericmessagi

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 "food" or whatever tags you want to use. olinux --- Ma

[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 >

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 thi

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, 200

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 b

[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

[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 PROT

[PHP-DB] Storing last access

2001-07-30 Thread olinux o
_Name" 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 __

[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-DB] Checking radio buttons for multiple records/Updating multiple records...

2001-07-28 Thread olinux
E value together? 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 commands, e-mail

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 tw

[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

[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

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: [P

[PHP-DB] phpmyadmin troubles - creating tables

2001-07-24 Thread olinux
ckage INT not null , apartment VARCHAR (75) not null , apt_address VARCHAR (' at line 1 I have tried creating the table as type myisam and still no luck. Thank you, olinux _ Do You Yahoo!? Get your free @yahoo.com addre

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

2001-07-09 Thread olinux
ll boxes. Is there a way to do this. Or better yet, does 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

[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

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 he

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

2001-07-07 Thread olinux
; - if i choose open 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 Databas

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] 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] To

[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

[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

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 w

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 m

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

2001-06-30 Thread olinux o
, 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 begi

[PHP-DB] ereg_replace

2001-06-30 Thread olinux o
the matches] 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: [EMA

[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 = "<"; 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] ereg and first occurence

2001-06-29 Thread olinux o
extract 'NAME' from the following and not CITY? NAME CITY 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,

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

2001-06-29 Thread olinux
thing like ($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/) To unsubscri

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

2001-06-28 Thread olinux
lah..." It only gets worse 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] Subje

  1   2   >