Micah,
Your right! I regretted this post after I hit send.
The code generator is actually okay. I'm learning
more about PHP, and what the code actually means, in
the event it needs to be modded / edited.
Sorry again for the post and thanks for the reply!
Stuart
--- Micah Stevens [EMAIL
I'm thinking you should either get a better code generator, or learn more
about php.. :)
-Micah
On Monday 13 September 2004 02:49 pm, Stuart Felenstein wrote:
Thanks to help here I was able to overcome some ivalid
query errors.
Now I'm back, (probably the same mistake)
It's coming off
Hi,
You can use LEFT OUTER JOIN
Table1 : software list
Table2 : installed ones
$res=mysql_query(select table1.software_name, table2.software_name from
table1 left outer join table2 on
table1.software_name=table2.software_name);
Check if there is not a matching record on table 2
-Original Message-
From: Matthew Moldvan [mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 01:03
Have you tried the built in Oracle functions in PHP?
http://us3.php.net/oracle
That's only for Oracle up to version 7.
For Oracle 8 or 9, use the OCI extension http://www.php.net/oci8.
Have you tried the built in Oracle functions in PHP?
http://us3.php.net/oracle
oracle_logon() may be useful here ...
Let me know if it works out for you.
Regards,
Matt.
-Original Message-
From: Y Al Hinai [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 8:03 PM
To: [EMAIL
Make sure that u had installed Oracle Client on your Machine and Recompile your php
with --with-oracle=$ORACLE_HOME then
check wether your Apache included -lpthread
-Original Message-
From: Marcial Comern Mario [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 31 Mar 2003 07:57:38 -0600
SpiderWebb,
One posting to one list is enough...
I dont know if this is possible in PHP (Newbie) im working on a project
where each product has 3 diffierent prices depending on the amount sold so
say for example 1- 100 price A 101-299 price B and above 300 Price C.
What
I need to be able to
If any of the values you are trying to insert are not integers, you need to
put single quotes around the variables, ie. $SCRIPT_NAME, $date, $BName, etc
in the insert statement.
Robby Whiteside [EMAIL PROTECTED] said:
Hi There,
I have a query whenever I try to insert something into a
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 9:24 AM
To: Robby Whiteside; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] HELP PLEASE!! Get query error when inserting into
MySql
If any of the values you are trying to insert are not integers, you need to
put
]'; Robby Whiteside; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into
My Sql
If your first field is an auto insert field, then you have to do it like
this:
insert into tablename (column2,column3,column4,column5) values
(value2,value3,value4,value5)
The auto
, October 29, 2001 10:46 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My
Sql
This also works:
INSERT INTO vcstats VALUES( NULL,column2,column3,column4,column5)
The NULL value will be replaced with theauto-incremented value in the table
Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 10:46 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My
Sql
This also works:
INSERT INTO vcstats VALUES( NULL,column2,column3,column4,column5)
The NULL value
Just use PHP's string searching functions. I had a similar situation where
I was inserting user-provided data into a MySQL database. I searched for
MySQL bad words that I didn't want a hacker to insert into queries, such
as DELETE, ADD, INSERT, MODIFY, etc. to prevent mischief.
FYI, you can
Cheers Rick ... I think I nailed it. I've copied my little function
below for anyone else interested.
Am keen on the saving milliseconds bit, though (will add it to the
function below before making it live). Any more tips?
Dave
function parse($what) {
$what =
Try
$link = addslashed($HTTP_SESSION_VARS[HREF])
and then use $link in the sql insert
and..
stripslashes(query result)
when you retrieve the value and need to display it on the page.
hth
andre
brendan wrote:
hello,
i have hit a major stumbling block and am now getting really
frustrated..
BDY.RTF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
It's best if you can supply the full code. Code may not need to be attached,
you can just put in a text file and send the link so that we all can read.
Error in line 42 DOES NOT mean the error is in line 42, sometimes the error
can be in the couple of lines before line 42.
Best wishes,
Indri
--
17 matches
Mail list logo
