Hi Ben
Comments inline
On 31 Mar,2003 at 13:46 Benjamin Trépanier wrote:
> border="0">
>
>
> $i!=$id_news_
> $id= mysql_result($req,$i,"id");
> $titre = mysql_result($req,$i,"titre");
> $date = mysql_result($req,$i,"date");
> $heure = mysql_result($req,$i,"heu
Hi All
Has anyone upgraded from PHP Home Edition 2.2.3 (from sourceforge.net) to
version 2.2.8 ? and if so were there any issues?
Steve Dodkins
_
IMPORTANT NOTICE This email (including any attachments)
is meant only for the intended recipient. It may also contain confidenti
You can store the value in a session variable
session_start();
if (isset($_HTTP_SESSION_VARS['your_variable_name'])) {
$value=$_HTTP_SESSION_VARS['your_variable_name']; //get the value
}else{
$_HTTP_SESSION_VARS['your_variable_name']=new value;
}
You can use this script to pass values between pa
On Tuesday 01 April 2003 11:20, Keith Spiller wrote:
> Can anyone recommend a pure php solution for thumbnail image creation and
> photo gallery script? Everywhere I look the scripts require either GD,
> NetPBM
> or ImageMagick. Is it not possible to build an thumbnail app without these
> tools?
You can't perform update like this.
You should loop through rows you want to update if they have different key
values.
UPDATE tbl_ib_articles SET col_name=new_value WHERE key_column=key_value;
You can change the condition part, which can include non-key columns,
HTH,
Mustafa
- Original Me
What kind of data do you need to collect at each booking?
"Shaun" <[EMAIL PROTECTED]> escribió en el mensaje
news:[EMAIL PROTECTED]
> Hi,
>
> I am creating a database for a web application. The idea for the
application
> is for a company administrator to be able to log into the site and
allocate
>
Hello,
Can anyone recommend a pure php solution for thumbnail image creation and
photo gallery script? Everywhere I look the scripts require either GD,
NetPBM
or ImageMagick. Is it not possible to build an thumbnail app without these
tools?
Thank you for any help...
Larentium
--
PHP Databas
You could set a cookie containing the value on the first page and access it
on the others.
> -Original Message-
> From: Alexa Kirk [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 6:35 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: [PHP-DB] Sharing variable values am
Everything looks okay with this when I echo the sql string:
INSERT INTO tbl_ib_articles (issue_brief,article) VALUES
('24','30'),('24','20'),('24','31')
My question was, what do I need to change to make this an UPDATE?
Thanks,
Charles
On Monday, March 31, 2003, at 08:30 PM, [EMAIL PROTECTED] wr
Does anyone know how to take a variable containing POST data from a form
and use this value in another PHP file? I need to take a username from
one PHP file and use it in a couple of other PHP files later when adding
to a database.
Thank you,
Alexa Kirk
How would I modify the code below to handle an UPDATE?
On Sunday, March 30, 2003, at 07:19 PM, Charles Kline wrote:
then I built the INSERT like so:
foreach($article_keys as $articleid)
{
$insert[] = "('$v_ib_id','$articleid')";
}
$article_sql = "INSERT INTO tbl_ib_articles (issue_brief,article)
This is not so much a database question. The answer is yes, it can be. You
can read the documentation to find out how.
http://www.php.net/manual/en/function.mail.php
A quick example is:
$val){
$body .= "$key = $val\n";
}
mail ($address, "Form submission", $body);
?>
That is really ugl
Hey. I just figured it out! So simple too :)
$myarray = array();
foreach ($sth_opt as $thekey => $thevalue){
$myarray[$thevalue] = true;
}
On Monday, March 31, 2003, at 06:05 PM, Charles Kline wrote:
hi all, i am changing the title are reposting - i have a clearer idea
now of what i am t
Can this fucktion be use to mail the submited content of a form? If so how?
Thanks for your time,
Mike Delorme
mail() will not run queries, you need to look at the php manual for the set
of functions for the database type you plan on using and execute the
database stuff in your script and pass the formatted results in the
appropriate argument of the mail function.
ie
$con = mysql_connect($host, $user,$pw);
Hi,
I am trying to get PHP mail() to do the following:
1) Grab email addresses from a database and put in the
BCC of the email. (hidding their email address)
2) Grab first names from a database and put in the
body of the email.
Below is a script I am using, does not do any queries
to any databa
hi all, i am changing the title are reposting - i have a clearer idea
now of what i am trying to do...
what is the syntax to initialize an associative array with values
returned in a query where the key in the array is coming from the query
and the value is static value of true?
i want to crea
Hmm... that is not quite it. Here is a better example:
Here is how I would define default values for a checkbox in
HTML_QuickForm;
$defaultValues['ichkABC'] = array('A'=>true,'B'=>true);
$form->setDefaults($defaultValues);
The checkboxes are defined later like this:
$checkbox[] = &HTML_QuickF
>$mystring;
>foreach ($sth_opt as $thekey => $thevalue){
> $mystring .= "'".$thevalue."'=>true, ";
>}
>$defaultValues['ib_article'] = array($mystring);
Try this ...
foreach ($sth_opt as $thekey => $thevalue){
$defaultValues['ib_article'][$thevalue] = 'true';
}
I'm not sure if the
Dan,
It is more of a HTML-related question:
Need to change the table width in percentage (%) rather than just numbers.
HTH,
-rob
"Dan Liu" <[EMAIL PROTECTED]>
03/31/2003 01:17 PM
To: <<[EMAIL PROTECTED]>
cc:
Subject:[PHP-DB] print table truncated
Hi
Here is more details. Thanks for the reply.
I am using HTML_QuickForm (pear) to create my forms. In order to set
the default state of some of the elements (checkboxes in this case) I
need to pass an array as the value to QuickForm.
This array needs to be in the format of this:
array('30'=>true
Instead of building a string in your loop do the assignment in the loop
I have no idea what is being pulled from where, so I can't really give a
good example
-Original Message-
From: Charles Kline [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 1:25 PM
To: [EMAIL PROTECTED]
Subject:
I am trying to build an array from the results of a query on a mySQL
table.
I am using a loop to create this string in a variable $mystring:
'30'=>true, '20'=>true
I then need to use it like this:
$defaultValues['ib_article'] = array($mystring);
It isn't working. I am sure there is a better
Hi,
I havea question about printing.When the table in HTML page is too big and I print the
page,part of the table got truncated.Is there a way to print the web page without
truncation?
Thanks in advance.
Dan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.
>Maybe mssql_connect()??
>
>www.php.net/mssql_connect
The documentation indicates using sybase_connect (etc...) unless you
are on a windows machine.
But that doesn't work either as the sybase.so file seems to be
non-existant (on my machine anyway)
Regards
Greg Cirino
"John W. Holmes" <[EMAIL
Hi,
I am creating a database for a web application. The idea for the application
is for a company administrator to be able to log into the site and allocate
staff to a project.
Staff will be able to log in and update the status of the project they are
working on and clients will be able to log in
Yeah it worked, thank you very much. I just have one more question.
How much space does the data takes up if I set it to text. Because in
VarChar (which I had before) will change it's size depending how long the
chars is, will changing it to text cause the data to take up a large amount
of space
> -Original Message-
> From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 9:13 AM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] MSSQL/PHP problem
>
>
> [snip]
>
> WHen I retrieve this data from php to display on my webpage I
> get this:
>
> Globe and
Hello people,
First, sorry my english. I´m brazilian.
I´m have a problem when work with date in a Firebird "date" field. By
default, Firebird set up the date format as month/day/year. I need date in
day/month/year format. In a Linux, i just add to the php.ini the following
line:
ibase.dateformat =
Hi,
I'm trying to using a news script and improve somes with a query.
$req = MYSQL_QUERY("SELECT * FROM $TBL_NEWS");
$res = MYSQL_NUM_ROWS($req);
?>
I want that my script show the content of the rows corresponding to my
Variable called: Id_News_
So the variable is moving w
On Mon, 31 Mar 2003, Roger 'Rocky' Vetterberg wrote:
> [Snip]
>
>
> >>About the second suggestion, just pulling the data back out; I could
> >>do that, but the only thing that is unique in the string is the
> >>timestamp. Theoretically, on a busy site even that could be identical
> >>in two rows
[Snip]
About the second suggestion, just pulling the data back out; I could
do that, but the only thing that is unique in the string is the
timestamp. Theoretically, on a busy site even that could be identical
in two rows. (Since timestamp is in one millionth of a second, its not
very likely but
Nathaniel Price wrote:
- Original Message -
From: "Roger 'Rocky' Vetterberg" <[EMAIL PROTECTED]>
To: "kevin myers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 4:52 AM
Subject: Re: [PHP-DB] getting serial in PHP
*snip*
What I do, when I need to reference an ID fr
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
For any who may be interested:
I fixed the problem, noted below, myself. Evidently the Slackware
PHP/Apache binary is somewhat broken. It worked after I rebuilt PHP with
"configure --with-axps --with-pgsql"
Apache did not require a rebuild.
dwb
> -Original Message-
> From: Dave Brunb
Are there any scripts out there, in PHP or ASP, that give similar support
in Microsoft SQL Server (MSSQL) that phpMyAdmin gives for MySQL databases?
I have a client who is requiring me to code in ASP using MSSQL server, and
I'd like to have a web-based (preferably in PHP) admin tool for the server.
- Original Message -
From: "Roger 'Rocky' Vetterberg" <[EMAIL PROTECTED]>
To: "kevin myers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 4:52 AM
Subject: Re: [PHP-DB] getting serial in PHP
[snip]
> >> From: "Roger 'Rocky' Vetterberg" <[EMAIL PROTECTED]>
> >> To: [
Hi,
I have this problem retrieving data from a mssql table with PHP.
I have this in my mssql table column:
Globe and Mail data are retrieved and processed for CustomSearch.
On the R30, the crontab entry:
0 4 * * 1-6 /usr1/applic/ntgm/ntgm_get.pl
will run the Perl script at 4 a.m. everyday to
Check out mysql manual, section 6.3.4 - Date and Time Functions, example
$condition='';
if($GET['week']) $condition .= "WEEK(date)='$_GET[week]' AND ";
if($GET['year']) $condition .= "YEAR(date)='$_GET[week]' AND ";
and so on
then use the condition:
$sql = "SELECT * FROM news WHERE $condition 1";
Are you sure you give access to this user from the machine to the database
server? Check IP address permissions and if the user has access to the
specific table and/or database in MySQL. Also check to make sure the
database server is setup to allow you access from your machine.. check the
MySQL and
Hi people,
I would like to select news from my database bases on week/year and
month/year.
How can i do this.. I would like to pass two arguments in the query
string, like news.php?week=14&year=2003 or news.php?month=3&year=2003.
Can anybody help me.. Thanks in advance. I have been looking at the
Hi all
I'm new with php.
I need connect with my db in oracle7.3.3, and doing it:
But not work.
thank's and regards
kevin myers wrote:
well right after you insert it you can pull it right back out again, or
i think you can do :
$query = "insert into logs values
((nextval('public.logs_log_id_seq'::text) as
$log_id),$id,'$logtext','now','$_SERVER[PHP_AUTH_USER]');";
and then use it that way, or maybe you can do
43 matches
Mail list logo