PDA

View Full Version : managing mySQL



Eclipse
January 30th, 2001, 03:57
How do I create and edit mySQL databases on my win 98 machine? I have downloaded myAccess97 to edit mySQL databases from within Access (never worked though) and I have downloaded and installed mySQL Maker. Both taken from http://www.mysql.com

any ideas!?

Eclipse
January 30th, 2001, 06:06
<?php

mysql_pconnect();
mysql_select_db("mysql");

$res=mysql_query("SELECT x_name FROM [users]");
echo mysql_result($res,0,"x_name");
?>

---

Here's my trial code so far. The echo line is not a valid line... What could I have made wrong?

Eclipse
January 30th, 2001, 07:06
Originally posted by Eclipse

$res=mysql_query("SELECT x_name FROM [users]");
?>

I quote myself... Above should be:

$res=mysql_query("SELECT x_name FROM users");

and then it worked! :-)

thanx,