Possible error in SQL statement.
Are you sure that SOME_TABLE exists?
EM> Hi all
EM> I have successfully managed to connect to the mysql database, using the
EM> following code:
EM> mysql_connect('localhost','php','***') || die ("Unable to connect to
EM> MySQL server.");
EM> $db = mysql_selec
Yo Evan,
Have you got an '@' in front of the mysql_query() to supress errors ?
Evan Morris wrote:
Hi all
I have successfully managed to connect to the mysql database, using the
following code:
mysql_connect('localhost','php','***') || die ("Unable to connect to
MySQL server.");
$db = my
- Original Message -
From: "Max 'AMiGo' Gashkov" <[EMAIL PROTECTED]>
To: "Evan Morris" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 18, 2003 10:13 AM
Subject: Re: [PHP-DB] More help with mysql
> Possible error in SQL statement.
> Are you sure that SOME_TABLE exists?
Since I'm new to PHP, this concept is new to me. What does the @ do and
where do you put it?
- Original Message -
From: "Corne' Cornelius" <[EMAIL PROTECTED]>
To: "Evan Morris" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 18, 2003 10:19 AM
Subject: Re: [PHP-DB] More hel
Try listing of fields by name, not as '*', and put SOME_TABLE in qoutes (').
EM> - Original Message -
EM> From: "Max 'AMiGo' Gashkov" <[EMAIL PROTECTED]>
EM> To: "Evan Morris" <[EMAIL PROTECTED]>
EM> Cc: <[EMAIL PROTECTED]>
EM> Sent: Tuesday, February 18, 2003 10:13 AM
EM> Subject: Re: [PH
GlacierHi List
I run mysql 3,23.. in a RH 7.2 Linux web server.=20
Sudenly mysql crash and non of my db's runnig. Mysqld (re) starts [OK].=20
The message in my browser is that mysql.sock file is missing
Does knows why? What is this file?
Thanx
If I remove the '|| die' part from the mysql_query() statement, it works
fine. This is bizarre, but there it is.
ie, if I have:
$result = mysql_query("SELECT * FROM SOME_TABLE");
it works.
If I have:
$result = mysql_query("SELECT * FROM SOME_TABLE") || die ("Unable to execute
SQL query");
it
OK, now I see 8)
$result after your operations contains not SQL result, it's value is 1 (logical
TRUE) -- result of logical operation
mysql_query("SELECT * FROM SOME_TABLE") || die(
If you want to exit after error try this construction:
if(!mysql_query("SELECT * FROM SOME_TABLE"))
{
I believe if you put OR instead of || it will work OK as originally posted..
ie mysql_query("SELECT * FROM SOME_TABLE") OR die(
Nick
-Original Message-
From: Max 'AMiGo' Gashkov [mailto:[EMAIL PROTECTED]]
Sent: 18 February 2003 08:42
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subje
I writing a software catalog that features "experts",
who a people especially skilled in a piece of
software. My db, has a "software" table and an
"experts" table.
I need to have a page that generates 2 multiple select
boxes, each on with the data from each table.
>From there one will be able to
You have to give the Mutli select box a name as an array. eg:
val1
then in PHP, you can access $experts as an array.
while (list ($key, $val) = each($experts)) {
print "$key = $val\n";
}
Jason End wrote:
I writing a software catalog that features "experts",
who a people especially skill
I am making a section on a web site which requires that visitors log-in.
Log-in, password, etc are in an MySQL table. I am using (via a web host) PHP
4.2.2 with global variables turned off. Until now, I have worked with a
different host in which global variables were switched on.
The way it works
[sorry for the incomplete posting of a couple moments ago. I hit ctl
something or other and outlook fired off the e-mail against my wishes!]
I am making a section on a web site which requires that visitors log-in.
Log-in, password, etc are in an MySQL table. I am using (via a web host) PHP
4.2.2 w
Hi Jeff
Don't use session_register() just use the $_SESSION superglobal as you would
use any other array.
So does this work?
http://mysite/index.php');
exit();
}
?>
HTH
Rich
> -Original Message-
> From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]]
> Sent: 18 February 2003 11
Nikos:
The mysql.sock file is created by mysqld when it is running.
The error you report is very common and you will find troubleshooting
tips at:
http://www.mysql.com/doc/en/Can_not_connect_to_server.html
Doug
On Tue, 18 Feb 2003 10:18:42 +0200, nikos wrote:
>GlacierHi List
>I run mysql 3,23..
Hi,
I'm building a form page that has 3 tags for different types of fields (i.e.
Personal details, location details, other). I want to preserve the values
of the filled in fields as the user moves from section/tag to section/tag.
I've tried making each tag a separate page and use the URL to pass
Try changing your code to
if ($_SESSION['verified'] != "yes"){
I think that's the problem
Nick
-Original Message-
From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]]
Sent: 18 February 2003 11:20
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] Session variables when global variables switc
Hi all:
I've installed apache for win98 and php 4.2 (also for
win98) and they are working fine but I'm having problems
with the form variables.
When I submit a form the variables are empty!!!
If anyone knows of issues in php-apache-win configuration
please let me know.
Thanks.
_
sometimes people really never use a search :(((
but the answer is:
php versions > 4 use another way of handeling postvars and arrays
and if users don't know where the values are, use the function:
phpinfo(); !!!
and try this:
print_r($_POST);
thats all i will say
-Oorspronkelijk beric
Hi,
I have a query that returns a list of staff members and which department
they are in. There's one table for departments, which is joined to the table
for staff members. Using the typical methods, I am currently displaying the
results in the form of Deparment Name: Staff Name for each staff mem
Here's an example to get you started - created 2 files as below, 1.html and
2.php
The important bit is value="
Nick
FILE : 1.html
FILE : 2.php
Name :
Address :
-Original Message-
From: news [mailto:[EMAIL PROTECTED]]
Sent: 18 February 2003 11:15
To: [EMAIL PROTEC
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 18 February 2003 08:26
>
> If I remove the '|| die' part from the mysql_query()
> statement, it works
> fine. This is bizarre, but there it is.
>
> ie, if I have:
>
> $result = mysql_query("SELECT * FROM S
I'm attempting to takke information submitted from a web page through a POST
action, insert it into a MySQL database and upon success display the information
in a table for the submitter to see. For some reason empty fields are inserted
into the database and the data doesn't show up in the resulti
> A new guest to the list needs your hlep!!. I am about to start working on
a project in which im going to use Oralce
> with PHP4. I am new to PHP. I am looking for a good book about working
with "PHP4 and Oracle" to help me pick
>up the basics as well as get the depth that i am looking for. To
How can i create a new user, with linux, apache and php?
Like this, in a form i ask for the username and password, than somehow use
the 'adduser' .
Can someone help me?
Cumprimentos
Bruno Pereira
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: ht
Hi,
I want to find a record. But I don't know in which
column should I expect it. I want to search for it in
all the columns. I don't see such a facility in the
phpMyAdmin's Select Table screen.
Can anyone guide me?
__
Thanks
Shantanu Oak
Learn HTML and Java at
http://www.shantan
I have two tables.
Table_1
contact_id (INT 5)
Table_2
contact_id (INT 5)
type (enum '1','2')
data (TEXT)
In table_2, there is a possible of two records that can be associated to an
entry in table in the form of the record type can be an either 1 or 2.
There will always be a type 1, but not nece
possibly use sessions?
--- news <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm building a form page that has 3 tags for different types of
> fields (i.e.
> Personal details, location details, other). I want to preserve the
> values
> of the filled in fields as the user moves from section/tag to
> sec
> Does anyone have a more practical/useful way of preserving field
> values from page-to-page... or hiding fields as a user clicks on each
> tag?
You can make it all one very, very large form and use DHTML to show
or hide the appropriate fields.
Chris
--
PHP Database Mailing List (http://ww
Hello everyone,
this is my first post, so please bare with me. I am very new to php and i am
currently working on modifying existing php e-commerce site.
so my question is as follow and its more of a general question but it
involves a db so i thought i would ask here
i have a mysql db, in one
adduser script is written in perl. You can easily disect it.
Quoting Bruno Pereira <[EMAIL PROTECTED]>:
> How can i create a new user, with linux, apache and php?
> Like this, in a form i ask for the username and password, than somehow use
> the 'adduser' .
> Can someone help me?
>
>
> Cumpr
[EMAIL PROTECTED] (Martin Dziura) writes:
> is there some sort of parsing call i can evoke to extract the url?
> Beginning with the http and ending with the first white space?
$str = "foobarbazhttp://www.foo.bar/";;
preg_match("/(http:\/\/\S+)/", $str, $match);
$match[1] should contain the url pa
when I try to connection to the access file using Microsoft Jet Engine. it
come up with following error!
can anyone help me?
$result = $conn->Execute($query)
Hello!
My name is Mike and I have no clue what I am doing. I have basic skills in PHP, but
for some reson I cant bring them together to make the web program that I need. I would
like to make a product site. When a client searches for product 6, the program goes to
sites listed in an array, aite
hey guys,
I need some assistance here...
I am toying with a search form that will allow the user to select 3 options from a set
of checkboxes to search by (eg.)
[[ Select any 3 type ]]
[ ] option1 [ ] option2 [ ] option3
[ ] option4 [ ] option5 [ ] option6
[ ] option7 [ ] option8 [
35 matches
Mail list logo