Re: [PHP-WIN] ORDER BY is not sorting
What kind of field is the keyID? is it int, char, varchar? - Aleksander Mark Abrams wrote: Is mysql_fetch_array the proper function to access sorted data?The problem is consistent on my test server and my ISPs mySQL DB. rowID is the primary key. Do I need to have an index attribute on a field I want to sort? <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I can't really see anything wrong with what you have there. It shouldn't matter that your SQL is inside the query function, although I like to build the query in a variable outside the query function, but either way it should work. And you're obviously getting data and not an error, right? What happens if you leave the "DESC" off? Does it come back 4, 3, 2, 1? or still 1, 2, 3, 4? You might try displaying more data from the result set to see if there's some other issue. And have you tested the SQL statement just using MySQL via command line, phpMyAdmin, WinSQL, Navicat, or something like that? -TG = = = Original message = = = Sorry, this seams very trivial but I can not sort the result set for any field. What am I doing wrong? php & mySQL 5 ' ?> 1 2 3 4 TIA Mark -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] Re: Small Help
Sorry I don't understand what your request is about? - Aleksander Gustav Wiberg wrote: Hi! If you need help in programming an application from scratch this might not be the list for you :-) Best regards /Gustav Wiberg -Original Message- From: Stephen [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 4:41 AM To: php-windows@lists.php.net Subject: [PHP-WIN] Re: Small Help also when the user registers. is there a peice of code that will let me send myself and e-mail informing me? ""Stephen"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I'm kind of trying to do this quickly. Can anyone give me some PHP code that will let me link to a different image if $veriable = blah blah blah. I need it for 4 different options. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] ORDER BY is not sorting
Gustav Wiberg wrote:
Hi!
I can't see anything with your code either. Mysql_fetch_array should work fine
yes. No indexes are needed to sort fields, but are recommended for speeding up
the process :-)
How does the table users look like? (Please send a link to a screenshot or
something like that)
Sometimes I have noticed that PHP isn't that good of getting right results when using
$variable inside ""-chars
what do you mean by that??? You mean PHP is having trouble getting
'right results' from a mysql database if _somewhere_ in the code there's
an interpolated string? Sounds a bit iffy to me...
- Tul
You could try doing this:
$table_name ='users';
// Select records
$result = mysql_query("SELECT * FROM " . $table_name . " ORDER BY rowID
DESC");
// Loop through the record set
while($row = mysql_fetch_array($result))
print 'rowID =' .$row['rowID']. ''
There might be some issues regarding permissons of MySQL. Have you tried doing
another sql-select statement on another table?
Best regards
/Gustav Wiberg
-Original Message-
From: Mark Abrams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 01, 2007 12:50 AM
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] ORDER BY is not sorting
Is mysql_fetch_array the proper function to access sorted data?The
problem is consistent on my test server and my ISPs mySQL DB.
rowID is the primary key. Do I need to have an index attribute on a field I
want to sort?
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
I can't really see anything wrong with what you have there. It shouldn't
matter that your SQL is inside the query function, although I like to build
the query in a variable outside the query function, but either way it
should work.
And you're obviously getting data and not an error, right?
What happens if you leave the "DESC" off? Does it come back 4, 3, 2, 1?
or still 1, 2, 3, 4?
You might try displaying more data from the result set to see if there's
some other issue.
And have you tested the SQL statement just using MySQL via command line,
phpMyAdmin, WinSQL, Navicat, or something like that?
-TG
= = = Original message = = =
Sorry, this seams very trivial but I can not sort the result set for any
field. What am I doing wrong?
php & mySQL 5
'
?>
1
2
3
4
TIA
Mark
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-WIN] ORDER BY is not sorting
Just one thought :
The code itself, as shown, looks good, but is PHP getting what WE see ?
Meaning, try to
1) set a string with the SQL query you want
2) check the string before applying it
Maybe, just maybe, you are getting a broken string, and the "order" part is
missing, thus not being applied...
Luis
-Original Message-
From: M. Sokolewicz [mailto:[EMAIL PROTECTED]
Sent: quarta-feira, 1 de Agosto de 2007 11:24
To: Gustav Wiberg
Cc: 'Mark Abrams'; 'php-windows@lists.php.net'
Subject: Re: [PHP-WIN] ORDER BY is not sorting
Gustav Wiberg wrote:
> Hi!
>
> I can't see anything with your code either. Mysql_fetch_array should work
fine yes. No indexes are needed to sort fields, but are recommended for
speeding up the process :-)
>
> How does the table users look like? (Please send a link to a screenshot or
something like that)
>
> Sometimes I have noticed that PHP isn't that good of getting right results
when using $variable inside ""-chars
what do you mean by that??? You mean PHP is having trouble getting
'right results' from a mysql database if _somewhere_ in the code there's
an interpolated string? Sounds a bit iffy to me...
- Tul
>
>
> You could try doing this:
>
>$table_name ='users';
>
> // Select records
> $result = mysql_query("SELECT * FROM " . $table_name . " ORDER BY
rowID DESC");
>
>
> // Loop through the record set
> while($row = mysql_fetch_array($result))
> print 'rowID =' .$row['rowID']. ''
>
>
> There might be some issues regarding permissons of MySQL. Have you tried
doing another sql-select statement on another table?
>
> Best regards
> /Gustav Wiberg
>
>
>
>
> -Original Message-
> From: Mark Abrams [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 01, 2007 12:50 AM
> To: php-windows@lists.php.net
> Subject: Re: [PHP-WIN] ORDER BY is not sorting
>
> Is mysql_fetch_array the proper function to access sorted data?The
> problem is consistent on my test server and my ISPs mySQL DB.
>
> rowID is the primary key. Do I need to have an index attribute on a field
I
> want to sort?
>
>
>
>
> <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>> I can't really see anything wrong with what you have there. It shouldn't
>> matter that your SQL is inside the query function, although I like to
build
>> the query in a variable outside the query function, but either way it
>> should work.
>>
>> And you're obviously getting data and not an error, right?
>>
>> What happens if you leave the "DESC" off? Does it come back 4, 3, 2, 1?
>> or still 1, 2, 3, 4?
>>
>> You might try displaying more data from the result set to see if there's
>> some other issue.
>>
>> And have you tested the SQL statement just using MySQL via command line,
>> phpMyAdmin, WinSQL, Navicat, or something like that?
>>
>> -TG
>>
>> = = = Original message = = =
>>
>> Sorry, this seams very trivial but I can not sort the result set for any
>> field. What am I doing wrong?
>>
>>
>> php & mySQL 5
>>
>>
>> >
>> ...
>>
>> $table_name ='users';
>>
>>// Select records
>>$result = mysql_query("SELECT * FROM $table_name ORDER BY rowID
DESC");
>>
>>
>>// Loop through the record set
>>while($row = mysql_fetch_array($result))
>> print 'rowID =' .$row['rowID']. ''
>>
>>
>> ?>
>>
>> 1
>> 2
>> 3
>> 4
>>
>>
>> TIA
>> Mark
>>
>> --
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>> ___
>> Sent by ePrompter, the premier email notification software.
>> Free download at http://www.ePrompter.com.
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-WIN] Re: Small Help
Stephen, Generally speaking this list isn't for people to write code for you, but this is a very simple thing to do. For emailing, check the mail() function on php.net documentation. You will need to make sure your SMTP server is properly configured. For changing an image with 4 different options, I don't really know how you want it called, but you could call it in the query string. For example: And your url would be http://www.someurl.com/picture.php?imagenumber=4 I think that is what you wanted. Tom -Original Message- From: Aleksandar Vojnovic [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 5:22 AM To: Gustav Wiberg Cc: 'Stephen'; 'php-windows@lists.php.net' Subject: Re: [PHP-WIN] Re: Small Help Sorry I don't understand what your request is about? - Aleksander Gustav Wiberg wrote: > Hi! > > If you need help in programming an application from scratch this might not be the list for you :-) > > Best regards > /Gustav Wiberg > > > -Original Message- > From: Stephen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 01, 2007 4:41 AM > To: php-windows@lists.php.net > Subject: [PHP-WIN] Re: Small Help > > also when the user registers. is there a peice of code that will let me send > myself and e-mail informing me? > ""Stephen"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > >> I'm kind of trying to do this quickly. Can anyone give me some PHP code >> that will let me link to a different image if $veriable = blah blah blah. >> I need it for 4 different options. >> > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.0/927 - Release Date: 7/30/2007 5:02 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.0/927 - Release Date: 7/30/2007 5:02 PM -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-WIN] Solved - Re: [PHP-WIN] ORDER BY is not sorting
Mark,
I have another suggestion for you to try, you can use this while
using post variables, and class-access variables.
$result = mysql_query("SELECT * FROM {$table_name} ORDER BY rowID
DESC");
This is doing the exact same thing as your previous statement, but
it allows you to remove the parenthesis and you can also do nifty things
like
{$_myclass->getuserid()} without having to escape it with parenthesis.
Another thing to check, do you have register_globals set to on?
Your PHP may be requiring you to access $table_name as $_GET["table_name"]
or $_POST["table_name"]?
Cheers,
Tom Hearn
Software Engineer
N Software
http://www.nsoftware.com
-Original Message-
From: Mark Abrams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 01, 2007 9:59 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] Solved - Re: [PHP-WIN] ORDER BY is not sorting
Thank you all. Problem solved.
Gustav, I followed your recomendation and changed the table name var to the
actual table name and my problem is solved. Perpaps something is lost in the
interperter when PHP passes the code.
It has been this group that helps make working with PHP fun.
"Gustav Wiberg" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi!
I can't see anything with your code either. Mysql_fetch_array should work
fine yes. No indexes are needed to sort fields, but are recommended for
speeding up the process :-)
How does the table users look like? (Please send a link to a screenshot or
something like that)
Sometimes I have noticed that PHP isn't that good of getting right results
when using $variable inside ""-chars
You could try doing this:
$table_name ='users';
// Select records
$result = mysql_query("SELECT * FROM " . $table_name . " ORDER BY rowID
DESC");
// Loop through the record set
while($row = mysql_fetch_array($result))
print 'rowID =' .$row['rowID']. ''
There might be some issues regarding permissons of MySQL. Have you tried
doing another sql-select statement on another table?
Best regards
/Gustav Wiberg
-Original Message-
From: Mark Abrams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 01, 2007 12:50 AM
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] ORDER BY is not sorting
Is mysql_fetch_array the proper function to access sorted data?The
problem is consistent on my test server and my ISPs mySQL DB.
rowID is the primary key. Do I need to have an index attribute on a field I
want to sort?
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I can't really see anything wrong with what you have there. It shouldn't
>matter that your SQL is inside the query function, although I like to build
>the query in a variable outside the query function, but either way it
>should work.
>
> And you're obviously getting data and not an error, right?
>
> What happens if you leave the "DESC" off? Does it come back 4, 3, 2, 1?
> or still 1, 2, 3, 4?
>
> You might try displaying more data from the result set to see if there's
> some other issue.
>
> And have you tested the SQL statement just using MySQL via command line,
> phpMyAdmin, WinSQL, Navicat, or something like that?
>
> -TG
>
> = = = Original message = = =
>
> Sorry, this seams very trivial but I can not sort the result set for any
> field. What am I doing wrong?
>
>
> php & mySQL 5
>
>
>
> ...
>
> $table_name ='users';
>
>// Select records
>$result = mysql_query("SELECT * FROM $table_name ORDER BY rowID DESC");
>
>
>// Loop through the record set
>while($row = mysql_fetch_array($result))
> print 'rowID =' .$row['rowID']. ''
>
>
> ?>
>
> 1
> 2
> 3
> 4
>
>
> TIA
> Mark
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> ___
> Sent by ePrompter, the premier email notification software.
> Free download at http://www.ePrompter.com.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.11.0/927 - Release Date: 2007-07-30
17:02
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.11.0/929 - Release Date: 7/31/2007
5:26 PM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.11.0/929 - Release Date: 7/31/2007
5:26 PM
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] Cacti x Post
Hi there! Does anybody knows how can I install CACTI with PostgreSQL database? It works? Do you know if it recognizes switch, hub or acess points? Hugs! Vitor -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] Cacti x Post
Vitor Mendes wrote: Does anybody knows how can I install CACTI with PostgreSQL database? It works? Do you know if it recognizes switch, hub or acess points? You'll have better luck asking the people who develop Cacti - I'm sure they have their own mailing list. -Stut -- http://stut.net/ -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] Re: Cacti x Post
Yeap, they have their own mail lists... sorry... but Cacti is wrotten in PHP, so... Vitor -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-WIN] Cacti x Post
I have used Cacti for a about 6 months now, and as far as I know, is only meant to work with MySQL. I have never heard of anyone using it with PostgreSQL. Never ran across that in the forums. If you would like to know, just join the cacti forums at http://forums.cacti.net/ Jacob Bergman Network Technician Pullman School District #267 (509) 432-4012 [EMAIL PROTECTED] -Original Message- From: Vitor Mendes [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 7:05 AM To: php-windows@lists.php.net Subject: [PHP-WIN] Cacti x Post Hi there! Does anybody knows how can I install CACTI with PostgreSQL database? It works? Do you know if it recognizes switch, hub or acess points? Hugs! Vitor -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] Solved - Re: [PHP-WIN] ORDER BY is not sorting
Thank you all. Problem solved.
Gustav, I followed your recomendation and changed the table name var to the
actual table name and my problem is solved. Perpaps something is lost in the
interperter when PHP passes the code.
It has been this group that helps make working with PHP fun.
"Gustav Wiberg" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi!
I can't see anything with your code either. Mysql_fetch_array should work
fine yes. No indexes are needed to sort fields, but are recommended for
speeding up the process :-)
How does the table users look like? (Please send a link to a screenshot or
something like that)
Sometimes I have noticed that PHP isn't that good of getting right results
when using $variable inside ""-chars
You could try doing this:
$table_name ='users';
// Select records
$result = mysql_query("SELECT * FROM " . $table_name . " ORDER BY rowID
DESC");
// Loop through the record set
while($row = mysql_fetch_array($result))
print 'rowID =' .$row['rowID']. ''
There might be some issues regarding permissons of MySQL. Have you tried
doing another sql-select statement on another table?
Best regards
/Gustav Wiberg
-Original Message-
From: Mark Abrams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 01, 2007 12:50 AM
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] ORDER BY is not sorting
Is mysql_fetch_array the proper function to access sorted data?The
problem is consistent on my test server and my ISPs mySQL DB.
rowID is the primary key. Do I need to have an index attribute on a field I
want to sort?
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I can't really see anything wrong with what you have there. It shouldn't
>matter that your SQL is inside the query function, although I like to build
>the query in a variable outside the query function, but either way it
>should work.
>
> And you're obviously getting data and not an error, right?
>
> What happens if you leave the "DESC" off? Does it come back 4, 3, 2, 1?
> or still 1, 2, 3, 4?
>
> You might try displaying more data from the result set to see if there's
> some other issue.
>
> And have you tested the SQL statement just using MySQL via command line,
> phpMyAdmin, WinSQL, Navicat, or something like that?
>
> -TG
>
> = = = Original message = = =
>
> Sorry, this seams very trivial but I can not sort the result set for any
> field. What am I doing wrong?
>
>
> php & mySQL 5
>
>
>
> ...
>
> $table_name ='users';
>
>// Select records
>$result = mysql_query("SELECT * FROM $table_name ORDER BY rowID DESC");
>
>
>// Loop through the record set
>while($row = mysql_fetch_array($result))
> print 'rowID =' .$row['rowID']. ''
>
>
> ?>
>
> 1
> 2
> 3
> 4
>
>
> TIA
> Mark
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> ___
> Sent by ePrompter, the premier email notification software.
> Free download at http://www.ePrompter.com.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.11.0/927 - Release Date: 2007-07-30
17:02
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] Code sample - Small Help
if (var) {$path='/image/a.jpg';}else{$path='/image/b.jpg';}
?>
>
""Stephen"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm kind of trying to do this quickly. Can anyone give me some PHP code
> that will let me link to a different image if $veriable = blah blah blah.
> I need it for 4 different options.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] Code sample - Small Help
$path = '';
even shorter :)
- Aleksander
Mark Abrams wrote:
if (var) {$path='/image/a.jpg';}else{$path='/image/b.jpg';}
?>
>
""Stephen"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
I'm kind of trying to do this quickly. Can anyone give me some PHP code
that will let me link to a different image if $veriable = blah blah blah.
I need it for 4 different options.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-WIN] Template
Can you explain what you mean by "template"? That can mean so many things. Bill -Original Message- From: Cédric Joubert [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 1:41 PM To: php-windows@lists.php.net Subject: [PHP-WIN] Template hi, wich template do you use for a little php application ? Cedric -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] Template
hi, wich template do you use for a little php application ? Cedric -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] Template
Cédric Joubert wrote: wich template do you use for a little php application ? Template? What exactly do you mean by that? -Stut -- http://stut.net/ -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] Template
Template? As in html templates that are used in combination with PHP to generate a page? - Aleksander Quoting Stut <[EMAIL PROTECTED]>: Cédric Joubert wrote: wich template do you use for a little php application ? Template? What exactly do you mean by that? -Stut -- http://stut.net/ -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
