If I take out the title like:
SELECT MAX(reads) FROM articles
Then it gets the top article number but obviously not the title.
Can anyone shed some light?
Cheers,
Jord
--
Jordan Elver
Web Developer
The InternetOne UK Ltd
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
Hi,
Could anyone point me in the right direction with this one please.
I have a table of records wit a field of artists.
I want to select all the records which begin with the letter a-h then i-p etc
What is the best way to do this?
Cheers,
Jord
--
PHP Database Mailing List (http://www.php.net
Hi,
I thought it was about time I started using a db abstraction class. Problem
is, there are so many out there that I don't which one to start using?
I've heard of ADODB (I think).
Anyone have any suggestions?
Cheers,
Jord
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Hi,
I'm trying to build an article management system. Basically it will have
normal artcile type things, a picture or two etc. The articles will be
ordered by date by default, but I want to include the option of being able to
order the articles if need be. i.e. say I add more artciles but i sti
Hi,
I'm putting together a db with articles in it. Would it be better to have two
tables with the main text of the articles in it linked to a main article
table or just chuck it all in together in one table.
I want to be able to do a full text search on the articles.
Any help please,
Cheers,
Hi,
I have some code which I decided to make into a function. Some of the code
updates a session var which holds the current time. It now does not work.
// update session variable with new time
session_register("LOGGED_IN['time']");
$LOGGED_IN['time'] = mktime();
Hi,
I've got a db with a username and password in it. I can let people log in,
like SELECT * FROM table WHERE username = username AND password = password.
But how can I add an access level column so that I can have different levels
of security. So admin's can read everything, but users can only
gt; user_logins.user_id = users.id
> order by name,time
>
>
> -Original Message-
> From: Jordan Elver [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 1:43 PM
> To: PHP Database Mailing List; PHP General Mailing List
> Subject: [PHP] Query - Groupi
do you get.
>
>
> -Original Message-
> From: Jordan Elver [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 2:39 PM
> To: Jeff Armstrong
> Cc: PHP Database Mailing List; PHP General Mailing List
> Subject: Re: [PHP] Query - Grouping Results
>
>
> Doesn't seem to
Hi,
I've got a table like:
id user_id ip time
1 2 127.0.0.1 20010316105018
Etc, etc.
I do a join on the this table and the users table to get the coresponding
username to user_id like this:
SELECT users.name AS name, user_logins.ip AS ip,
U
Hi,
I want to keep filenames of different kinds of media(real sudio, qt, mp3) for
articles in a db table. Would it be best to store each kind of media in a
different table like one table for real audio, one for quicktime, one for
mp3. Or, would it better to store them all in the same table but
able and have one column which holds the
> filetype. There's (almost) no speed profit to put the information in
> several tables.
>
> Have fun,
> Maarten Verheijen
>
> >>> Jordan Elver <[EMAIL PROTECTED]> 27-03-01 13:37 >>>
>
> Hi,
> I w
I am.
Jord
On Tuesday 27 March 2001 14:06, you wrote:
> Why don't you just store the file names in a db?
>
> iets much easyer
>
> > Hi,
> > I want to keep filenames of different kinds of media(real sudio, qt, mp3)
>
> for
>
> > articles in a db table. Would it be best to store each kind of media
igned database modell, 'cause you have only one table (instead
> of 10 or twelve depending on the count of your datatypes), but you are able
> to select over the filetyp criteria!!
>
> Stefan Siefert
>
> -Ursprüngliche Nachricht-
> Von: Jordan Elver [mailto:[EMAIL PROTECT
Hi,
i was just wondering what you guys do to check if a wquery suceeded or not?
I know about mysql_num_rows() and mysql_affected_rows(), just wondered what
you guys do?
I normally do something like:
$sql = "SELECT something FROM table";
$result = mysql_query($sql);
if(@mysql_num_rows($result) >
Hi,
How can I pass an array between two pages. I've tried using serialize and
unserialize. But it doen't return an array. When I use gettype() on it, it
say's that the typ-e is boolean?
Any ideas?
Cheers,
Jord
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
Infrastructure Technology
> http://www.openlinksw.com
>
> -Original Message-
>
> > From: Jordan Elver [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 04, 2001 11:46 AM
> > To: PHP Database Mailing List; PHP General Mailing List
> > Subject: [PHP-DB] mysql_res
Hi,
If I knnow that a query will only retrun one row, can I do thiss (below)
rather than using a while loop for one record?
$id = @mysql_result($result, 0, 'id');
$name = @mysql_result($result, 0, 'name');
$email = @mysql_result($result, 0, 'email');
$address1 = @mysql_result($result, 0, 'addres
Hi,
I'm getting a bit confused about what date types to use in my applications
and MySQL db.
I have used timestamps and I know how to format them, convert them and
compare them etc but now I am about to build a calender type script and I'm
not sure what to use. For example, if I insert a load
Hi,
I'm trying to select records based on dates.
I have a table with dates in the format 2001-04-08 and I'm using the query:
SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001
AND MONTH(date_time) = 04 AND DAYOFMONTH(date_time) = 08
But it doesn't yield any records? I
Hi,
I've got a load of records that are in different categories.
What is the best way to get all the records or selected records and print
them in such a way that they are grouped (on the page) in their relevent
category, like:
Fruit
-> Apples
-> Pears
-> Bananas
Vegetables
-> Carrots
-> Cabba
Hi,
If I'm doing more than one query on a page what is the best way to check if
they all succeeded with out using transactions?
TIA,
Jord
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact
fon: +49-(0)7531-89207-17
> fax: +49-(0)7531-89207-13
> e-mail: mailto:[EMAIL PROTECTED]
> internet: http://www.suchtreffer.de
> _______
>
> > -Original Message-
> > From: Jordan Elver [mailto:[EMAIL PROTECT
Hi,
I'm trying to print out a list of usernames and the times they logged in.
I want to print it out like:
joe
fred
frank
Then when you click on one of the names it show just there login times, like
this, so if I click on fred it prints out:
joe
fred
-
-
-
frank
But it doesn't continue p
>
> > loads of users.
>
> but what if i have loads of users? and why can't i use this approach?
>
> rudy
--
Jordan Elver
Web Developer
The InternetOne UK Ltd
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional com
25 matches
Mail list logo