[PHP-DB] php/mysql problem

hi, i've a problem with php and mysql. a mysql-server is running on my server on that i can access from 'outside'. but, if i want to connect to the server with a 'local' php skript (running on the same server), mysql refuses the login ('acces denied for user [...]'). the problem is that the login

[PHP-DB] Make new linux user accounts with pjp /mysql

Hi All I think this may be a bit of topic but here goes. I would like to know what logic is needed to create a new user on a Linux box Once this user has completed a sign up. I want to create my own php / mysql driven webhost control panel which allows Creation of vhost in http.conf Creation of

Re: [PHP-DB] php/mysql problem

Hi Stefan, i've a problem with php and mysql. a mysql-server is running on my server on that i can access from 'outside'. but, if i want to connect to the server with a 'local' php skript (running on the same server), mysql refuses the login ('acces denied for user [...]'). the problem is

Re: [PHP-DB] little question from beginner

Well, I would look at 2 possible problems: 1). Submit is an HTML input type, and I would try to avoid using it as a script variable just to make sure avoid confusion. 2). You may not have register_globals turn 'on' in your php.ini file. So, if the form method is POST, try: $_POST['submit']. Or

Re: [PHP-DB] Selecting more than asked for

$SQL = SELECT * FROM resources where unit_id='{$unit_id}' order by level ; Ignatius - Original Message - From: Alex Francis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 8:37 PM Subject: [PHP-DB] Selecting more than

Re: [PHP-DB] Selecting more than asked for

You shouldnt get any syntax errors i think use $sql = SELECT * FROM resources WHERE unit_id='$unit_id' AND unit_id IS NOT NULL ORDER BY level; as far as your unit_id is DEFAULT NULL. Otherwise try using WHERE unit_id0 AND unit_id'' or something like this, depending on your type of variable. If

[PHP-DB] OpenSSL, PHP and MySQL

Hey all, I was wondering if anyone could point me to a good tutorial to learn how to use the OpenSSL functions to set access a MySQL db under a secure connection. I have tried reading the manual, looking at PHPClasses.org, PHPBuilder.com, and Hotscripts.com and I haven't come accross anything

Re: [PHP-DB] OpenSSL, PHP and MySQL

I usually build an SSH tunnel whenever I need to connect securely to a remote MySQL server. There's a tutorial on how to do that here: http://www.netsys.com/cgi-bin/display_article.cgi?908 Marco -- php|architect - The Magazine for PHP Professionals The monthly magazine dedicated

Re: [PHP-DB] OpenSSL, PHP and MySQL

Unfortunately that doesn't answer my question because of what I need to do. I probably should have included this in the first post, but here is the scenario: My client has a website in which a customer will be purchasing gift certificates online. They don't need a comprehensive e-commerce

[PHP-DB] Querying two tables

Hi all, I have several tables from which I have to fetch certain products categories based on customer selection. The tables are as follows: Table 1 - Categories catid (autonum) catname Table 2 - Sub categories subcatid (autonum) subcatname Table 3 - Products prodid (autonum) prodname Table

RE: [PHP-DB] OpenSSL, PHP and MySQL

Hey all, I was wondering if anyone could point me to a good tutorial to learn how to use the OpenSSL functions to set access a MySQL db under a secure connection. I have tried reading the manual, looking at PHPClasses.org, PHPBuilder.com, and Hotscripts.com and I haven't come accross

RE: [PHP-DB] OpenSSL, PHP and MySQL

My client has a website in which a customer will be purchasing gift certificates online. They don't need a comprehensive e-commerce package, just simple information passed across a secure connection, such as: user names, passwords, credit cards and mailing addresses. We already have a MySQL

[PHP-DB] UPDATE tbl problem...

Hi, I am having a small problem when it comes to updating some tables that I have. tblmembers and tbloptions are both linked together with the exact same userid #. here is the code i have been using... mysql_query(UPDATE tbloptions SET strColorPref='$tmpColorPref'

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

On Sunday 15 December 2002 09:24, Hartleigh Burton wrote: Hi, I am having a small problem when it comes to updating some tables that I have. tblmembers and tbloptions are both linked together with the exact same userid #. here is the code i have been using...