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?
--
MIGUEL GUIRAO AGUILER
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 AGUIL
Hi All,
I have developed a script that allows me to select a students name from the
client table and display the call information from the case_note table, but
the report only shows the first available case_note for an individual. I
want this script to display all entries for the specific client
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
Use mysql_escape_string so that query is considered part of the WHERE
clause.
$result=mysql_query('SELECT * FROM users WHERE
username="'.mysql_escape_string($_GET['
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", "
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: http://www.php.net/unsub.ph
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 [mailto:[E
'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 counted"(sic)?
no. (bu
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 I
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]
$db_connect
It does count blank lines, note that the line with the error maybe well
above the line shown in the error...the only indicates where the error
(whatever it may be) causes a problem in the script.
Bastien
From: 'Yemi Obembe <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] php line e
Thank you very much for the reply.
That was what I needed to know.
That this is the Normal behavior and will not vary in different
configurations (exept of the magic_quotes_XXX settings that I'm aware of)
Milen
- Original Message -
From: "Firan Corneliu" <[EMAIL PROTECTED]>
To: "Petzo"
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
om
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
2. are externally included files (using include(), require() etc) also "line
counted"(sic)?
3. are d parts of the file
you might want to check to see if magic quotes GPC is turned on, if it is
then you are adding slashes twice. You can either turn it off or do not use
addslashes ;)
--
Joseph Crawford Jr.
Codebowl Solutions
[EMAIL PROTECTED]
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:
-
hi there
i'm having trouble with compiling php in linux shell with oracle support.
usually first i install oracle client via xwindow. but now the problem is,
the machine currently need to be installed is do not have a xwindow
installed.
is there anyway to compile php with oracle support us
17 matches
Mail list logo