No way. PHP is server-side. Javascript is mostly clientside.
Best regards,
Andrey Hristov
- Original Message -
From: "jas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 8:17 AM
Subject: [PHP-DB] Disable Right click w/ php?
&g
mysql_insert_id()
Regards
Andrey
- Original Message -
From: "Andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 23, 2002 3:32 PM
Subject: [PHP-DB] Getting the ID of the last inserted record possible?
> Hi there,
>
> I would like to name pictures I uploaded aft
;pear" instead of
"php4").
Best regards,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: "php List" <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002
The problem is that you probably use phpMyAdmin for editing data.
Regards,
Andrey Hristov
- Original Message -
From: "Marco Coletta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 10:08 AM
Subject: [PHP-DB] Problem with symbol &
phpMyAdmin has changed & to & and then put it in the DB.
So it is better not to use phpMyAdmin or any toher web based tool for tasks which
includes & entering. Not sure for <,>
Regards,
Andrey Hristov
- Original Message -
From: "Marco Coletta" <[EMAIL PR
AM
> Subject: Re: [PHP-DB] Problem with symbol &
>
>
> > It's not phpMyadmin that changed & to & but the PHP script.
> > Than because I could not find with the PHP script the record I looked in
> > with phpMyadmin.
> >
> >
> > "A
Try those provided in PEAR(in the distro).
Best regards,
Andrey Hristov
On Friday 08 March 2002 08:04 pm, you wrote:
> I'm looking for a good MySQL db abstraction layer. I'm just coming back to
> PHP/MySQL and rather writing my own I figured I'd try to see if any ar
list($sum)=mysql_fetch_assoc(mysql_query('SELECT SUM(salary') FROM employes;'));
Best regards,
Andrey Hristov
On Friday 08 March 2002 09:17 pm, you wrote:
> I need to add up the (integer) values of columns, and return the added up
> value as one column to php. Is this p
select cat_id, count(prod_id) from some_table order by cat_id;
Best regards,
Andrey Hristov
- Original Message -
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 16, 2002 12:46 PM
Subject: [PHP-DB] a Count() ?
> Hi All
&
rents
using(parent_id);
or
select * from parents,parentlog left join students using(student_id) where
parents.parent_id=parentlog.parent_id;
Hope this helps.
Andrey Hristov
- Original Message -
From: "John Hughes, Jomari Works" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&g
In php
$your_timestamp += gmmktime(0,0,0,1,1,1972);
MySQL has INTERVALling options.
Regards,
Andrey
- Original Message -
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 10:11 AM
Subject: [PHP-DB] How to add 2 years to todays date ?
> Hi Al
select * from sometable where (SUBSTRING(somefield,1,1) in
('a','b','c','d','f','g','h')) AND (SUBSTRING(somefield,2,1) in
('i','j','k','l','m','n','o
The info is not full but I'll try to help. Lets say the name of the field in the two
tables is common_field.
Then we do
SELECT all_that_is_needed FROM table1,table2 WHERE
table1.common_field=table2.common_field;
And an optimized variant:
SELECT all_that_is_needed FROM table1 LEFT JOIN table2 USI
Otidi tuk : http://www.php.net/unsub.php i vig kak se pravi Unsubscribe
Andrey
- Original Message -
From: "Stefan" <[EMAIL PROTECTED]>
To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; "'Ron'" <[EMAIL PROTECTED]>
Cc: <[EM
aster than eregi().
Regards,
Andrey Hristov
- Original Message -
From: "John Fishworld" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 25, 2002 12:59 PM
Subject: [PHP-DB] Comparing Strings
> Whats the best way to compare 2 strings (city names
On Mon, Mar 25, 2002 at 02:49:07PM -0500, Scarbrough, Jeb (ISS Atlanta) wrote:
> Is it possible to create a transaction the involves multiple pages using PHP
> and oracle. For example, can I log onto oracle using OCIPLogon on one page
> named master, insert information, go to the next page na
JOIN (RIGHT JOIN) is probably the best choice escpecially if
you have very big tables).
Regards,
Andrey Hristov
- Original Message -
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "PHP-DB" <[EMAIL PROTECTED]>
Sent: Tuesda
Do you receive "???"s ?
Regards,
Andrey
- Original Message -
From: "Igor Georgiev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 7:11 PM
Subject: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem with cp1215
PHP 4.1.2
Apache 1.3.23
Slackware
Is it possible Access to load a bunch of SQLs and execute them? If it is possible it
is better than CSV. Mysql has a command-line
tool for table & database dump into SQLs. Another solution is to look at PHPMyAdmin's
code to view how it dumps tables.
Best regards,
Andre
>
To: "Andrey Hristov" <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 2:20 PM
Subject: Re: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem with cp1215
> I recive this
> PHP -
> in DB - Нормативна уредба
> - Original Message
LIMIT limits only to output.
So if a SELECT creates 1 million rows and you LIMIT 10, you got the first 10 rows but
the full SELECT is done.
To speedup consider adding some id columnt with unique ints in ascending order.
Andrey
P.S.
I've to go. Have a nice evening.
- Original Message -
Another suggestion - use explicit joins.
SELECT c.*, p.province, co.country
FROM test.cities AS c LEFT JOIN test.countries AS co USING(country_c)
LEFT JOIN test.provinces AS p ON c.province_no=p.province_id
ORDER BY country , province
limit 0, 10;
This might work. If not read the docs at
Get all table names in a db and lock them :"show tables;";
Andrey
- Original Message -
From: "andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 7:37 PM
Subject: [PHP-DB] how to bring down the mysqlserver without getting an inconsistant db?
> Hi there,
>
closed.
Andrey
- Original Message -
From: "andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 7:47 PM
Subject: Re: [PHP-DB] how to bring down the mysqlserver without getting an
inconsistant db?
> what if I have 50 tables??
>
>
>
ECTED]>
Sent: Thursday, April 11, 2002 7:47 PM
Subject: Re: [PHP-DB] how to bring down the mysqlserver without getting an
inconsistant db?
> what if I have 50 tables??
>
>
> "Andrey Hristov" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> 02f701c1e177$abd40
update some table set some_field='X' where ((some_field IS NULL) OR (some_field!=""));
HTH
Andrey
- Original Message -
From: "Natividad Castro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 12, 2002 2:47 PM
Subject: [PHP-DB] converting
> Hi to all,
> I'm having a lot
here
}
}
}
in pseudo code.
HTH
Andrey Hristov
- Original Message -
From: "andy" <[EMAIL PROTECTED]>
To: "Andrey Hristov" <[EMAIL PROTECTED]>
Sent: Friday, April 12, 2002 3:58 PM
Subject: Re: [PHP] is it possible to scann subdirectories?
>
Look at PEAR repository for userspace abstraction layer.
Look at the dbx extension for compiled abstraction layer.
Andrey
- Original Message -
From: "adi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 4:08 AM
Subject: [PHP-DB] database absraction layer
> dear
sraction layer
> thanks,
> but what I want is, they don't have to --enable-dbx or enable pear in
their php
> configuration to be able to use this class.
>
>
> "Andrey Hristov" <[EMAIL PROTECTED]> wrote on 5/7/02 9:29:24 AM:
> >
> >Look at PEAR re
- Original Message -
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 24, 2002 6:45 AM
Subject: Re: [PHP-DB] Global variables, $_GET problem
> On Wednesday 24 July 2002 11:38, Ruth Zhai wrote:
>
> > We just upgraded our PHP to version 4.2.1. I reali
There is another small RDBMS that supports subset of the ANSI-92 standart.
It's name is SQLite
there is a module for it here :http://sourceforge.net/projects/sqlite-php/
MOre info about SQLite here : http://www.hwaci.com/sw/sqlite/
Regards,
Andrey
- Original Message -
From: "Pentothal"
s($systems);
> $sys_list = "\n";
> $sys_list .= "System Name\n";
> $sys_list .= "---\n";
> while($name = mysql_fetch_row($systems)) {
> $sys_list .= "$name[0]\n";
> }
> $sys_list .= "\n";
>
> Thanks in advance for
Maybe it will help you but I've read that when using persistent connections
PHP uses 2 on every request.
So if in one moment you have 10 scripts,that use persistent connections,
running you will have 20 connections used to the mysql.
Regards,
Andrey
- Original Message -
From: "Paul Worthi
omething in the way the array is being built.
>
> Paul Worthington
> [EMAIL PROTECTED]
>
> "Andrey Hristov" <[EMAIL PROTECTED]> wrote in message
> 01cd01c237e8$7e1438b0$1601a8c0@nik">news:01cd01c237e8$7e1438b0$1601a8c0@nik...
> > Maybe it will help you bu
onnections parameter from the
default of 100.
[/snip]
Andrey
- Original Message -
From: "Rasmus Lerdorf" <[EMAIL PROTECTED]>
To: "Andrey Hristov" <[EMAIL PROTECTED]>
Cc: "Paul Worthington" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sen
Yeaah!
I am a fool. My biggest excuses.
Sorry Rasmus and everyone else.
Andrey
- Original Message -
From: "Rasmus Lerdorf" <[EMAIL PROTECTED]>
To: "Andrey Hristov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 8:11 PM
S
k2) values (5,3);');
you must have in the rollback array this
$rollback_ar = array('DELETE FROM some_table WHERE k1=4 and k2=2;',
'DELETE FROM some_table WHERE k1=5 and k2=3');
Hope this is clear.
Best regards
Andrey Hristov
- Original Message -
From: ":B ner
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
Quick hack for those who think that the MM handler is not stable
is to use the standard handler and the directory where the session files
will be to be mounted as tmpfs (even /tmp). This will give almost of the
MM's speed
without worrying whether MM is stable or not.
Andrey
- Original Messa
king/admin/
putenv("ORACLE_HOME=/home/oracle01/app/oracle/product/8.1.5");
/***/
but if my web server is an Apache under windows and the oracle is on other
machine under Linux(RH), what have to be done to make my PHP work with the
DB.
Many t
Can someone tell me where I can find already done benchmarks of Oracle
compared to other RDBMSes like DB2, MySQL,PostgreSQL or how many connection
will get oracle8i on a machine with 512 or 1024MB RAM, dual CPU PIII 500 or
dual PIII 1.1Ghz.
Sincerely : Andrey Hristov
IcyGEN Corporation
http
Try apache benchmarking tool to view what is the peak of executions per
second.
I don't use linux but think that the name of the executable is 'ab'
Andrey Hristov
http://www.icygen.com
99%
- Original Message -
From: "haheho" <[EMAIL PROTECTED]>
To: <
kldjlsjkdf
}
But keep in mind that it is better to get result_id of mysql_query in a
variable which eventually can be used to free (mysql_free_result($res))
instead of giving it directly ot mysql_fetch_array();
Also it is good idea after mysql_query to check
if ($res){
} else
{//error with the d
Try
$file_content = implode('',file($path_and_name_of_file));
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message -
From: "Jack" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]
\n";
}
echo "".$ar['services']."";
}
}
mysql_free_result($res);
?>
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message -
From: "Andrius Jakutis" <[EMAIL PROTECTED]>
To: <[EMAIL
$func_body = "return ($a==1 or $b==2)";
$newfunc = create_function('$a,$b',$func_body);
if ($newfunc($first_par,$second_par)){
}
or
if ($newfunc($a,$b,"return (\$a==1 or \$b==2);")){
}
or
if ($newfunc($a,$b,'return (\$a==1 or \$b==2);')){
ot;(a==1) OR (b==1)";
must be
$test = "(\$a==1) OR (\$b==1)";
if it was
$test = "($a==1) OR ($b==1)";
then there will be a substitution. As a side effect this will work because
if $a=1
then $test="(1==1) or (what_is_b==1)
which given to eval() will work.
Andrey Hristov
Get and install phpMyAdmin. It can dump to you, the stucture, the data or both. Then
save them from the browser(better with lynx
because you can get the source of a page piped). And pipe it to another "mysql", or
use it in another phpMyAdmin.
Andrey Hristov
IcyGEN Corpor
OIN
your mysqld will fork too much.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message -
From: "Scott Mebberson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 9:33 AM
Subject: [PHP-DB] DISTINCT in SQL
See:
1)strip_tags
2)fgetss
3)preg_replace('|(<.*?>)(.*?)()|','\2',$string);
Example:
alabala";
$string=preg_replace('|(<.*?>)(.*?)()|','\2',$string);
echo htmlspecialchars($string);
?>
Produces :
alabala
Andrey Hristov
IcyGEN C
phpMyAdmin can do this also. Can dump the data and structure to SQL Statements. The
problem appears if the table for dumping is
100,000 rows or something bigger than the computer can get and start swapping.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message
Use addslashes() when inserting/updating the DB
use stripslashes() when extracting.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message -
From: "Jorge Giménez Mayorgas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28
I'm not so sure, but there is another parameter to md5() - the salt.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message -
From: "Ignat Ikryanov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 4:
while ($row= mysql_fetch_array($result,MYSQL_ASSOC))
{
foreach ($row as $value){
print ("$value |");
}
}
- Original Message -
From: "Jack" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 6:16 PM
Subject: [PHP-DB] Couldn't get all data using
I think that by using ODBC you can connect to the MS Access server.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "user" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 31, 2001 4:33 PM
Sub
$my_arr= array(.);
echo implode(' ',array_keys($my_arr));
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 11, 2
t;/cgi-bin/test.php"
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'its me'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 11
, ok, sorry for the disturbance. greets.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; "Rick Emery&q
var_dump($query) and see what you send to mysql. you may also use mysql_error(hmm
no sure about the name).
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: <[EMAIL PROTEC
That's correct. I've seen a discussion on dev phorum about embeding SMTP code
in PHP, but as I remember the final decision was that SMTP code will stay
outside of PHP code.
--
Andrey Hristov
Web Developer
Icygen Corporation
BUILDING SOLUTIONS
http://www.icygen.com
On Monday 22 Oc
: There is a solution but I don't know how good is it?
I'm not sure but the name of the project is PHPerl or something about it.
--
Andrey Hristov
Web Developer
Icygen Corporation
BUILDING SOLUTIONS
http://www.icygen.com
On Wednesday 24 October 2001 12:05 pm, you wrote:
> I
to change by user).
I think that this makes clear how to implement the tree.
Have fun.
--
Andrey Hristov
Web Developer
Icygen Corporation
BUILDING SOLUTIONS
http://www.icygen.com
On Monday 29 October 2001 03:02 pm, you wrote:
> Is there an easy way to implement tree structure in a datab
Use sessions. (session_start() and session_register()), and at the start of the test
save row_ids(question_ids) in arrray which you
make with session_register a session variable. On other pages you do session_start()
and after that you have access to the array.
Regards,
Andrey Hristov
IcyGEN
USING
Other problems?
Write..
Regards,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Matt Williams" <[EMAIL PROTECTED]>
To: "Php-Db@Lists. Php." <[EMAIL PROTECTED]>
Sent: Friday, November 16, 2001
Ooops
SELECT count(f.room),WEEK(MAX(b.date),1), WEEK(MIN(b.date),1) FROM freerooms as f LEFT
JOIN booking AS b USING(room);
Apolgizes
- Original Message -
From: "Andrey Hristov" <[EMAIL PROTECTED]>
To: "Matt Williams" <[EMAIL PROTECTED]>
Cc: <[EMAIL
"blablaba...".
--
Andrey Hristov
Web Developer
Icygen Corporation
BUILDING SOLUTIONS
http://www.icygen.com
-=-=-=--==--==--=-=-=-=-=-=-=-=-=-==--=-=-=-=-==--=-=
Hello-
I've always had this type of mail statement work for me:
mail($to, $Subject, $Body, "From: $From\r\nCo
3.23.29 is a interesting version. I'm not sure whether from .29 or from .30 in mysql
had been made big changes.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "John Steele" <[EMAIL PROTECTED]>
To: "
- Original Message -
From: "Matthew Tedder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 1:50 AM
Subject: [PHP-DB] Execution of non-PHP code from within PHP
>
> Using PHP, how can I spawn a process and execute non-PHP code
> off the console?
>
> --Matt
Yes, it is.
the return value of fopen is a resource of type file.
var_dump($data); will show that
if you want to read the data use : fread($data,$buf);
but I think its better with file() function. The example from the docs show a better
method:
Regards,
Andrey Hristov
IcyGEN Corporation
http
drive where PHP resides(create it). Check for
that.
Best regards,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Kevin Ruiz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 4:
('kunden/zip/'.$name.'.gz', "w");
fwrite($fp, $gzdata);
fclose($fp);
// this is ok
Regards,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Keith Whyman" <[EMAIL PROTECTED]>
To: "Andre
When you use "" the parser scans the string for variables. When ' is used it is not
parsed. So you know what $variable to put,
concatenate the strings with the variable(s). I think it's a faster method. IMO, yes
it seems ugly, but I want to be faster not so
readable as a nov
to remove .png from the filename.
Regards,
Andrey
- Original Message -----
From: "Keith Whyman" <[EMAIL PROTECTED]>
To: "Andrey Hristov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 5:30 PM
Subject: Re: [PHP-DB] gzip image files
> h
,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "Rosen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 5:34 PM
Subject: [PHP-DB] Problem with SQL query on several tables
> Hi,
&g
Try
header('Content-type: image/gif');
Regards,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "PaulC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 10:28 AM
Subject
excuses,
image/jpeg
- Original Message -
From: "PaulC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 10:28 AM
Subject: Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible?
> I am using this to read the uploaded file
>
> $attach_data =
> addslashes(fr
$sql = '..'.($var? $var:'NULL').'.;';
Regards,
Andrey
- Original Message -
From: "Silvia Mahiques" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 11:37 AM
Subject: [PHP-DB] set NULL vaules in Access DB
>
> Hello,
> I have some problems to put Null
of mysql.
Regards,
Andrey Hristov
- Original Message -
From: "Martin E. Koss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 12:09 PM
Subject: [PHP-DB] JOIN Very SLOW...
> The following does work but it extremely slow.
>
> $phse
echo "\r\n";
while($row = mysql_fetch_assoc($result)) { // if assoc is not available - will work
but double results
foreach($row as $key => $value){
echo "$key$value\r\n";
}
}//end loop
echo "\r\n";
HTH
Regards,
Andrey Hristov
IcyGEN
t;displayorder");
> while($forum = $db->fetch_array($query)) {
> $forumlist .= forum($forum, "index_forum");
> }
> }
> }else {
> $forumlist .= forum($group, "index_forum");
> }
> }
> Reg
1)find php_mysql.so
2)edit php.ini
uncomment
extension=php_mysql.so
3)restart apache (/usr/local/apache/bin/apachectl stop
/usr/local/apache/bin/apachectl start)
HTH
Regards,
Andrey Hristov
- Original Message -
From: "Karthikeyan" <[EMAIL PROTECTED]>
To: <[EMA
you can use REGEXP instead of like.
Regards,
Andrey Hristov
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 5:40 AM
Subject: [PHP-DB] Replace like
> Can anyone tell me how would i replace the followi
find the section where error_reporting is set in php.ini and set i to 0
This is not an error but an warning (E_WARNING).
Regards,
Andrey Hristov
- Original Message -
From: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 11:
anges
HTH
Regards,
Andrey Hristov
- Original Message -
From: "Nagasea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 23, 2001 4:56 PM
Subject: [PHP-DB] Change value in the table
> I want to change all the text XXX to YYY in the posts_text ta
Mysql has support for indexes on two or more fields. So you can create index on
country_code AND province.
At the moment I cannot remember the syntax but look at the docs www.mysql.com/doc/ to
find it.
HTH
Regards,
Andrey Hristov
- Original Message -
From: "Andy" <[EM
Try printing before and after them
Regards,
Andrey Hristov
- Original Message -
From: "Barry Rumsey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 2:19 PM
Subject: [PHP-DB] Formated Results
Hi
I have a database that has lyrics in
Old modules (compiled for php 4.0.x) are not binary compatible with 4.1.x series.
To compile oci8.so you need an oracle installation. More info on oracle from Thies
Arntzen.
I'm not sure but
./configure --enable-mysql && make
will produce the .so
Regards,
Andrey Hristov
- Ori
try this :
select password, 1 as auth from acl where (username='andrewd' and
password=MD5("andrewd.madonna"));
- Original Message -
From: "Necro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 6:18 PM
Subject: RE: [PHP-DB] MySQL Result Resource
> Same err
, 2002 6:29 PM
Subject: RE: [PHP-DB] MySQL Result Resource
> Parse error: parse error in d:\htdocs\infekt\packages\auth.inc on line 104
>
> $arg = "select password, 1 as auth from acl where (username='andrewd' and
> password=MD5("andrewd.madonna"))";
>
AFAIK he uses *nix, not windows.
(.so-s are possible sollution but prebuilt ones are not shipped with php).
Andrey
- Original Message -
From: "xxx " <[EMAIL PROTECTED]>
To: "Anthony Carlos" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 4:32 PM
Subject: Re:
ndrey
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; "xxx " <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 4:37 PM
Subject: R
Compile with --with-oci8
Andrey
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 4:56 PM
Subject: RE: [PHP-DB] Oracle
Hey,
A friend of mine told me that :
kalo 19:02: trjanbva ti
tnsping vdb.masq
kalo 19:02: uf.. ne znam kak ce nastrojva tnslistaner-a..;(
kalo 19:03: ima si programa s kojato se pipat nastraojkite na TNSListener-a
kalo 19:03: ina4e ne mozesh ada se zaka4ish..
Translared to english :
19:02
Hi,
Does mysql user has rights to write in this directory or permissions over
this file?
Andrey
- Original Message -
From: "conbud" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 11:00 AM
Subject: [PHP-DB] MySQL Database connection Problem
> Hello can some
http://www.alt-php-faq.org/local/74/
Question :
I am trying to create a database and keep getting an error :- (Errcode: 28)
Answer :
errcode: 28
No space left on device
This means that you are out of disk space.
Try du to see how much space is free/used
Best regards
Andrey Hristov
lready and theres over 80 gig left on the
> server and about 17 gig of that is still alloted to the database.
>
> "Andrey Hristov" <[EMAIL PROTECTED]> wrote in message
> 010c01c2b309$8d8d7210$1601a8c0@andreywin">news:010c01c2b309$8d8d7210$1601a8c0@andreywin...
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 '
Fernando,
try to store you data in unicode (utf8) for example.
You iconv to transform if it is needed.
Andrey
- Original Message -
From: "Bernain, Fernando G." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 7:25 PM
Subject: [PHP-DB] Special characters
> I'
sion
is good to transform you iso-8859-1 strings to utf8. after retrieving from
db just converted them fron unicode.
Regards,
Andrey
- Original Message -
From: "Bernain, Fernando G." <[EMAIL PROTECTED]>
To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; &quo
Keep in mind that BLOB is up to 64k thus you may need larger BLOB.
Look at the mysql's documenations for more information
http://www.mysql.com/doc/en/
Andrey
P.S.
Have a nice night.
- Original Message -
From: "Natividad Castro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
1 - 100 of 102 matches
Mail list logo