On Tue, 17 Dec 2002, conbud wrote:
> Conbud wrote:
> > Hello,
> > Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was
> > wondering how to get PHP to list let says row 5 - 10 from a database, I
> > read the MySQL manual and all I could find is LIMIT 0,5 to list just the
> > first 5, b
Conbud wrote:
Hello,
Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was
wondering how to get PHP to list let says row 5 - 10 from a database, I
read the MySQL manual and all I could find is LIMIT 0,5 to list just the
first 5, but I dont know how to make that list 5 - 10 or 10 - 15
Hello,
I am pretty new to PHP and I am trying to create a admin login page so my
client can view thier product line and orders. I have MySQL set-up properly
and have data in it and I am able to view information from the db with no
problem. I do all my testing on my local machine before I blast it
Thank you for your reply
I change it but now my page does nothing. I enter the user name and password click
login, the page reloads the login.php
I will repost this with a new Subject line.
ThX
David
"Adam Voigt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED
Thanks Miles.
Long story about why they need to be random.
I'll give all the suggestions here a good review.
Thanks everybody for the help.
tmb
"Miles Thompson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I dunno - why does this topic pop up periodically
Try this; it only works on certain versions of mysql:
select * from table order by rand();
Peter
On Tue, 17 Dec 2002, Miles Thompson wrote:
> I dunno - why does this topic pop up periodically. Anyway, here are two
> suggestions:
>
> 1. Add a field to the table, called rand_order. Whenever you u
> I need to...
>
> 1 - Select a set of records from a db
>
> 2 - Return a list of one or two fields from the selected record set in
> random order on a web page.
>
> Once I have my selected records & fields... say I end up with 20
records
> after my select query...
>
> How can I return the sele
I dunno - why does this topic pop up periodically. Anyway, here are two
suggestions:
1. Add a field to the table, called rand_order. Whenever you update the
table insert a random number in it and when fetching records order by
Rand_order.
2. Generate an array of 20 random numbers and use it to
I need to...
1 - Select a set of records from a db
2 - Return a list of one or two fields from the selected record set in
random order on a web page.
Once I have my selected records & fields... say I end up with 20 records
after my select query...
How can I return the selected records in _rando
I need to use PHP to duplicate the schema of a database. This seems like
it should be a simple task -- taking a 'template' db and cloning it with
a new name.
I've tried things like:
$filename = "myDB.sql";
$fd = fopen ($filename, "r");
$sql = fread
Hi everyone,
I know that inserting actual pictures into a MySQL DB is not the best
solution, but since I know the size is going to be limited I want to do it
anyways. How do I upload a picture into a DB? (what type of table etc.).
Jacco
--
http://seabird.jmtech.ca
Attitude is Everything!
But Rem
Hi, guys
I have a small and delicate problem. This I think, involves using the
rewriterule from apache server, but I don't know where to post it Here's
my situation :
Until recently, my client had his site on a stack server. In this way,
all his pages where addressed by :
http://www.sitename.com/s
Hi Jim Hatridge,
> Warning: unlink() failed (Permission denied) in
> /home/hatridge/public_html/Database/currency.php on line 12
> permissions and all are either 666 or 777.
The modification 777 means everyone can do everything. So there
can't be any problem in writing or reading.
Insert a
Do you have root access to the internet MySQL server? The easiest way to do
this would be to use replication, I think. It doesn't sound too difficult to
set up and it would do all of the updating for you. Is that an option? If
not, then you can enable binary logging (I think that's what it is) in y
Figuring how shouldn't be too tough. Compiling software for the
most part is a breeze. My concern was whether I needed to recompile or not.
I am now trying that, and hopefully this will address the problem for me.
As to the recompiling with every release, that is no big deal either as the
BTW... I'm not the one stuck trying to figure out how to recompile my current version
of PHP to include the oci functions... haha! And guess what, with every release you
get to do it all over again... so polish up on the shell scripting unless you want to
reinvent the wheel every month or two. :
:-) ... Windows is the best at running the C# .NET applications I have to build to
:make everyone happy that we are "industry standard" ... when big brother is not
:looking I use PHP for everything I can get away with. I'm actually very impressed
:with how easily PHP integrates into an IIS / MSS
Hello everybody!
I've got a very intersting task for myself and I hope somebody can help me to solve it.
I have a big site in the Internet that stores many information in several tables. The
site is PHP and MySQL based. I have a copy of this site on my local server. Any data
for the site I add
Thanks, but my web server is HP-UX.
Didn't anyone ever tell you Win-blows sucks? :)
-Original Message-
From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 3:07 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Oracle/PHP question...
If your
If your webserver is win32 then you need to uncomment the line in php.ini that says :
;extension=php_oci8.dll
if it is unix based I am not sure what you need to do.
<>< Ryan
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 1:
Thanks to everyone for your help. It was my own stupidity which was
collecting the wrong data. I wasn't passing the value of unit_id to my
table.
"Andre gemünd" <[EMAIL PROTECTED]> wrote in message
000b01c2a3af$753d2160$596d8550@lithium3">news:000b01c2a3af$753d2160$596d8550@lithium3...
> You shoul
I am now trying to setup connectivity to a remote Oracle database
for my PHP/Apache web server. I am attempting to verify connectivity to the
database by:
I have installed the Oracle client on the system, and I have also
setup the ORACLE_HOME and ORACLE_SID environment variables
> LIMIT 5,10
> LIMIT 10,15
>
> Something like that should work.
Not quite. LIMIT n,m where n is the starting point and m is how many rows
you want returned.
LIMIT 5 or LIMIT 0,5
LIMIT 5,5
LIMIT 10,5
etc...
---John Holmes...
> Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was
> wo
LIMIT 5,10
LIMIT 10,15
Something like that should work.
Aaron
-Original Message-
From: conbud [mailto:[EMAIL PROTECTED]]
Sent: December 16, 2002 3:10 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Listing A Certain # Range
Hello,
Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I
Hello,
Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was
wondering how to get PHP to list let says row 5 - 10 from a database, I
read the MySQL manual and all I could find is LIMIT 0,5 to list just the
first 5, but I dont know how to make that list 5 - 10 or 10 - 15. Any
help wou
Hi all...
I've at last got "safe_mode" turned off (I think). But when I try to do an
unlink I get this:
Warning: unlink() failed (Permission denied) in
/home/hatridge/public_html/Database/currency.php on line 12
Also I'm trying to do exec() and it just ignore it. I've checked the
permissions a
> I have a field in a news CMS that could contain " Infact most of the
time
> it
> does in the form of URL's etc. Getting the data initially into the
> database
> is no problem - Infact MySQL shows has no toruble with it. The problem
i
> am
> getting is when i edit the data - basically loading into
Gotcha. thanks to everyone for the advice. I'm going to switch it to
the 2 table format.
Thanks again,
Doug
David Eisenhart wrote:
I would go along the lines that Stas suggests.
You appear to have a two table database here:
Table1: tblHole
hole_id, hole_no, course_id, par, WH, MH, Trees1
on 16/12/02 5:15 pm, mike karthauser at [EMAIL PROTECTED] wrote:
> I have a field in a news CMS that could contain " Infact most of the time it
> does in the form of URL's etc. Getting the data initially into the database
> is no problem - Infact MySQL shows has no toruble with it. The problem i a
I have a field in a news CMS that could contain " Infact most of the time it
does in the form of URL's etc. Getting the data initially into the database
is no problem - Infact MySQL shows has no toruble with it. The problem i am
getting is when i edit the data - basically loading into a form -> tex
I would go along the lines that Stas suggests.
You appear to have a two table database here:
Table1: tblHole
hole_id, hole_no, course_id, par, WH, MH, Trees1, Trees2, Trees3 etc...
--- -- - --- -
1 1 1
On Sun, 15 Dec 2002, David wrote:
> It is coming from this line:
>
> this is line 43 code
>
> # $myquery = .'" AND password = '" . crypt($password, "xpz8ty") . "'";
You have the wrong quotes and such. It should look like this:
$myquery .= " AND password = '".crypt($password,"xpz8ty")."'";
Hi David
>// Query Database with username and encrypted password
> #$myquery = "SELECT * FROM user WHERE username = '" . $user
> #$myquery = .'" AND password = '" . crypt($password, "xpz8ty") . "'";
> #$result = mysql_query($myquery);
In the first line of the query there is no semicolon at
Your missing a semicolon (;) after your first "$myquery =" line.
- Original Message -
From: "David" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 16, 2002 2:16 AM
Subj
You should write:
$myquery = "SELECT * FROM user WHERE username = '{$user}' ..." ;
As a bonus, it is much more readable.
Ignatius
- Original Message -
From: "David" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 16, 2002 2:
Hi
Yesterday I tried out phppgadmin. I didn't chage anything in the
pg_hba.conf but only edited the config.inc.php.dist file in the phppgadmin
distribution and saved it as config.inc.php. These are the lines I changed:
$cfgSuperUser = "superuser_name";
$cfgServers[1]['host'] = 'localhost';
$cf
Hello all,
I am new to PHP so I am going to need some help.
I am trying to create a admin login page. But I am getting this error
message:
Parse error: parse error, unexpected T_VARIABLE in c:\program files\apache
group\apache\htdocs\sunwestsilver\admin\tmpi5pcf76sy9.php on line 43
tmpi5pcf76sy
The grid for each course looks like this (excluding CourseName, State, County,
Street, City, State)
Hole1 | Hole2 | Hole 3 | . | Hole18
Par 9 47 .. 6
WH 8 44 .. 5
MH 5
Doug Parker wrote:
I'm about to embark on a project where I have to enter many, many fields
into a MySQL database, and I don't know how to approach the database
structure. The data is statistics for a golf course. There are 18
holes, and each hole has a Red Tee Par, White Tee Par, and Blue Te
Cesar Aracena wrote:
Table 1 - Categories
catid (autonum)
catname
Table 2 - Sub categories
subcatid (autonum)
subcatname
Table 3 - Products
prodid (autonum)
prodname
Table 4 - Relationships
Catid
Subcatid
Prodid
Now, the question is how to fetch all the sub-categories let's say that
are relat
Hello to everyone,
I have a problem connecting to database with the phppgadmin
i have put in the pg_hda.conf the line
local all trust
which i think gives access to all the users in the local system to all
the databases but i cannot connect with phppgadmin with any conf i have
tried.
Thx in a
what kind of stats are you storing - scores?
what fields do you need to store - these are necessary
to help you
start with the top and work your way down
- courses have name, location, holes, members etc.
- holes have par, distance, blah
- members have blah, blah
You can add/remove fields later,
42 matches
Mail list logo