[PHP-DB] autoincrementing ? and a little database structure

2001-02-02 Thread olinux
ct them to use this number to insert apartments? I am really confused right now, I know that there are some problems in my thinking so letme know if you spot these areas. Thanks much, olinux _ Do You Yahoo!? Get your free @yahoo.com addre

[PHP-DB] redirection based on login username

2001-02-06 Thread olinux
each could theoretically have unlimited agents. Just keep adding numbers after the "base" ID So, anyone have any ideas to go about this, I don't think that I can use a DB, unless maybe it was a flat text file... [never worked with those befo

[PHP-DB] storing checkbox data to DB

2001-02-07 Thread olinux
if anyone checks it out, maybe you can tell me why I have a Blank screen. thanks olinux ICQ me at 81933324 _ 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] [php-db] php install?

2001-03-01 Thread olinux
.html?tag=st.dl.10001- 103-1.lst-7-1.2711921 olinux -Original Message- From: Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 3:57 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] [php-db] php install? Hey, looking for a hand here. System Running: Win 98, Apache

Re: [PHP-DB] Where do I get started?

2001-03-08 Thread olinux
but i needed a quick references [ tiny little $13 book ] antoher great book is HTML 4: No Experience required by Sybex Books. olinux - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 08, 2001 4:59 PM Subject

Re: [PHP-DB] Resource for PHP and other technologies

2001-03-11 Thread olinux
AWESOME man! I will definitely be back to check it out more in depth. olinux - Original Message - From: "narsu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 09, 2001 2:35 PM Subject: [PHP-DB] Resource for PHP and other technologies > I

[PHP-DB] must I "while" loop

2001-03-12 Thread olinux
uestion, shouldn't I be able to use the variables $company $fname $lname before the WHILE loop since I know that there is only one record? olinux

[PHP-DB] storing checkbox data in DB - very cool

2001-03-13 Thread olinux
work. I am not very familiar with functions so it is probably obvious what i am missing. i would love to figure this out, so if you can help me [or we could help each other] I would appreciate it! you may ICQ at 81933324 thanks much, olinux

[PHP-DB] 2 while loops - 2 tables

2001-03-14 Thread olinux
mysql_fetch_array($result)) { $apt_ID = $row['apt_ID']; $feature1 = $row['feature1']; $feature2 = $row['feature2']; $feature3 = $row['feature3']; } $table_block .= "[ this contains HTML code for table rows to display data ]"; } Thanks Much! olinux

[PHP-DB] SELECT * vs. SELECT field, field, field

2001-03-14 Thread olinux
erstand that they do the same thing. Just wondered if there is a difference in execution speeds. I realize that its probably trivial, but I'm curious. thanks olinux

Re: [PHP-DB] 2 while loops - 2 tables

2001-03-16 Thread olinux
l web development/design > www.ryanflynn.com - Original Message - From: "Ryan Flynn" <[EMAIL PROTECTED]> To: ""olinux"" <[EMAIL PROTECTED]> Sent: Thursday, March 15, 2001 7:40 PM Subject: Re: [PHP-DB] 2 while loops - 2 tables > _

[PHP-DB] dynamic columns

2001-03-16 Thread olinux
perty of item 1 that corresponds to field_2 */ /* Now here we put an if statement that counts the number of records that were displayed and doe something based on that number */ $comparison_table = " $field_1 $item_1_1"; I don't know! Now I am lost, please help me if you can. Thanks olinux

Re: [PHP-DB] PHP mysql_connect Access Denied

2001-03-19 Thread olinux
NT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost; mysql> GRANT USAGE ON *.* TO dummy@localhost; olinux - Original Message - From: "Mat

[PHP-DB] comparison table script

2001-03-22 Thread olinux
le or if/for loop */ if ($car_ID[$next] != "") $table .= "$car_ID[$next]"; So basically that is as far as i have got. I would appreciate if anyone can provide some direction Thanks much, olinux

Re: [PHP-DB] Going bonkers again ...

2001-03-23 Thread olinux
You have to escape your "" > $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = > '$m_id'"; try this $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id = \"$m_id\" "; - Original Message - From: "Martin Skjöldebrand" <[EMAIL PROTECTED]> To: <

Re: [PHP-DB] comparison table script

2001-03-23 Thread olinux
t;abc"; $a[1]="def"; After an array_flip() you get: $a["abc"]=0; $a["def"]=1; gotta love it! olinux > De: olinux <[EMAIL PROTECTED]> > Para: <[EMAIL PROTECTED]> > Enviada em: sexta-feira, 23 de março de 2001 12:37 > Assunto: Re: [PHP-DB] co

[PHP-DB] re-using arrays

2001-03-24 Thread olinux
(); session_register('last_search'); $last_search = $result_of_query Any thoughts? I was just thinking that once the client has the results on his/her machine, then there should be no need to reconnect to the DB (unless the search is different) Thanks much, olinux

[PHP-DB] uploading files.

2001-03-24 Thread olinux
e... It looks set to me :) puzzled, olinux [who thanks you all greatly]

Re: [PHP-DB] uploading files.

2001-03-24 Thread olinux
mmmK, i have figured it out, anyone want it? lemme know olinux - Original Message - From: "olinux" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "PHP-DB" <[EMAIL PROTECTED]> Sent: Saturday, March 24, 2001 4:27 PM Subject: [PHP-DB] uploading file

RE: [PHP-DB] uploading files.

2001-03-25 Thread olinux
here is the working script on my local windows machine. note that you will need to change $the_path Everything is pretty self explanatory. You can read the article that I took this from at http://phpbuilder.com/columns/bealers2904.php3 olinux

[PHP-DB] Re: [PHPLearners] uploading files.

2001-03-25 Thread olinux
here is the working script on my local windows machine. note that you will need to change $the_path Everything is pretty self explanatory. You can read the article that I took this from at http://phpbuilder.com/columns/bealers2904.php3 olinux

Re: [PHP-DB] MySQL for Billng Question

2001-03-26 Thread olinux
a whole lot of mySQL functions, it's a wonderful little reference and I have learned some neat things real fast. I understand that it is far from "complete" but i feel it is worth it for me [starting out] olinux - Original Message - From: "Jeff Oien" <[EMAIL P

Re: [PHP-DB] PHP/MySQL Program

2001-03-26 Thread olinux
I would suggest going to www.hotscripts.com they have a marvelous collection of all sorts of scripts - content management, database crap, pretty much everything. I think that if actually learning the PHP, mySQL is not going to happen these scripts would work quite well olinux - Original

Re: [PHP-DB] Help Export Excel to MySQL database

2001-03-27 Thread olinux
save the file as a .csv [comma delimited] file and you will be able to import that into mysql. sorry, that's as much as i know. olinux - Original Message - From: "John" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 27, 2001 4:14 PM Subject:

[PHP-DB] checkbox data

2001-03-27 Thread olinux
Does anyone else work with ceckbox data in their DB? thanks much, olinux

Re: [PHP-DB] post method

2001-03-28 Thread olinux
just change the FORM action attribute to action="http://www.web.com/comunidad/directorio/directio.php" olinux - Original Message - From: "Gaby" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 28, 2001 5:04 AM Subject: [PHP-DB] post m

[PHP-DB] global vars

2001-03-28 Thread olinux
ble, WHERE uid = $uid"; mysql_query($q); } ... function create_checkbox_query($arr, $table, $uid) { global $table_name; $q = "INSERT INTO $table (uid, skill_id) VALUES"; foreach ($arr as $check) { $q .= " ( $uid , $check )" . ","; } return substr($q, 0, -1); } insert_skills("1", $skills); thanks much, olinux

Re: [PHP-DB] global vars

2001-03-28 Thread olinux
nevermind, sorry it was a stupid comma in my sql query... what i have is very sool tho, so if you would like the script its great! i derived it, almost entirely from Dan LaFlamme's NOT working script at http://phpbuilder.com/columns/laflamme20001016.php3 olinux - Original Message -

[PHP-DB] functions and using vars outside of them

2001-03-28 Thread olinux
need to call the function skill_search($skills); but this does not make the variables inside the function available. thanks much, olinux

[PHP-DB] multiple file uploads

2001-04-01 Thread olinux
/jump.cgi?ID=9644 the second is supposed to be a multiple file uploader, but i could not get it to work. you can see what i have compiled so far. http://www.angelfire.com/ak5/olinux/mult_upload.txt thans much, olinux

[PHP-DB] ecommerce - storing as an array or temporary record

2001-04-01 Thread olinux
insert the records as they come in - each form - ? I am thinking that one connection to the DB might be easiest to carry out. thanks much, olinux

Re: [PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread olinux
you can, choose the database on the left hand side and you will se all of your tables in that db on the right with the option to EMPTY olinux - Original Message - From: "Naga Sean" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 02, 2001 12:25 AM Su

[PHP-DB] storing arrays in sessions

2001-04-02 Thread olinux
I searched some for this and found nothing that didnt confuse me more how can i store an array in a session? Must I register each variable and then put them into the array? Can you provide an example? thanks much, olinux

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

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

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

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

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

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

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

[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

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

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

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

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

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

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

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

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

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

Re: [PHP-DB] HELP URGENT

2001-04-04 Thread olinux
here are some links to free tree menu scripts http://www.hotscripts.com/Detailed/8821.html - UltraTree http://www.hotscripts.com/Detailed/9035.html - iScouter Smart Tree View http://www.hotscripts.com/Detailed/3704.html - PHP TreeMenu let me know how they work, please? olinux - Original

[PHP-DB] display formatting with a while loop

2001-04-04 Thread olinux
al 1 they do not print anything] My problem is, i do not know how to get these inserted. I have about 15 fields so i would like to be able to display them in table cells of 4 or 5 each. Thank you, olinux

Re: [PHP-DB] display formatting with a while loop

2001-04-04 Thread olinux
what if i put the if statements inside of another if statement and then set the $i back to 1. if ($1 = 4) { $display .= ""; $i = 1; } how exactly would i do this, or is it totally wrong? olinux - Original Message ----- From: "olinux" <[EMAIL PROTECTED

Re: [PHP-DB] Problem with frames

2001-04-05 Thread olinux
there is no "$" when registering then begin each frame with and all of your registred variables will be available! olinux - Original Message - From: "Bartek Pawlik" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 11:56 PM Subject: [P

[PHP-DB] sessions and page has expired warning

2001-04-08 Thread olinux
know that pressing refresh works fine, but some people do not understand and get confused. How can i fix this? thanks much olinux

Re: [PHP-DB] PHP & MySql

2001-04-08 Thread olinux
Try removing the last comma in your update statement change: com_type=$com_type, WHERE to: com_type=$com_type WHERE olinux - Original Message - From: "Jonathan Underfoot" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 08, 2001 4:16 PM Subject

[PHP-DB] inserting a timestamp

2001-04-18 Thread olinux
hey all, I am having a hell of a time getting a timestamp to insert correctly. it keeps coming up 00 here's what i have

[PHP-DB] inserting a timestamp

2001-04-18 Thread olinux
e prob, but i do not know thanks much olinux

Re: [PHP-DB] PHP and MySQL

2001-04-19 Thread olinux
try the tutorial at www.thickbook.com or at www.devshed.com for setting everything up. olinux - Original Message - From: "Mike Corredea" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 10:02 AM Subject: [PHP-DB] PHP and MySQL >

Re: [PHP-DB] Values for Popdownmenu (Categorie and Subcategorie) from MySQL

2001-04-21 Thread olinux
if you want to got the jscript route, try something like this http://www.a1javascripts.com/site_navigation/doublecombo/doublecombo.html then just figure how you want to insert the variables. shouldn't be too hard, just match things up from the working script to the new one. o

[PHP-DB] extracting login name

2001-04-25 Thread olinux
Hey all, I have a htpsswd protected directory and would like the client to only log on once. Is there a way i can get their USERNAME so that i can pull the correct records from the db? thanks much olinux

[PHP-DB] dynamic input tyep text updates

2001-05-07 Thread olinux
hey all, I am trying to create a form that does the following: [ i have most of it done] 1. queries the db and gets the values of the ID, TITLE, and FILENAME columns in a table 2. creates a form with the TITLE with the filename echoed if it exists 3. on submission the form update the FILENAME

[PHP-DB] dynamic form inputs and updating

2001-05-07 Thread olinux
PDATE executes correctly. thanks much, olinux Here's some of my code. This generates the form inputs while ($row = mysql_fetch_array($result)) { $id = $row['id']; $title = $row['title']; $filename = $row['filename']; $form .= "$title

Re: [PHP-DB] super simple....... but!

2001-04-21 Thread olinux
uot;); print ("Connection successful!"); olinux - Original Message - From: "Francois Boucher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 21, 2001 1:34 PM Subject: [PHP-DB] super simple... but! > I wrote this code but no

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 with

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

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

[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

[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

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

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

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

[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

  1   2   >