Hi Everyone, Happy Easter to you all.
I have this query, reasoning for posting on this
Mailing List is under it. :)
SELECT `username` , `score` FROM round" .
$round_number . " WHERE 1
ORDER BY `score` DESC LIMIT 0, 30
Is there a way to make it output the $round_number -1
(minus one number)?
I n
[EMAIL PROTECTED] (Jerry) wrote in
news:[EMAIL PROTECTED]:
> Hi Everyone, Happy Easter to you all.
>
> I have this query, reasoning for posting on this
> Mailing List is under it. :)
>
> SELECT `username` , `score` FROM round" .
> $round_number . " WHERE 1
> ORDER BY `score` DESC LIMIT 0, 30
>
http://freshmeat.net/search/?q=helpdesk§ion=projects&Go.x=0&Go.y=0
I use oneorzero available at www.sf.net
http://helpdesk.oneorzero.com/
Redhat wrote:
Anybody out there familiar with some helpdesk software? I found some
called "teacup" that runs as a cgi and used Postgres but I wanted to see
if
Tables are listed below the code
I couldnt get the foreach to work properly that Brent sent..I keep getting:
"Invalid argument supplied for foreach() ".
I've tried lots of different stuff but here's an example:
*
$query = "SELECT * FROM cust"
Hi all, new to the list :)
I would try something like this:
Select name, company, choice
>From Table1, Table2
Where Table1.id = Table2.id;
Fg
> Can someone please help me or direct me to some scripts that might get
> me unstuck, as I've not done this kind of query before.
>
> To simplify:
>
antonio bernabei wrote:
The work is to apply a formula to some fields of each record and
update another field of the same table.
If this is the case, why don't you simple use an UPDATE query?
Example: [ UPDATE table SET some_field=
100*0.1/other_field+yet_another_field ]
No PHP i
A php upload script has been written. Uploading happens on the server.
The file upload works fine when the server path is hardcoded into the php
code.
The file upload however does not work otherwise.
I believe that the php upload script works fine, however its a
setting/configuration issue on IS
My PHP installation seems to be confused as to where to find the MySQL
socket file.
The error I'm getting is: "Warning: mysql_connect(): Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
This isn't where the mysql.sock file is. It's at /tmp/mysql.sock.
Thank you FG - this is exactly what I needed.
I think I 've got the query perfect, but how best to display like:
5 jane doe send_rep
4 mignon hunter tic 2-3, send_rep
here's my query:
$query = "SELECT cust.id, first, last, company, choice FROM cust, contact
where cust.id = contact.id";
while ($r
A question pertaining to this topic was posted in another forum. I have
included the answer here for those who have to deal with this issue.
Unlike MS SQL Server 7.0/2000, MS Access 2000 does not use separate types
for non-UNICODE and UNICODE text data. Instead, ALL text data is stored as
UNICODE.
Hello all,
My script works fine as it is, but I am trying to reduce the number of
queries to the database. I am running PHP 4.3.4 and MySQL 4.0.3.
Here is my table structure:
mysql> desc application;
+-+--+--+-+-+---
-+
| Field
I have this script which SHOULD produce a linked webpage for soon-to-be
created static web pages, however I can't seem to find the error in my
code:
PFS Sales Categories Select a category to
see its items.";
//Show categories first
$get_cats = "select id_num, id_name, description, cat_code from
P
using grouping:
SELECT count(application.*), application.media_ID, mailbox.company_ID
FROM application, mailbox
WHERE mailbox.app_ID = application.ID
GROUPBY mailbox.company_ID, application.media_ID
SQL is unchecked;
try to look at the problem from the other direction
determine what information y
does the page actually error or does it not do anything?
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 3:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Where's the error?
I have this script which SHOULD produce a linked webpage for soon-
It is not displaying anything at all.
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]
Sent: Friday, April 09, 2004 3:52 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Where's the error?
does the page actually error or does it not do anything?
-
If you "view source" on the page that's displaying nothing, is there any
HTML code there? If so, search through it and let us know if there's a PHP
error buried in the HTML code somewhere.
> -Original Message-
> From: Robert Sossomon [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 08,
Not even the title?!?!
Dan
On Apr 8, 2004, at 2:55 PM, [EMAIL PROTECTED] wrote:
It is not displaying anything at all.
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]
Sent: Friday, April 09, 2004 3:52 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Wher
Nothing,
I just found this in the error log:
PHP Parse Error: parse error, unexpected $ in catalog.html on line 74
This is the last line of the whole file... Guessing I have a curly
brace not closed somewhere???
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent
I think you're right, Robert. Hopefully, your editor has a Match Brace
feature or something similar so you don't have to search manually. You also
might want to raise your level of error reporting in your PHP.ini file so,
in your testing environment, those errors get spit out to the browser. It'll
OK... I had double checked when I put in each new line of code (it's an
old page I was modifying today for a new task) and I know I
double-checked that I put in the right and left curly braces around the
new stuff. Somehow I lost an ending one...
How the heck do you miss 1 curly brace in a mile
If only to have a testing server... *sigh* maybe next budget meeting I
can squeak an old box out of them to turn into one.. :)
I fired up nedit on the server and looked at the file, danged thing
pinged out the error in like 3 seconds when I hit the last curly brace
before the ?>. Was missing on
At 00:01 08-04-2004, Ryan Jameson (USA) wrote:
I know this isn't technically DB related but this is the list that I
use. I'd just like to know if anyone else thinks the below statement is
accurate. If it is, why hasn't the mail function been modified in the
more recent builds? I've been using PHP s
He says later in his email that:
"The reason I mention this is because any email delivery failures will
not be sent back to you, but to our servers (due to the way that PHP
writes the email headers when using the mail() command)."
... Is there a way to get the bounces to go to the reply to addres
Ryan Jameson wrote:
He says later in his email that:
"The reason I mention this is because any email delivery failures will
not be sent back to you, but to our servers (due to the way that PHP
writes the email headers when using the mail() command)."
... Is there a way to get the bounces to go to
Date: 8 Apr 2004 09:12:46 -
To: [EMAIL PROTECTED]
From: "David Robley" <[EMAIL PROTECTED]>
Subject: Re: Query Help!
[EMAIL PROTECTED] (Jerry) wrote in
news:[EMAIL PROTECTED]:
> Hi Everyone, Happy Easter to you all.
>
> I have this query, reasoning for posting on this
> Mailing List is
Date: 8 Apr 2004 09:12:46 -
To: [EMAIL PROTECTED]
From: "David Robley" <[EMAIL PROTECTED]>
Subject: Re: Query Help!
Have you tried
SELECT `username` , `score` FROM round" .
($round_number -1) . " WHERE 1
ORDER BY `score` DESC LIMIT 0, 30
Ahh just tried it and relised what is going
Justin Patrin wrote:
accurate. If it is, why hasn't the mail function been modified in the
more recent builds? I've been using PHP since it was invented & never
had a problem with mail.
"Also note that your form page is currently using the PHP mail()
function, which doesn't work very well anym
On Friday 09 April 2004 02:38, Noah Davis wrote:
> How can I get PHP to not get confused about which .sock file to use?
php.ini
> Do I need to recompile PHP?
No.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Interne
28 matches
Mail list logo