Having issue with SELECT * FROM

[samsam]

<?php

$connection = mysql_connect("xxxxxx", "xxxxxx", "xxxxx","xxxxxxx") or die ("Couldn't connect to server."); 
 
$db = mysql_select_db("persons", $connection) or die ("Couldn't select database.");  

    $search=$_POST['search']; 

$data = 'SELECT * FROM `table_name` WHERE `ID` = "'.$search.'"'; 

  $query = mysql_query($data) or die("Couldn't execute query. ". mysql_error()); 

  $data2 = mysql_fetch_array($query); 
   
   
?>

still getting this ERR Couldn't execute query. No such file or directory

[Beverleyh]

Try removing the weird apostrophes around `table_name`and `ID`and check that table_name is correct

[james438]

Try echoing $data and see what query is being sent.

EDIT:

The backtics you are using are fine. They are known as identifiers and allow you to use odd names for tables and columns that are outside of the normal [a-zA-Z_0-9] character list. I personally don't use them. For more on identifiers see this:

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

It appears the MySQL website has been updated finally and is actually user friendly now. I was beginning to wonder if they would ever update their website

In your case if you echoed your query it would look like this:

SELECT * FROM `table_name` WHERE `ID` = "search"

where search is whatever your search term or phrase is. Notice that your quotes are being displayed as well. I have not tested it, but the additional quotes you have added should not be necessary. I would just use

$data = "SELECT * FROM table_name WHERE ID = $search";

You are also using the very deprecated mysql as opposed to the standard mysqli

Here is one of my typical queries using this method:

$get_addresses        = "SELECT ID FROM news WHERE ID = $ID";
   $get_addresses_res = mysqli_query($conn,$get_addresses);
       $add_info      = mysqli_fetch_array($get_addresses_res);
           $ID        = $add_info['ID'];

To read more about it go here: http://dev.mysql.com/downloads/connector/php-mysqlnd/

There is also one or two threads here you should take a look at:

http://www.dynamicdrive.com/forums/s...ng-deprecated-!

In fact I'm thinking the above thread should be stickied to the MySQL forum.