Helo,
why you don't make some kind of "db_connect.php" which will make "mysql_pconnect()"
and include it in top of your first script? You then will be able use mysql query in
everyone of your page. You can also make $mysql_is_connected=true; there and check
that variable in other scrips if nee
> Hi Guys,
>
> I did try that but I will try it again.
>
> Also, I have echo'd the data and it does appear as I expect.
>
> Any other thoughts while I try this?
Don't know if this has anything to do with your problem, but
> $headers = "Return-Path: <$support_email>\r\n";
should be
> $headers .=
Did anyone hear about "match against" construction? I is easy to build
this:
$query = "SELECT *, MATCH field AGAINST ('$searchwords') as relev FROM table
ORDER BY relev DESC"
(you need do "ALTER TABLE table ADD FULLTEXT(field)" before.
This could be usefull:
http://detail.phpclub.net/download/s
Hiya,
I remember ages ago that mysql does not properly handle upwards of 10
million records in a table?
Any details would be great!
Thanks,
Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Friday 25 October 2002 10:40, Garry Climacosa wrote:
> 6. heres the action page check_act.php
> $file2write = fopen("/var/lib/data/access.temp2.txt", "w");
> $write2line = "$myline\n";
> $filewrite = fwrite($file2write, $write2line);
> ?>
The first thing to check -- did you echo $myline (or $
On Friday 25 October 2002 16:10, Steve Vernon wrote:
> Hiya,
> I remember ages ago that mysql does not properly handle upwards of 10
> million records in a table?
>
> Any details would be great!
Try it, or ask on the mysql list?
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> I remember ages ago that mysql does not properly handle upwards of 10
> million records in a table?
What's this got to do with PHP?
And yes, MySQL will handle it, depending on what you're doing with the data.
There are always alternatives, though.
---John Holmes...
--
PHP Database Maili
Which is the MySQL list you are talking about please?
Thanks,
Steve
> On Friday 25 October 2002 16:10, Steve Vernon wrote:
> > Hiya,
> > I remember ages ago that mysql does not properly handle upwards of
10
> > million records in a table?
> >
> > Any details would be great!
>
> Try it, o
yes i did, and it creates a the access.temp2.txt file but it only contains
the last array...
- Original Message -
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 6:40 PM
Subject: Re: [PHP-DB] Fw: array transfer via form.
> On Friday 25 Octobe
Go to www.mysql.com and join their's general list. it's address is
[EMAIL PROTECTED]
Andrey
- Original Message -
From: "Steve Vernon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 2:15 PM
Subject: Re: [PHP-DB] Millions of records in MySQL
> Which is the MyS
Hello, friends.
I am working with PHP+ORACLE project. I need there to request a procedure
with pl/sql table parameter.
e.g. something like:
TYPE tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
I had found OCINewCollection() function in manual. Unfrortunatly this
function description is only "com
You can also do something like this:
if ($db_link = mysql_pconnect($host, $user, $pass)) {
if (mysql_select_db($db,$db_link)) { return $db_link; }
else die("MySQL Error: Cannot select {$db} database using {$user}@{$host}:
".mysql_error());
} else die("MySQL Error: Cannot connect to {$db}:
I want to apologize for my ignorance in advance...
I'm developing PHP code with MySQL on Unix platforms for quite a while. Now
I'm asked to use my unix based PHP code with a MS-SQL database on a
Microsoft platform. So while having the php code on a unix platform the
MS-SQL database is obviously sit
yes this works. if your code is going to remian on Unix you'll have to
install freetds (www.freetds.org). there are instructions on
www.php.net/mssql for install in the comments...
when you get to the site(freetds.org) I know it says Sysbase..but it is
what you're looking for.
hope this hel
Axel,
Well, I'm not sure what everyone will tell you, but this is what I did. I
used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()"
PHP functions. There is also the matter of changing your SQL Statements to be
compatible with SQL Server. MySQL and SQL
Thanks John!
Say, are there any arguments not to use MS-SQL?
Did you run into any problems?
Thanks,
Axel
-Original Message-
From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com]
Sent: Friday, October 25, 2002 3:14 PM
To: Axel; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] PHP and
Great, thanks a bunch!
-Original Message-
From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke@;Keane.com]
Sent: Friday, October 25, 2002 3:11 PM
To: Axel
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP and MS-SQL
yes this works. if your code is going to remian on Unix you'll have to
install
Hi
I get an error message with the following statement, if I remove the 'AND
works_order_part_no=parts_parts_no' I don't get an error message but also
get the wrong data ??
$link = mysql_connect($host, $user, $pass);
mysql_select_db("DB_EDMsystem", $link);
$result = mysql_query("SELECT * FRO
What's the error?
-Original Message-
From: Steve Dodkins [mailto:Steve.Dodkins@;ebm-ziehl.co.uk]
Sent: 25 October 2002 16:46
To: Php-Db (E-mail)
Subject: [PHP-DB] select statement
Hi
I get an error message with the following statement, if I remove the 'AND
works_order_part_no=parts_pa
First time playing with PHP, Apache, and MySQL. I have a simple form error
and I don't know how to solve it. I was doing the Webmonkey PHP/MySQL
tutorial and when I started using forms with $PHP_SELF I started getting
errors with variables not defined.
PHP 4.2.3
MySQL 4.0 Windows 2000
Apache 1.3
Hi all, I'm having a problem inserting a value from a checkbox into a MySQL DB. I can
print out what the variable holds, the problem is it just won't go into the DB. Weird
thing is when I login to SSH there isn't a NULL value for it instead that field is
just blank.
Anyone got any ideas what
Graeme,
first, extend the for loop over the "if" and the query for insertion of
data. As you have it now, it just inserts the last element of the array.
second, I think that the for loop should be $a<$number. if you put <=,
then the loop is processing the array with the last value not assigned by
In addition to what Mihail had to say, I saw a couple of minor things as
well. I'm not sure if they're the cause of or solution to the problem you're
experiencing.
First, I'm pretty sure that a value of value=\"Y\" is not valid HTML. I
don't know what it does to your name/value pair when you POST
Hey guys,
Not really off topic as this involves some Db work as I have to query
the DB.
Got a logic problem that was jumped dumped on me from UPS (dummys!).
Basically I need to pull some records out of a database and for the
first record do_this logic and for each record after in the array
do_s
on 10/25/02 2:53 PM, Aaron Wolski at [EMAIL PROTECTED] appended the
following bits to my mbox:
> Basically I need to pull some records out of a database and for the
> first record do_this logic and for each record after in the array
> do_something_else logic.
Psuedo code:
$first_record = 'yes';
$x = 1;
while($row = mysql_fetch_array($result)) {
if ($x) {
do_something();
$x = 0;
continue;
} else {
do_something_else();
}
}
This sets $x = 1 before the loop. The first time it goes through the loop
it does something for the first record and sets $x
What about wrapping your logic in a counter? Set $count=1,
if($count=1){do_this; then $count++;} else{do_that}. Wouldn't really add any
overhead to your script since the counter only gets incremented once when
the if() statement is true then stays at 2 and executes the else{} stuff
after that.
Pre
I'm sure there are a hundred ways
$rs = 0; // record set array
for ($i = 0; $i < count($rs); ) {
while($rs = mysql_fetch_array($result)) {
if ($i ==0 ) {
//do first thing
} else {
//do other things
}
$i++
}
Jeff
Why not use the for loop to post the values?
for ($i=0; $i<$num_rows, $i++) {
if ($i==0) {
bla bla
}
else {
bla2 bla2
}
}
$i=0 ensures that the first record of his query is retrieved.
On Fri, 25 Oct 2002, Hutchins, Richard wrote:
> What about wrapping your logic in a counter? Set $count=1,
> if($
Mihail, thanx for your advice, I've got it going now ! :) Thank you !
Richard, your points were valid, the HTML code with the slashes was just a
copy n' paste from a PHP script and the comma I think I deleted by accident
so its all sorted now.
Thank you again!
Graeme :)
- Original Message
Mario,
The one neat thing about PHP is when something goes wrong with the code, it
usually tells you where the error is happening and like a small reason why.
On line 11 of your code, you have:
$PHP_SELF,
this is the variable that needs to be defined as to what this string is
supposed to be.
PHP is
We faced this problem, and decided if we couldn't get a good solution to
eliminate the printer. Turns out the users liked it better, and we
eliminated a lot of paper.
- First we wrote a report writer.
- All reports go to the database.
- We wrote a report file system.
- The report output title sho
32 matches
Mail list logo