Webmaster Forum / PHP / Database Access / March 2004

I would like to retrieve the first 150 characters from a string but
count the spaces as a character.  I cannot find an example anywhere.
Any Ideas?
Thanks

I've been trying to "order by" on more than one column, both which are
integers. However, it sorts the first one correctly (i.e in descending
order on DESC) but not the second one. I want the second column to be
sorted in ascending order, i.e first sort on the first column in ...

I'm new to SQL. I know most of the basics but I can't seem to find out how
to select post not older than 14 days (ie. posts made in the last 14 days)
Can someone write an example??
regards.

Another question -- If I wanted to use a wildcard in a query, how would I go
about doing that? Basically what I'm trying to do is search for a username.
For example, if the user says "begins with 'Ten'" then I need something
that searches for a username of Ten*. Any ideas?

Has anyone an idee how i can replace every character in a string if it is not alphanumeric ?
something like eregi_replace, but i don't know how i say in regex NOT.
Tnx

I'm running MySQL with many tables. I want to create a backup of them onto a
floppy. What files do I need to move over to the floppy to back up those
tables? Actually, I'd prefer to do multiple databases too, but I figure
that's not going to be much different.

A 2 row table , "picture" and "attribute"  ; picture will hold names of
graphics like p34.jpg  , attribute aspects of the photo , like "Porsche"
"BMW",  "red",  etc ;  multiple rows will hold the same graphic, but
different attributes. A query should enable the user to find all red ...

I am completly new to both PHP and SQL, and am trying to make mods to some
software.
Basically I have what I want up to the foreach statement below. I want to
loop through the results from the "TONYquery" and get the "fud" from it.

I have table with user_id and  points. How can i recognize position in
ranking  for fixed  user_id ?  (position  is determined  by number  of
points). Can you help me generate some query ?

Thank those who e-mailed me back on my last question. I am now writing
a script from a tutorial I found at "HotScripts" ... I am trying to
upload an image from html form to apache. I chmod(ed) the directory
and typed in the right path name but I am confused on why this isnt

tbllanguage: languageid, language
tblpubdetail: languageid, pubid, active (0 or 1)
tblpub: pubid, active (0 or 1)
I need to show all languages and number of publications next to each,

Hello,
I have two databases with two different usernames and passwords and I
need to draw a query from both.
rough example of what I need: <--- not realy code

I have a table that looks like this
xref_id     title_id     topic_id
-----------------------------------
1             1             1

Hey everybody, has anybody a php login code (without mySQL) , thank you

I have a very slow query,
YES I'm using indexes and the table definitions are already optimized.
Is there a way to speed up this query?
I think the most time is used for the last lines.