Welcome! Log In Create A New Profile

Advanced

Good reference site for MySQL

Posted by Mac 
Announcements Last Post
Announcement : Programming Students at UNISA School of Computing 06/19/2019 02:01PM
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
avatar
Mac
Good reference site for MySQL
July 23, 2013 11:45AM
Re: Good reference site for MySQL
July 23, 2013 02:45PM
Yes good indeed,

one could want to try this as well: http://www.w3schools.com/sql/default.asp
Re: Good reference site for MySQL
July 23, 2013 04:11PM
I am going to try it, but currently I am using Beginning PHP5, Apache, MySQL Web Development Textbook as reference.
Re: Good reference site for MySQL
July 24, 2013 10:04PM
Hi, the simplicity of the site seems great. Tried the following without success.
Am I missing a trick or are there no short cuts?

<?php
$user_name="root";
$password="";
$database="moviesite";
$server="127.0.0.1";

$db_handle=mysql_connect($server,$user_name,$password);
$db_found=mysql_select_db($database,$db_handle);

if($db_found){
print "Database Found!";

SELECT movie_type,
movie_name
FROM tb_movie;

}
else{
print "Database NOT found";
mysql_close($db_handle);
}
?>
avatar
Mac
Re: Good reference site for MySQL
July 25, 2013 08:58AM
Missing as in?
Re: Good reference site for MySQL
July 25, 2013 11:07PM
Hi mac,

Nothing missing , just a screw loose! Fixed the silly syntax error added the while loop
and now finding the site to be a real time saver. Thanks!
Re: Good reference site for MySQL
October 15, 2013 12:19PM
HI,
I found a pretty good MySQL tutorial for absolute beginers,

WikiHow MySQL

It's on Wiki How, Its shows you how to Create Databases in MySQL Terminal (Command Line), This is actualy easier than the GUI.
Before this Tutorial, I had no @#!*ing clue how to use SQL.
PLEASE check it out if you lost and considering giving up!! grinning smiley
Sorry, only registered users may post in this forum.

Click here to login