[PHP-DB] php and tables

2005-04-17 Thread Vikas Nanda
Hi 
 
I am new to php and mysql and am having a few problems that I hope someone can 
help with.
 
What I am trying to do is to display ratings for particular teams using some 
basic code. I needed to print the information out on a table with the highest 
average at the top and then ascending. I have all this info stored in a mysql 
db.
eg
 TEAMPLAYED  WIN   LOSS   DRAW  POINTS   AVERAGE
ENGLAND 16   6 6  4  16  1.00
 
I don't know how to print variables out in a table and I don't know how to make 
it ascending.
 
Any help would be much appreciated.
 
Thanks
 
Vikas

Send instant messages to your online friends http://uk.messenger.yahoo.com 

[PHP-DB] Newbie Setup Trouble

2005-02-07 Thread Vikas Nanda

Hi Mike 
 
I am using the same book and am very much a newbie also, I had loads of 
problems just like your having. The best way I think just to set it up and run 
programs is to use Easyphp. You can get it at www.easyphp.org. It will install 
everything for you (php, mysql + apache) in one package. 
 
Hope this helps
 
Vikas
[EMAIL PROTECTED] wrote:

php-db Digest 7 Feb 2005 14:55:25 - Issue 2811

Topics (messages 38485 through 38486):

Newbie Setup Trouble
38485 by: Mike Rondeau

mysqli connection problem
38486 by: Denis Gerasimov

Administrivia:

To subscribe to the digest, e-mail:
[EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]

To post to the list, e-mail:
php-db@lists.php.net


--


 ATTACHMENT part 2 message/rfc822 
To: php-db@lists.php.net
From: Mike Rondeau 
Date: Sun, 6 Feb 2005 17:57:17 -0800
Subject: Newbie Setup Trouble

Hello,

I have just begun study of using PHP, MySQL and Apache server. Right now 
I'm following a book, PHP and MySQL For Dummies and am having trouble 
already. I must be a REAL dummy! I have installed all 3 programs but 
something is not right somewhere. Being so new to this I am having a real 
time trying to figure out which program is messed up. Certain things work, 
but others don't.

For instance, my book told me how to make a phpinfo.php page, which works 
fine. But it also tells me to create some other pages to test if PHP and 
MySQL are working or not. I followed the scripts provided exactly but keep 
getting syntax errors, even though the script is just what the authors 
wrote. For instance, it said to make a page and call it mysql_up.php. Here's 
the script for it:





$host=localhost;
$user=blablablabla;
$password=blablabla;

mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if ($result == 0)
{
echo Error  . mysql_errno() . : 
. mysql_error() . ;
}
else
{
?


Variable_nameValue

for ($i = 0; $i  mysql_num_rows($result); $i++) {
echo ;
$row_array = mysql_fetch_row($result);
for ($j = 0; $j  mysql_num_fields($result); $j++)
{
echo  . $row_array[$j] . ;
}
echo ;
}
?






But when I open it in my browser I get this error:

Fatal error: Call to undefined function mysql_connect() in C:\Program 
Files\Apache Group\Apache2\htdocs\mysql_up.php on line 10

Could anyone of you smart people point me in the right direction? I'd be 
pulling my hair out if I had any left :)



I can't make any progress with this study until I know my 3 programs are 
talking to eachother properly, but my book gives no info on this error.

Thanks a millionfold for any advice, and I appologise for the length of 
this post.

Sincerely,
Mike Rondeau 


 ATTACHMENT part 3 message/rfc822 
From: Denis Gerasimov 
To: 
, MySQL General List ,
PHP General List 

Date: Mon, 7 Feb 2005 17:52:50 +0300
Subject: mysqli connection problem


Hello,

This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server (PHP
+ PEAR::DB_DataObject):

Can't connect to local MySQL server through socket '' (111)

(notice '' - is that right?)

Does anyone have any ideas about how to get rid of this error?

Configuration:
* RedHat Enterprise Linux AS3
* Apache 2.0.46
* PHP 5.0.2
* MySQL 4.1.9, mysqli ext.

Thanks!


-
 ALL-NEW Yahoo! Messenger - all new features - even more fun!  

[PHP-DB] php v jsp

2004-11-20 Thread Vikas Nanda
Hi 
 
I just wanted to know what the advantages are of using php against jsp. My 
supervisor wants me to use jsp but I think that php might be better. Also can 
php code be easy reused like jsp?
 
Many thanks all
 
Vikas


-
Moving house? Beach bar in Thailand? New Wardrobe? Win £10k with Yahoo! Mail to 
make your dream a reality.