[PHP-DB] Re: reload page

2001-08-14 Thread Russ Michell
() function: if (isset($refresh)) { header(Location: $PHP_SELF); } HTH :-) Russ On Tue, 14 Aug 2001 10:54:59 -0400 Hugh Bothwell [EMAIL PROTECTED] wrote: Schleipp [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi everybody, I have

Re: [PHP-DB] Re: reload page

2001-08-14 Thread Russ Michell
the first (origin) frame. Maybe you should re-state your problem and indicate use of DB's in there too, as I may easily have got the wrong end of someone else's stick. Cheers. Russ On Tue, 14 Aug 2001 11:09:28 -0400 Hugh Bothwell [EMAIL PROTECTED] wrote: Russ Michell [EMAIL PROTECTED] wrote

Re: [PHP-DB] blinking background

2001-08-09 Thread Russ Michell
in the table right? For people to look at and assimilate!? I'm aware of the concept A bad idea - but help out the person anyhow but this one is just silly! Russ On Thu, 9 Aug 2001 17:53:23 +0800 J- E- N [EMAIL PROTECTED] wrote: hello! is there anyone who can give me an idea on how i can write

Re: [PHP-DB] blinking background fwd

2001-08-09 Thread Russ Michell
Heh, there's a reason the blink tag has been depreciated... Actually I tried finding it in the newest version of HTML and can't even find it there anymore :-) That's cos it was a Nutscrape proprietry tag Russ Date: Thu, 9 Aug 2001 09:47:59 -0600 From: John Pickett [EMAIL PROTECTED

Re: [PHP-DB] 1 is not a valid PostgreSQL link resource

2001-06-22 Thread Russ Michell
to the list and I'll see if I can help out. Russ On Thu, 21 Jun 2001 12:03:26 -0500 Carlos Estala [EMAIL PROTECTED] wrote: ! Hi ยก i have redhat 7.1 and php 4.0.4 but i have a problem with conections becose send me this messages 1 is not a valid PostgreSQL link resource, how i cant fix

Re: [PHP-DB] MySQL connection: Change on syntaxis?

2001-06-22 Thread Russ Michell
. Russ On Thu, 21 Jun 2001 23:30:03 +0200 Tom=?ISO-8859-1?B?4XMgR2FyY+0=?=a Ferrari [EMAIL PROTECTED] wrote: Hello, I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed that this is a solution

Re: [PHP-DB] flush privileges

2001-06-21 Thread Russ Michell
, but you could go try: www.mysql.com/doc/P/r/Privileges.html and see if that helps. Cheers Russ On Wed, 20 Jun 2001 22:38:20 +0700 andRie Is [EMAIL PROTECTED] wrote: Hello php-db, what kind of privileges i should have if i want to run 'flush privileges

Re: [PHP-DB] Date field

2001-06-21 Thread Russ Michell
varchar(25) NOT NULL, dept varchar(25) NOT NULL, abstract mediumblob NOT NULL, submitDate datetime DEFAULT '-00-00 00:00:00' NOT NULL, // The //bit you need scale varchar(7) NOT NULL, PRIMARY KEY (id), UNIQUE id (id) ); HTH !! Russ On Wed, 20 Jun 2001 18:27:42 +0300 Rosen [EMAIL

Re: [PHP-DB] concatenation

2001-06-21 Thread Russ Michell
U I might be missing something but isn't it something like: $emailVal = a href=\mailto:; . $email . \ . $email . /a; HTH :-) Russ On Thu, 21 Jun 2001 00:05:46 -0500 DanielW [EMAIL PROTECTED] wrote: Greetings. Can anyone tell me how to concatenate text to the value of a cell pulled

Re: [PHP-DB] mssql_fetch_array problem

2001-06-20 Thread Russ Michell
that are and are not returned? Compare them and try altering the differences you find to see what happens. Good luck! Russ On Wed, 20 Jun 2001 13:17:23 +0800 Jennifer Arcino Demeterio [EMAIL PROTECTED] wrote: Thanks for all your answers, but, they still seem not to work. In my query, the value

Re: [PHP-DB] Help With Getting Values Please!

2001-05-24 Thread Russ Michell
mysql_result() is used when you know the row number of the item you want to retrive from your table. mysql_query() is used to get all results from a query, so you can loop thru an array of them or something. Russ On Wed, 23 May 2001 18:47:22 +0200 Johannes Janson [EMAIL PROTECTED] wrote

[PHP-DB] checking mechanism

2001-05-22 Thread Russ Michell
; } //and: if($num != 1) { $display_news = pSorry, no news items./p; } As I seem to remember the former working fine...now I have to switch to the latter??? Cheers. Russ #---# Believe

[PHP-DB] web to access/excel

2001-05-22 Thread Russ Michell
but this is a pressing matter, that requires I find a pointer to a solution, or an actual solution as fast as I can! Kind regards: Russ #---# Believe nothing - consider everything Russ Michell

Re: [PHP-DB] INSERT statement

2001-05-21 Thread Russ Michell
I don't use PostgresSQL, but the SQL can't be that different: INSERT INTO table (column2,column4) VALUES ('$x','$y') WHERE column1 = '$z' //Loose the brackets after the WHERE clause, and add single quotes //around your variable. Russ INSERT INTO table (column2,column4) VALUES ('$x','$y

Re: [PHP-DB] Date display problem

2001-05-14 Thread Russ Michell
where the date lies in your table. A MySQL TIMESATMP comes in the mmdd hh:mm:ss formate, and changes whenever that field ia altered or updated. Hope that is what you needed! Russ On Sat, 12 May 2001 18:27:36 + vipin chandran [EMAIL PROTECTED] wrote: Hi, How do I display the time

Re: [PHP-DB] variable vaule lost

2001-05-14 Thread Russ Michell
value=Enter); echo(/form); ? The value of '$i' can now be picked up by calling it from the new var: 'passvar' HTH :) Russ how The variable being passed will be seen in the next form? On Fri, 11 May 2001 01:55:42 +0530 Sharmad Naik [EMAIL PROTECTED] wrote: pls look at the attachment

Re: [PHP-DB] mysql newbie

2001-05-10 Thread Russ Michell
- in Linux you can type mysql -p anywhere at the shell prompt (if you installed it to run in the background as a 'deamon') and it'll prompt you to type a username and a password. Take care to remember these as it's v.hard to recover when you loose these (I know 'cos I did it!) Good luck! Russ On Thu

Re: [PHP-DB] Apache+PHP+MySQL installation at once - HOW?

2001-05-04 Thread Russ Michell
I remember, that I saw somewhere some prepared package for very fast and comfortable installation of these three at once. Don't you now where I can find it? Thanks I think you wanna be going to: http://www.phpgeek.com/phptriad.php Good luck! Russ. On Fri, 4 May 2001 09:45:41 +0200 Vojtech

[PHP-DB] Simple query problem

2001-05-03 Thread Russ Michell
for example?? Please help - as I have nearly completed the projectjust some fiddly lil' things need to be sorted.. Many thanks. Russ #---# Believe nothing - consider everything

Re: [PHP-DB] INSERT into mySQL over PHP (internet)

2001-05-03 Thread Russ Michell
I'd like to have some kind of a GUI on the internet Could you not use phpMyAdmin?? Download it for free from http://www.phpwizard.net/projects/phpMyAdmin/ Cheers. Russ On Thu, 3 May 2001 15:43:11 +0200 Nils Wetterich [EMAIL PROTECTED] wrote: Hi NG Now that I finally realy work

Re: [PHP-DB] update problems

2001-04-27 Thread Russ Michell
=\$var\$var/option; }//end while loop $dropdown .= /select/form; Just replace the name of the column 'yourcolumn' and $var to the variable and column names you want to be pulled from the database. Good luck and happy coding! :-) Russ On Thu, 26 Apr 2001 20:16:38 +0200 ns [EMAIL

[PHP-DB] Query problem cont'd..

2001-04-26 Thread Russ Michell
= SELECT * FROM $table_cal WHERE item_activity='$id' AND DATE_FORMAT('item_date','%b')='$sortedBy'; } Thanks to Rasmus for helping me out so far! Can anyone see what I may be doing wrong??? I'm using mysql-3.22.32 and the item_date column is a MySQL DATE() column.. Cheers: Russ

[PHP-DB] query problem

2001-04-25 Thread Russ Michell
...;-) Cheers: Russ #---# Believe nothing - consider everything Web Developers do it on-the-fly. Russ Michell Anglia

[PHP-DB] Querying 2 databases...???

2001-04-24 Thread Russ Michell
to point me in the right direction?? I am using php4.0.3pl1 with MySQL3.22.32 on RH6.1 Any help would be very much appreciated. Kind regards: Russ Michell (APU Webteam) #---# Believe nothing - consider

[PHP-DB] Querying 2 databases...???

2001-04-24 Thread Russ Michell
sportdb.table_name.username_field = mysql.user.User Do I not need to define for php what 'mysql' is, as I've done for 'sportDB' ?? and is there any specific sort of JOIN I need to do?? Many thanks for your prompt reply.. Regards: Russ

Re: [PHP-DB] Error Msg: Wrong data type when performing extract()

2001-04-19 Thread Russ Michell
; $result=mysql_query($sqlstmt); # print $result; $row=mysql_fetch_array($result) That way if an error existed somewhere B4 then it'd go.. Sorry if that was next-to-useless. Russ #---# "Be

Re: [PHP-DB] Make history HOW?

2001-04-19 Thread Russ Michell
of the users progress throughout the site. if(!empty($yourvar)) { session_unregister('yourvar'); } Hop this is of some use to you! Regards: Russ #---# "Believe nothing - consider every

Re: [PHP-DB] Designing a database

2001-04-19 Thread Russ Michell
* Use useful and memorable names for your tables and table columns I do: tablename_colname Good luck! Russ #---# "Believe nothing - consider everything" "We

Re: [PHP-DB] Fw: sending e-mail thru PHP page.

2001-04-19 Thread Russ Michell
HaHa!! I'm just sorting that one too: Try: $sender = "[EMAIL PROTECTED]"; mail("$mail_to","$subject","$body","From: $sender"); That should do it... Also check out the threads on phpbuilder.com: http://www.phpbuilder.com/forum/read.php3?nu

Re: [PHP-DB] hide passing value

2001-04-18 Thread Russ Michell
Ok fair play - What about using sessions then: ?php session_start(); session_register('password') ? simply place the code between the ?php and ? at the top of each page you wish the password to be available on. Hope that helps... Russ

[PHP-DB] SQL help

2001-04-10 Thread Russ Michell
e with even slightly advanced (over me) SQL knowledge help me out?? Many thanks! Russ #---# "Believe nothing - consider everything" &q

Re: [PHP-DB] SQL help

2001-04-10 Thread Russ Michell
Sweet!! Many thanks! Russ #---# "Believe nothing - consider everything" "Web Developers do it on-the-fly."

Re: RE: [PHP-DB] Robust OO Shopping Cart 4 sale -ohmygod

2001-04-10 Thread Russ Michell
Okay boys easy now - let's just get on with what we know best eh?? - developing. Russ #---# "Believe nothing - consider everything" "Web Developers d

Re: [PHP-DB] checkbox checking..

2001-04-10 Thread Russ Michell
Thank Johannes!! I'll give that a go! Cheers - Russ #---# "Believe nothing - consider everything" "Web Developers d

Re: RE: [PHP-DB] overrun??

2001-04-09 Thread Russ Michell
Cheers Ben. However if I close a connection, how is it possible to reconnect if the connection needs to be reused, i.e if further DB data is requested? Is it just a matter if refreshing the page and it all resets?? Russ

[PHP-DB] overrun?

2001-04-09 Thread Russ Michell
folks. Russ #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam www.apu.ac.

Re: [PHP-DB] PHP an MySQL

2001-04-02 Thread Russ Michell
ider everything" Russ Michell Anglia Polytechnic University Webteam http://gertrude.sipu.anglia.ac.uk/webteam [EMAIL PROTECTED] +44 (0)1223 363271 ext 2331

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

2001-04-02 Thread Russ Michell
Using PhpMyAdmin click the 'empty' hyperlink. This will empty all the data from the table but not delete the table. HTH :) Russ #---# "Believe nothing - consider every

Re: [PHP-DB] Keeping Variables

2001-04-02 Thread Russ Michell
t;big" more form stuff etc etc yadda yadda yadda /form ? //Submitting the form will reload the page and if you detect for it, //the variable $arse should be available with the value of 'big' HTH ;-) Russ #---#

Re: [PHP-DB] $vars to JS in a linked js page.

2001-03-29 Thread Russ Michell
Not too sure if this is what you want, if not - I'm sorry: $some_number = $mysql_num_rows() sizeof() This counts the number of elements in an array..(Just wipped that outta the open page in "PHP Fast and Easy"

Re: [PHP-DB] auto_increment in mysql

2001-03-28 Thread Russ Michell
I may be semi-new to this MySQl lark but I'm sure auto_increment starts at 0. Russ #---# "Believe nothing - consider everything"

Re: [PHP-DB] syntax trouble

2001-03-16 Thread Russ Michell
-colon and finds incorrect syntax. (Due to lack of said-semi colon) Go check it out! HTH :) Russ #---# "Believe nothing - consider every

Re: [PHP-DB] Help w/ displaying return vals

2001-03-15 Thread Russ Michell
ave) And given mysql_connect all 3 arguments it should have to make a successful connection to your database server. (Not sure wether you missed these out simply for clarity though) Hope that all helps and makes sense!! Cheers Russ #---

Re: [PHP-DB] Apache + PHP4

2001-03-14 Thread Russ Michell
) # will typically use: # AddType application/x-httpd-php-source .phps AddType application/x-tar .tgz AddType application/x-httpd-php .php3 AddType application/x-httpd-php .php AddType application/x-httpd-php .phtml /snippet_of_httpd.conf HTH :) Russ

Re: [PHP-DB] Variable variables ! - help

2001-03-14 Thread Russ Michell
art_nr_$i\" input type=hidden name=\"quantity\" value=\"$quant$i\" "; } endfor; //Echo thwe variable to the page ?php echo"$display_this"; ? #---# "Believe nothing - consider everything"

Re: [PHP-DB] directrory browsing

2001-03-13 Thread Russ Michell
Ummm a bit more info on your part may be helpful for folk to help you Like in what context your problem lies, using which system and what it has to do with Databases working with PHP Russ

Re: [PHP-DB] Displaying Graphics dynamically

2001-03-12 Thread Russ Michell
able data (of paths-to-images) and display them dependent on whatever criteria it is you are using. HTH :) Russ #---# "Believe nothing - consider everything"

Re: [PHP-DB] Using selected fields

2001-03-12 Thread Russ Michell
Sure: while($row = mysql_fetch_array($result)) { $usrLevel = $row['userlevel']; $member = $row['member']; $pswd = $row['pw']; } //end -while loop Now $usrLevel, $member and $pw are available as variables taken from this array to use as you please in you php scripts! Russ Hi

Re: [PHP-DB] Apache Question

2001-03-12 Thread Russ Michell
index.php3 DirectoryIndex index.phtml HTH :) Russ #---# "Believe nothing - consider everything" Russ Michell Anglia P

[PHP-DB] composite keys

2001-02-19 Thread Russ Michell
. Any advice or other methods I could possibley employ, are most welcome. Regards: Russ #---# "Believe nothing - consider every

Re: [PHP-DB] mysql_query failure

2001-02-16 Thread Russ Michell
ysql_x() instead of: mysql_x () (loose the gap!) Hope that helps somewhat! ;) Russ #---# "Believe nothing - consider everything"

Re: RE: [PHP-DB] Can you recommend a development tool?

2001-02-09 Thread Russ Michell
When you say integral editor of DW, do you mean, the 'hit F10' editor? I use EditPlus, (www.editplus.com) it is preconfigured to recognise and highlight php code as well as javascript etc and what have you.. Russ

[PHP-DB] Can you recommend a development tool?

2001-02-09 Thread Russ Michell
behaviours, F6 library etc - sadly no longer.. /whimper Russ #---# "Believe nothing - consider everything" Russ Michell Anglia P

<    1   2