Thanks Jeremy, I finally found the solution:
?php
$query=SELECT * FROM DB1 JOIN DB2 ON DB1.dataid=DB2.dataid;
$queryupd=UPDATE DB1 SET dateval='20010101' where dateval='2101';
$hostname = serverdb;
$username = user;
$password = pwd;
$dbName = DB;
mssql_connect($hostname,$username,$password)
To retrieve data from a text file, I'm using:
$fp= file(textfile.txt,r); foreach($fp as $line) echo - $line -;
Jerry
Arik Ashepa [EMAIL PROTECTED] wrote:
Can someone please tell me how can I add and retrive data from a text file
I
know it has something to do with Spliting...???
But I dont
Hi!
I use ODBC to connect to M$ Access. How can i know last oid after insert?
--
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]
To connect to Microsoft SQL 7 I'm using the following script which works
fine:
?php
$query=SELECT * FROM DB1;
$queryupd=UPDATE DB1 SET dateval='20010101' where dateval='2101';
$hostname = dbserver;
$username = username;
$password = pwd;
$dbName = DB;
Go with:
$query = SELECT * from counter;
$result = mysql_query($query) or die(Error:.mysql_error());
$i = 0;
while( $row=mysql_fetch_array(result) {
echo $i = .$row['time'].BR;
$i++;
}
this assumes that you've opened your server connection and selected database
prior to executing the
Those who are new to PHP, mySQL, or both, come to this list looking for
help. Some posters are tentative about posting questions for fear of
looking ignorant, or even worse. Responses, such as Mr Ferger's below, do
not help this situation.
If you have a suggestion for a poster, please make it
I have a db site that always displays the most recent occurrence of news
stories
The last occurrence of stories was last year (2001-12-31) and up to the new
year rolling over, I had no difficulty subtracting days, etc.
Is there a bug in Mysql? PHP that I don't know of..
Please help.
--
No bug, mate.
Post your code so that we can help ya...
-Original Message-
From: Faye Keesic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:56 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date problem with new year
I have a db site that always displays the most recent
Hi there,
I have two tables in two different db. Now I have to compare those records.
How can I do this from PHP? As I know I have to connect to the db first,
than make the querry. How can I compare them? Is there another way, than
first writing the data into an array and then comparing?
Cheers
I've done stuff like this in VBScript and haven't yet done it in PHP,
so this advice may be worth what you're paying for it:
1. Make sure you've got a space in your sql string.
$query .= WHERE MANUFACTURER LIKE '$manufacturername'
should be
$query .= WHERE MANUFACTURER LIKE
Did you convert the dates to PHP's Julian format before subtracting?
On Wed, 2 Jan 2002, Faye Keesic wrote:
I have a db site that always displays the most recent occurrence of news
stories
The last occurrence of stories was last year (2001-12-31) and up to the new
year rolling over, I
Okay, when I try to change the gregorian date to julian, I get
error: call to undefined function: gregoriantojd() in line...
Here's the code I used to replace $datetoget=($datetoget-1);
//from what I understand ,must be in month, day, year format
//so passed today's date
Hello,
Is it possible to order the table somethin like this
'select * from intrat order by idatum+iszam DESC; '
where idatum is date
and iszam is int
thanks
Thomas omega Henning
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
you can't make this query because type mismatches.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
Thomas Omega Henning [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello,
Is it
Hi,
IBM DB/2 uses Call Level Interface (CLI) for communication between clients and server.
The ODBC driver from IBM is a simple one to one wrapper arround CLI, as CLI and ODBC
share the same specifications.
Using ODBC will give you an extra layer though. On *nix platforms you can compile usen
Hello:
I would actually disagree with [EMAIL PROTECTED]
The mysql_query() function does not require both database and query as arguments,
only query.
The mysql_db_query() function does, thus the function name. Using mysql_query()
with database as a parameter would actually be incorrect. (See
I forgot to type in something if i substr the date so i get only the year
from it then is it possible?
George Nicolae [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
you can't make this query because type mismatches.
--
Best regards,
George Nicolae
IT
17 matches
Mail list logo