[PHP-DB] File retrieval from DB

2001-01-24 Thread Beau Lebens
found. Please try again later. end message Not very helpful at all. SO now I am at a standstill, I am completely stuck, and no one else I know has come up with anything that can solve the problem yet - any assistance would be fantastic - thanks all. Beau -- Beau Lebens - Web Master In

Re: [PHP-DB] Target window.

2001-01-29 Thread Beau Lebens
o unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- PHP Data

[PHP-DB] Streaming a file from DB over SSL using IE

2001-01-30 Thread Beau Lebens
could possibly think of (a couple really dodgy work-arounds remain..) to no avail. Currently my system works for every browser under the sun (including lynx surprisingly!) except i cannot download any of the files saved in the database on an IE client. Thanks Beau -- Beau Lebens - Web Master

Re: [PHP-DB] Streaming a file from DB over SSL using IE

2001-01-30 Thread Beau Lebens
MySQL, does it work with data embedded in the PHP >program? Will test that ASAP and post the results. -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- PHP Database Mailing List (http://www.php.net/) To unsubscri

Re: [PHP-DB] Help Me!

2001-01-31 Thread Beau Lebens
_ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands,

Re: [PHP-DB] assoc arrays

2001-02-20 Thread Beau Lebens
them, or do they >go in the post_vars array? > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Beau Lebens - Web M

Re: [PHP-DB] advice

2001-02-20 Thread Beau Lebens
;Cell Phone: +351 96 5867227 >SMS: [EMAIL PROTECTED] >Email: [EMAIL PROTECTED] > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-ma

Re: [PHP-DB] Primary Key Value

2001-02-27 Thread Beau Lebens
y without running a separate select query against the table? > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Selecting number of news items on frontpage

2001-02-28 Thread Beau Lebens
>You could then issue as select statement like " select * from articles >limit 7 order by nArticleKey descending" (maybe it should be "top" >instead of "limit", check your MySLQ syntax) and feed those to the front page. select * from articles order by nArticleKey desc limit 7 although a bette

Re: [PHP-DB] Drop down box

2001-03-01 Thread Beau Lebens
t; > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail:

Re: [PHP-DB] Insert a file in a mysql database!

2001-03-05 Thread Beau Lebens
-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- PHP Database Mailing Li

RE: [PHP-DB] Scheduling php task

2001-03-05 Thread Beau Lebens
[EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EM

Re: [PHP-DB] Import

2001-03-07 Thread Beau Lebens
e-mail: [EMAIL PROTECTED] > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > >-- >PHP D

Re: [PHP-DB] alphabetical order

2001-03-07 Thread Beau Lebens
; To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAI

Re: [PHP-DB] php-mySQL and an SQL query

2001-03-08 Thread Beau Lebens
>name. > >I don't think it likes my subquery, though I like it just fine. > >Regards, >Michael > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To c

Re: [PHP-DB] Select where

2001-03-20 Thread Beau Lebens
e that the values in the db are always lower-case to get the match (i *think* it's case-sensitive off the top of my head) HTH Beau >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROT

Re: [PHP-DB] SSI

2001-03-21 Thread Beau Lebens
use the php function include("side-nav.php3"); >Thanks > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-

Re: [PHP-DB] PHP Include

2001-03-21 Thread Beau Lebens
l: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- PHP Database Mailin

RE: [PHP-DB] drop down list

2002-01-30 Thread Beau Lebens
apologies for answering such an already-over-answered question, but i feel that no-one has given a particularly *good* answer, so i'll add mine to the list. I use this function (as well as a couple others which do similar things for all form elements; // Creates an HTML select box of values. // $

RE: [PHP-DB] More Date operations.

2002-01-31 Thread Beau Lebens
you have changed the command from when you do it in mysql to when you do it in php - you are leaving out the "'" quote marks around the date you are passing :) // $sql="SELECT TO_DAYS(2001-01-01) AS bar"; should be // $sql="SELECT TO_DAYS('2001-01-01') AS bar"; HTH beau // -Original M

RE: [PHP-DB] javascipt window

2002-02-10 Thread Beau Lebens
Mike, you have a conflict with your different quote-styles, have a look at the source code when you output that and you will see what i mean, you need to do something like this; echo "".$format.""; HTH Beau // -Original Message- // From: Mike [mailto:[EMAIL PROTECTED]] // Sent: Monday,

RE: [PHP-DB] Email Validation

2002-02-11 Thread Beau Lebens
have a look at the online annotated php manual under the regular expression functions, there are *stacks* of examples of using regexps to validate email patterns beau // -Original Message- // From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 12 February 2002 12:20 PM //

RE: [PHP-DB] protecting

2002-02-11 Thread Beau Lebens
you might find the library at http://www.dentedreality.com.au/jsvalidation/ useful, but you should also perform similar checks server-side using PHP since if you are that worried about malicious use of your site, people can easily circumvent javascript validation // -Original Message- //

RE: [PHP-DB] RE: Logging visits using a database

2002-02-14 Thread Beau Lebens
i think i saw an article on phpbuilder.com regarding how to set up a good thing for the path taken - something along the lines of storing IP vs time vs page hit, then a good method for selecting from the db that shows the path of the visitor HTH beau // -Original Message- // From: Peter

RE: [PHP-DB] Session confusion :-(

2002-02-17 Thread Beau Lebens
are you always "refreshing" the session on each page dave? i am pretty sure you need to call session_start() on every page that you will be accessing the session-based variables. HTH beau // -Original Message- // From: Dave Carrera [mailto:[EMAIL PROTECTED]] // Sent: Saturday, 16 Febru

RE: [PHP-DB] sql query

2002-02-18 Thread Beau Lebens
try replacing WHERE display=$custcatergory"); with WHERE display='$custcatergory'"); and also tru echoing the value of that SQL statement (assign it to a var first) to make sure you are getting the right thing. HTH /b // -Original Message- // From: CrossWalkCentral [mailto:[EMAIL PR

RE: [PHP-DB] formating problem

2002-02-19 Thread Beau Lebens
htat's because the delete button is in the wrong place in your code. if you put an HTML element between the and tags, but don't enclose it in at least and tags (pretty loose about closing them, but of course you should always close your tags!) then the browser will display that element above

[PHP-DB] SELECT where something exists but something else does not

2002-02-20 Thread Beau Lebens
cord in the DB under thesis_reports that doesn't eqal '2002', even if they happen to also have one that *is* for 2002 (ie. my test student has a report for 1999, 2001 and 2002, but still gets selected by that -- Beau Lebens, Technical Officer Science and Mathematics Education Cen

RE: [PHP-DB] Join

2002-02-20 Thread Beau Lebens
what you are referring to actually has nothing to do with PHP Jen - that's why the manual wasn't much help :) JOIN is an SQL command, so check out the manual of your RDBMS (ie. http://www.mysql.com/doc/J/O/JOIN.html for MySQL) good luck :) Beau // -Original Message- // From: Jennifer D

RE: [PHP-DB] Still bangin my head

2002-02-25 Thread Beau Lebens
you would need to do a select and find out how much is in the "account" first, then do a check on the equation to see if the result is going to come out negative - if it is, then either don't allow it, or give them an option to clear the account or whatever, otherwise just go ahead and do the with

RE: [PHP-DB] Delete selected files

2002-02-25 Thread Beau Lebens
your checkboxes should pass a value (probably just the filename) and you could perhaps name them all "filenames[]" or something, using the array trick in PHP, so that on the page you submit to, $filenames will be an array containing everything that was checked. you can then loop thru the array an

RE: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread Beau Lebens
rather than all the hidden fields and stuff you guys are trying to do - why not just build the array variable you want, then save it into a session, on the next page, access the session variable and wallah - there's your array, still in tact and just as you left it (ie. containing all the info you

RE: [PHP-DB] why won't session_start() work?

2002-02-27 Thread Beau Lebens
Ryan, you need to make all of those calls *before* ANY output has been sent by your script, otherwise you can't send a header any more. so the TOP of a script might look like if you get what I mean. you can actually do a lot of coding before you start the session if you want, provided you ha

RE: [PHP-DB] accessing system cmds w/ PHP

2002-02-27 Thread Beau Lebens
JJ, I seem to recall most people saying that the shorthand works best $output = `chmod -R 777 *'; HTH beau // -Original Message- // From: Jeremiah Jester [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 28 February 2002 9:37 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] accessing syste

RE: [PHP-DB] I have a " in my db ?

2002-03-06 Thread Beau Lebens
try using echo htmlspecialchars($name); that wya the " will convert to a " and should display properly in the HTML (check your source before doing this, it is probably all there, but the " is causing HTML rendering problems or something) HTH Beau // -Original Message- // From: Dave

RE: [PHP-DB] GREATEST, LEAST

2002-03-11 Thread Beau Lebens
Is it perhaps actually MAX and MIN? SELECT MAX(profit) FROM schemes WHERE revenue>expenses (not tested, confirmed etc :P) HTH Beau // -Original Message- // From: Jeff Oien [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 12 March 2002 10:20 AM // To: PHP-DB // Subject: [PHP-DB] GREATEST,

RE: [PHP-DB] Renaming files after a name in a db field possible?

2002-03-13 Thread Beau Lebens
andy, this should be pretty basic - just try something along the lines of 1. SELECT country/codes from DB [1] 2. loop thru those results [2] a. check if a file called "country code"-map.gif exists[3], if it does, rename[4] it to matching "country name"-map.gif b. i

RE: [PHP-DB] PLEASE HELP !!!!!!!

2002-03-13 Thread Beau Lebens
try an IP // -Original Message- // From: Inter-Media Webmaster [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 14 March 2002 6:00 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] PLEASE HELP !!! // // // PLEASE HELP !!! // HOW I CAN GET CONNETCTION TO REMOTE HOST IN OTHER SERVER

RE: [PHP-DB] Random Selecting from mySQL

2002-03-13 Thread Beau Lebens
could you perhaps do the select on the first page, then store the results in a session (array) and just load different indexed portions of the resultset each page? only problem there is that you wouldn't get any refreshed results while browsing those pages - but i don't know if this matters for y

RE: [PHP-DB] Selecting random record from a database?

2002-04-02 Thread Beau Lebens
SELECT * FROM quotes ORDER BY RAND() LIMIT 1 something like that, take a quick look in the MySQL (or other) docs for the RAND() function. HTH Beau // -Original Message- // From: Dan Swensen [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 3 April 2002 1:45 PM // To: [EMAIL PROTECTED] //

RE: [PHP-DB] Date Question

2002-04-03 Thread Beau Lebens
Jennifer, assuming you are using MySQL, then I would imagine the field which is updating itself automatically is actually a TIMESTAMP type, rather than plain DATE (or perhaps DATESTAMP?) The *STAMP ones will update themselves I am pretty sure - but you might want to check this. HTH Beau // ---

RE: [PHP-DB] saving details problem (big)

2002-04-04 Thread Beau Lebens
Dave, would it be possible (not ideal, but might work) to do something like this; - user fills out form - user clicks submit - submit fires off 2 events, one submits to AFD server, the other opens a new window, behind the current, submits certain values (the 3 new ones) and saves them into the

RE: [PHP-DB] Local to Global Variables

2002-04-11 Thread Beau Lebens
if it is within a function, then you should define the var outside the function, then inside the function you can do this; $foo = "bar"; function foobar() { global $foo; $foo .= " bar"; } echo $foo // will output "bar bar"; HTH Beau // -Original Message- // From: eat pasta ty

RE: [PHP-DB] Upload Multiple Images

2002-04-11 Thread Beau Lebens
brandon, you can only ever upload 1 file per "file" input box, but you can have more than one of these input fields per form. you might have something like that way when you are processing (assuming PHP4+) you can use something like $HTTP_POST_FILES["file2"]["name"] blah blah hope that hel

RE: [PHP-DB] Limitations on sending text to a database via text area forms

2002-04-17 Thread Beau Lebens
could you perhaps save the contents directly into a file, then read the file into the database? I know for a fact (http://www.dentedreality.com.au/webpad/) that you can use a textarea to pump more info than that into a file, but haven't tried doing it straight into a database. HTH Beau //

RE: [PHP-DB] REG_BADRPT

2002-04-18 Thread Beau Lebens
basically it means that you have an invalid regular expression pattern in a regex function. i think it's something to do with the . * ? + symbols - but just take a good look at your pattern and somewhere in there it is invalid :) HTH Beau // -Original Message- // From: Camelia Enderby

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

2002-04-18 Thread Beau Lebens
there might even be some cool SQL you can use tho, which would avoid having to get the data out and then put it back in again. I *think* (don't quote me on this) I remeber seeing something like UPDATE myTable SET myField = CONCAT(myField + 'new string of stuff here') WHERE myID='1' HTH beau

RE: [PHP-DB] Upcoming event script

2002-05-12 Thread Beau Lebens
assuming you are using a date format field, you can do something like (not tested, please check syntax!) $SQL = "SELECT text FROM events WHERE date < " . date("Y-m-d") . " SORT BY date DESC LIMIT 1"; good luck Beau // -Original Message- // From: Andrew [mailto:[EMAIL PROTECTED]] // Sen

RE: [PHP-DB] Link for next db record

2002-05-12 Thread Beau Lebens
jen, assuming you are "currently" looking at a page which is something like php.php?record=3, then you should be able to just do Previous recordNext record and then on the php.php page, you would obviously being grabbing something from the database using a unique identifier or similar. one "got

RE: [PHP-DB] Link for next db record

2002-05-12 Thread Beau Lebens
ot;; // echo "Previous // Record"; // echo "Next // Record"; // echo "Search Another Record"; // // I can get the first record say I choose space 35 if I click // the link for // $row[rv_space]+1 then it returns a blank page what can I do // to fix this? //

RE: [PHP-DB] Link for next db record

2002-05-13 Thread Beau Lebens
3 May 2002 3:14 PM // To: [EMAIL PROTECTED] // Subject: Re: [PHP-DB] Link for next db record // // // This line sets $row["rv_space"] // echo"Search Record by Space Number //  "; // // // // "Beau Lebens" <[EMAIL PROTECTED]> wrote in message // news:[E

RE: [PHP-DB] IIS - hangs up after one hour

2002-05-13 Thread Beau Lebens
Memory Leak? check task manager periodically over that time to see how much memory IIS is hogging (under "Processes" - you might have to add the column "Mem Usage") Other than that... my only suggestion would be to upgrade to Apache :) (and yes, I intentionally use the phrasing - upgrade :) Bea

RE: [PHP-DB] SELECTING a sentence from a text field?

2002-05-13 Thread Beau Lebens
Larry, take a look in the MySQL manual (or other SQL reference, but MySQL has it there) String Functions http://www.mysql.com/doc/S/t/String_functions.html Particularly, look at (no named anchors that I can see :) LOCATE(substr,str,pos) ie, you could use perhaps LOCATE(" ", yourField, 95) ? H

RE: [PHP-DB] DROP tables with prefix match

2002-05-15 Thread Beau Lebens
if it's only a one-off thing, you could use php to get all table names (mysql_list_tables) and then go thru and create an array of the names that match your criteria, then go thru that array and DROP each one progressivly. HTH Beau // -Original Message- // From: John Hughes [mailto:[EMA

RE: [PHP-DB] SORT resutls

2002-05-21 Thread Beau Lebens
ORDER BY foo [ ASC | DESC ] // -Original Message- // From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 22 May 2002 10:42 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] SORT resutls // // // I am using the code bellow however this is not a proper way // to sort my

RE: [PHP-DB] HELP USING THE MAIL FUNCTION WITH HTML

2002-05-26 Thread Beau Lebens
you have to change the Content-Type header or something (text/html) but the easiest way is to use a pre-packed class (unless you really want to do it yourself). Check out hotscripts or just do a google for "php mail class" or similar :) HTH Beau // -Original Message- // From: CrossWalkC

RE: [PHP-DB] dropping one word from column entries

2002-05-29 Thread Beau Lebens
A cleaner option might be to do this before you get it to PHP at all, via your SQL query. Check out the string functions available, there are a number of substring-style things available, string position etc. HTH Beau // -Original Message- // From: Ed Gorski [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] mysql exclusion in php

2002-05-29 Thread Beau Lebens
chris, you'll need to do a little PHP manipulation, perhaps (pseudo) if "- SQL .= " NOT LIKE '%% AND'" endforeach endif for each SQL .= " LIKE '%%' AND" endforeach strip trailing "AND" clean up SQL as required query db - ok, obviously that's ve

RE: [PHP-DB] Truncated Data

2002-05-29 Thread Beau Lebens
htmlspecialchars() Beau // -Original Message- // From: Larentium [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 30 May 2002 10:40 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Truncated Data // // // Hello, // // I desperately need help... I've based my entire project on // the us

RE: [PHP-DB] random

2002-06-04 Thread Beau Lebens
substr($foo, 0, 3); check the other string functions in the manual - they are *very* useful Beau // -Original Message- // From: Natividad Castro [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 5 June 2002 3:57 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] random // // // hi to all, /

RE: [PHP-DB] values across functions

2002-06-05 Thread Beau Lebens
have you declared the variables as global int eh function? eg function foo($bar) { global $this, $that, $theOther; [...] } that way $this, $that and $theOther variables are available everywhere HTH Beau // -Original Message- // From: James Kupernik [mailto:[EMAIL PRO

RE: [PHP-DB] CSV/TXT file imported via PHP into MySQL

2002-06-10 Thread Beau Lebens
Keiran, in your second page, you refer to $textfile as the thing that you want to load into the database; this file doesn't exist on the server, so it is inserting nothing I would imagine. You need to use something like $_FILES['tmp_name'] to refer to the actual file, once it has been successfull

RE: [PHP-DB] E-mail address verification

2002-06-23 Thread Beau Lebens
also, you might like to do some client-side validation before sending it to the server, in which case you can use somehting like http://www.dentedreality.com.au/jsvalidation/ HTH Beau // -Original Message- // From: [EMAIL PROTECTED] // [mailto:[EMAIL PROTECTED]] // Sent: Friday, 21 June

RE: [PHP-DB] Excel to MySQL??

2002-06-30 Thread Beau Lebens
make sure there are no "#" chars in there, unless you have commented lines out (as below) # commented line in phpMyAdmin that is a comment, and the way it reads, if there's a # on a line, it comments from there onwards (from memory) HTH Beau // -Original Message- // From: Chase [mailt

RE: [PHP-DB] disable backbutton

2002-07-07 Thread Beau Lebens
sander, this isn't so much a problem with people using the back button or whatever, but if you set all your pages not to cache header("Expires: 0"); header("Cache-Control: no-cache"); will do that, then also require a cookie once they are logged in. during the logout process (and have the cookie

RE: [PHP-DB] Urent please

2002-07-07 Thread Beau Lebens
how about when u open the new window (using something like window.open(...)) you make it open a URL something like foobar.php?var1=foo and then on that page (foobar.php) you can grab the value of "$var1" as "foo" HTH Beau // -Original Message- // From: its me [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] Form field problem

2002-07-08 Thread Beau Lebens
Keiran, A couple possibilities for you; 1. Try referring to the field (in JavaScript) as something like; (might have to play around with this) document.existing["groupchoice[]"].selectedIndex 2. Make it so that each selection on the tag is mirrored into another hidden input field (onSelect=>)

RE: [PHP-DB] Session data not being deleted on browser close.

2002-07-08 Thread Beau Lebens
have you closed all browser windows? eg. if you open your browser, then spawn a new window (ctrl-n or similar) then do something with one of them which creates session vars, then close that window, then open a new one again, the session has probably remained active because the first window was st

RE: [PHP-DB] A Simple Question

2002-07-09 Thread Beau Lebens
Also, as far as limitations go, the following are considerations; 1. You can't pass an array using the querystring 2. Multiline variables (ie. contents) are bad 3. There is a limit of 255 or something characters to a URI (someone?) 4. Be careful with the $_GET[] array that Tony mentions, it is o

[PHP-DB] Apache DBM/htaccess Management with PHP

2002-07-10 Thread Beau Lebens
quot; in a sexist manner :P). Beau -- Beau Lebens, Technical Officer Science and Mathematics Education Centre Curtin University of Technology, GPO Box U1987 Perth, Western Australia 6845 CRICOS provider code 00301J t: +61 8 9266-7297 (has voice-mail) f: +61 8 9266-2503 (ATT: Beau L

RE: [PHP-DB] A Simple Question

2002-07-10 Thread Beau Lebens
then on link.php you'd have the array $array[] (with globals) or $_GET['array'][] cool Beau -Original Message- From: Adam Royle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 10 July 2002 9:05 PM To: Beau Lebens; [EMAIL PROTECTED] Subject: RE: [PHP-DB] A Simple Question

RE: [PHP-DB] "resource ID #3"

2002-07-11 Thread Beau Lebens
Jonathan, most (all?) of the database query-related functions in PHP return a "Resource ID" which contains the data resulting from your query. To access that information, you need to pass the Resource ID thru a function like (assuming u r using MySQL) mysql_fetch_array() or mysql_fetch_row() Have

RE: [PHP-DB] change data before its sent to db?

2002-07-16 Thread Beau Lebens
Chip, a couple ideas 1. why not display the select list something like this Please Select January February ... That way the user sees the names of the months, but your database gets sent nice, easy-to-deal-with numbers? 2. What didn't work with your monthname=>number assignment routine? you s

RE: [PHP-DB] TEXTAREA ...

2002-07-18 Thread Beau Lebens
do i understand the question correctly? you are getting a "" when you are expecting a "" ? if that's the case then the simple answer (and as Jason pointed out, this is in the manual) is that it's the same thing, but with the " /" in it, it becomes XHTML compliant. As copied directly from the ma

RE: [PHP-DB] or statement in url

2002-07-18 Thread Beau Lebens
or alternatively just do something similar to what you did, using either the in-built array handling, or your own string manipulation ie. http://url.com/page.php?var1=foo http://url.com/page.php?var1=bar could be either; http://url.com/page.php?var[]=foo&var[]=bar ($_GET["var"] will be an arra

RE: [PHP-DB] php and javascript?

2002-07-22 Thread Beau Lebens
Bo, you have really answered your own question (question 1) all you need to do is replace http://detination with http://localhost/index.php?id=1 (as per your examples) and it should send them to the page which triggers the deletion of the page (if they confirm the box) as far as q2 goes, you coul

RE: [PHP-DB] Global variables, $_GET problem

2002-07-23 Thread Beau Lebens
Ruth, your reference to $_GET('var') is close, but as you have seen - no cigar :) using the "()" after GET makes it refer to a function, but it is actually an array which is automatically created, so you need to use $_GET['var'] (note the square brackets as for point 2 (register_globals) did yo

RE: [PHP-DB] Resetting MySQL Auto_Index - How?

2002-07-24 Thread Beau Lebens
monty, i found that if you do the command DELETE FROM table (with no WHERE clause) it deletes everything, and resets Beau // -Original Message- // From: Monty [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 25 July 2002 1:34 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Resetting MySQ

RE: [PHP-DB] php mysql external server

2002-07-31 Thread Beau Lebens
Meethoo as it says in the PHP documentation, you can access a MySQL server whether it's on the same machine as the PHP install or not. ie. mysql_connect('localhost', $user, $pass) OR mysql_connect('111.111.111.111', $user, $pass) Beau // -Original Message- // From: Meethoo Salim [mailto

RE: [PHP-DB] Log Application Help...

2002-08-13 Thread Beau Lebens
Scott, can you just do it by sorting your query, then limiting the results to 10? ie. SELECT * FROM tables WHERE somthing='1' ORDER BY date DESC LIMIT 10 should sort highest -> lowest date (ie most recent, backwards) and give you the top 10 results. then if you have the option of flipping thru

RE: [PHP-DB] MySQL/PHP

2002-08-29 Thread Beau Lebens
try a little thought... http://www.google.com/search?sourceid=navclient&q=php+mysql+tutorial // -Original Message- // From: Bryan McLemore [mailto:[EMAIL PROTECTED]] // Sent: Friday, 30 August 2002 2:52 PM // To: PHP LIST // Subject: [PHP-DB] MySQL/PHP // // // Where can I find a goo

RE: [PHP-DB] What's wrong with this code?

2002-09-01 Thread Beau Lebens
I'd use var inclusions like this; VALUES ('" . $_POST['Name'] . "', that might help you // -Original Message- // From: Shoulder to Shoulder Farm [mailto:[EMAIL PROTECTED]] // Sent: Monday, 2 September 2002 11:42 AM // To: PHP Database List // Subject: [PHP-DB] What's wrong with this c

RE: [PHP-DB] External file integryti check

2002-09-03 Thread Beau Lebens
can't you just make the name of the file include a unique identifier of some sort, or store each user's files in a different directory or something, to make sure that they can't overwrite each other's (or their own) files? Or would that not work in your app? HTH Beau // -Original Message--

RE: [PHP-DB] Upload csv file into mysql

2002-09-03 Thread Beau Lebens
try phpMyAdmin - nice and easy, although i'm pretty sure there is a direct command line. // -Original Message- // From: Dr. Indera [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 4 September 2002 12:21 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Upload csv file into mysql // // //

RE: [PHP-DB] Apache 2.X and PHP

2002-09-08 Thread Beau Lebens
i'm running php 4.2.2 and apache2 on my win2k laptop and it appears to be running fine (stable etc) but obviously only as a dev platform, so not under any sort of load or anything like that. also not running particularly complex operations, so don't know about how it will handle that :) but it wo

RE: [PHP-DB] 's "id" and "name" -- question...

2002-09-17 Thread Beau Lebens
nope - an id is used for other things (like javascript, style sheets, DHTML etc). They shouldn't affect your variable names. HTH Beau // -Original Message- // From: Michael Zornek [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 18 September 2002 6:41 AM // To: [EMAIL PROTECTED] // Subje

RE: [PHP-DB]opening and reading from file

2002-09-22 Thread Beau Lebens
just use should work. your parse error is probably because of the "\" in your filename, you need to escape them with another "\". HTH Beau // -Original Message- // From: roslyn jose [mailto:[EMAIL PROTECTED]] // Sent: Monday, 23 September 2002 12:54 PM // To: [EMAIL PROTECTED] // Sub

RE: [PHP-DB]opening and reading from file

2002-09-22 Thread Beau Lebens
, // i tried what u told me but im still getting the same error // at the fopen(.). any other bright ideas. please help. thanx alot // // // // regards, // roslyn // Beau Lebens wrote:just use // // $filename = "C:\\Documents and Settings\\roslyn\\My // Documents\\note.txt";

RE: [PHP-DB]opening and reading from file

2002-09-22 Thread Beau Lebens
// // html // // // // // // // // // regards, // // roslyn // // Beau Lebens wrote:what exact error are you getting, and // what line is it on etc? // // beau // // // // -Original Message- // // From: roslyn jose [mailto:[EMAIL PROTECTED]] // // Sent: Monday, 23 September 2002 1:07 PM // //

RE: [PHP-DB] Query error

2002-10-02 Thread Beau Lebens
If it's on MySQL, then the problem is that it doesn't support nested queries :) If it's on something else, i'm afraid i don't know :/ Back to MySQL, you can get around that by doing your "select author_code from authorxcat" component query, then put the results into 'x', 'y', 'z' format, then do

RE: [PHP-DB] Set Cookies

2002-10-15 Thread Beau Lebens
what's on lines 1 and 2? you can't have *any* output before you set a cookie. HTH Beau // -Original Message- // From: Steve Dodkins [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 15 October 2002 4:25 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Set Cookies // // // Hi // // I'm tr

RE: [PHP-DB] displaying flash from db

2002-10-21 Thread Beau Lebens
*** APOLOGIES FOR CROSS POSTING *** I haven't done this directly, but I imagine the process would be similar to working with images, and the same restrictions/rules of thumb would apply regarding storing them in the db versus storing them on the filesystem, i.e. store the flash files in the filesy

RE: [PHP-DB] exporting to xml

2002-10-29 Thread Beau Lebens
you don't see them because they are interpreted as HTML tags, they are unknown, so they are ignored. options; 1. View -> Source 2. Encode all "<" as < (HTML version) and it will display it all as text, then you can copy-paste it to somewhere else 3. Wrap it all in a tag, then follow 2. 4.

RE: [PHP-DB] string

2002-10-31 Thread Beau Lebens
you can do this as a part of your db query check the string functions available for your rdbms. mysql would use something like; SELECT SUBSTRING(monthname(blah), 0, 3) AS monthAbbrev FROM tablename from memory HTH beau // -Original Message- // From: John Coder [mailto:jcoder@;insight

RE: [PHP-DB] Warning - newby question -- $_GET

2002-11-06 Thread Beau Lebens
did you try echoing the value of $id after you have assigned it? you may find it's because you aren't connected to your database or something and also, i am assuming that you are using a recent install/verison of PHP, because $_GET wasn't available until the last few releases. beau // -Ori

RE: [PHP-DB] A Question on Javascript

2002-11-13 Thread Beau Lebens
Not that there is actually a question in there... I assume your question is "How do I pass a value from a window which was opened via JavaScript, back to the window which opened it" Short answer: "window.opener" <-- read up in a javascript reference manual about this object. Longer answer aft

RE: [PHP-DB] standart variabels melfunction

2002-11-19 Thread Beau Lebens
[php.ini] register_globals=On Beau // -Original Message- // From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 20 November 2002 12:41 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] standart variabels melfunction // // // Hi all, // // I have a problem with my se

RE: [PHP-DB] implode()

2002-11-25 Thread Beau Lebens
implode accepts an *array* as input, not a string. you would need to change your $sqlUpdate to be an array, and each statement look something like; if($textfield12 != '') { $sqlUpdate[] = "textfield12='$textfield12'"; } of course it would probably be easier to just do something like this; if($ima

RE: [PHP-DB] Assign a variable with another variables value

2002-12-01 Thread Beau Lebens
// Example: $foo = "BAR"; ${'new' . $foo} = "some string"; // this should do it i think, in this case creating a var called "$newBAR" HTH Beau // -Original Message- // From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] // Sent: Monday, 2 December 2002 10:30 AM // To: [EMAIL PROTECTED]

RE: [PHP-DB] calling function on submit instead of going to a new script

2002-12-04 Thread Beau Lebens
long story short - you can't you can only call a function in javascript or some other client-side scripting language like that, and you would use the onSubmit="" attribute of the tag. by the sounds of what you want to do - i would say you would do something like; 1. load values from db and disp

  1   2   >