[PHP-DB] Problem with the beginning variable

2002-04-03 Thread Ron Allen
I have a problem with the inital load of my page When it loads it says that the variable is not defined. When I click on search after that it works fine. How do I get PHP to recognize a variable as a certain value without making it a static value? -- PHP Database Mailing List

[PHP-DB] Database Sorting by date

2002-04-04 Thread Ron Allen
Here is the problem I want to be able to view all or search through the currency lists in the database by the month. Any help would be great!!! Here is the code TABLE FORM name=currency METHOD=POST ACTION=testtest.php TR HEIGHT=20TD COLSPAN=2FONT SIZE=+0 FACE=VERDANA BR TRTD ALIGN=LEFT BSelect

[PHP-DB] Re: Date Question

2002-04-04 Thread Ron Allen
Steve is right you can do it that way, but I would put in the area where you insert the information into the database. Either way is correct. but I find this way easier and you don't take up any area on your from. (preferences) mysql_select_db($DBName) or die(Unable to select database $DBName);

Re: [PHP-DB] Database Sorting by date

2002-04-05 Thread Ron Allen
Croatia [EMAIL PROTECTED] [EMAIL PROTECTED] +36-82-50 ext. 22580 DSN: 760-2000 -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 16:43 To: 'Ron Allen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Database Sorting by date Ron

[PHP-DB] Cosmetics

2002-04-05 Thread Ron Allen
Does anybody out there know how to get the amount of time that a search took and then display it on the webpage!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Cosmetics

2002-04-05 Thread Ron Allen
Works like a champ..friggin sweet Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Friday 05 April 2002 17:57, Ron Allen wrote: Does anybody out there know how to get the amount of time that a search took and then display it on the webpage!!! $TIMER_START

[PHP-DB] Re: Local to Global Variables

2002-04-11 Thread Ron Allen
guessing here, but have you tried to use include'filename.txt' in your if statement? Eat Pasta Type Fasta [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Not 100% DB related but soon I am processing a text file by looking for strings which later depending on

[PHP-DB] Re: count

2002-04-11 Thread Ron Allen
I know how to get the results for the total number of records select count(*) from $table but how do I put them into a variable for me to use later??? David Robley [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... In article [EMAIL PROTECTED], [EMAIL PROTECTED]

[PHP-DB] Re: count

2002-04-11 Thread Ron Allen
What is the Aliases used for??? Aliases. SELECT COUNT(*) AS howmany FROM table Then use the variable $howmany -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] appending new entry to old entries

2002-04-18 Thread Ron Allen
I would like to make it so that my helpdesk section can append entries in their Master Station Log. Update replaces the entryany clues?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-04-18 Thread Ron Allen
Thanks Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Thursday 18 April 2002 16:51, Ron Allen wrote: I would like to make it so that my helpdesk section can append entries in their Master Station Log. Update replaces the entryany clues?? You would have

[PHP-DB] Pulling from 2 databases

2002-04-22 Thread Ron Allen
I would like to pull from 2 different databases at the same time so that I can have the relating information displayed together. This is what I have so far.any suggestions? $sqlquery = mysql_query(SELECT * FROM log, logtime WHERE log.ID=logtime.ID order by log.logtime desc;); $sqlquery1

[PHP-DB] Accessing MySql using Flash while using PHP as the middleware

2003-06-25 Thread Ron Allen
Does anybody have an idea how-to use Flash and PHP to access a MySql database. I know how to use PHP and mysql with no problem to pull info, but with Flash I am struggling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Multiple same values only wanting one

2003-07-15 Thread Ron Allen
How do I select * from a table, but I do not want it to return the same value if two fields are the same. Example test test test test new new new Results that I want are just test new Any suggestions? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Query problem

2003-07-22 Thread Ron Allen
I have done this in the past, but for some reason it isn't working now (maybe a moron). I am trying to select all of the empty or NULL fields in a column. This is what I have select * from ticket where Type = 'Line' and Closeddate = ' empty space' and have tried the following select * from

[PHP-DB] Comparing tables

2003-08-25 Thread Ron Allen
I would like to compare 2 tables in a database to determine which records are different!!! Any clues out there. Thanks in advance! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Comparing 2 tables in the same database

2003-08-25 Thread Ron Allen
I would like to compare 2 tables in the same database so that I can find out which records are different! Thanks in advance! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php