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 PROTECTE
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
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
while($row=m
> -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/oc
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 PROTECT
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 Comerón Mariño <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Mon, 31 Mar 2003 07:57:38
>From original msg:
>> I need to be able to do is increment an mysql database field each time an
DN> =possibly an AUTO_INCREMENT field is what is needed here
Is that what he has been trying to do? I think SpiderWebb needed to see
how many pieces of the item were sold, didnt'he?
So let's say he's
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 t
To: 'Rick Emery'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into
My Sql
I was never able to assign a null value to get a row to automatically insert
into SQL server 7. It would always give me an error that said something
like "you
nt: 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 will be replaced with theauto-incremented value in
ECTED]'; 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)
-
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
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
Joshua,
Thanks for this. The original question wasn't mine, but I'm sure Robby will be
interested to read it...
=dn
- Original Message -
From: "Joshua Long" <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>
Sent: 28 October 2001 07:10
Sub
> I have a query whenever I try to insert something into a mysql table. This is
> the code I am using:
>
> $host1 = gethostbyaddr("$REMOTE_ADDR");
> $date = date("Y-m-d h:i:s");
> $link = mysql_connect("$host", "$user", "$passwd");
> mysql_select_db("$database", $link);
> $sql = "INSERT INTO vcst
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 = strtolo
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 d
cheers andre
i tried that too..
and while i can get it to work by extracting with stripslashes i was
trying to enter the '.' itself ..
when i see the entry in myphpadmin it is still a '@'
thanks tho..
brendan
Andre P. wrote:
> Try
>
> $link = addslashed($HTTP_SESSION_VARS["HREF"])
> and then
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
> frustrat
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
--
21 matches
Mail list logo