I was wondering if someone could point me in the right direction to a tutorial or something along those lines. Basically I want to be able to pull data from a mysql db into a form and edit the information in that form and then send the updated data back to the db. Got any links? <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/notworthy.gif" style="vertical-align:middle" emoid=":notworthy:" border="0" alt="notworthy.gif" /><!--content-->
Here is one <a href="http://www.tizag.com/mysqlTutorial/mysqlquery.php" target="_blank">tutorial</a> and you can find many others with a <a href="http://www.google.com/search?hl=en&lr=&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=3Dv&q=mysql+query+tutorials&btnG=Search" target="_blank">Google search</a>.<!--content-->
I did a few google searches and didn't find anything that was close to what I was looking for. Thanks for the link but unfortunately it's not exactly what I'm looking for. Thank you for looking though.<!--content-->
Maybe this'll get you started: <br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1--><?php<br />$username = "username";<br />$password = "password";<br />$database = "database";<br />$table = "table";<br /><br />// Connecting, selecting database<br />$link = mysql_connect("localhost", "$username", "$password")<br />Â Â or die('Could not connect: ' . mysql_error());<br />echo 'Connected successfully';<br />mysql_select_db("$database") or die('Could not select database');<br /><br />// Performing SQL query<br />$query = "SELECT * FROM $table";<br />$result = mysql_query($query) or die('Query failed: ' . mysql_error());<br /><br />// Printing results in HTML<br />// echo "<table>\n";<br />echo "<html><body>";<br />echo "<p>";<br />while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {<br />Â Â foreach($line as $key => $value) {<br />Â Â Â Â Â Â echo "\$$key == $value";<br />Â Â Â Â Â Â echo "<br>";<br />Â Â Â Â Â Â }<br />Â Â echo "<p>";<br />Â Â <br />Â Â }<br /><br />echo "</body></html>";<br /><br />// Free resultset<br />mysql_free_result($result);<br /><br />// Closing connection<br />mysql_close($link);<br />?><!--c2--></div><!--ec2--><br /><br />When I have more time, if you still haven't figured the rest out, I might be able to look deeper into it.<br />Although, you could just use phpmyAdmin in your controlpanel:<br /><a href="http://yoursite.com:2082/3rdparty/phpMyAdmin/index.php" target="_blank">http://yoursite.com:2082/3rdparty/phpMyAdmin/index.php</a><!--content-->
Here is one <a href="http://www.tizag.com/mysqlTutorial/mysqlquery.php" target="_blank">tutorial</a> and you can find many others with a <a href="http://www.google.com/search?hl=en&lr=&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=3Dv&q=mysql+query+tutorials&btnG=Search" target="_blank">Google search</a>.<!--content-->
I did a few google searches and didn't find anything that was close to what I was looking for. Thanks for the link but unfortunately it's not exactly what I'm looking for. Thank you for looking though.<!--content-->
Maybe this'll get you started: <br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1--><?php<br />$username = "username";<br />$password = "password";<br />$database = "database";<br />$table = "table";<br /><br />// Connecting, selecting database<br />$link = mysql_connect("localhost", "$username", "$password")<br />Â Â or die('Could not connect: ' . mysql_error());<br />echo 'Connected successfully';<br />mysql_select_db("$database") or die('Could not select database');<br /><br />// Performing SQL query<br />$query = "SELECT * FROM $table";<br />$result = mysql_query($query) or die('Query failed: ' . mysql_error());<br /><br />// Printing results in HTML<br />// echo "<table>\n";<br />echo "<html><body>";<br />echo "<p>";<br />while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {<br />Â Â foreach($line as $key => $value) {<br />Â Â Â Â Â Â echo "\$$key == $value";<br />Â Â Â Â Â Â echo "<br>";<br />Â Â Â Â Â Â }<br />Â Â echo "<p>";<br />Â Â <br />Â Â }<br /><br />echo "</body></html>";<br /><br />// Free resultset<br />mysql_free_result($result);<br /><br />// Closing connection<br />mysql_close($link);<br />?><!--c2--></div><!--ec2--><br /><br />When I have more time, if you still haven't figured the rest out, I might be able to look deeper into it.<br />Although, you could just use phpmyAdmin in your controlpanel:<br /><a href="http://yoursite.com:2082/3rdparty/phpMyAdmin/index.php" target="_blank">http://yoursite.com:2082/3rdparty/phpMyAdmin/index.php</a><!--content-->