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
unauthor
> 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 i
I know that, but what if I need to access data from the next row? If I
have 3 rows, is there a way to access something from row 3 while the
loop is in row 2, but still have the loop go to row 3 when it's done
with row 2?
John W. Holmes wrote:
>>Using mysql, how do I access the data of the ne
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 PROTECTED]]
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 PROTE
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.");
mssql_selec
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 firs
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
Training Wave:
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
video_4_17-
How about using PHP as a pipe to funnel the MPG files through:
This way you can place your MPG files completely outside the server root
and your users will have to go through your scripts in order to even get
to them. Even better, they won't be able to bookmark them because even
if they do they
Hi,
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').
Thanks,
Bas
--
PHP Database Mailing List (http://ww
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?
Thank
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 MySQLODBCPostgreSQLMicrosoft SQL
ServerFrontBase
There isn't a 'mysql' section.
I am not sure if [shared] is allowed, it should be considering that the
vers
> 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 divid
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 appr
Rename your database. Either PHP or MSSQL doesn't like the '-' in the
name.
---John Holmes...
> -Original Message-
> From: Kadir Leblebici [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 14, 2002 4:36 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] mssql select db problem
>
> Hi frien
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 -with-m
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 -
Thanks for the info. Now, I am getting the following error:
Warning: dbx: module '1' not loaded or not supported.
If any one has any ideas
Thanks,
Bhavin.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 11:29 AM
To: Vyas, Bhavin
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
Ok, next question:
Here's my upload script:
file $upfile1_name already
existsNote: Your file may have been renamed if it contained
spaces, this is so that links to the file will work correctly. If
you want to replace an existing file, Talk to Michael Knauf.";
exit;
}
if (!is_
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 ($upfile1=="
Hiya,
Just wondering what is the best way to do this please.
I have various birthdays stored as dates including birth years.
Just wondering is there a function, or an easy way to work out the birthdays in
the next two weeks say. Just be nice on my website to remind me of birthd
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 v
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: http://www.php.net
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
e
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:
> > H
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 Dunn
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
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 using
Sounds like it must be getting cast to a number somewhere along the track.
You probably have been here, but make sure that:
1. You are not performing any mathamatical calculations or comparisons on
them.
2. When putting then in the DB make sure the string of numbers is quoted.
Try var_dump($s
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 chi
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 h
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 o
> 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
47 matches
Mail list logo
