[PHP-DB] Re: Converting values from text to numerical

yes you can switch the type of var for examle with: $number = (integer)$textvar; But if you do store it as a textfield you want be able to do some special sql stuff directly in mysql. For example if you store the date as text in the db you want be able to filter out entries which are between x

RE: [PHP-DB] Re: Converting values from text to numerical

Hi All, upon looking at the link Russ gave me earlier... the PHP site recommends the use of is_numeric() function. This does exactly what I want.. there will only be numbers of text in the field. I can quickly run this returned result from the record through this function.. and if it is

Re: [PHP-DB] Innodb and transactions.

Hi, you have to do something like this: mysql_query('SET AUTOCOMMIT=0'); mysql_query('COMMIT'); or mysql_query('ROLLBACK'); mysql_query('SET AUTOCOMMIT=1'); bye, Steve Bradwell schrieb: Hi all, I have just figured out and set up my Innodb on my mysql server so I can use transactions

[PHP-DB] a back include script

Hello, I want to create a file include .inc which by calling it in almost all the pages which I use, will return me to the previous page, thus this script should have the same function as the back the button of the navigator, somebody has an idea of the script???. Thank you in advance.

[PHP-DB] intercative selection menu

Hello, I need to get back the present value in the data base and to post(show) it in the menu of selection. somebody has an idea?? Thank you in advance. TRTDB?php echo(cell name)?:/B/TD TDselect name=cellname option value=1904 selected 1904/option option

[PHP-DB] ARRAY, IF INSERT

Hi all. I have this form in which one Administrator can insert new members and after that, in another page, a form where he/she can insert the new member’s sons daughters. I want to display a table with “text inserts” into the admin can type let’s say a maximum of 5 kids in the second page.

[PHP-DB] Re: ARRAY, IF INSERT

(i am new to these groups, but shouldn't there be a follow-up-to on a X-post?) César aracena wrote: I have this form in which one Administrator can insert new members and after that, in another page, a form where he/she can insert the new member’s sons daughters. I want to display a table

[PHP-DB] FW:

- Nco quebre a brincadeira. Se seu nome estiver na lista, coloque um asterisco ao lado. Se NAO, adicione seu nome em ordem alfabitica. Mande para 10 pessoas e tambim para pessoa que lhe enviou. Vai ver o que acontece... i super

[PHP-DB] WebSite Submissions Question

Hi All On the website I am building, my Index page (index.html) does a check to see if it is Internet Explorer or Netscape Navigator that the user has for a browser.. and redirects the user to either header(Location: ../nav/index.html); or header(Location: ../ie/index.html); depending on

Re: [PHP-DB] a back include script

On Fri, 21 Jun 2002, Dib, Walid (MED, Stagiaire GEMS) wrote: I want to create a file include .inc which by calling it in almost all the pages which I use, will return me to the previous page, thus this script To manipulate the browser in such a way, you have at least two options: 1) Make the

Re: [PHP-DB] WebSite Submissions Question

Since PHP is parsed before ever reaching it's destination for viewing/profiling, there should be no penalties for putting this on your page. If you have a page like the following (in PHP): ?php ### HAHAHA I HATE GOOGLE!!! THEY SUCK!!! ### ### HAHAHA I LAUGH AT THEM, THOSE IDIOTS ### ?

RE: [PHP-DB] Innodb and transactions.

So should I be using Innodb tables or BDB tables? Thanks, Steve. -Original Message- From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 2:49 AM To: Php-Db (E-mail) Subject: Re: [PHP-DB] Innodb and transactions. Hi, you have to do something like this:

Re[2]: [PHP-DB] a back include script

Hello Duncan, Friday, June 21, 2002, 3:50:10 PM, you wrote: DH On Fri, 21 Jun 2002, Dib, Walid (MED, Stagiaire GEMS) wrote: I want to create a file include .inc which by calling it in almost all the pages which I use, will return me to the previous page, thus this script DH To manipulate

Re[2]: [PHP-DB] a back include script

On Fri, 21 Jun 2002, Latex Master wrote: DH To manipulate the browser in such a way, you have at least two options: DH 1) Make the .inc just have a link to the REFERER value from the browser. The first one want work if the person is behing a socks server or PHP gets a referer diferently?

Re: [PHP-DB] Innodb and transactions.

Hi, use InnoDB, because InnoDB supports row-level locking, and InnoDB also supports referential-integrity, bye, Steve Bradwell schrieb: So should I be using Innodb tables or BDB tables? Thanks, Steve. -Original Message- From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] Innodb and transactions.

Great! thanks for your help. -Steve. -Original Message- From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 9:11 AM To: Php-Db (E-mail) Subject: Re: [PHP-DB] Innodb and transactions. Hi, use InnoDB, because InnoDB supports row-level locking, and InnoDB

[PHP-DB] Re: [PHP-WIN] RE: [PHP] How to Show my Own Error Message Instead of Mysql Error?

i made a Registration Form for user to input their Data, but i also had some Field Check before the data can be insert to the Mysql_Database! I had a question here, sometime the mysql shows the error : Duplicate Key for xxx I know what is this about, reguarding to my Registration Form, it

[PHP-DB] Re: intercative selection menu

You could have if statements for every option. May be better if you have a for loop for some of the options -- SEE BELOW. e.g TRTDB?php echo(cell name)?:/B/TD TDselect name=cellname ?php //Do some database stuff (connect, query, get result etc etc) to get the value that is stored. Put

RE: [PHP-DB] Innodb and transactions.

At 8:55 -0400 6/21/02, Steve Bradwell wrote: So should I be using Innodb tables or BDB tables? You have to be using *some* kind of transaction-safe tables (InnoDB and BDB qualify). If you use a table type like MyISAM, then all statements are committed as they execute, and use of a transaction

[PHP-DB] MySQL and datatime field and displaying on page

Hi I have a mysql table that has a field in it called 'DATETIMEADDED' which has data type 'datetime' I want to display the contents of the field on my page. I have tried usng the following code but the value in the 'DATETIMEADDED' only the value in the 'NAME' field which is a varchar is

Re: [PHP-DB] Populating multi-select list from mysql

On Friday 21 June 2002 10:31, bob wrote: Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is

Re: [PHP-DB] MySQL and datatime field and displaying on page

On Friday 21 June 2002 21:42, Charlie Grosvenor wrote: Hi I have a mysql table that has a field in it called 'DATETIMEADDED' which has data type 'datetime' I want to display the contents of the field on my page. I have tried usng the following code but the value in the 'DATETIMEADDED'

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

On Thursday 20 June 2002 23:59, [EMAIL PROTECTED] wrote: As you can see, the email can look right, but domain isn't valid. So you can check DNS record for MX domain. A valid email address does not necessary have to have an MX record. You could be incorrectly invalidating addresses like this.

Re: [PHP-DB] Can I be an ASP with PHP?

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

On Thursday 20 June 2002 23:26, Richard Black wrote: By passing a second parameter to mysql_fetch_array, MYSQL_ASSOC This means you only get back an array with the values indexed by fieldname. Or just use mysql_fetch_assoc(). -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open

Re: [PHP-DB] Creating an email form

On Wednesday 19 June 2002 10:35, Tim Best wrote: I am creating an HTML form that one will fill out, upload their resume, write a message, give their reply-to email address and send the email to me with the uploaded file as an attachment. I know I have to create the email message with mime,

RE: [PHP-DB] Can I be an ASP with PHP?

If your database server is on a remote server then expect the page to take even longer to render since it will take time to send the database query info back and forth between the two servers. -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: June 21, 2002 11:06 AM To:

RE: [PHP-DB] Populating multi-select list from mysql

Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = SELECT

RE: [PHP-DB] Populating multi-select list from mysql

You're logic seems to make sense. The output (page source) you are getting would help. :-) Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:06 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Populating

RE: [PHP-DB] Populating multi-select list from mysql

Whenever you are having trouble with your PHP pages, always echo! By doing this, you can see whether or not the query is formatted correctly, whether or not the variables are containing the values you think they are. It's incredibly helpful, no matter what the situation. Martin Ryan

Re: [PHP-DB] Innodb and transactions.

One other obvious thing to remember is that you need to to use: create table (int id blah blah blah) type = InnoDB; Also, to take advantage of these features you will also need to update your /etc/my.cnf file (assuming you run some *nix flavored OS) so the InnoDB files are created on disk. I

RE: [PHP-DB] Populating multi-select list from mysql

Thanks for all the help. I got it working using the following code from Martin. Rob. $sql = SELECT category FROM categories; $result = mysql_query($sql, $connection); echo select name=\name here\\n; while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category =

[PHP-DB] MYSQL Socket error :\

Hi sorry for my english but i'm italian. I have a server who run with WIN XP HOME Abyss Web Server (Freeware) www.aprelium.com MySql 4.0.1-alpha-nt PHP 4.2.1 when i use mysql_connect($host,$user,$pass) or die(mysql_error()); function he write: Can't create TCP/IP socket (10106) i have

RE: [PHP-DB] MYSQL Socket error :\

I'm no expert on XP, but you may want to check the firewall settings, to make sure that windows XP isn't preventing the connection. For the $host, you may want to either use 'localhost' or 127.0.0.1 Cheers, Dan -Original Message- From: Marco Lanini [mailto:[EMAIL PROTECTED]]

[PHP-DB] Finding numbers in a string

Hello all - I am trying to seperate numberic characters from a string. The book I was looking at described something like this: if(ereg([[:alnum]]+, $textandnumbers, $numbers)) { print($numbersBR); } When I run my script I receive this error: Warning: REG_ECTYPE in ../mypage.php

[PHP-DB] BBS program

I would like to avoid reinventing the wheel and find an existing BBS program. Do these exist? Thank you -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] BBS program

BBS = Backyard Bible Study? -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 11:40 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] BBS program I would like to avoid reinventing the wheel and find an existing BBS program. Do these exist? Thank you

Re: [PHP-DB] BBS program

I would like to avoid reinventing the wheel and find an existing BBS program. Do these exist? You could probably take a look at PHPNuke or something along those lines. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] BBS program

One of the best PHP Message Boards around is Invision Boards (http://www.invisionboard.com). It's made by the same person who made IkonBoard. For an example check out my boards, which are still in development (I'm slow, what can I say? hehe): http://www.completesource.net/forums/ Martin

Re: [PHP-DB] BBS program

BBS = Backyard Bible Study? Heh. Good guess. BBS = Bulliten Board System. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: [PHP] Re: ARRAY, IF INSERT

Thanks for the input. I wasn't considering the possibility of making a new table for kids until now which seems pretty logic when trying to save space. The only thing missing now is how to assign a unique relation number for each kid/relative. That's 1 for the first born, 2 for the second one,

Re: [PHP-DB] BBS program

AHAHAHAH Now that was funny!! Do any of you remember the game Nuk'em?? That was a Blast!! Dan On Friday, June 21, 2002, at 12:50 PM, [EMAIL PROTECTED] wrote: BBS = Backyard Bible Study? Heh. Good guess. BBS = Bulliten Board System. Chris -- PHP Database Mailing List

[PHP-DB] help with $_Get in form

I'm trying to get a partnum field into a select statement but i'm not getting anything passed into the varable. i'm sure it's a simple fix but i can't find it. thx mike html head Inventory Lookup meta name=GENERATOR content=W3e 2000 title/title /head body ?php $partnum=; function

RE: [PHP-DB] help with $_Get in form

Just from quickly looking you are trying to submit a form and grab the submitted value and stick it into the DB? If so try using METHOD=POST on your form, and using the variable $_POST[form_field] in the insert statement Matt Babineau MCWD / CCFD - e:

[PHP-DB] retrieving all information from a single table

Hello everyone, I am brand new to php, so any replies I get are very much appreciated. My goal is to retrieve one entire table from my database and post the information on the web. My query seems successful, but I am having trouble getting the information out from the variable $result. My

[PHP-DB] Emulating HTTP File Uploads

Does anyone know how to upload a file through PHP through the HTT interface. I use fopen() to open remote php scripts using the GET method for non-file uploads but it doesnt work with HTTP POST or file uploads. Does anyone have any ideas? -- Regards, Georgie Casey [EMAIL PROTECTED]

[PHP-DB] [Q] EXT SQL IN PostgreSQL

# Sorry to my poor English I have a procedure ( named by select_table ) ## BEGIN; select select_table('select_cur','table_name'); FETCH ALL IN select_cur; COMMIT; ## This Query is right In Console (psql). I wanna

RE: [PHP-DB] Converting values from text to numerical

Hi Matt, I think this might be the answer to your problem. It basically checks if the string is an integer. I generally love the PHP automatic type conversion, but sometimes it can trick ya :) if (intval($val) == $val){ // integer stuff } else { // string stuff } Adam

[PHP-DB] how expensive is mysql_connect in performance

I'm just getting into some stuff where I seem to be making a lot of mysql_connect and mysql_close calls. I wonder, how taxing is this on the server? Is there any performance test of PHP/MySQL out there I could run on my development or deployment machines? ~ Mike -- Mike Zornek | Project Leader

[PHP-DB] Re: Populating multi-select list from mysql

Hi Bob, I have written some functions which make select lists much easier. I have two functions: - BuildQuickSelect() - you pass a couple of parameters (tablename, etc) - BuildSelectMenu() - you pass $sql and some more parameters Unfortunately, they require a few things (such

Re: [PHP-DB] how expensive is mysql_connect in performance

At 22:39 -0400 6/21/02, Michael Zornek wrote: I'm just getting into some stuff where I seem to be making a lot of mysql_connect and mysql_close calls. I wonder, how taxing is this on the server? Not very. MySQL's connection-establishment sequence is pretty efficient. mysql_pconnect() by

[PHP-DB] Re: [Q] EXT SQL IN PostgreSQL

PostgreSQL module does not have cursor. All you have to do is execute query then fetch records one by one. For example, $result = pg_query($db_connection, 'select * from your_table;'); while ($record = pg_fetch_array($result)) { print_r($record); } Above code can be used to print all

[PHP-DB] password()... is it possible?

Hi all, I need the administrators of one site to actually see the user’s passwords. I like using password() for encrypting but doesn’t know if it can be retrieved in common English. Thanks, Cesar Aracena mailto:[EMAIL PROTECTED] CE / MCSE+I Neuquen, Argentina +54.299.6356688

Re: [PHP-DB] MYSQL Socket error :\

Thanks Dan, but i have already tested this solution... i have build a very little test script, who generate this error. ?php mysql_connect(127.0.0.1,root,admin) or die(mysql_error()); print(connected!!!); ? i am in localhost and i use very simple root admin login but the message is always

RE: [PHP-DB] MYSQL Socket error :\

It may prove beneficial to check the event log. More clues may lie in there. If the webserver has any type of error log check that as well. Aaron Weiker -Original Message- From: Marco Lanini [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 1:10 AM To: [EMAIL PROTECTED]