Re: [PHP-DB] Problem with creating parallel connections with mysql_connect

2006-01-18 Thread Bastien Koert
If no connection is made, there is no mysql error. You would need some custom error message output when the mysql_connect fails... Bastien From: Aarno Syvänen [EMAIL PROTECTED] To: David Robley [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] Problem with creating parallel

RE: [PHP-DB] problem of retrieving urls from mysql

2005-12-07 Thread Edward Gray
actually, you may want to check the source of the page. if the url does not start with http://; (or https, or ftp, etc.), browsers will assume the link is on the current server. how are you storing the urls? as full urls, as domain/path/file.htm, ? if all of your urls should start with

RE: [PHP-DB] problem of transmiting variabl into another page?

2005-12-07 Thread Ford, Mike
On 02 December 2005 13:06, Bastien Koert wrote: ?php for ($j=ord('A'); $j = ord('Z'); $j++) { echo | ba href='alpha.php?artist=.chr($j).'.chr($j)./a/b ; } ? You need to use the ORD function to get the numerical ascii equivalent of the letter and the CHR function to go back the

Re: [PHP-DB] problem of retrieving urls from mysql

2005-12-07 Thread Mohamed Yusuf
I am getting link from visitor using form, that means I don't have control what they would type. e.g they may type http://www.suggestedlink.com/myfav.wav, www.suggestedlink.com/myfav.ram and http://suggestedlink.com/myfav.mp3 or so I am looking general version which can handle all. and on top of

Re: [PHP-DB] problem of retrieving urls from mysql

2005-12-07 Thread Edward Gray
you should then check the strings provided by your users. you can do this before or after the link is added to your database. use a regex to verify that the url provided is a full url (starting with 'http://', etc.). if it is not, then prepend 'http://'. i would recommend doing this before

RE: [PHP-DB] problem of retrieving urls from mysql

2005-12-06 Thread Bastien Koert
$url = str_replace(www.mydomain.com,,$url) bastien From: Mohamed Yusuf [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] problem of retrieving urls from mysql Date: Tue, 6 Dec 2005 09:51:18 -0800 I would like to store and retrieve urls, but I have problem which is I get my url +

RE: [PHP-DB] problem of transmiting variabl into another page?

2005-12-02 Thread Bastien Koert
?php for ($j=ord('A'); $j = ord('Z'); $j++) { echo | ba href='alpha.php?artist=.chr($j).'.chr($j)./a/b ; } ? You need to use the ORD function to get the numerical ascii equivalent of the letter and the CHR function to go back the other way. Bastien From: Mohamed Yusuf [EMAIL

Re: [PHP-DB] problem of transmiting variabl into another page?

2005-12-02 Thread Cal Evans
Using the code below, when you click on the link for A it will go to alpha.php?artist=A In alpha.php, you should be able to query $_GET['artist'] to get the letter clicked on. You could also check $_REQUEST['artist'] for the same info. Is that what you needed or are you having other

RE: [PHP-DB] Problem of Upload media file

2005-11-17 Thread Bastien Koert
Check your permissions on the folder...you may need to make them 777 to allow read/write by all for the upload Bastien From: Mohamed Yusuf [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Problem of Upload media file Date: Thu, 17 Nov 2005 08:58:15 -0800 I am trying to upload

Re: [PHP-DB] Problem of Upload media file

2005-11-17 Thread Mohamed Yusuf
the permissions are right, I mean they are all setted to 777. On 11/17/05, Bastien Koert [EMAIL PROTECTED] wrote: Check your permissions on the folder...you may need to make them 777 to allow read/write by all for the upload Bastien From: Mohamed Yusuf [EMAIL PROTECTED] To:

Re: [PHP-DB] Problem of Upload media file

2005-11-17 Thread Micah Stevens
Keep in mind you're referring to a filesystem path, and a relative one to boot, so what you're telling php is, that your upload directory is: /home/somally/public_html/music/music/media/ Which doesn't sound like what you intend. Also don't trust the php line numbers if you have significant

Re: [PHP-DB] Problem of Upload media file

2005-11-17 Thread Mohamed Yusuf
here is the complete code, so you can check it ? $uploadDir = 'www/media/'; if(isset($_POST['upload'])) { $fileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType =

Re: [PHP-DB] Problem of Upload media file

2005-11-17 Thread Micah Stevens
Well, the error doesn't match the code, but the code says to upload the file to: /home/somally/public_html/music/www/media/ Is that correct? On Thursday 17 November 2005 9:41 am, Mohamed Yusuf wrote: here is the complete code, so you can check it

Re: [PHP-DB] Problem of Upload media file

2005-11-17 Thread Mohamed Yusuf
so should I change the directory? where I want to upload file is www.somalilyrics.com/music/media/http://www.somalilyrics.com/music/media/, therefore what about if I say *$uploadDir = 'music/media/'; *is that fine? if it is not fine would you please show me how I have to do it? On 11/17/05,

Re: [PHP-DB] Problem of Upload media file

2005-11-17 Thread Micah Stevens
No. It's not okay.. you're already in the music directory.. if you want it in the media subdir, just put 'media/' On Thursday 17 November 2005 10:40 am, Mohamed Yusuf wrote: so should I change the directory? where I want to upload file is

Re: [PHP-DB] Problem of Upload media file

2005-11-17 Thread Mohamed Yusuf
Many thanks for your help. it works. On 11/17/05, Micah Stevens [EMAIL PROTECTED] wrote: No. It's not okay.. you're already in the music directory.. if you want it in the media subdir, just put 'media/' On Thursday 17 November 2005 10:40 am, Mohamed Yusuf wrote: so should I change the

RE: [PHP-DB] problem with mysql_error()

2005-10-27 Thread Bastien Koert
brError Message: . @mysql_error the '@' symbol suppresses the error message...remove it bastien From: Jason Gerfen [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] problem with mysql_error() Date: Thu, 27 Oct 2005 08:43:13 -0600 I am not sure why this is not returning any

Re: [PHP-DB] Problem with mail funktion

2005-09-17 Thread Chris
As far as I know the Unknown error related to the mail function indicates that PHP could not connect to the SMTP server specified in php.ini. You could load phpinfo(); and check to see what php.ini file you are using. Then check that for the SMTP setting. FYI: doing a google search on 'PHP

RE: [PHP-DB] Problem with mail funktion

2005-09-17 Thread Daryl Booth
I'm not sure what should be in the php.ini. Where can I find out what needs to be in the SMTP section? -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Sonntag, 18. September 2005 05:10 To: php-db@lists.php.net Subject: Re: [PHP-DB] Problem with mail funktion As far as I

Re: [PHP-DB] Problem with mail funktion

2005-09-17 Thread Chris
: [PHP-DB] Problem with mail funktion As far as I know the Unknown error related to the mail function indicates that PHP could not connect to the SMTP server specified in php.ini. You could load phpinfo(); and check to see what php.ini file you are using. Then check that for the SMTP setting

Re: [PHP-DB] Problem with mail funktion

2005-09-17 Thread viraj
2005 05:10 To: php-db@lists.php.net Subject: Re: [PHP-DB] Problem with mail funktion As far as I know the Unknown error related to the mail function indicates that PHP could not connect to the SMTP server specified in php.ini. You could load phpinfo(); and check to see what php.ini file you

Re: [PHP-DB] Problem with MySQL Extension

2005-06-25 Thread Georg Richter
Am Do, den 23.06.2005 schrieb Bomgardner, Mark A um 22:44: I upgrade the php-mysql extension from 4.3.2-8 to 4.3.2-23, which is the most current rpm and still no luck. I now get the message that it can't find mysqli extension. mysqli extension is part of PHP5, not of PHP4. /Georg --

Re: [PHP-DB] Problem Using Sessions. .. .

2005-05-05 Thread Patel, Aman
Shawn Singh wrote: that was very helpful...Thank you. One question I have is that I want to ensure that my admin page cannot get accessed unless a variable that was registered upon a successful login has been passed into the session...what can I do to ensure this? There are several ways to do

Re: [PHP-DB] Problem Using Sessions. .

2005-05-04 Thread Patel, Aman
From the PHP help page on session_register() If your script uses session_register(), it will not work in environments where the PHP directive register_globals is disabled. I'm assuming since you compiled and installed PHP 5.0.4 that your register_globals is disabled. I wouldn't recommend

Re: [PHP-DB] Problem Using Sessions

2005-05-04 Thread Mignon Hunter
The browser has already sent headers on line 13 of your code- line 25 must be the session_start - it has to come first and be at the very top of your code Shawn Singh [EMAIL PROTECTED] 05/04/05 03:13PM Hey All, I'm fairly new to PHP Programming. I have compiled and installed postgres version

RE: [PHP-DB] Problem Using Sessions

2005-05-04 Thread Miguel Guirao
Why dont'n you use soma classes from www.phpclasses.com about User Management!! There are great classes in this site!! -Original Message- From: Shawn Singh [mailto:[EMAIL PROTECTED] Sent: Miércoles, 04 de Mayo de 2005 03:14 p.m. To: php-db@lists.php.net Subject: [PHP-DB] Problem Using

Re: [PHP-DB] Problem Using Sessions. .

2005-05-04 Thread Shawn Singh
that was very helpful...Thank you. One question I have is that I want to ensure that my admin page cannot get accessed unless a variable that was registered upon a successful login has been passed into the session...what can I do to ensure this? Thank you, Shawn On 5/4/05, Patel, Aman [EMAIL

RE: [PHP-DB] Problem with foreach looping...

2005-04-07 Thread Mike Johnson
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] I am attempting to use a simple foreach loop on a query result, and I am only getting the first element of the array back. Here is the code... $exclude_query = SELECT hostname FROM exclusion; $exclude_results =

RE: [PHP-DB] Problem with foreach looping...

2005-04-07 Thread Wendell Frohwein
Try this $exclude_query = SELECT hostname FROM exclusion; $exclude_results = mysql_query($exclude_query, $Prod); while ($exclude = mysql_fetch_array($exclude_results)) { echo $exclude[hostname].\n; } -Wendell -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] Problem with MySQL configuration

2005-04-01 Thread Bastien Koert
Depending on what you do, you may need to go to things like replication and queries (selects only) off the replicated server. You may also want to look caching the results to limit the number of sql queries. Have a look at high performance mysql (www.highperformancemysql.com) for more info.

RE: [PHP-DB] Problem with an update after an insert: MySQL

2005-02-07 Thread Bastien Koert
Change yourr code to place the sql into a variable and the echo the variable out to see what the problem might be. You can also cut'n'paste the variable into the the mysql gui of your choice to see if there are other errors Bastien From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject:

Re: [PHP-DB] Problem with an update after an insert: MySQL

2005-02-07 Thread Bestman4unowwa
Bastien, Thanks for your help!. I think I found the answer to my problem. My system is a windows based system and it is not windows based. The system where the code doesn't work is Unix and is case sensitive. I went online to the mysql reference and found this link,

Re: [PHP-DB] Problem using session bu submitting the session id through a form

2005-01-08 Thread graeme
Hi, Not certain what is happening try the following script. On my machine the form retains the session ID. Note the sending the ID as a GET is only done for cross checking. You can remove it and there will be no change in the display. ?php session_start(); ? html body ?php $id =

Re: [PHP-DB] Problem using session bu submitting the session id througha form

2005-01-08 Thread Henk Jan Wils
thanx, i did use the GET method to send a form. with the POST i works!!! thanks again! - Original Message - From: graeme [EMAIL PROTECTED] To: Henk Jan Wils [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, January 08, 2005 11:36 AM Subject: Re: [PHP-DB] Problem using session

Re: [PHP-DB] Problem with permissions Win32 dba_open

2004-12-30 Thread Ian
Bastien Koert [EMAIL PROTECTED] wrote: have you set the permissions in the folders? Right click on the folder and choose Properties...then set the appropraiate permissions bastien [snip] Thanks, Bastien. Altering permissions doesn't appear to work, at least not the way it seems to be

Re: [PHP-DB] Problem with permissions Win32 dba_open

2004-12-30 Thread Bastien Koert
make sure in the general tab that the read only checkbox is NOT checked bastien From: Ian [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] Problem with permissions Win32 dba_open Date: Thu, 30 Dec 2004 12:54:49 - Bastien Koert [EMAIL PROTECTED] wrote: have you set

Re: [PHP-DB] Problem with permissions Win32 dba_open

2004-12-30 Thread Ian
[EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] Problem with permissions Win32 dba_open Date: Thu, 30 Dec 2004 12:54:49 - Bastien Koert [EMAIL PROTECTED] wrote: have you set the permissions in the folders? Right click on the folder and choose Properties...then set

Re: [PHP-DB] Problem with permissions Win32 dba_open

2004-12-29 Thread Ian
Bastien Koert [EMAIL PROTECTED] wrote is your ms firewall turned on? ms sp2 screws a lot of stuff up.. bastien Thanks bastien, I'm running Norton IS 2005, with Windows Firewall switched off. Whether or not I turn off the Norton firewall results in the same error: ?php $db = dba_open(

Re: [PHP-DB] Problem with permissions Win32 dba_open

2004-12-29 Thread Bastien Koert
have you set the permissions in the folders? Right click on the folder and choose Properties...then set the appropraiate permissions bastien From: Ian [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] Problem with permissions Win32 dba_open Date: Wed, 29 Dec 2004 09:15:01 -

RE: [PHP-DB] Problem with permissions Win32 dba_open

2004-12-28 Thread Bastien Koert
is your ms firewall turned on? ms sp2 screws a lot of stuff up.. bastien From: Ian [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Problem with permissions Win32 dba_open Date: Tue, 28 Dec 2004 23:36:08 - Hi all, Season's Greetings! I am testing my PHP scripts locally under XP

Re: [PHP-DB] Problem with an insert query

2004-11-15 Thread Simon Rees
On Saturday 13 November 2004 20:25, GH wrote: Explain Bind Vars please... Thanks It is a technique for preparing an SQL statement with placeholders which can then be substituted with values when the statement is executed. It will be unavailable to you unless you are using MySQL 4.1.3 or above

RE: [PHP-DB] Problem with an insert query

2004-11-13 Thread Bastien Koert
what mysql version are you running? versions under 4.1 DONT support subqueries bastien From: GH [EMAIL PROTECTED] Reply-To: GH [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with an insert query Date: Sat, 13 Nov 2004 01:29:58 -0500 In my mySQL database I have the following

Re: [PHP-DB] Problem with an insert query

2004-11-13 Thread Simon Rees
You also appear to have a quote in the value that contains the word members' You will need to escape this or use bind vars. Simon On Saturday 13 November 2004 06:29, GH wrote: In my mySQL database I have the following tables: +-+ | Tables_in_AHRC | +-+ |

Re: [PHP-DB] Problem with an insert query

2004-11-13 Thread GH
Explain Bind Vars please... Thanks On Sat, 13 Nov 2004 19:08:59 +, Simon Rees [EMAIL PROTECTED] wrote: You also appear to have a quote in the value that contains the word members' You will need to escape this or use bind vars. Simon On Saturday 13 November 2004 06:29, GH wrote:

RE: [PHP-DB] Problem with script

2004-11-02 Thread Bastien Koert
from the brief error message your provided, I think its blowing up on the single quote contained in the word can't. you need to handle this by choosing one a few of these methods replace all single quotes with two single quotes $text = str_replace(','', $text); addslashes function $text =

Re: [PHP-DB] Problem with script

2004-11-02 Thread Robby Russell
On Tue, 2004-11-02 at 10:41 -0600, [EMAIL PROTECTED] wrote: Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 't read card','1099413551')' at line 1 My initial guess is that you do not have

RE: [PHP-DB] Problem with script

2004-11-02 Thread Russell Johnson
Just looking at the error message shows why it's failing in this case: 't read card','1099413551')' at line 1 One of the fields you're trying to insert is likely 'Can't read card', and since in the query you are surrounding it with single quotes, and it's coughing on the word Can't , which has

RE: [PHP-DB] Problem with script

2004-11-02 Thread Peter Lovatt
Try echoing the actual query being run. It will give you more info to work with. Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 November 2004 16:42 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with script Hi all, greetings from

Re: [PHP-DB] Problem with this query?

2004-08-02 Thread John Holmes
Dylan Barber wrote: Okay maybe its late or something but this should work, however I get this #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT tblVideos.PerformerID FROM tblVideos WHERE 1 =1 AND

RE: [PHP-DB] Problem with this query?

2004-08-02 Thread Dylan Barber
AM To: Dylan Barber Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Problem with this query? Dylan Barber wrote: Okay maybe its late or something but this should work, however I get this #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL

RE: [PHP-DB] Problem with this query?

2004-08-02 Thread Dylan Barber
To: Dylan Barber Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Problem with this query? Dylan Barber wrote: Okay maybe its late or something but this should work, however I get this #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL

Re: [PHP-DB] problem....

2004-06-23 Thread David Robley
: water_foul [EMAIL PROTECTED] Date: Wednesday, June 23, 2004 8:58 am Subject: Re: [PHP-DB] problem I checked em all they were right Daniel Clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sounds like it doesn't like your SQL statement. Perhaps a field or table name

Re: [PHP-DB] problem....

2004-06-23 Thread Jonathan Haddad
23, 2004 8:58 am Subject: Re: [PHP-DB] problem I checked em all they were right Daniel Clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sounds like it doesn't like your SQL statement. Perhaps a field or table name is incorrect? Warning

Re: [PHP-DB] problem....

2004-06-22 Thread Cole S. Ashcraft
Just from looking at it, it seems to be because you are redefining a variable, which destroys it, then calling for a mysql resource that has been destroyed. What is the error? I can't gaurantee that that is what is happening. Cole why doesn't this work: $pic=mysql_query('SELECT Rune,

Re: [PHP-DB] problem....

2004-06-22 Thread Daniel Clark
What error are you getting? why doesn't this work: $pic=mysql_query('SELECT Rune, username FROM RuneRunner RuneRunner_1 WHERE (User_ID = 3)',$connection); $pic=mysql_fetch_array($pic); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] problem....

2004-06-22 Thread water_foul
I tried that it didn't work Cole S. Ashcraft [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Just from looking at it, it seems to be because you are redefining a variable, which destroys it, then calling for a mysql resource that has been destroyed. What is the error? I can't

Re: [PHP-DB] problem....

2004-06-22 Thread water_foul
I checked em all they were right Daniel Clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sounds like it doesn't like your SQL statement. Perhaps a field or table name is incorrect? Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

Re: [PHP-DB] problem....

2004-06-22 Thread water_foul
PROTECTED] Date: Wednesday, June 23, 2004 8:58 am Subject: Re: [PHP-DB] problem I checked em all they were right Daniel Clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sounds like it doesn't like your SQL statement. Perhaps a field or table name is incorrect

Re: [PHP-DB] problem....

2004-06-22 Thread Cole S. Ashcraft
single quotes around the digit 3. - Original Message - From: water_foul [EMAIL PROTECTED] Date: Wednesday, June 23, 2004 8:58 am Subject: Re: [PHP-DB] problem I checked em all they were right Daniel Clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sounds like

Re: [PHP-DB] problem....

2004-06-22 Thread Cole S. Ashcraft
? And also wrap single quotes around the digit 3. - Original Message - From: water_foul [EMAIL PROTECTED] Date: Wednesday, June 23, 2004 8:58 am Subject: Re: [PHP-DB] problem I checked em all they were right Daniel Clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED

Re: [PHP-DB] Problem with PHP ODBC

2004-05-05 Thread Robert Twitty
If you are able to place the Access database on a Windows machine that can be accessed by the Linux machine, then you can use odbtp. You can get it at http://odbtp.sourceforge.net. -- bob On Wed, 5 May 2004 [EMAIL PROTECTED] wrote: Hi, I try to configure a web server under Debian/GNU/Linux

Re: [PHP-DB] Problem with PHP ODBC

2004-05-05 Thread ofontes
I try to configure a web server under Debian/GNU/Linux Sarge. All fonctionning perfectly except odbc connect. I have to read datas in an ACCESS2000 mdb file to import in Mysql. Actually this run correct under a windows 2000 workstation with apache/PHP/Mysql I installed on my

Re: [PHP-DB] Problem with PHP ODBC

2004-05-05 Thread Robert Twitty
If you are able to place the Access database on a Windows machine that can be accessed by the Linux machine, then you can use odbtp. You can get it at http://odbtp.sourceforge.net. -- bob My problem is i can't modify my PHP code. Actually the web site runs on a windows2000

Re: [PHP-DB] Problem with update-command

2004-04-22 Thread jeffrey_n_Dyke
$result=mysql_db_query(usr_172_1,UPDATE artikel SET Preis='\$preis\' WHERE ID='\$id\'); //mysql_error($result); Here you're escaping the $ and then the ', have you tried $result=mysql_db_query(usr_172_1,UPDATE artikel SET Preis='{$preis}' WHERE ID='{$id}'); with those escapes this is the

Re: [PHP-DB] Problem with update-command

2004-04-22 Thread Torsten Roehr
Jeffrey N Dyke [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] $result=mysql_db_query(usr_172_1,UPDATE artikel SET Preis='\$preis\' WHERE ID='\$id\'); //mysql_error($result); Here you're escaping the $ and then the ', have you tried $result=mysql_db_query(usr_172_1,UPDATE

Re: [PHP-DB] Problem, please help!

2004-03-21 Thread John
try writing it like $sql = UPDATE round1 SET game1=' . $game1 . ', game2=' . $game2 . ', game3=' . $game3 . ', game4=' . $game4 . ', game5=' . $game2 . ', game6=' . $game6 . ', game7=' . $game7 . ',

Re: [PHP-DB] Problem, please help!

2004-03-20 Thread Filip de Waard
On Mar 21, 2004, at 3:44 AM, JeRRy wrote: Hi, I have not used this site in a while and have a problem. I can't get anything to save to the database. :( Not sure what is wrong, need a fix fast as the site needs to be active in a few days by the latest so hopefully I can get help in that time.

Re: [PHP-DB] Problem, please help!

2004-03-20 Thread JeRRy
snip $sql = UPDATE round1 SET game1='$game1' , game2='$game2' , game3='$game3' , game4='$game4' , game5='$game5' , game6='$game6' , game7='$game7' , game8='$game8' , misc='y' WHERE username= \$sidarray[0]\; This only updates an existing record, where the username is equal to

Re: [PHP-DB] Problem, please help!

2004-03-20 Thread php
it looks like the use of double and single quotes could be at fault try writing it like $sql = UPDATE round1 SET game1=' . $game1 . ', game2=' . $game2 . ', game3=' . $game3 . ', game4=' . $game4 . ', game5=' . $game2 . ',

Re: [PHP-DB] problem Connecting

2004-03-07 Thread Jochem Maas
Will wrote: Hello all, When I try to connect I get this message: #1045 - Access denied for user: [EMAIL PROTECTED]' (Using password: YES). Can anyone help me? Do I need to do anything in the php.ini file or anywhere else. sounds like you need to set a password in the phpMyAdmin config file

Re: [PHP-DB] problem Connecting

2004-03-07 Thread Will
That was already done!!! I knew that. It is still doing it. MySQL in installed in a window XP machine. What else is there?? ~WILL~ Jochem Maas wrote: Will wrote: Hello all, When I try to connect I get this message: #1045 - Access denied for user: [EMAIL PROTECTED]' (Using password: YES).

Re: [PHP-DB] problem Connecting

2004-03-07 Thread Will
I might add that I can access the database through C: prompt. ~WILL~ Will wrote: That was already done!!! I knew that. It is still doing it. MySQL in installed in a window XP machine. What else is there?? ~WILL~ Jochem Maas wrote: Will wrote: Hello all, When I try to connect I get this

Re: [PHP-DB] problem Connecting

2004-03-07 Thread Will
When I bring up \mysql\bin\mysqladmin status proc is says that the user is ODBC, is that right?? Should I have another user in there?? Please help!! :) ~WILL~ Will wrote: I might add that I can access the database through C: prompt. ~WILL~ Will wrote: That was already done!!! I knew

Re: [PHP-DB] problem Connecting

2004-03-07 Thread Will
I GOT IT YEAH! Thanks everyone. ~WILL~ Will wrote: When I bring up \mysql\bin\mysqladmin status proc is says that the user is ODBC, is that right?? Should I have another user in there?? Please help!! :) ~WILL~ Will wrote: I might add that I can access the database through C:

Re: [PHP-DB] Problem with ODBTP

2004-02-17 Thread Robert Twitty
Your query resource was detached from the connection. Can you supply the code prior to calling odbtp_fetch_row() and starting from odbtp_query()? -- bob On Tue, 17 Feb 2004, Sascha Kaufmann wrote: l Hello everyone I try to port an application from Windows/ODBC to Linux/ODBTP, I have a MSSQL

RE: [PHP-DB] Problem with cookies

2004-02-16 Thread Hutchins, Richard
Normally, you get that warning when you've already sent display information to the browser before you attempt to use the header() function. You need to make sure you haven't sent ANY HTML to the browser prior to the header() line in your code. You can check the PHP documentation regarding the

Re: [PHP-DB] Problem with passing variables

2004-01-27 Thread Viorel Dragomir
- Original Message - From: Phil Matt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 17:08 Subject: [PHP-DB] Problem with passing variables Hello to all. I am a relative newcomer to PHP. I am trying to pass the value of a variable from a MySQL database from

Re: [PHP-DB] Problem with passing variables

2004-01-27 Thread Ricardo Lopes
If you have something like this: echo 'tda href=email.php?recip=$myrow[0]img src=graphics/mail.gif class=imglink alt=Click to send mail to this person //a/td/tr'; It wont work. Use instead: echo 'tda href=email.php?recip='.$myrow[0].'img src=graphics/mail.gif class=imglink alt=Click to send

Re: [PHP-DB] Problem with passing variables

2004-01-27 Thread Phil Matt
On 27 Jan 2004 at 15:56, Ricardo Lopes wrote: If you have something like this: echo 'tda href=email.php?recip=$myrow[0]img src=graphics/mail.gif class=imglink alt=Click to send mail to this person //a/td/tr'; It wont work. Use instead: echo 'tda href=email.php?recip='.$myrow[0].'img

Re: [PHP-DB] Problem with passing variables

2004-01-27 Thread Ricardo Lopes
; [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 4:27 PM Subject: Re: [PHP-DB] Problem with passing variables On 27 Jan 2004 at 15:56, Ricardo Lopes wrote: If you have something like this: echo 'tda href=email.php?recip=$myrow[0]img src=graphics/mail.gif class=imglink alt=Click to send

[PHP-DB] Re: PHP-DB Problem

2003-12-18 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... *Sorry if this is a duplicate* Using mySQL db to store my data. Using a select statement on my PHP page. When it lists out the data it seems to be skipping the first row. Any ideas? Without seeing your code, I'll have to guess that

Re: [PHP-DB] Problem with PHP_AUTH_USER

2003-12-15 Thread Ng Hwee Hwee
hi, i think $PHP_AUTH_USER will only get unset the next time session_start() is called. try to use a header(location: ...) to direct your logout page to your index page and then print $PHP_AUTH_USER right after session_start().. by right, you should not have any value... i faced the same problem

Re: [PHP-DB] Problem

2003-11-05 Thread Boyan Nedkov
A bit difficult to debug this without the file included (config.php); providing the error message would also be helpful. At first glance, I'm just wondering what does the dot mean in the table name used in the FROM clause: FROM school.physics_chris_rockets It shouldn't generate a php syntacs

Re: [PHP-DB] Problem

2003-11-05 Thread George Patterson
On Thu, 06 Nov 2003 05:46:03 +0100 Boyan Nedkov [EMAIL PROTECTED] wrote: A bit difficult to debug this without the file included (config.php); providing the error message would also be helpful. At first glance, I'm just wondering what does the dot mean in the table name used in the FROM

Re: [PHP-DB] problem - query inside a function

2003-10-16 Thread Luis M Morales C
My Comment bellow: On Wednesday 15 October 2003 14:38, Kirk Babb wrote: Hi, I'm having trouble with a query inside a function. I thought I'd written this so that the function would fail if email and zipcode supplied were not in the same row (trying to use those two things to identify the

Re: [PHP-DB] problem - query inside a function

2003-10-16 Thread CPT John W. Holmes
From: Luis M Morales C [EMAIL PROTECTED] My Comment bellow: On Wednesday 15 October 2003 14:38, Kirk Babb wrote: Hi, I'm having trouble with a query inside a function. I thought I'd written this so that the function would fail if email and zipcode supplied were not in the same row

RE: [PHP-DB] problem - query inside a function

2003-10-16 Thread Hutchins, Richard
PROTECTED] Sent: Thursday, October 16, 2003 10:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] problem - query inside a function From: Luis M Morales C [EMAIL PROTECTED] My Comment bellow: On Wednesday 15 October 2003 14:38, Kirk Babb wrote: Hi, I'm having

RE: [PHP-DB] problem - query inside a function

2003-10-15 Thread Hutchins, Richard
Kirk, First, I'd recommend troubleshooting this function by doing the following: [code snippet] function getEditData($email,$zipcode) { $sql = SELECT * FROM contact_info WHERE zipcode='$zipcode' AND email=\{$email}\; echo $sql; //ADD THIS LINE //$query = mysql_query($sql);

Re: [PHP-DB] Problem with uploadscript

2003-10-08 Thread George Patterson
On 08 Oct 2003 17:26:55 +0200 Ruprecht Helms [EMAIL PROTECTED] wrote: Hi, I've problems with a http-uploadscript. When I run the htmlfile and the script replies an output of the filename but I can't find the file in the destinationdirectory. Why this can happen. Addes you can see the

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-10 Thread Gnanavel
- Original Message - From: Sean Burlington [EMAIL PROTECTED] Newsgroups: php.db To: [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 3:26 PM Subject: Re: [PHP-DB] Problem in executing linux command from PHP Gnanavel wrote: $output=exec(cp file1 file2); echo pre$output/pre; does

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-07 Thread Sean Burlington
Gnanavel wrote: $output=exec(cp file1 file2); echo pre$output/pre; does not works. can any one help me out of this problem When I was executing the cp command it doesn't return anything. But it returned the name of the last file when i executed the ls `cp file1 file2` doesn't return anything -

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-06 Thread Gnanavel
- Original Message - From: Sean Burlington [EMAIL PROTECTED] Newsgroups: php.db To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:11 PM Subject: Re: [PHP-DB] Problem in executing linux command from PHP Gnanavel wrote: I have problem in executing linux command $output=exec

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-02 Thread Gnanavel
I have problem in executing linux command $output=exec(ls -a); echo pre$output/pre; the above coding works, but $output=exec(cp file1 file2); echo pre$output/pre; does not works. can any one help me out of this problem When I was executing the cp command it doesn't return anything. But it

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-02 Thread Sean Burlington
Gnanavel wrote: I have problem in executing linux command $output=exec(ls -a); echo pre$output/pre; the above coding works, but $output=exec(cp file1 file2); echo pre$output/pre; does not works. can any one help me out of this problem When I was executing the cp command it doesn't return

Re: [PHP-DB] Problem in executing linux command from PHP

2003-09-02 Thread David Smith
Gnanavel wrote: I have problem in executing linux command $output=exec(ls -a); echo pre$output/pre; the above coding works, but $output=exec(cp file1 file2); echo pre$output/pre; does not works. can any one help me out of this problem When I was executing the cp command it doesn't return

Re: [PHP-DB] Problem in executing linux command from PHP

2003-08-29 Thread Gnanavel
Quoting [EMAIL PROTECTED]: From: Gnanavel [EMAIL PROTECTED] I have problem in executing linux command $output=exec(ls -a); echo pre$output/pre; the above coding works, but $output=exec(cp file1 file2); echo pre$output/pre; does not works. can any one help me out of

Re: [PHP-DB] Problem in executing linux command from PHP

2003-08-27 Thread CPT John W. Holmes
From: Gnanavel [EMAIL PROTECTED] I have problem in executing linux command $output=exec(ls -a); echo pre$output/pre; the above coding works, but $output=exec(cp file1 file2); echo pre$output/pre; does not works. can any one help me out of this problem Riddle me this... exec()

Re: [PHP-DB] Problem with $_SERVER['HTTP_REFERER']

2003-07-28 Thread jeffrey_n_Dyke
is it possible that there is no referer. what happens if you link to this page from another, ensuring there is a referer, will it display it then? Jeff

RE: [PHP-DB] problem with starting a session

2003-07-15 Thread Ford, Mike [LSS]
-Original Message- From: Ahmed Abdelaliem [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 08:54 i have a problem with starting a session in the page that validates the user input and sends it tothe database, when the user clicks register he gets this error Warning:

RE: [PHP-DB] problem with starting a session

2003-07-15 Thread Sourabh G
PROTECTED], [EMAIL PROTECTED] Subject: RE: [PHP-DB] problem with starting a session Date: Tue, 15 Jul 2003 10:29:06 +0100 -Original Message- From: Ahmed Abdelaliem [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 08:54 i have a problem with starting a session in the page that validates the user

<    1   2   3   4   >