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
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
How would the entire query look
select * from ticket where Type = 'Phone' and ???
"Dirk Kredler" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
> > This is what I have
> > sel
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 ticket
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: http://www.php.
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
That is what I would say as well
"Clever" <[EMAIL PROTECTED]> wrote in message
003301c1e9eb$8e1965a0$[EMAIL PROTECTED]">news:003301c1e9eb$8e1965a0$[EMAIL PROTECTED]...
> You could send it in a
>
>
> - Original Message -
> From: "Alex Francis" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTE
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
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 e
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
(EURO) as EURO,
> MAX(KUNA) as KUNA from $table limit 1";
>
> "Ron Allen" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am trying to determine how to use the MAX() function
> >
> > I was think
I am trying to determine how to use the MAX() function
I was thinking about this
$sqlquery = "SELECT MAX(HUF,KM,EURO,KUNA) from $table limit 1";
any suggestions
here is the code:
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to
database");
@mysql_select_db("$DBName") or die("
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
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 PROTEC
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 dependin
I would like to count all the total records from a database. How would I go
about doing that???
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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
k at a month it says "Query Failed"
>
> >Ronald L. Allen (MCSE NT, MCP, CCNA)
> SR. LAN/WAN Administrator
> >SFOR - Hungary, Croatia
> >[EMAIL PROTECTED]
> >[EMAIL PROTECTED]
> >+36-82-50 ext. 22580
> > DSN: 760-2000
>
>
> -Original Messa
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
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
Select a CCSD:
SELECT
VIEW ALL
March 2002
April 2002
May 2002
June 2002
July 2002
August 2002
September 2002
October 2002
November
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 (http://www.php
22 matches
Mail list logo