In article <01cd01c09b0d$7f247630$0101a8c0@server>, [EMAIL PROTECTED]
("Pankaj Ahuja") wrote:
> Is it possible to insert apostrophe into a Mysql database ?? I have a
> varchar type column and want to insert " manufacturer's" into it. How can I
> do this ??
Escape it with a slash: " manufacturer
Is it possible to insert apostrophe into a Mysql database ?? I have a
varchar type column and want to insert " manufacturer's" into it. How can I
do this ??
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMA
Brandon Feldhahn wrote:
> im making a webdesign website that has a members login, do i have to
> make a member page for each member or can i get the
> info from the database of the person whom logged in and put it on the
> members page
You could make individual pages for each member, but it's a l
im making a webdesign website that has a members login, do i have to
make a member page for each member or can i get the
info from the database of the person whom logged in and put it on the
members page
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
>The following big chunk of code produces the following line:
>uukjh has been deletedMySql has been selectedDELETE FROM db WHERE Db =
>uukjhUser Db has failed
>Which tells me that everything but the delete command does not work.
>
>The above line is broken down to database name has been deleted,
Just wondering...
DATE_FORMAT($datevariable, \"%Y%c%e\") works great in a query but I only
need to list the date once on the page (as opposed to in each row of the
query result) and I don't want to use a second query to MySQL. The date is
passed to the page as a variable in md (month and day
Try use a delimited string and split it on retrieve.
HTH.
Jayme.
-Mensagem Original-
De: Kyle Mathews <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: segunda-feira, 19 de fevereiro de 2001 19:35
Assunto: [PHP-DB] Inserting arrays into a database
> Hello:
>
> I'm wondering wh
> && ($file_name !="*.php")
>
> how come that still displays all the *.php files?
Because that's an exact string match for a file called '*.php' which
probably doesn't exist. Try some thing like
&& (substr($file_name, -4) != '.php')
That should exclude all files ending in '.php'.
- Darr
MySQL do support composite keys . Have a look on the mysql database
structure the "columns_priv" table has 5 fields in its primary key.
I think you should use an auto_increment as your primary field instead.
HTH.
Jayme.
-Mensagem Original-
De: Russ Michell <[EMAIL PROTECTED]>
Para: <[E
In article <000c01c09ac2$7ed27ab0$0100a8c0@fusion>, [EMAIL PROTECTED]
("Fusion") wrote:
> while ($file name = readdir($dir)) {
>
> if (($file name != ".")
> && ($file name != "..")
> && ($file name !="*.php")
> && ($file name !="main.gif")
>
> )
> {
>
> how come that still displays all
At 04:22 PM 2/19/2001 -0600, you wrote:
>while ($file_name = readdir($dir)) {
>if (($file_name != ".")
> && ($file_name != "..")
> && ($file_name !="*.php")
> && ($file_name !="main.gif")
>)
>how come that still displays all the *.php files?
You cannot use wildcards in this comparison:
$file_
Hello:
I'm wondering what is the best way to insert an array into a database table.
As well as the best way to extract and show that information.
The information that I'd be inserting is a bunch of id numbers for data in
another table.
So when getting the information, I'd like to do a table join
while ($file_name = readdir($dir)) {
if (($file_name != ".")
&& ($file_name != "..")
&& ($file_name !="*.php")
&& ($file_name !="main.gif")
)
{
how come that still displays all the *.php files?
Maybe this will help,
I use lynx -d to do some stuff on the database every day. Basically, I just
made a php page that does the thing I need to do in the database and it
doesn't generate any output.
My command is lynx -d http://website/phppage.php
Hope this helps.
Marky
> From: "Simon R Jones"
Hi all,
I'm still trying to get my site to work just right. Basically I'm
building a "secure" portal. What I want to do is:
1) get user info from form
2) submit name & password to query template
3) query template checks login:::
i) if good - needs to...
a) initialize this user's ses
On 19 Feb 2001, at 12:54, Fusion wrote:
>
> Hey can somone show me how to make something to list all files in a =
> directory spedified ?
>
Check this out:
http://www.php.net/manual/en/function.readdir.php
HTH!
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
Fabrizio Ermini
Hey can somone show me how to make something to list all files in a directory
spedified ?
fread?
I used to do this:
function nice( $value )
{
if ($value=="")
{
return "- ";
}
else return $value;
}
print nice($row["company"])
Lennin Arriola
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional comma
> > Oh god, let's not get started on that..
> >
> lol oh well.. hey do you know how to fix up the securit for internet users?
>
Maybe you could be able to configure different virtual directory to
run under the right of different users.
If this is not possible you have to find Win2000 analog
Hey,
I've been using PHP for 'bout a month
and my programming abilities are pretty limited.
I'm using a script (further below) to retrieve
results from a MySQL database. It's intended to retrieve
potentially 6 fields of information.
Some of these fields in the record, though, may be NULL, but th
> > Also i hear
> > that running a server on windows 2000 is just as good if not
> > better then unix..
>
> Oh god, let's not get started on that..
>
> --
lol oh well.. hey do you know how to fix up the securit for internet users?
--
PHP Database Mailing List (http://www.php.net/
> Also i hear
> that running a server on windows 2000 is just as good if not
> better then unix..
Oh god, let's not get started on that..
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To con
I may be mistaken, but I believe that something as simple as calling a
javascript window.open function effectively starts a parallel process, i.e.
it is a non-blocking operation in a browser
heres the sample code i used to test it.
1. A frameset with 2 frames, A and B. frame A has src=test1.php
Hey I have checked out some of the user options but where would I go about changing
them for secure modes? Also i hear that running a server on windows 2000 is just as
good if not better then unix..
Thanks..
Michael
> I run my PHP crons like this:
>
> 0 6 * * * /usr/local/bin/lynx -source "http://www.domain.com/file.php"
>
> This is not the most secure of course, as the file is below the root
> and could be hit by any user. But works for my particular case ...
>
> Anyone know of a method to make this more se
Hello,
I run my PHP crons like this:
0 6 * * * /usr/local/bin/lynx -source "http://www.domain.com/file.php"
This is not the most secure of course, as the file is below the root
and could be hit by any user. But works for my particular case ...
Anyone know of a method to make this more secure
> > I have PHP installed as an Apache module and I can't have it as
> CGI.. now
> > I'm looking into ways to run PHP scripts off the cron, and I saw
>
> Rebuilt php again and don't specify the apache configuration option. This
> will build php as a CGI program which you can then use in cron.
>
> D
IMHO, I don't think you can doit on PHP, you may have to do it outside PHP,
for instance in java, java has multithreading, and then you might access it
through PHP,
Lennin Arriola
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
Fo
> I have PHP installed as an Apache module and I can't have it as CGI.. now
> I'm looking into ways to run PHP scripts off the cron, and I saw
Rebuilt php again and don't specify the apache configuration option. This
will build php as a CGI program which you can then use in cron.
Does anyone els
hi there,
I have PHP installed as an Apache module and I can't have it as CGI.. now
I'm looking into ways to run PHP scripts off the cron, and I saw that PHPAds
does a fetch command to parse the script on a regular basis.
I'm just wondering if anyone else out there has had to do this, and what is
hello all!
i was wondering how to do a php script that works like this.
i need to make an update to a database but at the same time i need to make a
query to another database.
the update and the query doesn't have anything to do with each other, they
just need to run both in a paralel way.
i was
Russ:
Keep an independent key, for instance a field called ID,
with auto-counter. That will make your rows uniquely identified...
then if you want to search for a player in a specific team, and a specific
sport,
just with a query select * from players where team = t?, sport=?
no need for compos
> I want to find out which memberIDs have BOTH choice 2 AND choice 3.
>
> --> SELECT memberID from table where choice=2 AND choice = 3
>
> That won't work (0 results, of course, because no row has two choices,
> they're mutually exclusive)
>
Exactly, keep several rows for choices,
have two tabl
> With HORA, it is no problem to display the hierarchic structure via the
> CONNECT BY clause. I tried the same statement in PHP3 and it
I'm using php4pl1 with Oracle 8.1.6 and this works:
select c.cvsn_id,
c.parent_cvsn_id,
level
from cvsn c
where start wit
Hello there!
I'm new to this list and I've got a problem ;). Have I to introduce myself?
Anyway, here it is:
I'm using an oracle database to store hierarchic data in a single table.
With HORA, it is no problem to display the hierarchic structure via the
CONNECT BY clause. I tried the same stat
Randall,
Apparently I mis-understood you. I thought you meant upgrade the servers...
Yes we can upgrade the client. Do you have a URL available for the 8.1.6
version of the client... Thanks.
Later,
Jorge
[EMAIL PROTECTED]
- Original Message -
From: Randall Barber <[EMAIL PROTECTED]>
To:
Hi all:
I am using php4.0.3pl1 with MySQL 3.22.32 on Apache for RH Linux.
I have a table/relation of sports, where amongst other categories, are
teams, where there can be many 'teamNames' & 'teamInfos' for one sport.
The problem here is that without the use of a composite key:
'sportName' & 'T
thanks y'all
the header("location: blahblahblah...");
worked for my cgi-redirect question!
Thanks for the crucial help!
-f
--
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 admi
38 matches
Mail list logo