> Hello all,
>
> Not sure what I am doing wrong.
>
> I have a simple form that populate the variables in a mysql query. I
> know the selected values are making it to the form porcessing script
> because I can echo them on the processing script as indicated below.
>
> You Selected Cell_Sect = 1_1
Hello all,
Not sure what I am doing wrong.
I have a simple form that populate the variables in a mysql query. I
know the selected values are making it to the form porcessing script
because I can echo them on the processing script as indicated below.
You Selected Cell_Sect = 1_1
You Selected Date
Stan wrote:
OK.
If I change the test to "if(mysql_num_rows($thisRow) < 1)" it does what I
want.
I guess if I want to understand why False was returned originally (just
after I created the database) I need to start over.
According to the docs mysql_query only returns false if there's an error.
OK.
If I change the test to "if(mysql_num_rows($thisRow) < 1)" it does what I
want.
I guess if I want to understand why False was returned originally (just
after I created the database) I need to start over.
Do I have 4 possible conditions here: 1) the mysql_query() function fails
and I get a PH
Yes. I deleted all records.
Prior to the DELETE, if I did a SELECT with specific criteria (WHERE
p.pictureFile = "some valid content"), and those criteria were not met,
mysql_query() returned False ... and, conversely, if those criteria were
met, mysql_query() returned "a resource" against which I
Stan wrote:
I did a "DELETE FROM picture" where "picture" is a table in my database.
Because this deletes all your records - so doing a select afterwards
will find nothing.
Afterward, this piece of code does not generate an error
--
try
{
I did a "DELETE FROM picture" where "picture" is a table in my database.
Afterward, this piece of code does not generate an error
--
try
{
$query = "SELECT * FROM picture p " .
"WHERE p.pictureFile='" . $pictureFile
On Aug 10, 2009, at 4:15 AM, "Ron Piggott"
wrote:
I have the syntax
mysql_query("INSERT INTO );");
If this is successful I want to do update a column in one of my tables
$query = "UPDATE ... ";
mysql_query($query);
How do I test if the INSERT INTO mysql_query, in order to trigger
I have the syntax
mysql_query("INSERT INTO );");
If this is successful I want to do update a column in one of my tables
$query = "UPDATE ... ";
mysql_query($query);
How do I test if the INSERT INTO mysql_query, in order to trigger the UPDATE?
Ron
On Oct 12, 2004, at 7:15 AM, [EMAIL PROTECTED] wrote:
hello,
I have a begining question.
I've got simple html form and php script, but insert doesn' t work.
What is
wrong in my insert mysql_query?
mysql_query( "insert into obiskovalci (ime, priimek, ulica, hstevilka,
pstevilka, posta) values('$im
if your installation of PHP is running with 'register
globals' on.
Much warmth,
Murray
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, 12 October 2004 10:15 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_query
PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_query
1. place your query string into a variable for easy dumping...
i.e. $query = "insert into obiskovalci (ime, priimek, ulica, hstevilka,
pstevilka, posta) values('$ime', '$priimek', &
)
-B
- Original Message -
From: [EMAIL PROTECTED]
Date: Tuesday, October 12, 2004 8:15 am
Subject: [PHP-DB] mysql_query
> hello,
>
> I have a begining question.
> I've got simple html form and php script, but insert doesn' t
> work. What is
> wrong
hello,
I have a begining question.
I've got simple html form and php script, but insert doesn' t work. What is
wrong in my insert mysql_query?
mysql_query( "insert into obiskovalci (ime, priimek, ulica, hstevilka,
pstevilka, posta) values('$ime', '$priimek', '$ulica', '$hstevilka',
'$pstevilka
esult($testResult);
?>
-Original Message-
From: Brad Wright [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2001 06:31
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_query troubles
Hi all',
I have a mysql_query that reads:
$testResult = mysql_query("SELECT * FROM login
Hi all',
I have a mysql_query that reads:
$testResult = mysql_query("SELECT * FROM login_table where Pass =
password('$password')") or die ("ouch");
$num_rows = mysql_num_rows($testResult);
the problem is that I keep getting a value of 0 for $num_rows when I know
the table has 1 entry for PAs
> -Original Message-
> From: Stefan Siefert [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 04, 2001 9:07 AM
> To: PHP Mailingliste
> Subject: [PHP-DB] mysql_query returns nothing?
>
>
> Hm, since we are using PHP 4.0.6 we do get sometimes no
> returnvalue
Hm, since we are using PHP 4.0.6 we do get sometimes no
returnvalue...(function mysql_query) I think, this is always then, when we
are executing update oder delete syntax hm, does anyone know anything
about it?
Stefan Siefert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscrib
>$con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS)
>or die ("Cant connect");
>mysql_select_db($DB_NAME);
Try:
$con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS)
or die ("Cant connect");
mysql_select_db($DB_NAME, $con);
Also try and make your php functions like so: mysql_x() instead of:
I am getting this weird error with my mysql database. I have 100 pages with
code to access my database. All my queries
work except one. Here is an example
$con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS)
or die ("Cant connect");
mysql_select_db($DB_NAME);
$rst = mysql_query("SELECT * FROM D
20 matches
Mail list logo
