[PHP-DB] database search

Hope you can help, I have put a basic database together which add, deletes, updates and edits records but I am not sure where to start with searching the data base. I have already got it working a bit using ereg and a while loop, but it is case sensitive and wont find a match in the middle of a

[PHP-DB] Saving a form

I have a form that runs into several pages (17 pages in all). When a user fills in the form, is there any way by which I can ask him to save the page so that he can and return to the last filled page and resume at a later stage ?? -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Re: Saving a form

an example of this can be seen at http://www.cfsloans.com - Original Message - From: Pankaj Ahuja To: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 1:49 PM Subject: Saving a form I have a form that runs into several pages (17 pages in all). When a user fills in the form, is there

RE: [PHP-DB] Tree structures...

BDY.RTF -- 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-DB] date_format yet again

I realise that CC Zona answered this question earlier but I haven't understood. I have attempted to use the date_format in generating the query variable and applying the result with a while loop to display the date data in an html table as dd-mmm- Generating the query variable include

[PHP-DB] Read lines

Hello, I want to read lines from a file between !--begin-- And !--End-- Can someon help me. Walter

Re: [PHP-DB] Read lines

On Mon, Mar 26, 2001 at 12:38:38PM +0200, [EMAIL PROTECTED] wrote: don't know why this is on php-db I want to read lines from a file between !--begin-- And !--End-- read the file line by line, match every line with a regexp. If you hit the line !--begin-- start stuffing the lines in

Re: [PHP-DB] Read lines

First Thx for your response I don't think you know wat i mean. My brother give me a HTML file. I must place a menu from a DB but Then i must have the folowing code !--begin_menu-- tr tdmenu/td /tr !--end_menu-- So i must read from !--begin_menu-- till !--end_menu--. - Original

Re: [PHP-DB] date_format yet again

"boclair" [EMAIL PROTECTED] wrote in message 000e01c0b5d0$720921c0$[EMAIL PROTECTED]">news:000e01c0b5d0$720921c0$[EMAIL PROTECTED]... | I realise that CC Zona answered this question earlier but I haven't | understood. | | I have attempted to use the date_format in generating the query | variable

[PHP-DB] Another newbie question

Hi guys/gals Having had my head sorted out by this list already today, I am in need of some more help...!! I have an input form that, through php queries a MySQL db and passes results back and the browser displays them (at this stage just as a list). I have been looking into the LIMIT command

[PHP-DB] regular expressions

Hello all. Can anyone tell me where i can find some detalied help about regular expressions used at ereg, eregi, etc ? Thanks Mircea

RE: [PHP-DB] Another newbie question

OK, Matt, so you've got the basics =8). Your beginning is good, using the $Offset. Now you only have to add navigation-buttons (First, Previos, Next, Last) with html and a hidden field namded Offset. LIMIT is defined as a constant. You could also use your $Limit. here is a snippet of my

[PHP-DB] classes and sessions

hi, i'm busily rewriting an exisitng calendar system that is in use at work. we're using UML as a design tool and hope to have an OO version of the system we have at the minute that wil 'fit in' with future devs. our system at the moment makes heavy use of postgresql and i am hoping to

Re: [PHP-DB] Another newbie question

Hi Michael Thanks for the prompt reply, much appreciated I can see where the code snippet is going. Creating values for $offset for the set of navigation buttons. But how do I use those values? I am stumped on (and am prolly just blinkered) how to make the query again from the nav button? If

Re: [PHP-DB] date_format yet again

It has been pointed out to me that there is an error. I had failed to include the two date fields in the select. The actual scripting is. The query include ("inputs/connect.php"); |$plantavail = mysql_query("SELECT * date_format(online,'%d-%b-%Y') AS logon, date_format(offline,'%d-%b-%Y') )

RE: [PHP-DB] Another newbie question

Ok, so you have to put the 'Offset-Event-Handler' prior to your select-statement. $Offset is calculatet by the event-handler and then you specify the LIMIT (already done in your skript): // specify LIMIT $limit = "LIMIT "; $limit .= $Offset; $limit .= ", 10"; ... here comes your query ...

RE: [PHP-DB] Another newbie question

Hello I too wanted to have next/previous links... So I found this and it's the best out there... http://www.oreillynet.com/pub/a/php/2000/11/02/next_previous.html?page=1 to output the query... echo $data-Print_Name //Or whatever you want to display . Within that

[PHP-DB] Regular expressions

Hello all. Can anyone tell me where i can find some detalied help about regular expressions used at ereg, eregi, etc ? For example i have this string: html head meta name="keywords" content="poli, easjkdha, owersweoihjwe, uitsodgfisdgisdiv" meta name="description" content="a,

RE: [PHP-DB] classes and sessions

Yes. You can create your class, instantiate it and store it in the session like any other variable. However. before you issue a Session_start() you MUST have already included the class definition in your page. If you start the session and have not, it will throw an error because it will not

RE: [PHP-DB] reading a URL...

Try: $sqlStatement = "Select * from newStories where id = ".$GLOBALS['HTTP_GET_VARS']['id']. " order by whateverValue"; Then execute that statement. The value ID that you passed in on the URL is stored in the associative array $HTTP_GET_VARS. Check the manual at www.php.net, there's a section

Re: [PHP-DB] continuously view database updates.

At 26.03.2001 15:44, you wrote: Hi, I am doing a college project which involves using PHP scripts to update a MySQL database. For demonstration purposes I would like the new updated table in my Database to be shown each time it is updates without me having to go to the command prompt window

RE: [PHP-DB] continuously view database updates.

HI Kevin, you are the first Irish person I have seen on this list!! Anyhow, When you submit the form insure that the form submits to itself so you don't have to worry about a refresh. On the top of the page have the form and below do the select statement to show what is in the table. When the

RE: [PHP-DB] reading a URL...

Hello Try to use this one with mysql_fetch_object... printf ("TD WIDTH=80a href=\"%s?Art_Job_Number=%s\"%s %s/a\n","list.php", $data-Art_Job_Number, "BEdit/B", "BView/B"); Then on the list.php do a select statement like this query = "SELECT * FROM Table1 WHERE Art_Job_Number =

RE: [PHP-DB] reading a URL...

Which I think I must have been!! Lisa -Original Message- From: Brunner, Daniel [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 4:07 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] reading a URL... Hello Try to use this one with

RE: [PHP-DB] reading a URL...

I am a newbie, so I gotta admit that most of that went over my head, hit a brick wall, and is now residing in the big server in the sky. If you go to: http://www.pcformat.co.uk Select news, and then any article, and if you look at the URL, you'll see the result I'm trying to achieve. They've

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

Hi, I really need help, I wrote a function so that I can call for db user/password in an include file. It looks like this: // Connect to the database function db_connect(){ global $MYSQL_USERNAME, $MYSQL_PASSWORD, $DB, $HOST; $db =

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

Hello... Try mysql_pconnect instead Dan -- From: Emir Musabasic Sent: Monday, March 26, 2001 9:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] What's wrong with this code? Hi, I really need help, I wrote a function so that I can call for db

RE: [PHP-DB] PHP/MySQL Program

I haven't used it yet but had it book marked. Try out www.codecharge.com It is not free but only $149 All the Best Lisa PS Let me know how you get on. -Original Message- From: Jason Stechschulte [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:13 PM To: Angela Curtis Cc: [EMAIL

[PHP-DB] error and general problems

I am getting a parse error for the return line every time I try and view the page. Can anyone tell me why? The code is below. $results = "select req, source, number from orders where req=" . $GLOBALS["req"] . ", source=" . $GLOBALS["source"] . ", number=" .$GLOBALS["req"] . ""; if

Re: [PHP-DB] Error Control

In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Jason Bell") wrote: Hello! I'm writing a script that validates a form It creates users in a mysql table, where there are 2 unique columns 'username' and 'email'. I'm putting mysql_error() into a variable, but I don't want the end user

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

In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Emir Musabasic) wrote: I have user/password/host variables inside a config file but for some reason when I include this into a php page when I test it, I get: Fatal error: Cannot redeclare db_connect() in

Re: [PHP-DB] error and general problems

In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Liz Bander) wrote: I am getting a parse error for the return line every time I try and view the page. Can anyone tell me why? The code is below. $results = "select req, source, number from orders where req=" . $GLOBALS["req"] . ",

[PHP-DB] MySQL for Billng Question

I want to have a database for my hours for my clients. I want to create a report where it shows only the hours back to the last time I was paid. I have no idea how to go about this. Any help would be appreciated. Jeff Oien PHP start here http://www.webdesigns1.com/php/ -- PHP Database Mailing

Re: [PHP-DB] reading a URL...

In article [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: Is it Possible, in PHP to read a URL? What I am trying to do is this... I have many news stories in a database, and a single static news page, that calls the story, and the corresponding headline. I have looked about on-line, and

RE: [PHP-DB] Tree structures...

Richard comes through again --- in spades!! Miles At 09:35 AM 3/26/01 +0100, [EMAIL PROTECTED] wrote: You may want to check out my tutorial on recursively processing this sort of structure on the easysoft website: http://www.easysoft.com/tech/php/tut_002/main.phtml Hope this helps _

Re: [PHP-DB] PHP/MySQL Program

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] Getting info from remote host

An outside host cgi script outputs some information, in this case - stock price. They output in plain ascii, stock price and last update on two separate lines. Would PHP be able to request the info from the CGI [it's a URL] and output it onto a page? I asked this here just in case there was

RE: [PHP-DB] MySQL for Billng Question

Jeff, Check www.freshmeat.net There are a couple of packages out there that already do this. Some of them use MySQL. If nothing else, you can borrow their database schema. Cal http://www.calevans.com -Original Message- From: Jeff Oien [mailto:[EMAIL PROTECTED]] Sent: Monday, March

Re: [PHP-DB] Getting info from remote host

In article [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: My idea was to make the http request and load it into an array, to be output in a PHP page. http://www.php.net/manual/en/function.file.php -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] table 1 to table 2

Using PHP, I need to run a query against one MySQL database table (table1) and transfer the results into another identical MySQL database table (table2). Am I simply overlooking something simple on how to do this? Can someone give me input or direction on the best way to do this? Thanks in

RE: [PHP-DB] table 1 to table 2

insert into table2 Select * from table1 where myConditionIsMet; Cal http://www.calevans.com -Original Message- From: Tobe Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 1:41 PM To: PHP-DB Subject: [PHP-DB] table 1 to table 2 Using PHP, I need to run a query against

RE: [PHP-DB] Getting info from remote host

I have done this by making a fsockopen call to the remote host (port 80), request the page to be loaded using a http "get", read the returned page into a buffer and parse through it for the information requested. - Brian Hardwick Tangible Networks -Original Message- From: [EMAIL

Re: [PHP-DB] MySQL for Billng Question

At 26.03.2001 22:21, you wrote: how bout something like this. You have 3 columns TOTAL_HOURS | UNPAID_HOURS | LAST_PAID when you are paid, update TOTAL_HOURS to add UNPAID_HOURS and clear [delete, or set to zero] the UNPAID_HOURS column... LAST_PAID would be type = timestamp, or date. You could

Re: [PHP-DB] mysql grant problem?

On Sat, Mar 24, 2001 at 11:22:37PM +0800, Fai wrote: When we use grant as following: GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by "peter"; Then peter can only select the field of col_name_1 on the tbl_name_1 of db_name_1. However, when peter issue the query:

[PHP-DB] PostgreSQL and PHP - some Great Bridge news

All, I'm pleased to announce two initiatives at Great Bridge aimed at improving the integration of PostgreSQL and PHP, and some exciting stuff that we're doing as a company to get behind PHP more fully. First, Great Bridge is partnering with Zend Technologies to include a fully-integrated

[PHP-DB] reading a URL...

'ello, Is it Possible, in PHP to read a URL? What I am trying to do is this... I have many news stories in a database, and a single static news page, that calls the story, and the corresponding headline. I have looked about on-line, and seen a common URL,...

RE: [PHP-DB] reading a URL...

BDY.RTF -- 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-DB] Apache + php4 + pdflib + win32

Hi, Can I use pdflib on win32 platform using apache and php4? if can how? 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-mail: [EMAIL PROTECTED]

[PHP-DB] Code for adding,edit and deleting records

I am looking for some code that will allow a user to add, edit and delete records in a MySql table. Does someone know of site where I can see how to do this in a nice format? Thank you. Jim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] How to print last row in an array using WHILE?

Dear PHP Helpers, I have an array created by an mysql select statement. I have the code to display the "rows" from the select statement. Everything works fine except that only n-1 rows from the array will display. For example if the array contains four rows only three will display. If the

Re: [PHP-DB] How to print last row in an array using WHILE?

On Mon, Mar 26, 2001 at 10:35:37PM -0800, Bob Stone wrote: Everything works fine except that only n-1 rows from the array will display. no wonder (explained below at the code) This fetches the first row $myrow = mysql_fetch_array($result); ...and then the rest in the while-loop.

[PHP-DB] Indexing help

Dear reader, A newbie mysql/php-question here! I've filled a mysql-database with about 1600 records. All these records contain items which are on sale on a website. Every row contains an integer defining the category to which a item belongs. At the left of the website there are buttons linked