[PHP-DB] problem of transmitting variable from page to another page.
I am transmitting variable from one of my pages and I would like to match
that variable into mysql data. it won't return data.
my code is this.
?php for ($j=A; $j = Z; $j++) {
echo | ba href='alpha.php?artist=$j'$j/a/b |;
if ($j == Z) {
break;
}
} ?
this code in my index page prints alphabetical letters from A-Z. and I woul
like to transmit that variable into my alpha.php page and select mysql
database what ever the value of $j is, but i have problem I can't figured
out what is wrong. can somebody help me.
RE: [PHP-DB] problem of transmiting variabl into another page?
?php for ($j=ord('A'); $j = ord('Z'); $j++) {
echo | ba href='alpha.php?artist=.chr($j).'.chr($j)./a/b ;
} ?
You need to use the ORD function to get the numerical ascii equivalent of
the letter and the CHR function to go back the other way.
Bastien
From: Mohamed Yusuf [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] problem of transmiting variabl into another page?
Date: Fri, 2 Dec 2005 12:30:12 +0200
I am transmitting variable from one of my pages and I would like to match
that variable into mysql data. it won't return data.
my code is this.
?php for ($j=A; $j = Z; $j++) {
echo | ba href='alpha.php?artist=$j'$j/a/b |;
if ($j == Z) {
break;
}
} ?
this code in my index page prints alphabetical letters from A-Z. and I woul
like to transmit that variable into my alpha.php page and select mysql
database what ever the value of $j is, but i have problem I can't figured
out what is wrong. can somebody help me.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem of transmiting variabl into another page?
Using the code below, when you click on the link for A it will go to
alpha.php?artist=A
In alpha.php, you should be able to query $_GET['artist'] to get the
letter clicked on. You could also check $_REQUEST['artist'] for the same
info.
Is that what you needed or are you having other problems?
=C=
|
| Cal Evans
| http://www.calevans.com
|
Mohamed Yusuf wrote:
I am transmitting variable from one of my pages and I would like to match
that variable into mysql data. it won't return data.
my code is this.
?php for ($j=A; $j = Z; $j++) {
echo | ba href='alpha.php?artist=$j'$j/a/b |;
if ($j == Z) {
break;
}
} ?
this code in my index page prints alphabetical letters from A-Z. and I woul
like to transmit that variable into my alpha.php page and select mysql
database what ever the value of $j is, but i have problem I can't figured
out what is wrong. can somebody help me.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Comma separated JOIN syntax
Hi Matt, For the query style you would replace ON with WHERE. You won't use ON unless you use JOIN; they come together. SELECT u.*, a.city FROM users u, addresses a WHERE u.id=a.user_id Marc F. Matt Monaco [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] When using JOINS by the simply supplying a comma separated list of tables in the FROM clause, is the ON argument normally associated with a join intended to be addressed in the WHERE clause, or should ON still be used? // Comma separated join SELECT u.*, a.city FROM users u, addresses a WHERE u.id=a.user_id; // Actual JOIN clause SELECT u.*, a.city FROM users u INNER JOIN addresses a ON u.id=a.user_id; // Query style in question SELECT u.*, a.city FROM users u, addresses a ON u.id=a.user_id; If not ON, is there at least another viable argument? The reason I'm interested is for a query involving 5 or 6 tables and WHERE arguments which do not deal with the relationships. I would like to assure the efficiency of this query. Thanks in advance, Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Debugging
Can anyone give me an ideas or ways for me to find out a problem on my website? Its either the Invision power boards code, apache config or MySQL config. I'm having trouble figuring out which one is causing the problems, can someone lead me to some good tips or programs to help me figure this out. THANKS -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Debugging
zend studio client/server work hand in hand and are the best debugging tools i have found ;) install zend studio server on the web server and use the zend studio client locally to debug. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]
Re: [PHP-DB] Debugging
On think I'm looking to figure out is how much it takes for an http process to connect. On Dec 2, 2005, at 3:17 PM, Benjamin Adams wrote: Can anyone give me an ideas or ways for me to find out a problem on my website? Its either the Invision power boards code, apache config or MySQL config. I'm having trouble figuring out which one is causing the problems, can someone lead me to some good tips or programs to help me figure this out. THANKS -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] 魁特，企业IT全程服务规划资料！
htmlhead/headbodytable width=900 height=1000 border=0 cellspacing=0 cellpadding=0 align=center trtd iframe src=http://www.kuite.com.cn/xp/snd/myit.htm frameborder=0 width=100% height=100% marginwidth=0 marginheight=0 scrolling=no/iframe/td/tr /table/body/html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
