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

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

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

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

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

Re: displaying a letter based on a query value

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 [EMAIL PROTECTED] Sent: Sunday, November 24, 2002 4:38 PM Subject: Re: displaying a letter based on a query

Re: displaying a letter based on a query value

-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 PROTECTED]; MYSQL [EMAIL PROTECTED] Sent: Sunday, November 24

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

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

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

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 PROTECTED]; MYSQL [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 9

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

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

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

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

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: ?php $db =

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.=nbsp;nbsp;nbsp;nbsp;a href=\%s\img src=\%s\ border=\0\/abrnbsp;nbsp;- a href=\%s\%s/abrbr,$a[url],$a[picurl],$a[url],$a[title]); } It just gives me a parse error on the

Re: primary key

-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, March 31, 2002 1:33 AM Subject: Re: primary key At 0:40

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

Re: problem with '

-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] To: Alex Behrens [EMAIL PROTECTED

Re: problem with '

/function.stripslashes.php --jeff - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: Son Nguyen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 31, 2002 11:35 AM Subject: Re: problem with ' Is it possible to have my script do this automatically if it detects a ' in the data

Re: problem with '

: 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 PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Sunday, March 31, 2002 6:03 PM

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

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: limiting a select

!) 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 PROTECTED]; Alex Behrens [EMAIL PROTECTED]; [EMAIL

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:

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,

Re: hits

] 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 PROTECTED] To: Alex Behrens [EMAIL

Re: hits

-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 a feature like that. Check the manual at www.mysql.com. I think you

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

Re: SELECT frmo two tables

WHERE players.player_name='$name' -Original Message- From: Alex Behrens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 4:00 PM To: [EMAIL PROTECTED] Subject: SELECT frmo two tables Hey All, I am having problems working on a script and need some advise. Here's my problem

Re: SELECT frmo two tables

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: Wednesday, March 27, 2002 9:45 PM Subject: Re: SELECT frmo two tables At 20:14 -0600 3

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: ?php if ($submit) // process form $namequery = mysql_query( SELECT * FROM

Re: Help with selects

Query Error message here; } } else { /* other code here */ } Alex Behrens wrote: 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

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: adding up row values....

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: [EMAIL PROTECTED] To: Alex Behrens [EMAIL PROTECTED] Sent: Saturday, March

Re: adding up row values....

] (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 Behrens [EMAIL PROTECTED]; [EMAIL PROTECTED

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

Re: dumb (re)newbie question...

] (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 Behrens [EMAIL PROTECTED] Sent: Friday, March 01, 2002

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

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

] 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 PROTECTED] To: Alex Behrens [EMAIL

need help debugging!

Hey All, I am new to mysql and I need help debugging this peice of code for my site: ?php $db = mysql_connect(db30.pair.com, net3dual, rosevilleX1); mysql_select_db(rahs,$db); $search = mysql_query(SELECT * FROM rahs); while($num=mysql_fetch_array($search)) { printf (div

Re: need help debugging!

: 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 01, 2002 7:35 PM Subject: Re: need help debugging! Hello

Re: need help debugging!

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 01, 2002 7:59 PM Subject: Re: need help debugging! Hello Alex

Re: need help debugging! (more!)

: [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 PROTECTED] To: Alex Behrens [EMAIL