Can you send the query and some code that you're using? You probably want to
loop like this:
while ($row = mysql_fetch_assoc($cursor)) {
echo $row{case_note} . br /;
}
Jos
-Original Message-
From: John R. Sims, Jr. [mailto:[EMAIL PROTECTED]
Sent: 17 May 2005 03:07
To:
Hi,
Instead of doing a SELECT *, specify the fields that you require. Allthough
you may think the rows are exactly the same, one might be empty () and one
null which is not the same.
You are more likely to get the result that you need if you specify the
fields:
SELECT DISTINCT somedata, rev,
Hi,
Okay lets say I own www.fred.com (which I don't but still) and
www.getpaid2reademails.com (so I own two domain, lucky me!)
Now I want to connect from getpaid to fred... Okay I have done this and
achieved this but is it possible to reject this operation and deny connections
outside of
Hello,
I have some questions about DB_DataObject and FormBuilder PK handling, should
I post them here or do you know a better list?
TIA
--
Alessandro Pasotti
ICQ# 245871392
Linux User #167502
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
turn of magic quotes or test for it before using addslashes
Bastien
From: Petzo [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] addslashes + stripslashes + mysql question
Date: Mon, 16 May 2005 11:20:41 +0300
Hi,
My question is about the norlmal behaviour of PHP and MYSQL but
'Yemi Obembe wrote:
just care to know how php does the line counting when it echoes error
messages like:
parse error: unexpected '}' on line 129
1. does the line counting includes empty lines
yes.
2. are externally included files (using include(), require() etc) also line
Acctually my problem was in that I was using the name of the table in
uppercase rather than in lowercase. So MySQL was looking for table REV
instead of rev. So for MySQL, REV and rev are very different tables!!
Regards,
Miguel Guirao
-Original Message-
From: Constantin Brinzoi
You have the string ' \
With addslashes it becomes '\ \\
When you insert it into the database
it goes into a query like this
update table set field=' '\ \\ '
But that inserts into the field only ' \ ,
in other words the original string.
It is a normal behaviour and you should
omit the
Addresses should definitely have their own table.
Have you considered using Postgres? It allows for table inheritance in
much the same way that inheritance works in OOP. You could have a parent
table (like a parent class) for People, and child tables (just like
child classes) for Employee,
Hi,
My question is about the norlmal behaviour of PHP and MYSQL but I cant
explain it without a simple example. Thank you for reading:
I have the following code:
?php
print $t = $_POST['txt'];
print $t = addslashes($t);
John R. Sims, Jr. wrote:
Martin; I have taken your advice and read both of the articles, but
unfortunately I have not been able to find what needs to be changed. As I
mentioned, I am very new at this.
Could you possibly look at the script and point me in the right direction?
[snip]
/head
If you mean database access that is simple, just create
a user that has access only from localhost (and of course
remove the others).
For mysql just do the query :
GRANT ALL PRIVILEGES ON your_database.* to 'user'@'localhost'
identified by 'password'.
If you mean http access then you can
We need to see your script or at least the portion where you do the query to
the database.
In general, you need to concatenate your different case-note for a given
student as the while cycle goes thru your fetch statement for such a given
student.
--
MIGUEL GUIRAO
What are you trying to connect to? Do you have a webservice on the second
domain? Is it a database - and if so, which?
-Original Message-
From: JeRRy [mailto:[EMAIL PROTECTED]
Sent: 17 May 2005 08:33
To: php-db@lists.php.net
Subject: [PHP-DB] Connection Question!
Hi,
Okay lets say I
Miguel Antonio Guirao Aguilar wrote:
Hi!!
I have this query in PHP:
$items2 = mysql_query(SELECT DISTINCT * FROM rev ORDER BY rev, $link);
I have three rows with the same data on it, and DISTINCT seems to be not
working, since I got all the rows, any ideas of what is going wrong?
distinc needs a field
select distinct(name) from table
bastien
From: MIGUEL ANTONIO GUIRAO AGUILAR [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Select
Date: Mon, 16 May 2005 19:26:20 -0700
Hi!!
I have this query in PHP:
$items2 = mysql_query(SELECT DISTINCT * FROM rev ORDER BY rev,
I would like to get the itemID number (autoincrement) of the last
insert.
(Insert order, get last orderID number and use it elsewhere.)
I'm having trouble understanding how to do a transaction in mysql/php
Code below:
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die
('Error
* Mayo [EMAIL PROTECTED]:
I'm new to PHP and would like to make certain that I have the basic
protection for the site:
Use double quotes to contain variable
This depends entirely on the variable type expected by MySQL; int and
floats don't necessarily need quotes. However, it's typically a
Thanks, the $orderId = mysql_insert_id($result) was what I was looking
for.
But in the long run, I'm still concerned about how to group several
queries into one transaction. As for example when one wants to make
multiple inserts with one submit.
Ex: User wants to input inventory. He's going to
Well, for something like this you would need one row for each item.
I just did a db for a clothing store (with cold fusion)
itemID: 1001 // autoincrement
itemTypeID: 1 // number -- refers to jeans
itemDesignerID: 5 // number -- refers to designer Antik
itemSize: 32 // number -- refers to waist
There is a function that gets the last auto increment value for an ID
field!!
-Original Message-
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Martes, 17 de Mayo de 2005 10:27 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] multiple queries, one transaction
I would like to get the itemID
21 matches
Mail list logo