Okay, the problem was the MSSQL Client Tools wasn't installed. Once it
was installed script connected perfectly.
What I had done prior to installing the MSSQL Client Tools was copied
ntwdblib.dll from the SQL Server to the Web Server. According the the
PHP documentation for Microsoft SQL Server
Martín Marqués wrote:
El Dom 01 Feb 2004 12:54, John W. Holmes escribió:
Shaun wrote:
>>>
Is it possible to have an incrementing row count in my query that is not
part of the table data?
If you _have_ to get this in your query I'd say you have a flaw in your
logic somewhere. However, you can do it
js wrote:
ok, 2 questions. first, how do i do a mysql
> query that orders by date? like this?
$newestquery = "SELECT artid,title,artdate,artauthor
> FROM article WHERE artdate <= $today ORDER BY artdate
> DESC LIMIT 5";
Honestly, you could have taken the two seconds to try that and see if it
wo
ok, 2 questions. first, how do i do a mysql query that orders by date? like, say i
want to have 5 newest members who have signed up? i want it to display only 5 also.
how do i do that? like this?
$newestquery = "SELECT artid,title,artdate,artauthor FROM article WHERE artdate <=
$today ORDER BY
thanks, wil use a java group next time, did not know that
roy
"Miles Thompson" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> PHP is SERVER side, not browser side.
> That's a Javascript question.
> Miles
> At 11:14 AM 1/30/2004 +0100, Roy G. Vervoort wrote:
>
>
> >Is it possible t
Hmmm...
I would not bet money on John Holmes bad coding.
(disclaimer: I have no financial stake in PHP|A, other than being a happy
subscriber)
More likely the original question was not well formulated.
cheers
Ignatius
_
- Original Message -
From: "Martín Marqués" <
El Dom 01 Feb 2004 12:54, John W. Holmes escribió:
> Shaun wrote:
>
> > Is it possible to have an incrementing row count in my query that is not
> > part of the table data?
> >
> > i.e.
> >
> > 1 data data
> > 2 data data
> > 3 data data
> > ...
> >
> > This has to be done in the query no
Buenos días a todos:
Espero que alguno de ustedes hable español y me pueda ayudar a descubrir qué
está mal en el siguiente código:
El objetivo de la función es acceder a una base de Datos (MySQL) y mostrar
los registros que cumplan cierta condición. Si no existe ningún registro
que cumpla la co
Shaun wrote:
Is it possible to have an incrementing row count in my query that is not
part of the table data?
i.e.
1 data data
2 data data
3 data data
...
This has to be done in the query not the PHP!!
If you _have_ to get this in your query I'd say you have a flaw in your
logic somewhere.
Read this then go away, this is not a CSS or javascript list.
http://www.alistapart.com/articles/elastic/
At 13:23 30/01/2004 +, you wrote:
Message-ID: <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Reply-To: "Roy G. Vervoort" <[EMAIL PROTECTED]>
From: "Roy G. Vervoort" <[EMAIL PROTECTED]>
Date: F
The best way I can think of is:
- create a temporary table T with an autoincrement field + desired output
column structure
- perform a INSERT INTO T SELECT 0, in the temp table
- you now have the desired result in your temp table
HTH
Ignatius
_
- Original Message -
Hi,
Is it possible to have an incrementing row count in my query that is not
part of the table data?
i.e.
1 data data
2 data data
3 data data
...
This has to be done in the query not the PHP!!
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
12 matches
Mail list logo
