jonbonazza

Awesome it works thanks! Unfortuantely, there must still be an error in my android code as it works find int he browser, but fails when doing it fro my android device.. bah... oh well.. Thanks for the help guys!

Mmkay, I edited my code to do what you suggested and I get the following result: Query: INSERT INTO Comments (user, comment) VALUES ('name', TestComment') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1 What is considered line 1? If it means the mysql_connect() function, it was copied from my grab_comment PHP file that works... why is it throwing an error on this one? edit: here is my updated script: <?php mysql_connect("localhost","bonafie0_mm","mm121289"); mysql_select_db("bonafie0_mm"); echo "connected to database"; $sql = "INSERT INTO Comments (user, comment) VALUES ('".mysql_real_escape_string($_REQUEST['user'])."', ".mysql_real_escape_string($_REQUEST['comment'])."')"; mysql_query($sql) or die ("Query: ".$sql."<br /><br />".mysql_error()); echo "done. "; mysql_close(); ?>

Pardon my ignorance, but I am a noob when it comes to PHP lol. I am not really understanding what you mean by "send in the data in the url and just echo out the sql statement that it is passing to the server". Could you elaborate on this? Thanks, Jon

Ok, so I did as you suggested and youa re correct the query is failing. It's weird though, because it even fails if I put "http://bonafide-software.com/mitsu-media/post_comment_rotm.php?user=name&comment=TestComment" into the browser bar. Am I doing something wrong in my script?

ok, so an android app I am working on needs to read from an online database and display the results dynamically. This works fine, but then when I press a button in my UI, I need it to add a new row into the same database. When I test the app and click the button, it doesn't throw any exceptions or anything and once it finsihes the process goes right back to letting me do w/e I need on the UI. When I test the PHP script through the browser, it goes through all the echos I have in the script and reaches the bottom of the script no problem, however it doesn't add the row... I am at a loss here... Maybe you all can help. Here is my PHP file: [syntax=php] <?php mysql_connect("localhost","XXXXX","XXXXX"); mysql_select_db("bonafie0_mm"); echo "connected to database"; mysql_query("INSERT INTO Comments (user, comment) VALUES ('".$_REQUEST['user']."', ".$_REQUEST['comment']."')"); echo "done. "; mysql_close(); ?> [/syntax] and for those of you who are experienced with java and/or the android SDK, here is my android code: [syntax=java] private void postComment() { String user = editName.getText().toString(); String comment = editComment.getText().toString(); OutputStream os = null; ArrayList<NameValuePair> nameValuePair = new ArrayList<NameValuePair>(); nameValuePair.add(new BasicNameValuePair("user", user)); nameValuePair.add(new BasicNameValuePair("comment", comment)); try { HttpClient client = new DefaultHttpClient(); HttpPost post = new HttpPost(ROTM_POST_URL); post.setEntity(new UrlEncodedFormEntity(nameValuePair)); HttpResponse response = client.execute(post); } catch(IOException e) { Toast.makeText(RoTM.this, "Unable to post comments", Toast.LENGTH_SHORT).show(); } editName.setText(""); editComment.setText(""); } [/syntax] Any ideas? I posted this on the only two reputable android dev forums I could find, but no one has been able to help me as of yet... Since I am fairly confident in my java abilities, I figured my problem probably lies in my PHP code.

Well, I did what Ken2k7 told me and now it works a bit better. It actually displays the first item in the database, however, it is not lopping around to display the other ones... Also, instead of displaying the data in the fields when they are called, it displays the ID number... perrij3, I tried your code and it does the same thing mine is doing right now. No loop... Yours does, indeed, display the right stuff, however, instead of just the ID. Here is the current code: <?PHP function data_get() { $Database = mysql_connect("localhost", "", "") or die(mysql_error()); mysql_select_db("") or die(mysql_error()); ; $result = mysql_query("SELECT MAX(ID) as maxID FROM table_here")or die(mysql_error()); $row = mysql_fetch_array($result) or die(mysql_error()); $max = $row["maxID"]; $result2 = mysql_query("SELECT MIN(ID) as minID FROM table_here")or die(mysql_error()); $row2 = mysql_fetch_array($result2) or die(mysql_error()); $min = $row2["minID"]; for($ID = $min;$ID != $max;$ID++) { $field = mysql_query("SELECT * FROM tblVendors where ID=$ID",$Database) or die(mysql_error()); $cname = mysql_result($field,"CompanyName"); $URL = mysql_result($field,"URL"); $rname = mysql_result($field,"RepName"); $remail = mysql_result($field,"RepEmail"); echo("<a href=\"$URL\">$cname</a>"); echo "<br>"; echo "<i style=\"font-family:Verdana;color:#cc0000;font-size:10px\">"; echo "-Representative's Name: "; echo "$rname"; echo "</i>"; echo "<br>"; echo "<i style=\"font-family:Verdana;color:#cc0000;font-size:10px\">"; echo "-Representative's Email:"; echo "$remail"; echo "</i>"; } } ?> and here is my calling of the function: ... <table border="0" width="100%"> <th style="background-color:#cc0000;font-family:Verdana;color:#e8e8e8;font-size:20px"> Vendor List </th> <tr> <td> <?php data_get(); ?> </td> </tr> </table> ... an lastly, again, here is the URL so that you cna see what is happening: http://www/turboshack.com/vendors/list.php

Hi, C++ is my language, but since I know some html, and I was asked to do a website for a friend, I thought I might as well take this chance to learn some PHP as well. Well I already created an application that takes the user's input and inserts it into a table called tblVendors located in a database called turbosha_Vendors. That script works fine, but now I am trying to make a script that grabs the the data from the table that has an ID field, which is set to contain an integer value and, as the primary key, it auto-increments as new rows are added, and displays it on a a webpage. Here is the PHP code I have. Keep in mind that the database username and password were replaced with X's for security purposes. <?PHP $Database = mysql_connect("localhost", "XXXX", "XXXX") or die(mysql_error()); mysql_select_db("turbosha_Vendors") or die(mysql_error()); ; $result = mysql_query("SELECT MAX(ID) as maxID FROM tblVendors")or die(mysql_error()); $row = mysql_fetch_array($result) or die(mysql_error()); $max = $row[maxID]; $result2 = mysql_query("SELECT MIN(ID) as minID FROM tblVendors")or die(mysql_error()); $row2 = mysql_fetch_array($result2) or die(mysql_error()); $min = $row2[minID]; echo "<br>"; echo "<br>"; echo "<center>"; echo "<table border=\"0\" width=\"100%\">"; echo "<th style=\"background-color:#cc0000;font-family:Verdana;color:#e8e8e8;font-size:20px\">"; echo "Vendor List"; echo "</th><tr><td><b style=\"font-family:Verdana;color:#cc0000;font-size:20px\">"; for($ID = $min;$ID != $max;$ID++) { $field = mysql_query("SELECT * FROM tblVendors where ID=$ID",$Database) or die(mysql_error()); $cname = mysql_result($field,1,"CompanyName"); $URL = mysql_result($field,2,"URL"); $rname = mysql_result($field,3,"RepName"); $remail = mysql_result($field,4,"RepEmail"); echo("<a href=\"$URL\">$cname</a>"); echo "<br>"; echo "<i style=\"font-family:Verdana;color:#cc0000;font-size:10px\">"; echo "-Representative's Name: "; echo "$rname"; echo "</i>"; echo "<br>"; echo "<i style=\"font-family:Verdana;color:#cc0000;font-size:10px\">"; echo "-Representative's Email:"; echo "$remail"; echo "</i>"; echo "<br><br></center>"; } ?> Lastly, here is the link to the page so you can see what is going wrong. http://www.turboshack.com/vendors/list.php Thanks in advance, Jon