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
[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
Is there
http://freshmeat.net/search/?q=helpdesksection=projectsGo.x=0Go.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
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
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
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
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:
?php
//connect to database
include 'db.php';
$display_block = h1PFS Sales Categories/h1 PSelect a category to
see its items./p;
//Show categories
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
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, 2004
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]
Nothing, htmlbody/body/html
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
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
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
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
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 under
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 on
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 * Internet
26 matches
Mail list logo