If you want to generalize the process to a n-set, a recursion method is
clearly required.
XSLT looks the best candidate to me to do this. I will tackle it when I find
some time.
Cheers
Ignatius
- Original Message -
From: Xepherys [EMAIL
Using mysql, how do I access the data of the next row using code
something like this:
$result = mysql_query(select column from table where whatever='whatever');
while($array = mysql_fetch_array($result)){
//Whatever
}
--
The above message is encrypted with double rot13 encoding. Any
Using mysql, how do I access the data of the next row using code
something like this:
$result = mysql_query(select column from table where
whatever='whatever');
while($array = mysql_fetch_array($result)){
//Whatever
}
Each iteration of the while loop will fetch a row for you and it's
if you want to access stuff from row 3 while being in row 2.. you first have
to put it all into an array.. and then you coul do that.. but i can't comup
with something where you need something like that.. a strange idea...?
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL
No. Try putting everything into an array and then working with that
array afterwards.
While($row = mysql_fetch_array($result))
{ $a[] = $row['column']; }
Then work with $a, which will have all the values.
---John Holmes...
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL
Create an array and go through the array as needed.
Here is some code from one of my db functions:
$DB_RESULT = mysql_query($sql) or die(Error executing query: .
mysql_error());
// create an empty array to fill with data
$arrData = array();
$rowCount = 0;
I just did something similar where I had a left join
that returns several rows for each record. So to make
sure that each record is outputted once and contains
the correct 'categories' at the end of the while i
store the current $id as $prev_id. This way I can
check to see if we're working on the
Hi friends
I have big problem
I connect to mssql server
I connected succesful
but i select_db
samples code is here
$hostname = 192.168.100.4;
$username = sa;
$password = ;
$dbName =WIN-PAK 2;
MSSQL_CONNECT($hostname,$username,$password) or DIE(DATABASE FAILED TO
RESPOND.);
Also, if you're not sure how to get the values from $arrThisRow /
$arrNextRow:
echo $arrThisRow['columnName'];
or $arrData[$i]['columnName'] if you want to access it manually without
the other two arrays
adam
On Monday, October 14, 2002, at 06:05 PM, Adam Royle wrote:
Create an array and
On Sunday 13 October 2002 20:41, Rosen wrote:
Hi,
I just installed MySQL server on WIndows 98 and when server starts the
window with mysqld-opt opens and stop responding. And server didn't
start. Any ideas for this?
Try asking on the mysql lists?
--
Jason Wong - Gremlins Associates -
Good morning all.
I am attempting to create a table in which there is a title cell populated
with a training wave number and then I would like to echo all members of
each training wave below the title cell (See example below for
clarification). All seems to be working with one exception. The
It seems to me that the first time you go through the loop, if
$record-wave_num is != $prior_wave then you print the wave number but
not the person's name--but you already have a record there with a
person's name!
Try taking out the else statement--if you follow the code from there you
should be
Thanks Marco!
It's working now. Based on your suggestion, here is waht I came up with.
It's working now.
Randy
SNIP
table width=375 cellpadding=0 cellspacing=0 border=0
tr
td colspan=2 height=10?php echo FILLER; ?/td
I was wondering about people's thoughts on file security through php
using database authentication.
Take the following example:
I have a folder (in webroot) called /videos/ which contains a heap of
files like so:
video_1_14-06-2002.mpg
video_2_15-06-2002.mpg
video_3_16-06-2002.mpg
How about using PHP as a pipe to funnel the MPG files through:
?
// Place your security logic here and exit if
// auth is not successful
// $filename is the path of the file
// to server
header (Content Type:video/mpeg);
readfile ($filename);
?
Ok, so I've got a simple upload script... User uses form to select a file,
the file is then uploaded to a dir on the web server, and a link is
provided for the user to view the file.
Of course when the user uploads my pic.jpg the resulting link is broken
(because of the space)... so I want to
Op maandag 14 oktober 2002 15:41, schreef Michael Knauf/Niles:
(because of the space)... so I want to replace any occurrence of with
_
$filename=str_replace(' ','_',$filename);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I get the following error:
Fatal error: Call to undefined function: mysql_connect()
on php 4.1.2.
It *has* been compiled with-mysql...here is a snippet from phpinfo()
'--with-kerberos=/usr/kerberos' '--with-ldap=shared'
'--with-mysql=shared,/usr'
Any ideas why I am getting the error?
does the mysql section show up in phpinfo() ? is [shared] allowed in that
configure argument?
|-|
| Jeff | KeaneIT - Presidents Landing |
| | Suite: 200|
| Outside: 617 -517-1772 | E-mail: |
| [EMAIL PROTECTED]
The only other place it shows up is in the dbx section
DBX
dbx support enabled
dbx version 1.0.0
supported databases MySQLbr /ODBCbr /PostgreSQLbr /Microsoft SQL
Serverbr /FrontBase
There isn't a 'mysql' section.
I am not sure if [shared] is allowed, it should be
When if have the keyword 'msq' i can match the field 'mysqldata'
SELECT * FROM table WHERE field LIKE $keyword%
But how do i get a match when the keyword is 'mysqldatabase' and the
field
'mysql'? (TRUE cause keyword contains 'mysql').
That'll never work unless you know where to divide up
Store the files outside of your web root or in an .htaccess protected
directory. You don't have to control an .htaccess password list, just
let PHP handle the sending of the file.
Validate your user and whether they should be looking at the file they
requested, then use header() to send the
I think this is how it works.if you're using dbx then you need to
connect using dbx_connect and not mysql_connect
and i don't think that [shared] is a valid argument.
I only connect to mysql and M$Sql so i have configured to connect to those
specifiacally.
I would reconfigure using
i'd get rid of the space as well, or use brackets around the db name to
account for the space.
John W. Holmes
sorry i mis spoke, the brackets will help you in queries with tables and
columns that have spaces, not in the connect with actual dbs(at least i
don't think so).
- Forwarded by Jeffrey N Dyke/CORP/Keane on 10/14/2002 11:40 AM -
what are you passing for module(the first argument for dbx_connect) it
should be DBX_MYSQL, or mysql, if that fails, recompile without the shared
argument, and i bet that would work
I am using mysq. I tried to re-install using rpm, but didn't work. Will
need to recompile. However, now, I am getting Mysql not loaded. My feeling
is that there must be a simple way to load this module, just don't know how
:-(
If anyone does, please let me know, else I will recompile.
Thanks for
Ok, next question:
Here's my upload script:
?
if ($upfile1==none)
{
echo no file selected for upload please go back and select a
file.;
exit;
}
if ($upfile1_size==0)
{
echo No data was transferred, your file may be too large or
Well, you can use the break statement to exit a loop or code block, but
wouldn't you rather want to create a single loop that can handle any
number of files?
On Mon, 2002-10-14 at 13:54, Michael Knauf/Niles wrote:
Ok, next question:
Here's my upload script:
?
if
How about
select * from table where birthday between now() and date_add(now(),
interval 15 day);
Assuming, of course, you're using MySQL.
Cheers,
Marco
On Mon, 2002-10-14 at 16:20, Steve Vernon wrote:
Hiya,
Just wondering what is the best way to do this please.
I have
Yeh but that does not take into account years does it? My table has there
birth year, wont that mess it up and not work? I assume I need to do a
function only on the months and days??
Thanks!
Steve
XX
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Bhavin Vyas [EMAIL PROTECTED] wrote:
I am using mysq. I tried to re-install using rpm, but didn't work. Will
need to recompile. However, now, I am getting Mysql not loaded. My feeling
is that there must be a simple way to load this module, just don't know how
:-(
You have to use
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
How about
select * from table where birthday between now() and date_add(now(),
interval 15 day);
Assuming, of course, you're using MySQL.
Cheers,
Marco
On Mon, 2002-10-14 at 16:20, Steve Vernon wrote:
Hiya,
Just
There has to be a better way than this, but this is what I came up with
before dinner...
$dayofyear = date(z);
$daysinyear = (date(L))?366:365;
$numover = ($dayofyear + 14) - $daysinyear
if($numover 0)
{
$sql = DAYOFYEAR(dob) $numover AND ;
$twoweeks = $daysinyear;
}
else
{
I have a PHP MIME class that works supurblymy big question is...
Is there a way to convert the subject line to simplified chinese. The
body of the email is fine but I havent been able to get the subject line
to display chinese.
Any hints, tips or advice would be great.
Regards,
Nigel
John W. Holmes [EMAIL PROTECTED] wrote:
There has to be a better way than this, but this is what I came up with
before dinner...
$dayofyear = date(z);
$daysinyear = (date(L))?366:365;
$numover = ($dayofyear + 14) - $daysinyear
if($numover 0)
{
$sql = DAYOFYEAR(dob) $numover
I have a problem using barcodes. They are variable in length (up to 13
integers). I had to add them to the tables a strings (varchar(13)) to
preserve the leading zeros that are not uncommon. The problem comes
with inserting these barcodes into other tables (passing them using
href). When
Hello,
On 10/14/2002 09:34 PM, Nigel Dunn wrote:
I have a PHP MIME class that works supurblymy big question is...
Is there a way to convert the subject line to simplified chinese. The
body of the email is fine but I havent been able to get the subject line
to display chinese.
I
Hello,
On 10/14/2002 09:34 PM, Nigel Dunn wrote:
I have a PHP MIME class that works supurblymy big question is...
Is there a way to convert the subject line to simplified chinese. The
body of the email is fine but I havent been able to get the subject
line to display chinese.
Reports of US annexing Iraq appears to be highly disturbing. The oil
reserves of Iraq appear to be the prime motive behind the US ambition of
ruling that country (without realising that even those reserves are
limited). Perhaps it would be more good if US could concentrate on research
to
CK,
This isn't really the forum for this is it?
| -Original Message-
| From: CK Raju [mailto:[EMAIL PROTECTED]]
| Sent: Tuesday, 15 October 2002 2:30 PM
| To: [EMAIL PROTECTED]
| Subject: [PHP-DB] Obsession for Oil
|
|
| Reports of US annexing Iraq appears to be highly disturbing. The
This isn't really the forum for this is it?
That was a response in my capacity as a human being, and we have seen similar
postings last year post WTC incidents. I believe, perhaps very foolishly,
that pre-emption is better than cure, and that someone influential hooked to
this list might give
42 matches
Mail list logo
