March 8th, 2004

gary
  • 45mph

Help?

MySQL/PHP question.

Alright. I'm wracking my brain trying to think of the solution to this. I know it must be simple, which is why I can't think of it. This is not the only place I've asked.

I'm writing a script. I want to display the contents of a table dependant upon the value of one of the columns.

Let's say I have a row that has the columns "Category", "Name," "Email" and "URL" -- in this example row, the values are like this - Category: Pointless, Name: Me, Email: here@there.com, URL: http://here.com. There are other rows like this, though they have varying values. I want to display the contents of the rows that have "Pointless" as the category.

I've tried

$query = 'SELECT * FROM ' . $db_table . ' WHERE ' . $site_sort . ' = ' . $category . ' ORDER BY title ASC';


In varying ways, and to no avail. I always get this result "Error executing query: Unknown column 'personal' in 'where clause'"

Any ideas?


I figured it out -- many thank-yous to rivv, though.
  • Current Mood
    distressed distressed

(no subject)

Has anyone here tried the South Beach Diet? Did you have any problems with it?

A bit of background information, so I don't get pounced or yelled at: I'm looking at changing the way I eat permenantly-- my current diet is very unhealthy and is wreaking havoc on my stomach and blood glucose levels (I'm a type 2 diabetic). My doctor suggested trying Atkins, but it only made me horrendously sick and miserable. I was thinking of using the South Beach Diet as a blueprint for new eating habits, since I've heard it's much more gentle on one's system than Atkins.

So, anyone want to give me their experiences with the diet, or point me in a better direction, if you've found one?
  • Current Mood
    uncomfortable uncomfortable
photoboothnew

(no subject)

who else has a snow day?

edit:
I have a new superintendent (he's the one who determines when we get delays and snow days) because my superintendent (Robert Sigler- google him if you must) is in jail for raping one of our students, yay! so yeah, this new guy is like... WHAT!? SNOW!?!? WE MUST CANCEL SCHOOL!!
ahem, so yeah. i don't think we should have had a snow day, but okay.
  • Current Music
    the get up kids - most depressing song
question
  • tbone

(no subject)

What do you know about permanent life insurance? What do you know about term life insurance? In very general terms, when would you recommend one over the other?
glasses by "maladroitkat" (c)kurt halsey

(no subject)

what are some reasons that the "check engine soon" light would come on? (and it just got an oil change a week and a half ago)

is it bad to drive it with that light on? I'd like to go to the barn, but don't know if I should risk the highway.

(no subject)

does anyone else think it's really annoying when people use a typically intransitive verb in transitive form? example: convex lenses converge the light. we exploded the car.

i've looked it up and it's technically proper but it sounds so damned stupid and improper to me. anyone else?
leave your turntable on

(no subject)

Where on Earth can I find information about women and minorities in photography, especially in photojournalism? Any kind of online source would work. I've tried Google, Yahoo, and almost anything else, but I can't think of anywhere else to go.
  • Current Mood
    stressed stressed
tank girl

Focus

So how does everyone get into focus?
How does everyone sit down and start the work they're supposed to do?
What if your having trouble concentrating, what do you do?

Any tips or mantras or motivating phrases to repeat or know?

(Oh yes, I'm a lazy student if you havent guessed)
Horror
  • avatar

Kazaa Katastrophe

I've heard the RIAA are hunting people on Kazaa now, and have been for at least a week or so. This is fairly news to me, but I've asked around, and a lot of people are saying this is for real. Does anyone know anything about this? I can't find any news reports on google, although I've also heard they're keeping it quiet.

It's hard to tell what's going on because nobody seems to really know for certain, everyone's just getting hella cautious and not using kazaa anymore. I don't know about you, but I don't want to be charged $2K+ or whatever it is if it's true. I only think it's real because I've heard from more than two sources among people I know. They're not the type to lie to me, especially not something that would be as trivial as not wanting me to download music (and my roommate is sacrificing his downloads too, and he would use it much more than I do).

Okay, so I'm assuming it's true.

Has anyone else heard anything about this? Where do you get your MP3's from instead?
  • Current Mood
    worried worried
Bitch Slap
  • amsa

(no subject)

ok two questions:
1. when your pupils get really big, you say they are dialated, what do you do you call when pupils really small?
and....
2. what is the literary term for: . . . ? (the dot dot dot, that's what i want to know, what is it actually called?)
  • Current Mood
    curious curious
Tattoo
  • kit_n

Born in the Wrong Era

I know there are some people out there who feel as if they were born in the wrong era. I have just realized, I am one of those people. I seriously belong in the 1700's. But let's not get into why ... I'm getting depressed, not being where I feel I should. So my question to you, for those who know what I am feeling ... what do you do?

(Please be serious).
  • Current Mood
    depressed depressed
Tiptoes

lj and movies

1) when was this community created?
2) when did you join this community?
3) how did you find this community?
4) when was the first time you thought "what the H is with the icon for this community?"
5) how long have you been on lj?
6) how often do you update your journal?

and totally non-related....

7) what was the last movie you saw in theaters? would you see it again?