Install on RH9

Hey All, Sorry I'm very new to the linux environment and I just recently installed RH9 that comes bundled with Mysql 3.23 and I'm having troubles upgrading to 4.0. When I try to install the latest client and server build it tells me I have failed dependences for mod_auth_mysql, php_mysql, and per

tracing ips

hey everyone, Kind of an OT subject, but since a lot of you are sys admins and what not I thought maybe someone could help. I'm trying to trace people on my message board to get a better idea of who they are. Does anyone know how to trace an ip and what program or method to use? I have ips from us

Desc question

hey all, I have a quick question. I'm trying to display a list of players by their name, number, position, and grade. Name, number, and position all display properly. However, grade (which is sorted grade number) is backwards, since 12th grade is after 11, 10, etc. How can I make it so only one fo

desc question

hey all, I have a quick question. I'm trying to display a list of players by their name, number, position, and grade. Name, number, and position all display properly. However, grade (which is sorted grade number) is backwards, since 12th grade is after 11, 10, etc. How can I make it so only one fo

Re: displaying a letter based on a query value

; Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Jeff Kilb

Re: displaying a letter based on a query value

779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]>; "MYSQL&quo

displaying a letter based on a query value

Hey All, I'm working on a site that displays all the players on my hockey team and I want to the page to indicate the captains automatically. Right now im using the following query to display all the captains, however, captains are indicated by a 1, is it possible to display a "C" when a 1 is foun

date conversion problem

Hey All, I'm storing date values for hockey game information using the DATE value and they are stored as MMDD and when I retrieve them from the database they are shown as: "2002-11-23" I was wondering if there was a way to have them converted to November, 23, 2002 when they are displayed on my

help with a simple query..

Hi Guys, I'm still new to this and I'm trying to get back into and I need help with a simple query. I have a list of info about a product for an article on my website and I'm pulling all this info from a mysql db and displaying it byway of php but don't know how to do the query. Right now I have

A lil help with a simple query...

Hi Guys, I'm still new to this and I'm trying to get back into and I need help with a simple query. I have a list of info about a product for an article on my website and I'm pulling all this info from a mysql db and displaying it byway of php but don't know how to do the query. Right now I have

Re: select by total goals

ief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Jeff Kilbride" <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTE

select by total goals

hey guys, I'm working on a script to display the season leading scorers for my lacrosse site and I don't know how to do the query. I am trying to display the leaders scorers by total goals throughout the season, however I don't know how to select the sum of goals by each individual player then s

select by total goals

hey guys, I'm working on a script to display the season leading scorers for my lacrosse site and I don't know how to do the query. I am trying to display the leaders scorers by total goals throughout the season, however I don't know how to select the sum of goals by each individual player then s

select

hey guys, I'm working on a script to display the season leading scorers for my lacrosse site and I don't know how to do the query. I am trying to display the leaders scorers by total goals throughout the season, however I don't know how to select the sum of goals by each individual player then s

row totals

Hey Guys, What is the command to add up the amount of rows in a total? I need to know how many total reviews are in my table for each category name, im using this query and it doesn't work: SELECT SUM(name) AS articletotal WHERE category = 'Processors' mysql Thanks! --

mysql and java

Hey Guys, I'm not sure if this is the right place to ask this question, but to be honest I didn't know where else to turn since my script deals with mysql. Here's my problem: I am using stylesheets and javascript to display a small blurb about a review on my site and it display is in a stylesheet

Re: create tmp table of column list of a table for future use

I believe it has to be like this: create table column_list (MYTABLE_NAME DESC); Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ:

help sorting by a column name

Hey Guys, I need to reorganize the list of reviews on my site so they are displayed by category. However, I want it to display all the reviews from all categories at once. How do I do this? Here is my syntax now for display all reviews at once, but not sorted by category: Hardware Reviews - %s A

need some help...

Hey Guys, I need help indentifiying why I have an error in this line of syntax: while($a=mysql_fetch_array($r)) { $retval.="  - %s",$a["url"],$a["picurl"],$a["url"],$a["title"])"; } It just gives me a parse error on the page for the $retval. = line Thanks! -

output to a file

Hey Guys, I know this is more of a PHP question, but since most people here now a lot about PHP I thought I'd ask. I have a script that outputs headlines for reviews and I need to output it to a file for inserting into my page, because I can't use php on this specific page so I want to output it

Re: problem with '

51-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Peter Lovatt" <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]>; "Jeff Kilbride" <[EMAIL PRO

Re: problem with '

Sunday, March 31, 2002 1:56 PM Subject: Re: problem with ' > http://www.php.net/manual/en/function.addslashes.php > http://www.php.net/manual/en/function.stripslashes.php > > --jeff > > - Original Message - > From: "Alex Behrens" <[EMAIL PROTECTED]> >

Re: problem with '

ECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Son Nguyen" <[EMAIL PROTECTED]

problem with '

Hey, I'm trying to insert data into a table with a TEXT field but the data I am inserting into the table has a ', present in the data and it gives me an error, the text is as follows: Of all the motherboard manufacturers in the world, there are only about half-a-dozen who consistently make relia

Re: primary key

x: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday,

primary key

Hey Guys, Is it possible to remove a primary key from a mysql table that has already been created without whipping out the table? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-4

column names

Hey Guys, What is the command to display the names of all the columns in a table? -mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-

Re: limiting a select

Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Chris Adams" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL P

limiting a select

Hey guys, quick question, I'm setting up a script that does headlines for my site and I need to pull some information from a table with my review info from it but I only want to view the 7 latest reviews, how do I make it so I can only view like 7 highest values for the "num" column? my query is

Re: hits

p://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Mike" <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 4:37 PM Subject: Re: hits > I don't think mysql has

Re: hits

EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Colin Faber" <[EMAIL P

hits

Hey Guys, I'm working on a script that displays reviews by a category for my site and I want the pull-down menu to be ordered by the amount of hits each category or review has, is it possible to sort by the amount of hits for a row value? My table is structured as follows: Name, Url, Author, E-

Re: SELECT frmo two tables

9 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]>; <[EMAIL PR

Re: SELECT frmo two tables

fs_won, > faceoffs_lost, date > > SQL: SELECT SUM(stats.groundballs) AS grounders FROM players LEFT > JOIN stats ON stats.player_number=players.player_number WHERE > players.player_name='$name' > > > -Original Message- > From: Alex Behrens [mailto:[EMAIL PROTECTED]]

SELECT frmo two tables

Hey All, I am having problems working on a script and need some advise. Here's my problem. I have two tables with teh following variables: rahs table: name, number, team, position stats table: name, team, penalty, groundballs, shots, faceoffs_won, faceoffs_lost, date and I need to make it so u

Re: Help with selects

sql_fetch_array($namequery)) { > printf ( "Name: %s",$set["playername"]); > printf ("$stat: %s",$set[$stat]); > } >} else { > print "Failed Query Error message here"; >} > } else { >/* other code here */

Help with selects

Hey Guys, I'm trying to get a form to submit to a mysql script and pull different variables when you select different values from the form, but I can't get it to work, can someone help me? Here's my code so far: ",$set["playername"]); } while($stats2=mysql_fetch_array($stats)): printf ("$stat:

Re: adding up row values....

il: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: "Alex Behren

Re: adding up row values....

sage - From: <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]> Sent: Saturday, March 02, 2002 4:58 PM Subject: Re: adding up row values > SELECT SUM(groundballs), SUM(shots) FROM table_name; > Also check out this: > SELECT SUM(groundballs), SUM(shots

adding up row values....

Hey Guys & Gals, I'm rather new to mysql and need some help accomplishing a command for my site: I am looking to take a column in my table and add all the values, they are all numerical. how do I do this? Below is an example of my table: +-++--+-+

Re: need help debugging! (more!)

gent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Jim Lucas [jimmysql]" <[EMAIL P

Re: need help debugging!

Q: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Uma Shankari T." <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March 0

Re: need help debugging!

51-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Uma Shankari T." <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent:

need help debugging!

Hey All, I am new to mysql and I need help debugging this peice of code for my site: Name:%s #%sTeam: %sPenalty: %sGroundballs: %sShots: %sFaceoffs Won:%sFaceoffs Lost: %sDate:%s",$num["name"],$num[" number"],$num["team"],$num["penalty"],$num["groundballs"],$num["shots"],$num ["faceoffs_won"

Re: using a datetime def in a column...

EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Paul DuBois" <[EMAIL P

using a datetime def in a column...

Hi All, I can't figure this out for the life of me, but since I'm rather new I know its a simple problem. I created a table an one of the rows has a 'datetime' for the defintions and everytime I instert data into the table it just comes up as, "00-00- 00:00:00. what is the proper way to inse

Re: dumb (re)newbie question...

EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Message - From: "Nathan" <[EMAIL PROTECTED]> To: "Alex Behre

dumb (re)newbie question...

Hey All, I recently got back into mysql again and haven't programmed for it in almost a year and have a really dumb newbie question. I need to add another row of data to an existing table what is the command to do so? Not like an UPDATE command where you input data into the table, but rather a wh