[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 --

[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; ?php include ('connect.php'); $query = SELECT * FROM stockiestandbookingagents order by city,companyname,postalcode; $result = mysql_query($query) or die(Query failed);

[PHP-DB] redirecting function

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

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 do

[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] 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 never

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, seems to me

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] 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 php-db@lists.php.net Subject: [PHP-DB] PHP MSSQL bug Date: Mon, 14 Mar 2005 09:16:40 +0200 I have created a stored procedure wich is

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 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: Raul IONESCU

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 script window.location='http://somewhere.com/' /script tried header(location:http://somewhere.com/) but it gave

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

[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: ?php session_start(); if(empty($_SESSION['username'])) { die('An error has ocurred. It may be that you have not logged in, or that your session has expired.

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

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:

[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 changing

[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]

[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/) To