Can anyone tell me if it is relatively an easy process for an experienced
coder (not me) to convert a php script to mainly functions/classes.
I have my own script that i would like to make more streamlined as it is
becoming very difficult to work with.
--
PHP General Mailing List
Can anyone tell me why this works on my localhost but gets an error on my
server:
?php
$sql = SELECT COUNT(*) FROM leaderboard WHERE points =( SELECT points FROM
leaderboard WHERE username= '$username' );
$result = mysql_query( $sql ) or die ( mysql_error() );
$rank = mysql_result( $result, 0 );
It works now: I replaced the last part of the sql with a variable
?php
$sql = SELECT COUNT(*) FROM leaderboard WHERE points = $my_points ;
$result = mysql_query( $sql ) or die ( mysql_error() );
$rank = mysql_result( $result, 0 );
echo $rank;
?
Bigmark [EMAIL PROTECTED] wrote in message
It works now: I replaced the last part of the sql with a variable
?php
$sql = SELECT COUNT(*) FROM leaderboard WHERE points = $my_points ;
$result = mysql_query( $sql ) or die ( mysql_error() );
$rank = mysql_result( $result, 0 );
echo $rank;
?
Bigmark [EMAIL PROTECTED] wrote in message
news
Hi, can anyone help me with this at all.
i have a table leaderboard with username points etc and can echo the scores
in asc order ok but what i want is to grab the scores and display a users
position using their session ID.
So if the scores are for example:
36 user3
22 user1
18 user4
12 user2
and just
below form 1, then when the second form is submitted it then goes back to
just form1.
What i am trying to do is get rid of multiple pages and have the user stay
on the same page for all admin functions.
Bigmark
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http
Does anyone have a simple example script.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is there anyway of creating a config.php file on the fly using a form.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
hi, does anyone know why this is not working, i have married 2 pieces of
code together and i have no idea what im doing--any help is appreciated.
I get an error that says it cant find the host--$host so obviusly its not
passing it from the form.
/
?php
= mysql_connect($host, $user, $pass);
Note : No SINGLE quotes.
In PHP, quotations are as follows
$host = 'localhost';
$a = '$host';
$b = $host;
echo $a;
that prints $host
echo $b;
that prints localhost.
HTH
-Minuk
- Original Message -
From: bigmark [EMAIL PROTECTED
-
username-
Password-
Choose database name-
Then it installs the database and tables then redirects to the main site
page and the config.php is already configured for them
BigMark
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
this piece of script makes alternate row colours, but i want the rows to be
coloured in blocks of 8. So the first 8 rows are white then the next are
mauve etc etc.
Alternatively i could make the rows all the same colour , but i need a blank
row after each 8 rows.? Any ideas
Thanks!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi i have a football tipping database and i need to extract certain records
from a users 'selections' table
table name 'Selections'
(rows) RoundGameName Winner Points
data eg 1 1mark Hawthorn 4
(if team is a winner then 4 points
why is this not working. I am using instead of a form ($name =
$_POST[name];)
and linking to it from a users logged in page.
$FirstName = $_SESSION['first_name'];
$LastName = $_SESSION['last_name'];
$name = $FirstName , $LastName;
Mark
--
PHP General Mailing List (http://www.php.net/)
To
This script by Rob Sossomon works great --Thanks!
however could anyone tell me if its possible to make it run horizontally. at
the moment the output is like this---
--
Round Game Winning team Wins
1 1 Collingwood
1 2 Melbourne 4
I am trying to learn how to take the value of $name and $quote from a form
and put it in the database -whosaid
but obviuosly i have it all wrong. Can anyone point out what im doing wrong.
thx in advance
?php
include(connect.php);
$name = $_POST['name'];
$quote = $_POST['quote'];
$sql = INSERT
OK no errors now but no data inserted, my form must be wrong as well.
form method=post action=input.php
NAME
input name=textfield type=text id=name
QUOTE
input name=textarea type=text id=quote
input type=submit name=Submit value=Submit
/form
--
PHP General Mailing List
Well getting closer now, its inserting into the tables but they are blank
(no text)
Any ideas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is it possible to have this code changed easily to make the output run
horizontally instead of vertically. example of current output to email
below code
//
//email selections to all
Hi i urgently need a complete ---connect_db/form/results script, does
anyone know of a ready to use script available and ready to use today.
All i need is a connect.php page, a form to input a users name and one for
some text -and also a page that shows all the table results . i have to
get
Is there a way for me to email this script so it executes the close of a
round instead of doing it from the website administration .
(it is a football tipping script)
?php
include(connect.php);
// Grab variables and insert into database
$x=1;
$Round = $_POST['Round'];
switch ($Round) {
Hi an anyone help here, i have a shoutbox that displays the time with each
message but the time is 8 hours behind my time.
//here are the headers//
header(Expires: .gmdate(D, d M Y H:i:s).GMT);
header(Cache-Control: no-cache, must-revalidate);
header(Pragma: no-cache);
I have tried a few things
I have a sports tipping script and instead of using the admin to close a
round off or input results ,would it be possible to do it via an email.
Mark
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
A: How can i send an email with the contents of a table
B: can it be sent automatically when a certain field has data.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is it possible to have usernames from my db populated into a drop down
list.
If so What and where does it go to make it all work, ive tried everything i
know
( which is not much by the way).
Mark
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi i am very new to PHP so need some help !
i have a form which allows the user to put in 2 team names and then displays
them, at the moment it displays them side by side but i need to insert V
(versus) in the middle--how can i do that.
I am guessing it goes in the lines of the code below
Hi i had your php news account setup on my outlook express buti lost it what do i put
as the address
Mark
At the moment this code accepts changes and deletes from the Db but when the
submit button is pressed it echos- 'Record updated/edited' and i
have to go back and refresh to view the updated list, how can i just have it
refresh. When you open the file it shows the list but when editing
Nope that didnt work!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
30 matches
Mail list logo
