mysql querry help...

fearfx

i need to get and id from a table where:

		    $name = $_GET['name'];

	    $name_id = mysql_query("SELECT id FROM cat_categories WHERE name = ??") or die(mysql_error());

now $name = a title under column 'name'

I want the id from the column 'name' where $name = a result from column 'name'

does this make sense?

ZibingsCoder

I may not be understanding this, but wouldn't this be what you're looking for?

$name_id = mysql_query("SELECT id FROM cat_ategories WHERE name='{$_GET['name']}'");

fearfx

ZibingsCoder wrote:
I may not be understanding this, but wouldn't this be what you're looking for?
$name_id = mysql_query("SELECT id FROM cat_ategories WHERE name='{$_GET['name']}'");

$_GET['name'] = a specific word from the column 'name'

now $_GET['name'] is not a column its information from the column 'name'

now i want to get the id from the row where $_GET['name'] came from in column 'name'

that better?

ZibingsCoder

Erm, not really?

Why don't you give an example of the data that $_GET['name'] can have and what it's going to look for in the database?

fearfx

	$result = mysql_query("SELECT name FROM cat_categories WHERE ref = 1 ORDER BY name ASC")
    or die(mysql_error());
	while ($row = mysql_fetch_assoc($result))
		{
    		echo '<a href="list.php?name=' . urlencode($row['name']) . '">'
    . htmlspecialchars($row['name']) . "</a><br />\n"; 
		}

this bit of code resides on a page called index_2.php

now when you click a link it goes to list.php

where in that php file i need to figure out which ad to show according to what link is clicked

atcually live operation : okauchee.fearfx.com/index_2.php

now when you go to that page theres 3 links

each link came from the above php code.

then you go to list.php to find out which link was clicked and show that corresponding ad

so for instance $_GET['name'] = Agency

now the WORD Agency came from the TABLE cat_categories and column 'name'

there is also a column called 'id' in TABLE cat_categories

I want to retrieve the 'id' from TABLE cat_categories

WHERE $_GET['name'] = info from column 'name'

follow?

ZibingsCoder

Yes, and I still say what I gave you is going to do what you want. You'll just want to do something like the following to pull out the actual ID:

$nameId = mysql_result($query, 0, 'id');

fearfx

this is the error i get

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/fearfxco/public_html/okauchee/list.php on line 99

for this line of code

		    $name_id = mysql_query("SELECT id FROM cat_ategories WHERE name='{$_GET['name']}'");

		$nameId = mysql_result($query, 0, 'id');

but i am a little confused

in the query = name =$GET['name'] because $GET['name'] does not represent a column name. its information from a specific row in column 'name'

fearfx

sorry if im confusing, but i am a beginner and am trying to learn

fearfx

what you gave me doesn't work

$name_id contains no information when I echo it