Welcome! Log In Create A New Profile

Advanced

Good reference site for MySQL

Posted by Mac 
AnnouncementsLast Post
AnnouncementSoC Curricula09/30/2017 01:08PM
AnnouncementDemarcation or scoping of examinations and assessment02/13/2017 07:59AM
AnnouncementSchool of Computing Short Learning Programmes11/24/2014 08:37AM
AnnouncementUnisa contact information07/28/2011 01:28PM
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);
}
?>
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