Haig Dedeyan (Home) wrote:
Hi everyone,
I'm a dbase rookie and I've ran into a small problem.
I created a basic faq table and all is fine regarding displaying &
searching the Q & A's on a web page.
Up until now, I;ve entered all Q & A's from phpMyAdmin.
I'm trying to create an admin page to
> Subject: mysql server has gone away
>
> do u knw any othr circumstances in which such an error
> occurs? n whts the
> best poss soln here- to do a reconnect
If you are using version 5.* and get a FUNCTION does not exist error before
loosing the connection, than patch your source as descri
Hi Juan,
Just wanted to touchbase and see if you had any suggestions based on
the my.cnf and machine config. Thank you in advance.
Best Regards,
Jason
On 1/15/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote:
Jason,
Send me a my.cnf in order to view your configuration ( using innodb storage
If you used TOAD in oracle, DBBrowser is similar to that.
Developers need a tool like DBBrowser to work with SQL database.
DBBrowser is excellent tool and is quite useful for developers.
DBBrowser is released under gnu/gpl license.
DBBrowser is quite impressive and in future it will find rapid
ado
Thanks for the Brent,
What do you think about trying to make this work by using a stored procedure? A
colleague mentioned it to me but I can't seem to get my head wrapped around it
yet.
- Thanks
>>> "Brent Baisley" <[EMAIL PROTECTED]> 1/15/07 7:45 AM >>>
When you said "multiple field unique
OK. I don't recall having a problem with this before, but, how do I assign
a variable to a MySQL Bit field? I'm trying to set up a CheckBox that is on
my form, and I've tried variations of the following:
FirstTime.Checked = CBool(RS("FirstTime"))
FirstTime.Checked = CBool(RS("FirstTime").ToSt
Of course you realize it's the ORDER BY in the subquery that is giving
you greif. I don't see why you wouldn't get the same net effect if
you remove the ORDER BY from the inner query and leave it on the outer
one.. to my eye, it looks like you would get the same randomized
result.
On 1/16/07,
Hmmm, I see the problem. I can't think of any other way to do it. I
have a table of people, and I want to return 20 random people. Each
person has multiple picture records, and I want to return a random
picture for each. That's why I'm trying to put the 'order by rand()'
in the subquery: if
I can't get MySQL 5 to like this query. Can you tell what I'm trying
to do, and is there a problem with my formatting?
select account_id,picture_id from pictures where account_id in
(select account_id from accounts order by rand() limit 20)
order by rand();
--
MySQL General Mailing List
For li
Thanks Johnatan.
After I put tables in brackets - everything worked fine!
;)
And thank to everybody else.
-afan
> View the documentation here:
> http://dev.mysql.com/doc/refman/5.0/en/join.html
>
> You could write your statement as
>
> SELECT
> Field1, field2
> FROM
> Table1
>
I have not tried, but i think this is what he meant:
FROM
tn t
INNER JOIN bill_info b ON (b.id_b = t.id_t)
LEFT JOIN shipp_info sh ON (b.bill_id=sh.bill_id)
HTH,
On 1/16/07, Chris White <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
> FROM ".$tn.", bill_info as b
> LEFT JOIN sh
View the documentation here:
http://dev.mysql.com/doc/refman/5.0/en/join.html
You could write your statement as
SELECT
Field1, field2
FROM
Table1
LEFT JOIN Table2
LEFT JOIN Table3
OR
SELECT
Field1, field2
FROM
(Table1, Table2)
LEFT JOIN Ta
> [EMAIL PROTECTED] wrote:
>> FROM ".$tn.", bill_info as b
>> LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id
>
> That would be the usage of multiple from's combined with a left join.
> Unfortunately with mysql 5 you can't do this. You're going to have to
> do bill_info as a left/right/inner j
If I fire a lot of querries, I get an error "mysql server has gone
away/lost
connection with the server" .
I've seen this error for the second reason you've mentioned, wrong
queries. You'll need to show us the query so we can see any possible
issues.
--
MySQL General Mailing List
For lis
[EMAIL PROTECTED] wrote:
FROM ".$tn.", bill_info as b
LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id
That would be the usage of multiple from's combined with a left join.
Unfortunately with mysql 5 you can't do this. You're going to have to
do bill_info as a left/right/inner join ins
Hi Cor,
Fusion Charts is Flash based... For example, if you need a bar chart
you just need to embed the file Bar2D.swf and send an XML to it using
params, or even a external url, but if you need a pie chart just use
the Pie2D.swf file instead... So the user just needs to have Flash
plugin
hi to all!
This is query I used before we moved to mysql4 based dedicated server:
SELECT ".$tn.".reg_id, b.*, sh.*
FROM ".$tn.", bill_info as b
LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id)
WHERE b.reg_id = ".$tn.".reg_id
AND b.table_name = '".$tn."'
AND ".$tn.".registration_status = '".$_
Hi Cor and everybody,
well this is my first collaboration, as I have the time today...
Well, if you want to generate statistical charts so the user can have
an overview of the data, you could use simple HTML and GIFs, but this
would make your code impossible to maintain in a sort time. Cours
Thanks El Cuy, Joshua, Ryan,
Let me be more specific about making graphs with MySQL data.
Currently my project is in development phase,
using MS Access as front-end and MySQL as back-end with MyODBC.
My next step is to replace the MS Access front-end by PHP
(because I don't see any use of MS Acce
On 15/01/07, Gabriel PREDA <[EMAIL PROTECTED]> wrote:
Read here: http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html
have fun !
-- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer
Thanks. Been quite a while since I've deserved a good RTFM! :)
Dotan Cohen
h
20 matches
Mail list logo
