Hi,
First you'll have to modify your query to show only ten rows.
$sql = "SELECT id, email, name, subject, url, image2, comments, dat
FROM users
ORDER BY id DESC LIMIT $start,10";
The $start variable shows the number of the first row to show
The links for the previous and next
What about...
SELECT WLPbib.bibID,
WLPbib.title,
WLPbib.publisher,
WLPbib.publicationDate,
WLPaddress.city,
WLPaddress.state,
WLPprofile.firstName,
WLPprofile.lastName,
WLPprofile.organization,
WLPcountry.languageName
FROM
Hi,
As I can see you're trying to set a cookie that has expired an hour ago. May
be you could try to modify the setcookie() arguments to something like this
setcookie ("logged_in", "yes", time() + 3600);
setcookie ("logged_user_name", "brad", time() + 3600);
This will make your cookies to expire
Hi,
Did you try to use something like this.
mysql_query("SELECT DISTINCT
WLPbib.bibID,
WLPbib.title,
WLPbib.publisher,
WLPbib.publicationDate,
WLPaddress.city,
WLPaddress.state,
WLPprofile.firstName,
WLPprofile.lastName
Here's a list of some free shopping cart stuff
http://www.missoulaweb.com/help/index.phtml?qid=46&cat=11
--
Allen Lee
http://MissoulaWeb.com
$10/month PHP4 MySQL Hosting
On Thu, 12 Jul 2001, Matthew Loff wrote:
>
> Ha ha... It makes perfect sense!
>
> I just assumed that since he was asking,
Ha ha... It makes perfect sense!
I just assumed that since he was asking, he was implying that he didn't
have the ability (due to administrative reasons) to install mysql.
Good point, though. :)
-Original Message-
From: Tom Peck [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12,
Matthew
So what's so funny about installing MySQL on a NT system that is already
running Perl and PHP? I think it makes perfect sense :-).
Tom
At 00:52 12/07/2001 -0400, you wrote:
>Everyone suggesting "Easy! Just install Mysql!" makes me laugh... :)
>
>Jeff-- I suggest you check:
>
>1) htt
Everyone suggesting "Easy! Just install Mysql!" makes me laugh... :)
Jeff-- I suggest you check:
1) http://www.hotscripts.com/
2) http://www.zend.com/
3) http://www.sourceforge.com/
4) http://www.mysql.com/ (Just kidding!)
Any shopping cart that uses ODBC should work just fine-- and moreso,
Hi there Everyone,
I currently have a dedicated Apache server with PHP 4.06, MySQL etc .. installed and
running fine. Below is alittle peice of code that I would love an answer to:
then all the HTML and display bits (Example at www.planetoxygene.com in the guestbook).
Now my questio
Stupid html e-mail...
That code may not come through properly... copy it from the site, as
what's below is only half complete.
Tom
At 16:23 12/07/2001 +1200, you wrote:
>Brad
>
>Try this:
>--
>$status = 0;
>if (isset($myTstCky) && ($myTstCky == "ChocChip")) $status =
Brad
Try this:
--
Cookie Check
Cookie Check Status:
%s
;',
$status ? "00FF00" : "FF",
$status ? "PASSED!" : "FAILED!");
?>
---
It's taken from here: http://www.php.net/manual/en/function.setcookie.php
If that still fails to work
I have one script that looks like this:
SENT
and another that looks like this:
";
echo $HTTP_COOKIE_VARS["logged_in"];
print "";
echo $logged_user_name;
print "";
print "end";
?>
which I have also tried like this:
";
echo $logged_in;
print "";
echo $logged_user_name;
?>
It seems like
Hi!
Is there a command like ocifetchstatement() for mysql?
I looked and looked and ... well it just does not seem to be there :-),
So I got ambitous and tried just making one...
function MyDataArray($query)
{
$this->result = @mysql_query($query, $this->id) or
ummm... why not install MYSQL on your server?
you can have the apache/mysql/php triad. all free/open sourced...
then there are a few shopping carts already written. the book titled,
"PHP and MySQL Web Development" has a shopping cart example...
http://shop.barnesandnoble.com/booksearch/result
phpMyAdmin is great! And I hear that they are coming out with a new version
pretty soon (or is it here - haven't checked)..
However I don't think that you can join tables in phpMyAdmin.. Perhaps I don't
know the app well enough though.
Mike
Beau Lebens wrote:
> altho this may not help at a
altho this may not help at all, rather than bashing away with php+SQL
statements, i usually just pilot my sql in phpmyadmin, then once it works
with set values (ie SELECT * FROM people WHERE personID='3' rahter than
personID='$personID' or something) i can then drop that SQL into my script.
HTH
B
Just build the SQL statement piece by piece instead of all at once.
Be sure that your tables are setup properly, allowing you to make joins
properly. Try not to rush, cause you might miss a couple of little things
along the way.
Kevin Johnson
- Original Message -
From: "Mike Gifford" <
Sorry Ken,
I'm trying to learn a few too many things at once. Switching it around
eliminated the error message but not the duplication.
I'm eliminating as much of the code as I can to see that it isn't coming from PHP.
Thanks again for your help.
Mike
Ken wrote:
> In general, you should al
Mike -
In general, you should always be reading the manual first. From the SELECT syntax at
http://www.mysql.com/doc/S/E/SELECT.html
GROUP BY must be indicated before ORDER BY. So reverse the order of those portions.
- Ken
At 10:35 PM 7/11/01 -0400, Mike Gifford wrote:
>It looked good, but it
Probably cause his host is extremely ghetto and refuses to install anything
non M$FT =P ...and he doesn't have full admin access to the server.
-- David Balatero
-Original Message-
From: Tom Peck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 6:53 PM
To: [EMAIL PROTECTED]
Subj
It looked good, but it gave me an error.. Sorry
Database error:
Invalid SQL: SELECT WLPbib.bibID,
WLPbib.title,
WLPbib.publisher,
WLPbib.publicationDate,
WLPaddress.city,
WLPaddress.state,
WLPprofile.firstName,
WLPprofile.l
Mike -
I'm not certain but it sounds like you might be looking for "GROUP BY". Do GROUP BY
and then the columns that are identical in your results.
- Ken
At 09:46 PM 7/11/01 -0400, Mike Gifford wrote:
>Hello,
>
>I posted this to the general list this morning & got a couple of good leads, but
Jeff
Have you tried: http://www.hotscripts.com it seems to have a huge
selection of PHP scripts - i'm not sure if it has what you are after
though. Why don't you have MySQL installed on your NT machine? It is a
LOT quicker than any MS Access database, or flat file - especially if you
are
Can anyone direct me to a shopping cart package (preferrably in PHP,
although PERL would possibly work) which utilizes either an MS Access
database or flat files? I've found several shopping carts, but they
all seem to require MySQL which I do not have access to on my server.
My server is Windows
Hello,
I posted this to the general list this morning & got a couple of good leads, but
they weren't able to actually fix the problem, so I'm posting here to the db list.
I'm making some headway on joining three MySQL tables.
However, when I run this query:
mysql_query("SELECT
WLPbib.b
If you created each column name on the table (i assume that's how this is
working) and then as rita said, dump the searched variables as hidden
inputs, then you could have something like this happen;
Sort By Position
which sets the value of the empty $sort input field to "position" and th
But instead I end up with the following:
001 user1
003 user3
Any idea or comment?
The auto incrementing feature of mysql unfortunately will always increase by
1 based on the (MAX) primary key ID number. Questions about this have been
made to the MySQL development team as to if they would m
"Ken Sommers" <[EMAIL PROTECTED]> wrote in message
000a01c10a32$a8ec8540$7344500c@zeospantera">news:000a01c10a32$a8ec8540$7344500c@zeospantera...
> What is function overloading?
Overloading is the ability to define several functions by the same
name but with different parameter lists and let th
check out the mktime() function
""David W. Banks"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Is there some way to get the equivalent of "select TO_DAYS(NOW())"
> out of PHP without querying MySQL (or whatever.) Some formatting character
> for the date() f
Manual says:
---
"Any valid PHP code may appear inside a function, even other functions and
class definitions.
In PHP 3, functions must be defined before they are referenced. No such
requirement exists in PHP 4.
PHP does not support function overloading, nor is it possible to undefine or
red
Hi
You don't need a text file. Just store a version number for each table row
and increment
on every change. Check to see if the version number has incremented means
that the row
has been updated. This is called optimistic locking.
Regards, John
"Raquel Rice" <[EMAIL PROTECTED]> wrote in messag
Hi again.
I just found an above message that states the DLLs I need are in the PHP package
I installed and I just need to uncomment them from php.ini. Am I off the beaten
track or is that true?
I found the listings for php_oracle.dll and php_oci8.dll in php.ini under the
'Dynamic Extensions' sec
Tom,
>From Oracle :)
Alternativley you can use the OpenLink Multi-Tier ODBC driver at
www.openlinksw.com. It downloads with a free 2-connection license, and has
free support available at www.openlinksw.com/support/suppindx.htm
HTH!
Best regards,
Andrew Hill
Director of Technology Evangelism
O
The Oracle Client for Windows NT/2000 and for Windows NT discs are both
included in the CD-ROM distribution pack for Sun SPARC Solaris. You don't
indicate which version you're running, but I've found the Windows (whatever
flavor) Client software to be included in every Oracle version we've ha
Tom:
Go to technet.oracle.com and download Oracle 8i Database for WinNT. When you
run the installer, you can do a custom set-up to only install the networking
libraries (Net8). Run Net8 Easy Config. That will get you started.
I'm not sure how much it costs officially. You'll have to call up Orac
Hi all.
Where can I get the Oracle client libraries for PHP4? I am running
Apache and PHP4 on my NT Server and I will be connecting to an Oracle
database on a Solaris server via remote connect? I saw some threads
earlier indicating that they could be found at download.swwwing.com but
that server
the ctype_alnum is experimental. is there an easy way wherein i can identify if the
input is an alphanumeric?
thanks for your help.
Hi
I am developing my website with this combo: W2K/IIS/PHP <--> W2K/MSSQL7.0
When I switch to production I intend to use: Linux/Apache/PHP <--> FreeTDS
<--> W2K/MSSQL7.0
My question is this: Will I be able to use ALL the PHP MSSQL functions (as
listed in the PHP docs) when on the Linux combo?
Thanks Jonathan,
The Microsoft site says just that, that it is a security precaution.
http://support.microsoft.com/support/kb/articles/q183/7/63.asp
But I wonder, is it only caused by PHP or ASP pages? If so,
what is to stop me from creating an line in my .htaccess file
that forces the Apache s
Good Morning,
You could create a form and save your variables as "hidden" elements of your
form. I've never tried it without having an actual visible form on the page
with a submit button and everything, but it should work.
The only other ways I can think of are pretty long winded...cookies,
dat
You can also change your form to use the GET method instead. That works
without changing your php.ini file. But don't use GET methods for logging in
or passing secure information. It's much more insecure than POSTing (not
that POSTing variables is a 100% secure method, either)...
"Keith Spiller"
I had this problem, too. It seems as though when using session variables and
POST forms, you get this error when trying to go back to a POSTed page.
I believe I read somewhere that the error is more of a security issue - to
keep others from simply going back and seeing any private data, but I'm n
Keith,
I believe this happens because most browsers feel that it is important
to regenerate any page that was generated with form input when you go
'Back' to it.
Therefore, there's not much you can do about it... I suppose you could
make links from the expiring page open in new windows, so the
So what is actually the problem with running sp in mssql?
Mike
-Original Message-
From: Carpe Diem Support [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 3:32 PM
To: Hugh Bothwell; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: problem running stored MsSQL proc
I've setup a members directory in mysql that is searchable via different field and I
limit the number of records.
I use session variables to remember the number of records to display, what the
starting record is, what the
search string and search fields are. At anytime a user can click on an id
"Ken Sommers" <[EMAIL PROTECTED]> wrote in message
001301c10994$717b4b80$0343500c@zeospantera">news:001301c10994$717b4b80$0343500c@zeospantera...
> Hello, pure HTML server question:
>
> images like (backgroundimage.jpg) stored on server at: /htdocs/img
>
> util.showpic.html is stored at : /htdo
Hi. I was using Apache 1.3.12 + Win 95 + PHP 4.06.
- Original Message -
From: "Dobromir Velev" <[EMAIL PROTECTED]>
To: "Wagner R. Landgraf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 4:15 AM
Subject: Re: [PHP-DB] PHP4 + interbase = bug?
> Hi,
> What versio
Cookie or session? A little extreme, but if you don't want it in the url
then that's the only other way I can think of to remember a variable when
the page is refreshed..
Tom
At 13:09 11/07/2001 +0200, you wrote:
>Hello!
>
>I have this little problem sorting a search result by different fie
Hello!
I have this little problem sorting a search result by different fieldnames.
I do my search, get a quite impressive amount of variables that I use in my
MySQL-query, and by default use "ORDER BY name".
But I want to be able to klick on different headers to sort like "ORDER BY
$order".
I'm using Php 4.0.1 pl2-9 and Mysql 3.23.22 and gets the following error in
Mysqls logfile:
010711 10:58:52 Aborted connection 381 to db: 'improvement' user: 'webusr'
host: `web.local' (Got an error reading communication packets)
After a while mysql doesn't accept more connection because it has
Hello all,
I have a form with my fileds filled with ECHO strings from a query, in order
to get the values of a product stored in MySql.
The question is:
wich is the string in order to update the fields I change in the form
ThankĀ“s all
--
PHP Database Mailing List (http://www.php.net/)
The variables wont become available until the cookies are read - which
happens when the script is first loaded. Normally the cookies are set,
then a header is sent to reload the page - but be carful not to create an
endless loop of browser reloading...
Check out the examples on:
http://www.p
52 matches
Mail list logo