[PHP-DB] Re: variable and MySQL

2005-03-14 Thread Nadim Attari
> I'd like to use $get_question_data[xxx_name_en] > $get_question_data[$test_name_en] > $get_question_data[{$test}_name_en] > ${get_question_data[$test_name_en]} try this ... $get_question_data["{$test}_name_en"] Hope it works... Nadim Attari -- PHP Database Mailing List (http://www.php.net

[PHP-DB] variable and MySQL

2005-03-14 Thread simon
Hi, I'm trying to make a script but have a problem ... How could I do this: I'd like to use $get_question_data[xxx_name_en] where xxx would be a variable variable according to the situation where the script is called... how would I do this? tried : $get_question_data[$test_name_en] $get_que

[PHP-DB] Error with "Where" Clause

2005-03-14 Thread kc68
I get only the table headings and text before and after the table, but not the table, when I add the "where" clause as below. Without the "where" clause, the table does come up but (as expected) is repetitive and very long. I'm using a template that I've used many times. I've tried chang

RE: [PHP-DB] Queries close session

2005-03-14 Thread Adept-Hosting.Net Administration
Thanks for the quick reply. That doesn't seem to be the problem, though, as I can't seem to find any additional spaces being sent in the headers. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Calvin Lough > Sent: March 14, 2005 3:07 PM > To: Adept

Re: [PHP-DB] Queries close session

2005-03-14 Thread Calvin Lough
Because the session you are using probably uses a cookie to remember the session, it is required that you call session_start before you output anything to the screen(aka: send any headers). So if you place the session start at the very top of your page before you include any files or output anythin

[PHP-DB] Queries close session

2005-03-14 Thread Adept-Hosting.Net Administration
I am using the following script to maintain a login session on some pages: logging in again or contact the mailto:[EMAIL PROTECTED]">system administrator'); } ?> The sessions are stable and work fine EXCEPT when I run another PHP script on the web pag

Re: [PHP-DB] PHP MSSQL bug

2005-03-14 Thread Robert Twitty
Then, is it safe to assume that you can run stored procedures and queries that don't use a remote linked server? Fundamentally, I don't know why PHP would be the problem, since the remote link is established within the stored procedure. To make sure that it is not a problem with the mssql extensio

Re: [PHP-DB] PHP MSSQL bug

2005-03-14 Thread Bastien Koert
You may be using the SA credentials, but will the sql server allow the connection from the webserver. That is a different situation. Bastien From: Raul IONESCU <[EMAIL PROTECTED]> Reply-To: Raul IONESCU <[EMAIL PROTECTED]> To: php-db@lists.php.net CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP M

Re: [PHP-DB] redirecting function

2005-03-14 Thread Ben Galin
On Mar 14, 2005, at 2:26 AM, Ken wrote: On Mon, 14 Mar 2005 01:43:09 -0800 (PST), Yemi Obembe <[EMAIL PROTECTED]> wrote: hi folks, who knows any function that can do this javascript trick
window.location='http://somewhere.com/'
tried header(location:ht

Re: [PHP-DB] PHP MSSQL bug

2005-03-14 Thread Raul IONESCU
Yes, of course; I'm running under sa credentials so that's not the problem. On Mon, 14 Mar 2005 09:28:15 -0500, Bastien Koert <[EMAIL PROTECTED]> wrote: > Do you have permissions to run the query as the php/webserver user? > > Bastien > > >From: Raul IONESCU <[EMAIL PROTECTED]> > >Reply-To: Rau

RE: [PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread Bastien Koert
Yes, the 'a' value can also be a table alias name. Bastien From: JeRRy <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Re: Handling database calculations with a php page Date: Mon, 14 Mar 2005 19:46:46 +1100 (EST) Hi, So in other words when we are talking queries anything before a .

RE: [PHP-DB] PHP MSSQL bug

2005-03-14 Thread Bastien Koert
Do you have permissions to run the query as the php/webserver user? Bastien From: Raul IONESCU <[EMAIL PROTECTED]> Reply-To: Raul IONESCU <[EMAIL PROTECTED]> To: php-db Subject: [PHP-DB] PHP MSSQL bug Date: Mon, 14 Mar 2005 09:16:40 +0200 I have created a stored procedure wich is accessing an remo

Re: [PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread Miles Thompson
That's the convention. You HAVE TO: - read and use the manual, the rest of us do - dig out and follow a tutorial on working with PHP and databases If you do not, you will have no real knowledge of what you're doing, only a piecemeal "Someone said to do it this way." Do this BEFORE

Re: [PHP-DB] ways of making access and visib compat with 4 and 5

2005-03-14 Thread Erwin Kerk
tony yau wrote: hi all, I'm trying to make my classes compat with php4 and php5 is there a way of doing something like this: if( version== 4) define( "VISIBILITY", "" ); else if (version==5) define( "VISIBILITY", "protected" ); class Flex { VISIBILITY function CompatFunc(); } No, seem

Re: [PHP-DB] ways of making access and visib compat with 4 and 5

2005-03-14 Thread Jochem Maas
tony yau wrote: hi all, I'm trying to make my classes compat with php4 and php5 is there a way of doing something like this: if( version== 4) define( "VISIBILITY", "" ); else if (version==5) define( "VISIBILITY", "protected" ); class Flex { VISIBILITY function CompatFunc(); } this will

[PHP-DB] ways of making access and visib compat with 4 and 5

2005-03-14 Thread tony yau
hi all, I'm trying to make my classes compat with php4 and php5 is there a way of doing something like this: if( version== 4) define( "VISIBILITY", "" ); else if (version==5) define( "VISIBILITY", "protected" ); class Flex { VISIBILITY function CompatFunc(); } -- Tony Yau -- PHP

Re: [PHP-DB] redirecting function

2005-03-14 Thread Ken
you forgot the quotation marks on header i believe header('location: www.foobar.com'); and also make sure your browser supports header redirects, not all browsers do. On Mon, 14 Mar 2005 01:43:09 -0800 (PST), Yemi Obembe <[EMAIL PROTECTED]> wrote: > hi folks, > who knows any function that can d

[PHP-DB] redirecting function

2005-03-14 Thread Yemi Obembe
hi folks, who knows any function that can do this javascript trick window.location='http://somewhere.com/' tried header(location:http://somewhere.com/) but it gave me an errorinclude() on the other hand only includes the url & doest redirect to it... thn

[PHP-DB] watch and learn

2005-03-14 Thread chintan
hi guys my code is as below just look at that and tell me what should i add to have two colomns in my table; include ('connect.php'); $query = "SELECT * FROM stockiestandbookingagents order by city,companyname,postalcode"; $result = mysql_query($query) or die("Query failed"); for($e=0;$e";

[PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread JeRRy
Hi, So in other words when we are talking queries anything before a . for SELECT etc means table name and after the . means column name within that table? So... (table_name).(Column_name) ? Is that right? J Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com --