 |
|
|
For SQL server, there is a very good default tool available on sql server download which is awesome but am not sure about mysql? I am currently using navicat but not too impressed with it? It doesn't really like stored procedures or cursor etc.
Any recommmendation pls?
Thanks
Andyyy
|
|
|
|
|
|
|
|
|
|
Toad for MySQL
[^]
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
|
|
Message Automatically Removed
|
|
|
|
|
|
|
am total newbie to programming, apart from knowing SQL, the thing is i have been given a MYSQL database containing various information about kids diseases and a web interface written in php to create reports from the database that can be accessed via the interface. there are almost 25 different variables that need to be computed in the report, i have written sql queries to compute all these values, but i don't know anything about PHP, if i have all these queries isn't there a way for me to combine all these sql queries to be display results on a webpage and come up with this report without writing PHP code?
Thanks for your help
very sorry if this is too basic
|
|
|
|
|
|
|
Please do not repost the same question; if anyone is able to help you then they will do so in their own time.
Binding 100,000 items to a list box can be just silly regardless of what pattern you are following. Jeremy Likness
|
|
|
|
|
|
|
It doesn't seem like you are getting much traffic on this, so I'll give it a shot.
SQL, which you are familiar with, is a way for us to interact with the database. It allows us to access the data through structured queries. It is not a web language, or a programming language. It's more of a tool to use with the database
PHP is a programming language. You have access to databases and SQL and can get results from it. PHP can use variables, routines, objects, etc in building web pages. PHP itself is not a database language (like SQL is).
As far as I know, the answer to your question is no. They are both tools with their own jobs. SQL is how you get/manipulate the information, PHP or another programming language is how you do something with it afterwords. You need both for what you are wanting to do.
If it moves, compile it
|
|
|
|
|
|
|
You shouldn't worry about having to use PHP. Running MYSQL queries in PHP is super simple. You use mysql_connect() to get your link to your MYSQL server, you use mysql_select_db() to select the database, you use mysql_query() to run the queries in the database, you use mysql_error() to find out what the error messages are if there were errors, and you use mysql_fetch_assoc() to get the results if there were no errors. Once you have the results, you use echo() on them to print them out wherever you need them on the webpage. So, you see, you'll really only need to learn how to use a handful of commands to do what you need to do.
|
|
|
|
|
|
|
There is one simple reason which would fail your journey. you will have to create a report that can be accessed from HTTP client. but you have mysql server which is not http server. so as a matter of fact you would have to go through some kind of scripting that can access mysql server and reply through http server. php is a very good answer and simpler answer
|
|
|
|
|
|
|
am total newbie to programming, apart from knowing SQL, the thing is i have been given a MYSQL database containing various information about kids diseases and a web interface written in php to create reports from the database that can be accessed via the interface. there are almost 25 different variables that need to be computed in the report, i have written sql queries to compute all these values, but i don't know anything about PHP, if i have all these queries isn't there a way for me to combine all these sql queries to be display results on a webpage and come up with this report without writing PHP code?
Thanks for your help
again very sorry if this is too basic.
|
|
|
|
|
|
|
|
|
|
How to upload image in jsp page
dkv
|
|
|
|
|
|
|
|
|
|
How to upload image in jsp page
|
|
|
|
|
|
|
|
|
|
Hi there,
I have 2 MySQL databases on 2 different servers and using php am pulling an array from each of them as follows...
From Server 1:
$query_Recordset1 = "SELECT login.`id`, login.username, tbl_countries.Country
FROM login, tbl_countries
WHERE login.Country = tbl_countries.id ";
$Recordset1 = mysql_query($query_Recordset1, $NU_Conn) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
From Server 2:
$query_Recordset2 = "SELECT newusb.ID, newusb.artist, newusb.title, tbl_ply_newusb.Week_14
FROM newusb, tbl_ply_newusb
WHERE tbl_ply_newusb.Song_ID = newusb.ID
ORDER BY tbl_ply_newusb.Week_14 DESC";
$Recordset2 = mysql_query($query_Recordset2, $Chartmenu) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
Between the 2 arrays I am trying to find the most played artists by Country, my thought is to have some sort of join between the artist name as the artist.id does not exist in the second array.
Do I create a 3rd array? if so how?
Any help on how to bring in a 3rd array based on the 2 existing arrays would be appreciated.
Many Thanks
Ray
|
|
|
|
|
|
|
how two tables are related?
|
|
|
|
|
|
|
Hi,
The tables are related only by username.
Regards
Ray
|
|
|
|
|
|
|
I am having trouble understanding what your table fields mean. I am assuming that Week_14 is the number of times a song was played in Week_14? In that case, you will want to use MAX(Week_14) with GROUP BY Country to get what the greatest Week_14 is for each Country (it will give you one row per country). I would need to know more about the table structure to give you more specific help than that.
|
|
|
|
|
|
|
sir my site is www.akashesp.co.in/form.php sir is site par form submit nhi ho rha hai is sorce ko offline karne par kam karta hai lekin online pe nhi koi nya sorce code dijiye
|
|
|
|
|
|
|
Try again, in English.
Bastard Programmer from Hell 
|
|
|
|
|
|
|
 sir pl give me form in sumbit html form code with msqul connection.
|
|
|
|
|
|
|
English, at least, I understand. No, I'm not in the business of "giving code".
Html doesn't speak with MySql, that's what we got PHP or ASP for. Google for "example PHP MySql", you should encounter a lot of examples.
Bastard Programmer from Hell
|
|
|
|
|
|
|
 sir pl give ve form code in php msql with connection because i can't connect this connectvity.............sir i have one php connection but this connetion is working on wamp server offline .and on online this connetion is is not work pl see my connetion www.akashesp.co.in/form.php
|
|
|
|
|
|
|
raman281990 wrote: i have one php connection but this connetion is working on wamp server offline
Cool. That means that your code is working.
raman281990 wrote: and on online this connetion is is not work
Ah, must be something in the configuration then. I just tried the site, and got a message, explaining the problem;
Sorry! for the inconvenience. Unable to select the Database
That probably means that you either misspelled the name of the database in your mysql_connect or the mysql_select_db call. Verify the name of your database, and try a small test-script to see if your database is alive and well. Something like below would do the trick;
<?php
$username = "root";
$password = "root";
$database = "somedatabase";
$server = "127.0.0.1";
$db_handle = mysql_connect($server, $username, $password);
$db_found = mysql_select_db($database, $db_handle);
if ($db_found)
{
$result = mysql_query("SELECT 1");
}
else
{
die ("PANIC: Someone stole somedatabase!!");
}
?>
Bastard Programmer from Hell
|
|
|
|
|
)
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Rant 
Admin