[PHP-DB] Most Read Article

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

[PHP-DB] Selecting Alphabetically

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

[PHP-DB] DB Abstraction

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,

[PHP-DB] Ordering Articles

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

[PHP-DB] Text Searches on MySQL

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,

[PHP-DB] Sessions in Functions

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();

[PHP-DB] Login System with access levels

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

[PHP-DB] Re: [PHP] Query - Grouping Results

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

Re: [PHP] Query - Grouping Results

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

[PHP-DB] Query - Grouping Results

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

[PHP-DB] Structure Question

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

[PHP-DB] Re: Betr.: [PHP-DB] Structure Question

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

Re: [PHP-DB] Structure Question

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

Re: AW: [PHP-DB] Structure Question

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

[PHP-DB] Best way to check if a query succeeded

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) >

[PHP-DB] Passing Arrays

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

Re: [PHP-DB] mysql_result()

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

[PHP-DB] mysql_result()

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

[PHP-DB] Timestamps VS Date/Time Types

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

[PHP-DB] Selecting Dates

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

[PHP-DB] Retrieving and Printing Categories

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

[PHP-DB] Checking query suceeded

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

Re: [PHP-DB] Printing out usernames and logins

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

[PHP-DB] Printing out usernames and logins

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

Re: [PHP-DB] delete user but keep the article

> > > 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