An Intermediate Question

[syphor]

Hey all,
I need to know how to get the value of a specific column from a mysql_query. Here is the query:

$Query = mysql_query( "SHOW CREATE TABLE Blah" );

The result returns 1 row and 2 columns. This is some of my code:

$Result = mysql_result( $Query, 0 );

echo $Result;

This returns the value of the 1st row/1st column.

I'm wondering how to get the value of the second coloumn.

[dustbuster]

Here's an example

$query="SELECT * from tablename WHERE id=id";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
echo $row['column1'];//column1 is the name of a column in your table
echo $row[0];
//OR
$row=mysql_fetch_row($result);
echo $row[0];//gets 1st entry

[[deleted]]

instead of mysql_fetch_array, you should probably use mysql_fetch_assoc.

mysql_fetch_array() fetches a row both as an enumerated array and as an associative array. If you only need the associative array, then you shouldn't really be fetching the enumerated array at all.

Note: Do always use the associative array. That way you can use columnnames so you always know which fields you are fetching, and the order of the columns nolonger matters:

for ex, look at these:
SELECT a,b FROM table;
SELECT b,a FROM table;

both queries fetch the same columns, but the order is reversed. If you fetch the columns by name you will get the correct values, but if you fetch them by 'number', they will also be in reverse order. This get's very nasty if when you have 35 queries on 7 tables with 24 fields each...