Don't mean to start a discussion whatsoever, I
love php, but
one thing i can't do in php is
Response.Redirect("page.asp") .
Apart from that no complains so far :)
Um, as I understand it this is simple to do in php. Just use:
header("Location: $somestring");
Here's
SUM(IF(letter_grade = 'B', 1, 0)) AS B_count,
SUM(IF(letter_grade = 'B-', 1, 0)) AS B-_count,
SUM(IF(letter_grade = 'C', 1, 0)) AS C_count,
FROM grades_table
GROUP BY uid;
should do.
Michael
Bob Ramsey wrote:
Hi,
I have a table of grades l
==
Bob Ramsey SYSTEMS ADMINISTRATION AND SYSTEMS PROGRAMMING III
MA, Management of Information Systems 2004
MA, English Literature, 1992
ph: 1(319)335-9956 187 Boyd Law Building
fax: 1(319)335-9019
Thanks for the replies. This appears to be the right answer:
where page_body regexp '.*.*' and page_body not regexp '.*.*';
bob
==========
Bob Ramsey SYSTEMS ADMINISTRATION AND SYSTEMS PROGRAMMING I
Chris Blackwell wrote:
not sure you can do this just with mysql, I think your gunna need to select
the html from the db then send it to something like perl or php and use a
regex parser on it.
Yeah, that's what I was afraid of. Now all I have to do is decide
between PERL and PHP for the script
Hi,
I have some web pages in a database and I want to check to make sure
that all of the images have alt tags in them. So what I need to do is
ask something like this in psuedocode:
select page_name from web_pages where page_body does not contain 'alt='
between '';
But I just can't figure out
Let's say I have two tables:
T1:
Name
---
apple
banana
cherry
T2:
value| name
-|--
1 | apple
2 | banana
3 | banana
4 | cherry
5 | apple
6 | apple
I want to get a result that looks like this:
name| all_values
apple| 1,5, 6
banana| 2,3
cherry| 4
In my head, t
Michael Mason wrote:
I'm new to MySQL and already very impressed with it's flexibility,
speed and functionality. This in mind, I am looking for a way to allow
users to upload documents to the server for later retrieval by an
administrator.
Can this be done or will I have to find a nasty thir
Personally, I'd split that into 2 fields. I think that's a better way
to model the data unless there's something I don't know.
Otherwise, try this:
mysql> select * from url;
+---+
| url |
+-
Whoops. I was thinking about how I have my isbn table stored. ;) I
prefer to remove all formatting from numbers like this(isbn, phone
numbers, social security numbers, etc) before storing them. Anyway,
here's something that should work. I'm not sure if it is the most
efficient way to do thi
Oh, I think I know this one.
Copied from my console:
mysql> select * from test;
++-+
| id | myvalue |
++-+
| 1 | 12 |
| 2 | 15 |
| 3 | 3 |
| 4 | 10 |
| 5 | 10 |
| 6 | 10 |
++-+
6 rows in set (0.04 sec)
mysql> select * from tes
Use the blob/text, mediumblob/mediumtext or longblob/longtext types.
Since you are just storing text, use the text versions.
It sounds like when you say "text" what you really mean is the varchar()
type. If you declare a field as a text type, you can store 2^16
characters, or 65,536 characte
2 |
|4 |
|5 |
|3 |
+--+
5 rows in set (0.00 sec)
Garth
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
==========
Bob Ramsey
[EMAIL PROTECTED] wrote:
hi,
Is there a way to do report writing from Mysql databases? I want to
transfer all the records from Mysql to a file. i used the Into OUTFILE but it
doesnt display properly.I want to diplay it properly like records or reports.
is there a way??
Thanks,
Liz
You a
Roy Smith wrote:
I've got a bunch of files which contain packed fixed-field-width
records. The records are pretty long; depending on the file, as long
as 1000 characters and 10's of fields. Fields are a mix of numeric
and alphanumeric types.
What's the best way to load these into mysql? Mys
Arjun Subramanian wrote:
Do you have any
specific sites or utilities in mind ?
Try the code posted in this newsgroup posting:
http://groups.google.com/groups?q=macro+access+export+mysql&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=tchs8rl5phqib7%40corp.supernews.com&rnum=3
It's a little long to post here
:13706295
> Every knee shall bow, and every tongue confess, in heaven, on earth, and
under
> the earth, that Jesus Christ is LORD -- Count on it!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing Li
I think that you can just do this:
select sum(ads.col)*1.191*sum(ads.depth)/131.77 where date ='2004-02-26'
AND editionID = '13' AND ads.page = '16';
because of the disttributive property of multiplication.
(2 * 1.191) +(6*1.91) +(4*1.91)/131.77 = 12 *1.91/131.77 =
(12*1.91)/131.77 = 12*(1.91/
7;t work]
I can use php and get take the current page and turn it into '/data1' and
then do:
select * from table where (path ='/data1/index.php' or path='/data1') and
user ='jones';
but I'm curious if there's a way to have '/data1/index.php
able where other_table.some_column=mytable.a+1) where mytable.b=6;
The goal is to set a column in a to a value based on a column in another
table when b in the same record has a specific attribute.
Can I do this?
Thanks,
bob
======
So how reflective of the real test is the sample test at mysql.com?
Normally the little sample tests are easier than the real thing, but I'm
curious. I got 8 out of 10.
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
At 03:52 AM 1/13/2004, Harald Fuchs wrote:
SELECT *
FROM tbl
WHERE user = 'jones'
AND '/data1/index.php' LIKE concat(path, '%');
Thanks for the tip.
Bob
==========
Bob Ramsey
7;t work]
I can use php and get take the current page and turn it into '/data1' and
then do:
select * from table where (path ='/data1/index.php' or path='/data1') and
user ='jones';
but I'm curious if there's a way to have '/data1/index.php
Has anyone seen something like this before:
We have an Access database (about 9 megs in size) with linked tables in
it. The machine DSN shows that the information for the connection is
correct. But when you try to open the table in Access, a dialog pops up
to connect to the mysql server and t
I saw a macro for access that will produce a script that will recreate
your tables and the data in them. But it only worked in older versions
of access.
Sorry I can't be more help.
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
| 2 |
| adam | 2 |
+--++
5 rows in set (0.00 sec)
Is that what you mean?
==========
Bob Ramsey Applications Development & Support II
ph: 1(319)335-9956 216 Boyd
Because you have to change 3->4, 2->3 so that you can insert a new number 2.
Is there a good workaround for this in version 3?
Thanks,
Bob
==========
Bob Ramsey Applications Development & Su
At 07:55 AM 4/6/2003 +, Neil Tompkins wrote:
Could someone give me some advice on the best way to store sensitive
information like credit card numbers on our mySQL database. Of course we
would be using SSL encryption for all transactions.
Take a look here:
http://www.mysql.com/doc/en/Miscel
ur message cannot be posted because
it appears to be either spam or simply off topic to our filter."
Now it should get through.
==========
Bob Ramsey Applications Development & Support II
ph: 1(319)335-99
u could do some pre-processing.
Bob
==========
Bob Ramsey Applications Development & Support II
ph: 1(319)335-9956 216 Boyd Law Building
fax: 1(319)335-9019 University of Iowa College of Law
mailto:[EMAIL PROTECTED]
t it just keeps
choking on the join statement.
"You have an error in your SQL syntax near '(fac_stud_lunch INNER JOIN
fac_stud_lunch_join ON fac_stud_lunch.instructor_hawk' at line 2"
Thanks,
Bob
======
l_time;
And I keep getting an error on the inner join. I've usually been able to
get the syntax for joining 3 or 4 tables by using Access, but it seems to
have failed me this time.
Any ideas why this select statement is failing?
Thanks,
Bob
=======
at either.
I'm using mysql and php. Any ideas? I'd hate to just keep looping through
and making lot's of small select statements, which I know I can do. It
seems like there's a better way.
Thanks,
bob
=========
33 matches
Mail list logo