Getting data from MySQL database

MitchEvans

I need some help, my code seems to be accepted fine as no error messages come display. Here's my code:

<?php
$connection = mysql_connect("localhost","root","computer")
or die ("Couldn't Connect");
?>
<?php
$db = mysql_select_db("mitch",$connection)
or die ("Couldn't select database");
$query = "SELECT * from mitch.product";
$result = mysql_query($query)
or die ("Couldn't execute query");
?>
<?php
echo $result
?>

The result given on my website is: Resource id#3. Instead of what the result of the query should be in the database.

Any help please!!

Mitch.

Weedpacket

The code is doing exactly what you're asking of it. [man]mysql_query[/man] returns a recordset resource, and you're telling it to print that resource as a string. And that's what it's doing.

Look at some of the code on the page linked to above to see how to get information out of the resource, and references to the functions to do it.

MitchEvans

Ok so does this look like mysql is connected and working as it should?

Mitch

Weedpacket

If the mysql functions were failing they'd be returning false (like the manual says they would). Therefore, the fact that you're not getting false but a recordset implies that they are working. Try fixing your code and seeing what happens.

faifas

Hey there,
You should use such functions as mysql_fetch_object or something similar,
For example:

$info=mysql_fetch_object(mysql_query("SELECT name FROM friends WHERE birthday='$today'"));

echo $info->name; // this will say you the first name mysql got, if you want to get all names you should use while($info=mysql_fetch_object($query)){

}// etc

PABobo

There are so many ways of getting information how do you want to get it?

$get_catagories = "SELECT * from catagories";
$list_catagories = mysql_query($get_catagories)or die(mysql_error());
$catagory_list = $list_catagories;
$num_fields = mysql_num_fields($catagory_list); 
$j=0;
$x=1;
while($row=mysql_fetch_array($catagory_list)){  

for($j=0;$j<$num_fields;$j++){
$name = mysql_field_name($catagory_list, $j);
$catagories[$x][$name]=$row[$name];
 		 }$x++;
	}
$i=1;
$ii=count($catagories);
for($i=1;$i<=$ii;$i++){
$data[] = array('types' => $catagories[$i]['catagory_type'], 'names' => $catagories[$i]['catagory_name']);
}

$get_venue = "SELECT * from sub_listings";
$get_venue .= " WHERE listing_id = '$subid'";
$new_get_venue = mysql_query($get_venue, $philly_scene) or die(mysql_error());
$row_venue = mysql_fetch_assoc($new_get_venue);