Re: [PHP-DB] parse error

Rob - I think I see what you're doing: you're concatenating $message with something else (the HTML output following line 357?). Problem is, you're just stating the right hand side of what should be an assignment. The concatenation should be: $variable = $variable .= 'HTML output'; and it looks

[PHP-DB] Re: PHP and dBase file support?

[EMAIL PROTECTED] wrote: > Is the dBase file format supported on both ApacheWindows and Apache *NIX > versions of PHP? > > I see to enable dBase support, the "--enable-dbase" option has to be > included in the > configure command. > > I need to know if this command is supported in the Apache/PH

Re: [PHP-DB] Re: Dynamically populating a dropdown box

or alternatively, you can download a drop down box populating class from http://phpclasses.upperdesign.com/ - Original Message - From: "Matthew Crouch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 6:57 AM Subject: [PHP-DB] Re: Dynamically populating a drop

RE: [PHP-DB] parse error

Is it possible that there's a string farther up with an unclosed single-quote? --- Mark Roedel | "Blessed is he who has learned to laugh Systems Programmer| at himself, for he shall never cease LeTourneau University | to be entertained." Longview, Texas, USA |

[PHP-DB] Re: Dynamically populating a dropdown box

I'm no expert, and my code is probably buggy, but I think this is the gist of it: %s", $myrow["colorid"], $myrow["colorname"]); } ?> Chris Payne wrote: > Hi there everyone, > > I have a shopping cart which is starting to work nicely, but I have to select >size/color from the entries, how do

Re: [PHP-DB] Re: parse error

Rob, Can you show us a few lines before and after the script? The only thing that I can figure is that line 360 should end with a single quote and a semicolon (';), but it would be easier if we could see the code in context. Richard At 02:42 PM 12/13/2001, you wrote: > > > I've written a sm

[PHP-DB] Dynamically populating a dropdown box

Hi there everyone, I have a shopping cart which is starting to work nicely, but I have to select size/color from the entries, how do I do this dynamically in PHP with MySQL? I need them to be dropdown form boxes but haven't got a clue how to populate them from the fields of my database. Plea

Re: [PHP-DB] Re: parse error

your line 357 doesn't appear to have its semicolon... Rob Day wrote: > Sorry for not giving enough info. This is right in the middle of the script. > I do have the opening and closing tags. It must ne something else. > > -Original Message- > From: Matthew Crouch [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] Re: parse error

Not sure but if line 358 is... 358>no .. as it says below, then the ">" before the "no" needs a beginnnig to it somehow. It's like a html-tag that's only half baked. -- __ _Tyler Nally / /__ _(_)___ __

RE: [PHP-DB] Re: parse error

Sorry for not giving enough info. This is right in the middle of the script. I do have the opening and closing tags. It must ne something else. -Original Message- From: Matthew Crouch [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: [PHP-

[PHP-DB] anybody using stored procedures in sql server

is anybody using procs in sql server? has anyone been able to get a return parameter? can you use mssql_query, or only odbc? is this just a BIG FAT php limitation??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-ma

[PHP-DB] Re: parse error

you haven't shut your script with the ?> before starting your HTML, near as I can figure it Rob Day wrote: > I've written a small script that processes a form from a webpage and sends > the submitted data as an HTML e-mail that has the form all filled out > already. I've gotten smaller versions

[PHP-DB] Multiple mysql inserts

I have multiple functions hitting the dB (mysql) with inserts in a single page, and they can't seem to get together; i.e. I can get this or that function to do its job, but not all of them at once. Is there something I should know about "closing out" a mysql_query or $result before another can be

[PHP-DB] parse error

I've written a small script that processes a form from a webpage and sends the submitted data as an HTML e-mail that has the form all filled out already. I've gotten smaller versions of this script to work without any problem just to test the idea.I can't figure out why I'm now getting the followi

RE: [PHP-DB] ODBC with MS Access DB

Charles, The specific error message would be helpful. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Charles F. McKnight [mailto:[EMAIL PR

[PHP-DB] ODBC with MS Access DB

I am writing a simple application that will store data in an Access database. I have gotten a simple script that connects and selects some data from the database and this works fine. when I try to insert or update data it fails. I assume I am missing some permissions or something to make it be rea

Re: [PHP-DB] mssql_query, sybase_query

Okay, I solved the problem. FreeTDS 0.52 is BROKEN. upgrade to a newer version and all is well, the documentation is correct (I think). -brad On Wed, Dec 12, 2001 at 02:47:24PM -0800, Bradley Bell wrote: > Is it just me, or is the documentation for these two functions totally wrong? > They are

[PHP-DB] PHP and dBase file support?

Is the dBase file format supported on both ApacheWindows and Apache *NIX versions of PHP? I see to enable dBase support, the "--enable-dbase" option has to be included in the configure command. I need to know if this command is supported in the Apache/PHP *NIX environment, or is it only supporte

Re: [PHP-DB] Connecting to MySQL Database

After using your suggestion, I found an additional SPELLING mistake that was causing my problem! Thanks for your help - Original Message - From: "Jonathan Hilgeman" <[EMAIL PROTECTED]> To: "'Michael Elliott'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 13,

[PHP-DB] quetion about Win PHP & mssql

I have php setup on the following platform: Web Server: Win2k IIS DB Server: MSSQL 2000 I'm having a problem when running a view that acesses a user defined function. The function outputs a converted date to varchar + a varchar string. The problem is that when I loop through the recordset I ge

RE: [PHP-DB] ODBC .. ehm .. help :)

If you followed the howto and you are still receiving an "undefined function" error, than you might have more than one apache/php instance, and you are starting the wrong one :) What was the configure command you used? Did you use a --prefix? If so, that is the one you need to start. Also, che

RE: [PHP-DB] Connecting to MySQL Database

Try moving session_start to the very top of the script (above the require statement), and then place the session_register on the line immediately below session_start. You should first create the empty session variable $admin_user, and THEN assign a value to it. But the most logical thing to do wou

Re: [PHP-DB] Connecting to MySQL Database

Alright here goes. This is my login function: function login($username, $password) // check username and password with db // if yes, return true // else return false { // connect to db $conn = db_connect(); if (!$conn) return 0; // check if username is unique $result = mysql_query("

RE: [PHP-DB] Connecting to MySQL Database

Can you show us the code that checks the username and password to see if they're correct? Is this a custom admin page that you created? If your page is authenticating against the "mysql" database, then you should know that MySQL encrypts the password and stores the encrypted password. So if y

Re: [PHP-DB] Data -> countinents, countries, provinces, cities >10.000

Why not try searching at www.google.com ? Andy wrote: >Hi there, > >I am building a travel portal and I can't get data for the registration. > >Does anybody have, or know where I can get this data from? > >I am searching for the continents belonging to the countries, belonging to >the provinces

RE: [PHP-DB] ODBC .. ehm .. help :)

Bikkel, Is ODBC enabled on your sever? If this is a *nix server, follow the Howto at www.iodbc.org. If windows, check your odbc.ini for the proper setting. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integ

[PHP-DB] Help me with php script calculate Download time of file

Hi everyone, Could anyone help me giving a php code that calculates time required to download a url (including downloading of images in that particular url). if you could tell me the site also it would be great helpful to you people. Thank You E.chidmbaram ___

[PHP-DB] Connecting to MySQL Database

I am trying to create an admin page to administer my database. I used a file .sql to create my database. In the file, I included: grant select, insert, update, delete on database.* to admin@localhost identified by 'password'; Why can I not log in successfully using admin and password? Thanks

[PHP-DB] Re: memory leak???

Sommai Fongnamthip wrote: > Hi, > > I have an error when try to query from 2 database (m$ sql). > > Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to > allocate 29 bytes) You have exhausted allow memory for PHP to use. Increase your memory limit. (Read php.ini-dist or php

Re: [PHP-DB] Dumb Question??

Sorry! just read-read my post, it should have been: particular column ('modified') *NOT* to appear under specific circumstances, somewhere along... Cheers. Russ On Thu, 13 Dec 2001 12:03:09 + (GMT Standard Time) Russ Michell <[EMAIL PROTECTED]> wrote: > Hi there everyone: > > I have

[PHP-DB] Dumb Question??

Hi there everyone: I have a genericphp/MySQL search+retrival mechanism. Generic in that it takes table names, fieldnames and fieldtypes as form lables and element names. However, because of this I cannot hard-code my SQL queries as they need to be as generic (univerally useful) as possible.

[PHP-DB] ODBC .. ehm .. help :)

Hi, i get the following error with the code listed below: "Fatal error: Call to undefined function: odbc_connect() in /home/users/sites/www.nlhq.nl/html/connect.php3 on line 2" This is the URL of the PHP script: http://www.nlhq.nl/connect.php3 Tought it might my usefull to give ya all the inf

[PHP-DB] memory leak???

Hi, I have an error when try to query from 2 database (m$ sql). Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 29 bytes) when I check my server memory it have free for a lot total used free sharedbuffers cached Mem:1

RE: [PHP-DB] Problem with MySQL and array loop

On Thu, 2001-12-13 at 11:42, matt stewart wrote: > you're only printing stuff while i=0, i=1,i=6. > therefore only 7 things come out. > either make the loop for($i=0;$i<=7;$i++), or for($i=0;$i<8;$i++). Oh! Thanks a million! It works like a charm now. So I guess the second alternative was ri

RE: [PHP-DB] Problem with MySQL and array loop

you're only printing stuff while i=0, i=1,i=6. therefore only 7 things come out. either make the loop for($i=0;$i<=7;$i++), or for($i=0;$i<8;$i++). -Original Message- From: +markus lervik [mailto:[EMAIL PROTECTED]] Sent: 13 December 2001 09:37 To: php-db Subject: [PHP-DB] Problem with

[PHP-DB] Problem with MySQL and array loop

Hello, I've got a really strange problem. When looping through a result given by mysql_fetch_row(), the code for some reason ignores the last column in the database. The code snippet I'm using now is while($row=mysql_fetch_row($result)) { print(""); for($i=0;$i<7;$i++) {

[PHP-DB] Re: PHP and Oracle

Hi Georgina, If projectID or moduleID is a number and not a varchar, you would remove the ' enclosing the values. WHERE projectID=$projectID vs WHERE projectID='$projectID' Regards, Philippe "Georgina Elaine Bailey" <[EMAIL PROTECTED]> a écrit dans le message news: 000801c18272$8189aa10$[EMA

Re: [PHP-DB] ODBC problem

Hello, We resolved ourselves the problem by changing the ODBC driver. Bye. - Original Message - From: "Christine Cameli" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Katell Galard" <[EMAIL PROTECTED]> Sent: Tuesday, December 11, 2001 5:03 PM Subject: [PHP-DB] ODBC problem Hello, I'