Hi,
I have been having a lot of trouble getting an
array into the MySQL table like I want it. This is supposed to take the
current maintenance tasks from a table in the database on apple.php each of
these is given a name $item[autoNo] where autoNo is the auto_increment id that
task is assoc
Hi,
I have been having a lot of trouble getting an
array into the MySQL table like I want it. This is supposed to take the
current maintenance tasks from a table in the database on apple.php each of
these is given a name $item[autoNo] where autoNo is the auto_increment id that
task is assoc
> I need some help from you MySQL gurus out there. This is pure SQL by
the
> way..no front-end.
>
>
> Lets say you have a table that has 2columns.columnA,
> ColumnB and columnC
> I have something like this
Oh CRAP! You lost me... you said two columns but listed 3! ;)
> if (columnA>'7', (c
> I am just joining this list so if this has been covered in the past I
> apologize. I am working with MS SQL and would like the functionality
that
> MySQL's limit function provides. I understand that MS SQL has no such
> command or equivalent. Has someone found a way to use standard (or MS
SQL
>
i forget exactly how to use it, but look up TOP. although it does not
perform like LIMIT.
hth
Jeff
"Grant, Dean
Hello,
On 01/23/2003 08:47 PM, Dean Grant wrote:
I am just joining this list so if this has been covered in the past I
apologize. I am working with MS SQL and would like the functionality that
MySQL's limit function provides. I understand that MS SQL has no such
command or equivalent. Has someo
Hi,
I am just joining this list so if this has been covered in the past I
apologize. I am working with MS SQL and would like the functionality that
MySQL's limit function provides. I understand that MS SQL has no such
command or equivalent. Has someone found a way to use standard (or MS SQL
spe
It is safe to test if the divisor is zero:
replace
columnB/columnC
by
IF( columnC = 0, 0, columnB/columnC )
(the "0" could be anything else; this depends on your business logic)
Ignatius
- Original Message -
From: "Jeremy" <[EMAIL PROTECTED]
Peter, et al --
...and then Peter Lovatt said...
%
% Hi
Hi!
%
% I test on NS 4.75 and IE4 as a minimum browser spec.
Those are too maximum, actually.
%
% I test on the following
%
% IE 4, 5, 5.5, 6.0
% NS 4.75, 7 (NS 6 has very low distribution and flaky table handling )
% Opera 5.0 and
Jeremy,
This question probably should be posted to the MySql mailing list but here
goes.
Take a look at this link:
http://www.mysql.com/doc/en/Where_optimisations.html
Your example was not very explicit so I am not sure, but I believe you are
in need of a
WHERE clause. For example;
Select a, b
Hi
Probably a missing ;
?>
">
-Original Message-
From: Ignatius Reilly [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2003 22:00
To: David Rice; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] need help spotting this php parse error
Dunno.
I also remember once havin
Hi
I test on NS 4.75 and IE4 as a minimum browser spec.
I test on the following
IE 4, 5, 5.5, 6.0
NS 4.75, 7 (NS 6 has very low distribution and flaky table handling )
Opera 5.0 and 6.0
Mozilla 1.1
Presentation in IE5+ must be perfect. I tolerate minor layout problems in
the other browsers, but
Dunno.
I also remember once having a parse error, but it was on line 35.
Cheers
Ignatius
- Original Message -
From: "David Rice" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 8:53 PM
Subject: [PHP-DB] need help s
Hello,
I need some help from you MySQL gurus out there. This is pure SQL by the
way..no front-end.
Lets say you have a table that has 2columns.columnA,
ColumnB and columnC
I have something like this
if (columnA>'7', (columnB/columnC) + 52, columnB/ColumnC) as "Number"
however i need to te
I keep getting the following error:
Parse error: parse error in
/var/www/cgi-bin/ld/lslreporting_edit/libs_by_house.php on line 8
I've included all my code below and marked line 8 with *
The curios thing is that I copied and pasted the first 8 lines of code from
another script, and that other s
Unless what showed up here isn't what you posted (quite possible),
the only differences between the first and second time you posted
were:
-require instead of include
-Removed quotes on
>
--- David Rice <[EMAIL PROTECTED]> wrote:
>
>
>
> It Does have a closing Br
In your second e-mail you posted the error message, but failed to identify
line 34. This is important so we can tell what code the parser is gagging
on. Otherwise, it's going to take longer to get an answer because we're
guessing which line is line 34.
> -Original Message-
> From: David Ri
It Does have a closing Brace, just check my second email it contains the
FULL code.. i missed the last few lines copying it the first time somehow.
From: "Andreas Sheriff" <[EMAIL PROTECTED]>
To: "David Rice" <[EMAIL PROTECTED]>
Subject: RE: [PHP-DB] need help spotting this php parse error
Da
"Parse error: parse error in
/home/filterseveuk/public_html/project/login.php on line 34"
That is the exact error message,
Cheers, Dave
session_start();
if(!$HTTP_COOKIE_VARS["username"]) {
/* The Cookie is not set, so load the page as if it is the first time
*/
require("library/in
You forgot to close the { of the first if-statement.
">
David Rice <[EMAIL PROTECTED]> [EMAIL PROTECTED] 20:53 Uhr:
> When i run this script it tells me that I have a parse error on line 34? I
you might try pulling the semi colon out before while. i put it in
red. i think,that's probably it. addison
When i run this script it tells me that I have a parse error on line
34? I really can't see it anyhelp (please!) would be much
appreciated Cheers, Dave
session_start();
if(!$HTTP_C
Tell us specifically what the parse error is reporting to you and
specifically what line is line 34.
> -Original Message-
> From: David Rice [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 23, 2003 2:53 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] need help spotting this php parse e
When i run this script it tells me that I have a parse error on line 34? I
really can't see it anyhelp (please!) would be much appreciated Cheers, Dave
session_start();
if(!$HTTP_COOKIE_VARS["username"]) {
/* The Cookie is not set, so load the page as if it is the first time
*/
inclu
Hi.
We have an FreeBSD 4.5 with php4 installed on it.
Now we need to connect from our php-Project to PostgreSQL-7.3.1.
But there is no php-extention installed. In Windows distribution it is
available.
Where can we get this extention for Unix?
Any help will be appreciated
Thanx in advance
Yurij Ny
Hello,
I have trouble with php-4.3.0 en mysql max 4.0.9 gamma.
If I use innodb and I want to use rollback and commit i got an error.
If I set auto commit=0 and try to insert a record I recieve the message
Lock wait timeout try to restart transactions.
I look into de newsgroup and don't find the a
When you go through the URL, you're using GET, not POST. ALl you really have
to do is this:
$parcel_query = "SELECT * FROM land01_02_03 WHERE (PelNumber LIKE
".$_GET["number"].") AND (OnerName1 LIKE ".$_GET["number"].") ";
Then you can drop the while loop that extracts the variables from the HTT
forget that code
just do this
$parcel_query = "SELECT * FROM land01_02_03 WHERE (PelNumber LIKE
'$_GET[number]%') AND (OnerName1 LIKE '$_GET[owner]%') ";
do this for seeing the url values:
print_r($_GET);
I am trying to get my values back out of a URL that has been passed from a
page
I am trying to get my values back out of a URL that has been passed from a
page with a form. Here's what the URL looks like.
searchresult.php?number=01&owner=smith&Submit=Submit
My mySQL query is working properly if I hard code a value in, but I can seem
to extract the values of number an
if(category = 'bla')
Maybe you shouldn't be using a constant if it's going to be changing each
time the page loads.
---John Holmes...
- Original Message -
From: "Shachar Tal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 7:46 AM
Subject: Re: [PHP-DB] While
Hi!
The same way you compare variables:
$a = 'a';
if($a == 'a')
echo '$a is a';
define('_a_', 'a');
if(_a_ == 'a')
echo '_a_ is a';
Remember to use ' instead of " so that $a is echoed not the value of $a.
.ma
Shachar Tal <[EMAIL PROTECTED]> [EMAIL PROTECTED] 13:46 Uhr:
> Thanks.
Here is a link to a tutorial which explains the issues and introduces
how
to use the new global variables.
Write Secure Scripts with PHP 4.2!
http://www.webmasterbase.com/article/758
Regards,
Doug
On Thu, 23 Jan 2003 00:30:24 +0100, Karina S wrote:
>Hi,
>
>I have read, that use global variables
Thanks. your way to do it gave me a good idea, and it's working now :)
Now I have another small question:
How can I check what's in a constant?
let's say i'm doing this :
define ( "category", $cat );
$cat can be something else each and every time the page loads, then, I want
to check what it is,
Jeffrey
Most probably site 2 has register_globals set to Off whilst site 1 has them
set to On...
Try using $_POST['name'] for $name, $_POST['age'] for $age and
$_SERVER['PHP_SELF'] for $PHP_SELF
Cheers
Rich
-Original Message-
From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]]
Sent: 23
I've learned the basics of PHP and MySQL by using a web hosting service over
the past few weeks. Call this site 1. And I am finally feeling that I am
getting the hang of things.
Now, another web host that I have been using is letting me try out PHP and
MySQL on their server. Call this site 2.
Th
Karina
Use the superglobal $_SESSION[] array together with session_start().
$HTTP_SESSION_VARS[] is not a super global.
Rich
-Original Message-
From: Karina S [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2003 23:30
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Secure variable transport (newbie)
I'm working on a similar project - I'm also a newbie - here's my approach -
which is fairly simple really.
Create a database of all members that includes columns for "login", "name"
and "paymentStatus" as well as any other info you need for your database.
paymentStatus would be an integer with val
On Thursday 23 January 2003 06:04, Shahar Tal wrote:
> Hello all!
>
> I got one page, with this code:
>
> echo insert_results();
> ?>
>
> Which grabs the data I send from another page, on that function.
> Here is the important part of the function while code:
>
> while ($row = mysql_fetch_array($r
37 matches
Mail list logo