Re: [PHP-DB] While + Function

2003-01-23 Thread Jason Wong
On Thursday 23 January 2003 06:04, Shahar Tal wrote: Hello all! I got one page, with this code: ?php 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 =

RE: [PHP-DB] Members area

2003-01-23 Thread Baumgartner Jeffrey
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 values

RE: [PHP-DB] Secure variable transport (newbie)

2003-01-23 Thread Rich Gray
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)

[PHP-DB] Data won't insert

2003-01-23 Thread Baumgartner Jeffrey
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.

RE: [PHP-DB] Data won't insert

2003-01-23 Thread Rich Gray
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

Re: [PHP-DB] While + Function

2003-01-23 Thread Shachar Tal
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,

Re: [PHP-DB] Secure variable transport (newbie)

2003-01-23 Thread Doug Thompson
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

Re: [PHP-DB] While + Function

2003-01-23 Thread Matthias St.
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.

Re: [PHP-DB] While + Function

2003-01-23 Thread 1LT John W. Holmes
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 +

[PHP-DB] Getting values back out of a URL

2003-01-23 Thread Danialle Wiltsie
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=01owner=smithSubmit=Submit My mySQL query is working properly if I hard code a value in, but I can seem to extract the values of number and

RE: [PHP-DB] Getting values back out of a URL

2003-01-23 Thread Snijders, Mark
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

RE: [PHP-DB] Getting values back out of a URL

2003-01-23 Thread Hutchins, Richard
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 HTTP array.

[PHP-DB] Lock wait timeout error

2003-01-23 Thread A.J. Kruit
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

[PHP-DB] Where can I get an extention to connect to PostgeSQL DB on Unix?

2003-01-23 Thread Yurij Nykon
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

[PHP-DB] need help spotting this php parse error

2003-01-23 Thread David Rice
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 */

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Hutchins, Richard
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 error

Re: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Addison Ellis
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();

[PHP-DB] Re. Need help spotting PHP parse error

2003-01-23 Thread David Rice
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 */

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread David Rice
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 Date:

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Hutchins, Richard
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

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Mark
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 option value=... If you count your open and close braces, they don't seem to match up. There's a close brace

[PHP-DB] another parse error

2003-01-23 Thread Rob Day
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

[PHP-DB] MySQL Query Question

2003-01-23 Thread Jeremy
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 test

Re: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Ignatius Reilly
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

RE: [PHP-DB] PHP-DB - ot browser compatibility

2003-01-23 Thread Peter Lovatt
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,

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Peter Lovatt
Hi Probably a missing ; ? option value=? echo $row[0]; ?? echo $row[1]; echo $row[2]; ?/option ? } ; - here ? /select /form -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED]] Sent: 23 January 2003 22:00 To: David Rice;

Re: [PHP-DB] MySQL Query Question

2003-01-23 Thread Frank Peavy
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,

Re: [PHP-DB] PHP-DB - ot browser compatibility

2003-01-23 Thread David T-G
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

Re: [PHP-DB] MySQL Query Question

2003-01-23 Thread Ignatius Reilly
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] To:

[PHP-DB] ms sql limit equivalence

2003-01-23 Thread Grant, Dean (OIT)
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

[PHP-DB] Re: ms sql limit equivalence

2003-01-23 Thread Manuel Lemos
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

Re: [PHP-DB] ms sql limit equivalence

2003-01-23 Thread Jeffrey_N_Dyke
i forget exactly how to use it, but look up TOP. although it does not perform like LIMIT. hth Jeff Grant, Dean

RE: [PHP-DB] ms sql limit equivalence

2003-01-23 Thread John W. Holmes
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

RE: [PHP-DB] MySQL Query Question

2003-01-23 Thread John W. Holmes
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',

[PHP-DB] Array trouble

2003-01-23 Thread Tyler Whitesides
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

[PHP-DB] Array trouble

2003-01-23 Thread Tyler Whitesides
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