best way to tell is to place .'or die(mysql_error())' after any call to
mysql_query() to see what mysql is complaining about. personally I
sometimes declare the query first so i can echo that as well after the
msyql_error() function, so i can see the query that has just been
excecuted.
How are the paragraph breaks represented in the original text? You have
have to detect the paragraph breaks and change to a /r/n.
Andrew.
At 11:40 PM 8/9/2003, Budelak wrote:
Hello,
Can someone help with this problem I've been trying to solve but don't how to.
I have a field of type longtext
The text are type into an input field by the user who is nonot a
programmer at all. This inputt field updates the database that is later
called up for display.
Bunmi
Andrew D. Luebke wrote:
How are the paragraph breaks represented in the original text? You have
have to detect the paragraph
Budelak wrote:
You guys thanks for the encouragement.
I finally solved it with this:
?php $text= preg_replace(/(\015\012)|(\015)|(\012)/,nbsp;br /,
$rsDailynewsDetail-Fields('newsfull')); echo $text; ?
Help came of course from the link Holmes gave.
You're welcome, I think. Why didn't you just
You are entirely wrong about ODBC. Linux has several implementations available.
On Sat, 14 Jun 2003 14:30:42 +0300
nabil [EMAIL PROTECTED] wrote:
PLEASE HELP ME PHP PEOPLE,
I have a stored procedure on a remote Microsoft (stupid) SQL server..
and I have to connect to it remotely and I have
could you help for that .??
Martin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
You are entirely wrong about ODBC. Linux has several implementations
available.
On Sat, 14 Jun 2003 14:30:42 +0300
nabil [EMAIL PROTECTED] wrote:
PLEASE HELP ME PHP PEOPLE,
I have a
Your IP users have no permissions. (Hint: N = No)
How is this a PHP problem? (Hint: It is all over the mysql list archives.)
Doug
On Thu, 12 Jun 2003 13:35:21 +0300, nabil wrote:
GUYS help me please.
1- mysql server in on my own machine..
2- my machine IP is 192.168.0.1
3- when i tired to
-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
My psychic powers are a bit out of tune, but I think the problem is on
line 35 of your code.
[EMAIL PROTECTED] wrote:
My PHP scripts don't execute the SELECT queries after execute the first.
My web execute PHP scripts for work with MYSQL, all on Apache webserver.
PHP version: 4.1.2
MySQL
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
Hi!
I hope, I understood you right: You want to delete a user completely from
your database?
If yes, you can just do it step by step (I hope the last step - putting all
the queries together works):
$uid = 1;
$qry = 'SELECT `Allocation_ID` FROM `WMS_Allocations` WHERE
`User_ID`='.$uid;
$ent =
there are a million sample php script in links...
http://www.php.net
muhammad_wahyu
Michelle Whelan wrote:
Does someone know why I am getting this error? $Yards =
$_POST[needdirtype] is line 45
Parse error: parse error in /havedirt2.php on line 45
You seem to be missing the ; from each line.
Neil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
' Cornelius [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 07, 2003 9:00 AM
Subject: Re: [PHP-DB] Help with a query
Why not use:
SELECT a.item_id, a.subtotal, a.quantity
FROM shopping_cart a, orders b
WHERE b.session_id = session_id()
AND b.customer_id = $customer_id
Why not use:
SELECT a.item_id, a.subtotal, a.quantity
FROM shopping_cart a, orders b
WHERE b.session_id = session_id()
AND b.customer_id = $customer_id
AND a.order_id = b.border_id
?
!Exclude Disclaimer!
Jonathan Villa wrote:
I can't figure this query out.
I want to pull data from 2
; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Help with MySQL Logic
A client of mine, a rail car storage company, has asked that I create a
PHP/MySQL application in which they will maintain and track rail cars. I
am
having a bit of trouble however working through one of thier
requirements
is what I wanted to avoid, but I guess
there's no other way
Thanks for the quick reply.
--- Jonathan
-Original Message-
From: Paul Burney [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:06 AM
To: [EMAIL PROTECTED]; PHP Database List
Subject: Re: [PHP-DB] Help with a query
Heh. Sounds like a programming class homework project.
I would say through the clever use of where clauses's, like:
UPDATE position SET posistion = (position-1) WHERE position $idremoved;
Would work, assuming $idremoved containted the position of the car removed.
On Mon, 2003-03-03
A client of mine, a rail car storage company, has asked that I create a
PHP/MySQL application in which they will maintain and track rail cars. I
am
having a bit of trouble however working through one of thier requirements.
They need to know in what position the rail car is on each track. For
What about two tables, one would have this:
carID
carCompany
carPayload
etc...
the second this:
position
carID
This table would be static and if a car was not present in certain conditions
they would contain (-1) for the carID. Then finding an empty slot to place an
incoming car should be
]
Subject: Re: [PHP-DB] Help with MySQL Logic
Heh. Sounds like a programming class homework project.
I would say through the clever use of where clauses's, like:
UPDATE position SET posistion = (position-1) WHERE position $idremoved;
Would work, assuming $idremoved containted the position
Put start_session() statement on first line of your code
- Original Message -
From: do khac duy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 13:31
Subject: [PHP-DB] help about session
i can't start session under incule row
ex: include(file.php);
i can't start session under incule row
ex: include(file.php);
start_session();
it say : can't add header header already sent by...v
somebody can help me?
You can't have any output before session_start(). Call it first in your
file or fix where you have output. The error
adduser script is written in perl. You can easily disect it.
Quoting Bruno Pereira [EMAIL PROTECTED]:
How can i create a new user, with linux, apache and php?
Like this, in a form i ask for the username and password, than somehow use
the 'adduser' username password confirm password.
Can
You can take the selected items posted to your page and use in_array() to
search for the current item as your code creates the list. this is a chunk
of code that i use to do the same thing. I wrote this a long time ago, so
there may be better ways to do thisbut it works. ;-)
snip
if
Have you correctly updated you web server's .ini file to point to the PHP
installation according to the PHP installation instructions?
-Original Message-
From: Tomas Liendo [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 10:29 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
On Tuesday 04 February 2003 11:29, Tomás Liendo wrote:
Hello I'm a beginner, I'm reading the PHP's manual but I can't test the
examples because always receipt the following error message:
Call to undefined funciont:name of any function that I want to use
I can't understand why! Please
On Tue, Jan 28, 2003 at 10:44:47PM +0100, Geckodeep wrote:
Hi Rajesh
First of all I'd like to thank you for your time.
No hassles.
I got the script working in a way that it feeds my DB table, but I am
getting this error message: Warning: copy() [function.copy]: Unable to
access in
I think I remember something about pack and unpack working with aunti
endian, uncle endian and all the little endians.
Jason
-Original Message-
From: Robert Trembath [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 9:02 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:
Can any one guide me through the uploading file procedure please?
Should I use copy() function to copy the image file to a temp file and
rename it to the real name and then reference the name in the data
base.
Or is there any other way.
Should say though my Service Provider does not support
On Mon, Jan 27, 2003 at 05:05:02PM +0100, Geckodeep wrote:
Hi,
Can any one guide me through the uploading file procedure please?
Should I use copy() function to copy the image file to a temp file and
rename it to the real name and then reference the name in the data base.
Or is there any other
Rodrigo Corrêa wrote:
I´m new with MySQL, i´m just wondering if there is a way to get the IP from a MySQL Server, since i acess this by localhost in the webserver
even if you could, the MYSQL admin probably set your account to access
your data with a LOCALHOST permission only... so if
Hello khac,
hmm what platform are you running on? what are PHP settings for
writing sessions? Check out permissions for /tmp directory, check out
free space on disk.
--
Best regards,
Martin mail [EMAIL PROTECTED]
mobile
Are you running on windows or Linux???
This looks like a Windows problem - you have to set your
SESSION_SAVE_PATH in php.ini AND make sure the folder you specify exists
and is accessible to PHP.
HTH,
Richy
==
Richard Black
Senior Developer,
when using start_session
the code tries to write a file to the tmp dir...
think you are working under windows
so make in c: a \tmp dir !!!
then it should work
-Original Message-
From: khac duy [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 10 januari 2003 1:08
To: [EMAIL PROTECTED]
You can do it very nicely with MySQL:
$query = SELECT WEEKDAY( '{$mydate}' ) ;
Provided your date is correctly formatted ( -mm-dd )
Ignatius
- Original Message -
From: Rodrigo Corrêa [EMAIL PROTECTED]
To: PHP1 [EMAIL PROTECTED]
Sent:
with mysql its:
WEEKDAY(date)
Returns the weekday index for date (0 = Monday, 1 = Tuesday, ... 6 =
Sunday):
mysql SELECT WEEKDAY('1998-02-03 22:23:00');
- 1
mysql SELECT WEEKDAY('1997-11-05');
- 2
http://www.mysql.com/doc/en/Date_and_time_functions.html
in php its:
string date (
You can specify a padding character and length with printf
www.php.net/printf
---John Holmes...
- Original Message -
From: Martín Agüero [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 9:52 AM
Subject: [PHP-DB] Help about printing an integer variable
I need to
something like
printf(%+4d, $int_var);
Andrey
- Original Message -
From: Martín Agüero [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 4:52 PM
Subject: [PHP-DB] Help about printing an integer variable
I need to print an integer varible using this format '',
-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 5:07 PM
To: Martín Agüero; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Help about printing an integer variable
something like
printf(%+4d, $int_var);
Andrey
- Original Message
use system() to run /bin/df
depending on the OS you might need to add a flag to it like -h (linux) or
-k (solaris).
www.php.net/system
Adam
On Fri, 27 Dec 2002, Dankshit wrote:
Is there a way to see how much space is left in a ftp server?
thanks in advance!
--
-- pada 2002-12-26, 14:36:00 [EMAIL PROTECTED] menulis: --
Hi.
I juz installed a RedHat 8.0 on my machine.
But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20..
It's preety weird.. coz there's nothing shown up in the browser when I
run phpinfo(); or even a simple 'helloworld'
Everything's perfect.. except my browser keep blank when I run my php
files...
--www.kapsul.org--
DuFronte
-Original Message-
From: adi setiawan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 5:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Help Needed
-- pada
Everything's perfect.. except my browser keep blank when I run my php
files...
No, obviously it's not perfect because it's not working at all. Your page is
blank because ? phpinfo() ? will be evaluated as an unknown HTML tag and
come out blank.
Find another tutorial that discusses how to set
At 02:36 PM 12/26/02 +0700, dufronte wrote:
Hi.
I juz installed a RedHat 8.0 on my machine.
But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20..
Apache 2 and PHP are not ready for prime time. If you must use Apache 2
with PHP, you are on the bleeding edge, and should plan
: [PHP-DB] Help Needed
At 02:36 PM 12/26/02 +0700, dufronte wrote:
Hi.
I juz installed a RedHat 8.0 on my machine.
But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20..
Apache 2 and PHP are not ready for prime time. If you must use Apache 2
with PHP, you are on the bleeding
Chris,
Does anyone know of a way to retrieve MS Outlook data via PHP? I am
creating
an intrant for my company and want to grab data from the MS Oulook contact
list on the server to using in my PHP/MySQL intranet project.
Any help would be most appreciated.
Rather than using PHP to go
Try mysql_connect instead. Doesn't sound as if you are at the stage at
which you would realize any gains from a persistent connection. I've
just seen a lot of comments regarding strange happenings with pconnect
- which I have no doubt will be addressed later.
Don Briggs wrote:
While
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
You might read the database to see how many have been sold previously
and put that into a PHP variable. Add the amount that you'd be
incrementing it by (I assume it's possible that it will increment by
more than one at a time), determine the price point, and then update
the row with both the new
Well...
1 day = 60*60*24 = 86400
You figure it out from there :)
Just one example.
Aaron
-Original Message-
From: Dankshit [mailto:[EMAIL PROTECTED]]
Sent: November 28, 2002 12:06 PM
To: PHP; PHP1
Subject: [PHP-DB] Help with date
How can i add days to a date??
If you use MySQL:
SELECT DATE_ADD( $my_date, INTERVAL n DAY ) AS new_date ;
Ignatius
- Original Message -
From: Dankshit [EMAIL PROTECTED]
To: PHP [EMAIL PROTECTED]; PHP1 [EMAIL PROTECTED]
Sent: Thursday, November 28, 2002 6:06 PM
Subject:
Rodrigo,
Is there a way to convert a date 20/11/2002 to a Float number in PHP,
since the date starts in 30/12/1899, just like the delphi treats the
dates
=Check out UNIX timestamps (but watch the valid date range),
=dn
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Is there a way to convert a date 20/11/2002 to a Float number in
PHP,
since the date starts in 30/12/1899, just like the delphi treats the
dates
Yeah, of course. To convert 20/11/2002 into a float, just do
echo (float)20/11/2002;
and you get 20!!
Or you can use strtotime() to convert
I do not think php is the problem here.
Take a look here
http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Gone
_away
There are some good pointers on what to do...
Regards
Joakim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi
try echoing the actual query, after the variables have been converted to
values
$qtrans = insert into $tbltrans
values('0', 'daily', '$building',
'$itemchoice',
'0', '$count', '0', '$ddate', '$cat');
echo $qtrans ;
and see if a comma or quote mark is in
If it is cutting off at the spaces (like is apple sauce, etc... cutting off
after apple instead of the comma after sauce), try urlencode'ing the data
before passing it to the next page.
For your print option statement, try this:
print (option value=urlencode($itemarray[description])$itemarray
you need a second REQUIRED parameter:
mysql_result
(PHP 3, PHP 4 )
mysql_result -- Get result data
Description
mixed mysql_result ( resource result, int
row [, mixed field])
as
Just from quickly looking you are trying to submit a form and grab the
submitted value and stick it into the DB?
If so try using METHOD=POST on your form, and using the variable
$_POST[form_field] in the insert statement
Matt Babineau
MCWD / CCFD
-
e:
you have to change the Content-Type header or something (text/html) but the
easiest way is to use a pre-packed class (unless you really want to do it
yourself). Check out hotscripts or just do a google for php mail class or
similar :)
HTH
Beau
// -Original Message-
// From:
You could try:
SELECT users.Name, Files.Filename
FROM Files
LEFT JOIN users ON Files.Userid = users.Id
GROUP BY Files.Userid
ORDER BY Files.Stamp DESC
I'm not sure if this would work, depends on if MySQL ORDER's before GROUP.
You could try it though. Capitolization may be incorrect, I
On Wednesday 10 April 2002 21:35, Christopher L. White wrote:
well, next to nothing. i'm a scripting programmer, but i'm quite unfamiliar
with the PHP syntax. trying to find some good examples of displaying field
values from tables in a database, in such a way to display a page. in other
Hi Djordie,
You need to have the connection to the DB in your php script
leksikon_in.php .
Gurhan
-Original Message-
From: Djordje Gacesa [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 07, 2002 9:44 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] help with insert needed
Hello, everybody!
Just do a while loop:
while(preg_match(/string to find unconverted links/, $TextBody))
{
// preg_replace here
}
But make sure you're not doing this on the fly every time the page is
viewed. That will take up an enormous amount of resources with lots of
visitors. Just convert it and
On Fri, Mar 29, 2002 at 11:46:24AM -0800, Kevin Won wrote:
I'm writing a knowledgebase (basically a content management system) application
where people are adding text via web forms then viewing this data on the web.
standard bread-and-butter kind of stuff.
of course people want to put in
ORA-12154: TNS:could not resolve service name
Cause: The service name specified is not defined correctly in the
TNSNAMES.ORA file.
Action: Make the following checks and correct the error:
- Verify that a TNSNAMES.ORA file exists and is in the proper place and
accessible. See the operating system
Berli,
Oracle's Apache is compiled with Oracle's libraries The php modules you
have are probably not compiled with the same libraries On Linux (in the
documentation) there is a procedure to compile Oracle's version of
Apache to include other modules
The other option you have is to run a
That's a pretty naive question to ask. For what specific task do you want to
compare them ? Besides if you can't write a comparison article on PHP vs.
JAVa , how can you set the outcome in PHP's favor?
I would advise you to sit down and try to do the task both in Java and PHP
, and compare both
Google search for php wiki, or save that step and go to
http://sourceforge.net/projects/phpwiki/
Miles Thompson
At 05:26 AM 2/6/2002 -0700, jas wrote:
Is there anyone out there that has developed an application using php and
mysql that allows clients etc to update and maintain their own
I'm not sure why that isn't working, but this might do what you want:
$index = strrpos($im_file, \\);
$im = substr($im_file, $index + 1, strlen($im_file));
I just tested it out here and that works fine, $im = image.jpg
On February 1, 2002 02:41 am, you wrote:
Good day to all.
I tried the
Hello!!!
What is the Length of the varchar field, in your database???
Dan
On Friday, January 25, 2002, at 01:22 PM, [EMAIL PROTECTED] wrote:
I'm having a problem with varchar fields out of mssql which are only
returning value lenghts = 256 characters.
I know that the php.ini setting
If you need something that big
Use a TEXT type instead.
Dan
On Friday, January 25, 2002, at 01:35 PM, [EMAIL PROTECTED] wrote:
thanks for your reply. It's 5000.
Kevin Won
-
ITG Web Developer,
Systems Administrator
which library are you using to connect to SQL Server? Is this php running
on windows or are you trying from unix?
On Fri, 25 Jan 2002, Kevin Won wrote:
I'm having a problem with varchar fields out of mssql which are only returning value
lenghts = 256 characters.
I know that the
It's php 4.0.6 on win2k/apache.
kevin
Brian Bruns [EMAIL PROTECTED] 01/25/02 02:19PM
which library are you using to connect to SQL Server? Is this php running
on windows or are you trying from unix?
On Fri, 25 Jan 2002, Kevin Won wrote:
I'm having a problem with varchar fields out of
It's php 4.0.6 on win2k/apache.
kevin
Brian Bruns [EMAIL PROTECTED] 01/25/02 02:19PM
which library are you using to connect to SQL Server? Is this php running
on windows or are you trying from unix?
On Fri, 25 Jan 2002, Kevin Won wrote:
I'm having a problem with varchar fields out of
Hi Shelly,
It is just the old trick. You can get the time at the beginning of the page
and at the end of the page and just calculate the difference in between two.
Since the default timeout value in PHP is 30secs. it will probably be a
short timeperiod so you can probably you use time() function
Help, i'm trying to connect to a remote oracle database from
win98/apache/php4 and win2k/iis/php4 but it always gives me tns
error. Other
apps however, works fine with the tns configuration. the php oracle module
was loaded successfully on both platforms.
I've tried all sorts of
You seem to be doing it fine as far as I can see, except for song_id which should be
songs_id in the query...
Bogdan
Barry Rumsey wrote:
Hi
I have three tables set out below:
xp_artist: artist_id , artist _name
xp_sings: artist_id , songs_id
xp_songs: songs_id , song_name , lyrics
I
PROTECTED]
To: Barry Rumsey [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, January 07, 2002 1:51 PM
Subject: Re: [PHP-DB] help on mulit query
You seem to be doing it fine as far as I can see, except for song_id
which should be songs_id in the query...
Bogdan
Barry Rumsey wrote:
Hi
I have
Your query looks fine, except that it should be xp_sings.songs_id. What you
are trying to resolve is a many to many relationship where many artists can
sing the same song, hence you have created the table xp_sings. This is also
known as a pivot table.
What problem are you having?
Have you
: Monday, January 07, 2002 1:51 PM
Subject: Re: [PHP-DB] help on mulit query
You seem to be doing it fine as far as I can see, except for song_id
which should be songs_id in the query...
Bogdan
Barry Rumsey wrote:
Hi
I have three tables set out below:
xp_artist: artist_id
Just echo a link of the form a href=\lyrics.php?song_id=$song_id\Click for
lyrics/a and use the incoming song_id in lyrics.php to get it from the
database.
Bogdan
Barry Rumsey wrote:
I did not see that ( I must be blind hehe ). One other question , I have the
lyrics also stored in the
Don't have any suggestions, but have these questions been asked:
Presumably your query works just fine at the SQL Server console?
What happens - the first 8k display, and then the rest of your page appears?
Or do you get an error message? Timeout?
What do you get?
Are you hitting an array
Are you positive fileupload.php is passing $userfile to the mail() script? A blank
result would seem to indicate that it's not getting passed. You could try passing it
through the URL if they're seperate scripts. Or, you could just include the mail()
script in
fileupload.php, eliminating the
not really sure how to do this, other than planning for as much as you can
in your original tables, then have a spare table with four columns - Row_ID,
Characteristic_Name, Characteristic_Value, and Product_Refer_ID.
so then if you get a new characteristic (eg colour) then you could have
values
,LAST_INSERT_ID() );
-Original Message-
From: matt stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 5:55 AM
To: 'Carlo Loiudice'; PHP DB
Subject: RE: [PHP-DB] help me on projecting some tables
not really sure how to do this, other than planning for as much as you can
in your
A couple of questions:
INSERT INTO traits VALUES(Added Chemicals,LAST_INSERT_ID(),Sugar);
1. Will LAST_INSERT_ID() work reliably in a multi-user environment? What happens if
you're
in the middle of inserting a dozen records and someone else inserts a record? Does
MySQL
keep the
Message-
From: Tim Foster [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 9:42 AM
To: PHP DB
Subject: RE: [PHP-DB] help me on projecting some tables
A couple of questions:
INSERT INTO traits VALUES(Added Chemicals,LAST_INSERT_ID(),Sugar);
1. Will LAST_INSERT_ID() work reliably
I am trying to run the SP 'sp_password' on mssql, using this command:
$sql=exec sp_password 'NULL','master','davet');
Is that the correct way ???
But when I run my script I get a error with this statement.. saying Incorrect
syntax near ')'
$sql_result=mssql_query($sql,$connection);
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
Richard,
Many thanks for that.
I was reading about the for statement in a book earlier today and wondered
if I could implement it in some way.
Looks so simple now I've been shown how :)
Thanks again.
Richard Chauvaux [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
Source code- CÛdigo fuente:
?
$based=articulo.dbf;
if (($descriptor=dbase_open ($based, 0))==0){
printf (brError al abrir la base de datos);
}else{
printf (brBase de datos abierta);
$num_registros=dbase_numrecords($descriptor);
$num_campos=dbase_numfields($descriptor);
if you have phpMyAdmin then just use that (if you don't then you *really*
should :)
otherwise, yeah just use mysql_query()
or use the command line
of course the second 2 options assume you can construct the SQL command to
do it, using phpMyAdmin you won't really need to know.
/beau
//
// Question 1:
// How to process the confirmation email by clicking the url
// given in the email
// and by replying the email.
when you send them an email, include some sort of confirmation code
ie http://server/confirm.php?confirmCode=xxx
when they click, it passes this code, and you look
Anthony,
Is the DSN usable from the ODBC Administrator control panel?
E.g. test it there first. Also, you mention File DSNs? PHP can only use
System DSNs on Windows, AFAIK.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data
201 - 300 of 334 matches
Mail list logo