[PHP-DB] redirection based on login username

2001-02-06 Thread olinux
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 before:)] Thanks M

[PHP-DB] storing checkbox data to DB

2001-02-07 Thread olinux
teresting, 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.

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

2001-03-08 Thread olinux
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] Where do I get

[PHP-DB] must I while loop

2001-03-12 Thread olinux
the variables $company $fname $lname before the WHILE loop since I know that there is only one record? 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
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 _ Apartment 1

[PHP-DB] dynamic columns

2001-03-16 Thread olinux
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 = " TR TD$field_1/TD TD$item_1_1/TD"; 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
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: "Matt Coyne" [EMAIL PROTECTED] To: [E

[PHP-DB] comparison table script

2001-03-22 Thread olinux
[$next] != "") $table .= "TD$car_ID[$next]/TD"; 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 Skjldebrand" [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 maro de 2001 12:37 Assunto: Re: [PHP-DB] comparison table script You c

[PHP-DB] uploading files.

2001-03-24 Thread olinux
this script and though i found an answer to the file://php2 thing [it was a stripslashes() solution] I am getting an error with this script that there is an unset variable... It looks set to me :) puzzled, olinux [who thanks you all greatly]

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

[PHP-DB] checkbox data

2001-03-27 Thread olinux
pler way. Does anyone else work with ceckbox data in their DB? 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 - From

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

2001-03-28 Thread olinux
will 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
to 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 Subject: [PHP-DB]

[PHP-DB] display formatting with a while loop

2001-04-05 Thread olinux
t equal 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-05 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 .= "/tdtd"; $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
quot; when registering then begin each frame with ? session_start(); ? 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: [PHP-DB] Problem

[PHP-DB] inserting a timestamp

2001-04-18 Thread olinux
b, 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 I just downloaded MySQL-3

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. 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 INPUT type=text with the filename echoed if it exists 3. on submission the form

[PHP-DB] dynamic form inputs and updating

2001-05-07 Thread olinux
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 input type=\text\ name=\$id\ size=15 maxlength=20; if ($filename

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

2001-04-21 Thread olinux
mysql_connect returns a positive MySQL link identifier on success, or an error message on failure. You are testing for True/False a better way to do your test would be $link = mysql_connect (localhost, username, password) or die (Could not connect); print (Connection successful!); olinux

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

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

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

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

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

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

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

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

[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

[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

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

[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

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

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

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

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

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

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

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

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

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

[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

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

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

[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] 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: Hi there, I am

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

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

[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

  1   2   >