[PHP-DB] International Addresses and Telephones

I have a form which captures US addresses ( address, city, state ) and telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I need to expand this to capture non-US info, so I was hoping for some guidance on forms and table structures. I have googled this to death and still have

[PHP-DB] First and Last Record Query

Does anyone know how to grab only the first and last record of a query. I have a table named periods with two fields, period_id and period_name. The user will select a start period and an end period from a drop down list, assigning $start_period and $end_period variables based on the period id.

RE: [PHP-DB] First and Last Record Query

>> Why are you iterating through the array? Inexperience. Thanks for the help guys. I'll give it a try. Randy -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:43 AM To: 'David Fudge'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] First an

[PHP-DB] Dynamic Table Columns

I have a form (criteria.php) that includes two drop down lists from which a user can select a start period and an end period from a MySQL table. This form posts to a form called order_summary.php on which I am using the $start_period and $end_period variables from the criteria.php form to pull dat

[PHP-DB] Dynamic Drop Down Box

Does anyone know how I might populate a drop down box based on the users selection from a previous drop down box? For example, if I have a table called 'autos' with 2 fields, 'make' and 'model'. I select distinct 'make' and populate the first drop down box. Based on the user selection, the 2nd dro

RE: [PHP-DB] creating a drop down menu from mysql categories

Chad, Try something like this: - $category_array[category_name]"; } ?> - Rand

RE: [PHP-DB] increase date()

Try this: $six_months_from_now = date("Y-m-d", mktime(0,0,0, date(m)+6, date(1), date(Y))); echo "Six Months From Now: $six_months_from_now"; -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 12:28 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] increase

[PHP-DB] Determine last quarter

Hello all, Does anyone know how I might determine the start date and end date of the previous calendar quarter based on today's date. For example, today is 2002-03-19, so the previous quarter start date would return 2001-10-01 and the previous quarter end date would return 2001-12-31. I am trying

RE: [PHP-DB] Determine last quarter

If anyone is interested, this is what I finally came up with. I'm not sure how graceful it is, but it works ;) "; echo "End of Period: $period_last_day"; ?> -Original Message----- From: Rankin, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 8:57

RE: [PHP-DB] redirect a page

Nato, Try something like this: $num = mysql_numrows($result); if ($num == 0) { echo "There were no records found."; } else while ... -Original Message- From: Natividad Castro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 11

[PHP-DB] Date Concat?

te FROM training This produces the following: start_date: September 16, 2002 end_date: Sepetember 20, 2001 Based on the above, I would like to echo out something like this: You will be in training September 16 - 20, 2002. Is this possible? Th

[PHP-DB] Confused

I have two MySQL tables, groups and users: groups: group_id, group_name users: user_id, user_name, group_id, etc. I would like to produce one table for each group which will list all the members for that particular group. For example: Blue (group_id 1) Tom (group_id

[PHP-DB] First record of array not being echoed

Good morning all. I am attempting to create a table in which there is a title cell populated with a training wave number and then I would like to echo all members of each training wave below the title cell (See example below for clarification). All seems to be working with one exception. The firs

RE: [PHP-DB] First record of array not being echoed

-- END ADDED CODE   last_name . ", " . $record->first_name; ?> -- END SNIP > -Original Message- > From: Marco Tabini <[EMAIL PROTECTED]> > Sent: Monday, October 14, 20

RE: [PHP-DB] Broken Links 2

Thanks to everyone for the help. For those interested, I have posted the final code below. It functions beautifully with one exception: the resized image quality is rather poor. I am now reading through the php manual and newsgroups for a solution, but if anyone knows how to handle this it would

RE: [PHP-DB] PHP On Linux

Try this: http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/ Randy Rankin Ben Cairns wrote: > > I have nearly 18 Months devel on Windows, but we are now moving to Linux, > > I have never installed PHP On Linux before, so could someone pls give me an > 'Installation Guide' to follow fo

[PHP-DB] Variable Assignment

All: I am new to PHP and was hoping for some input to what is probably an 'easy' question. The following SQL statement returns 1 row: $sql = "SELECT id, real_name FROM authorization WHERE username='$username' and password='$password'"; All I want to do is assign the results of the field real_

[PHP-DB] No MySQL-Link resource supplied

Is anyone familiar with this error and what causes it (or better, how to fix it). Warning: No MySQL-Link resource supplied in /usr/local/apache/htdocs/sales/login.php on line 46 Line 46 = mysql_close(); I cannot seem to find anything regarding this message in the MySQL or PHP manuals.

RE: [PHP-DB] odbc with ms access

http://www.microsoft.com/KB/Articles/Q128/8/08.HTM -Original Message- From: Dalyyla [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 7:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] odbc with ms access hi, Access to data with ms access via odbc is kinda slow . I would like to kn

[email protected]

Hello, I have a table in a MySQL DB (RH Linux/Apache) with a field called customer_name. Some of the customer names have an ampersand in them (ie; X & X Supply). I am performing a select statement on this table to create a sales summary with customer name and total sales. This works fine; howeve

[email protected]

again everybody!! Randy Rankin -Original Message- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 10:27 PM To: Rankin, Randy; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Escaping & Please explain the dynamic link . is that in the documentation somewhere>

[PHP-DB] Query on Oracle Views

I am connecting to an Oracle 8 server using OCI, PHP and Apache on a RH Linux 7.1 box. All works well until I try to query an Oracle dynamic view like the following: $query = "SELECT instance_name, host_name FROM v$instance"; When I execute this query, the server returns the following error.

RE: [PHP-DB] OCI support not functioning

Did you install the Oracle client? -Original Message- From: Tom Tsongas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:53 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] OCI support not functioning Hi folks. I posted on the install board but I figured I would run this by the gu

RE: [PHP-DB] Connection to Oracle8i

Rafael, I am assuming you can connect to your Oracle server from your client (using net8 for example). Did you recompile PHP with Oracle OCI support on your web server? Run and see if there is a section on Oracle OCI. If not, that may be at least part of your problem. Remember that Oracle and

[PHP-DB] OCI Query Results

We are using OCI to query an Oracle DB. Everything seems to work fine (i.e; data is returned to the browser), however, the first record of every recordset is NOT returned. I can run the same query in SQLPlus and all records are returned. It seems something in PHP is stripping of the first record i

RE: [PHP-DB] OCI Query Results

Nevermind, I figured it out. There was a duplicate OCIfetchinto statement in the script. Randy -Original Message- From: Rankin, Randy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:12 AM To: PHP List Cc: Barker, John Subject: [PHP-DB] OCI Query Results We are using

[PHP-DB] Help with MySQL Logic

Hello All, This may be a bit off topic. If so, my apololgies. A client of mine, a rail car storage company, has asked that I create a PHP/MySQL application in which they will maintain and track rail cars. I am having a bit of trouble however working through one of thier requirements. They need t

RE: [PHP-DB] Help with MySQL Logic

Thanks to everyone for your help. I was able to work out the logic last night based on your fine suggestions and all is well! Thanks again. Randy > -Original Message- > From: "1LT John W. Holmes" <[EMAIL PROTECTED]> > Sent: Monday, March 03, 200

RE: [PHP-DB] Datetime help in an INSERT...

If you are using MySql with the date field is of type timestamp, you should have to insert anything using the query. It will update automatically when the record is inserted and/or updated. ie; $denylog = "INSERT INTO deny (account, td ) VALUES ($tmp, $td )"; Randy -Original Message- Fro

RE: [PHP-DB] Datetime help in an INSERT...

ALUES ($tmp, $td )"; Randy -Original Message----- From: Rankin, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Datetime help in an INSERT... If you are using MySql with the date field is of type timestamp, you s

[PHP-DB] PHP, MySQL and Flash

Does anyone know of any articles on integrating PHP, MySQL and Flash to perform a drag and drop routine for updating a db? Specifically, I have a client who is _INSISTING_ that I integrate a drag and drop feature into his railcar storage application. He wants to be able to view two railcar storage