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... > > mys

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

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

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 accro

Re: [PHP-DB] Querying two tables

Hello Cesar-- Your database design is not normalized, so you're going to have to cheat a bit--try this (I'm doing it from memory, so it might not work on the first try): select distinct Relationships.Subcatid, Subcategories.* from Relationships Inner Join Subcategories On Catid = '0001' and Relat

[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

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 package

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 to

[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] 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_id<>0 AND unit_id<>'' or something like this, depending on your type of variable.

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 mo

[PHP-DB] Selecting more than asked for

When using the statement below, as well as getting the data corresponding to $unit_id, I also get any data where unit_id field is blank. I have tried various permutations of unit_id IS NOT NULL, but get syntax errors. Can someone help to get the syntax correct. $SQL = " SELECT * FROM resources whe

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 $_

[PHP-DB] little question from beginner

Hi, I am having trouble with using PHP for submitting a form. I've defined all the inputs for the form. and the html for the button is like this : when I wanted to process the data of the form using : if($submit){ ...//my script here } the browser tell the notice that variable submit isn't def

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 i

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

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