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
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
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
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
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 $_
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
$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
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.
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
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
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
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
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
> 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
> 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
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
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
17 matches
Mail list logo