Reading data from a query result

blackbox

Hello all,

I have a MySQL query that return aq number of rows.

The problem I have is I don't know how to read the data.

The Query:

SELECT DISTINCT
Room_Avail.UniqueID,
Table01.UniqueID,
Table02.UniqueID,
Table03.UniqueID,
Table04.UniqueID
FROM
Room_Avail
Left Join Table01 ON Room_Avail.UniqueID = Table01.UniqueID
Left Join Table02 ON Room_Avail.UniqueID = Table02.UniqueID
Left Join Table03 ON Room_Avail.UniqueID = Table03.UniqueID
Left Join Table04 ON Room_Avail.UniqueID = Table04.UniqueID

WHERE  Room_Avail.UniqueID  = 'LONHA02341375437396 '

If I want to read the content of "Table04.UniqueID" and write it to a String what would the code be.

I have tried:
print $row_SeqOpenSave['Table04.UniqueID'];

print $row_SeqOpenSave['UniqueID'];

Does not work.

Can anyone offer advice. Many thanks.

Weedpacket

Assuming you've correctly done all the stuff involved in running the query and getting data from the result set, you can find out what the keys of the resulting array are with

print_r(array_keys($row_SeqOpenSave))

blackbox

Hello Weedpacket,

Many thanks for your reply.

If I use "print_r(array_keys($row_SeqOpenSave)) " I get the following warning.

Warning: array_keys() expects parameter 1 to be array, resource given in /home/public_html/apps/imaint/seqmenu.php on line 252

If I run the query it returns one row of data which is what I would expect.

The complete query is:

mysql_select_db($database_iMaint, $iMaint);
$query_SeqOpenSave = sprintf("SELECT DISTINCT
Room_Avail.UniqueID,
Table01.UniqueID,
Table02.UniqueID,
Table03.UniqueID,
Table04.UniqueID
FROM
Room_Avail
Left Join Table01 ON Room_Avail.UniqueID = Table01.UniqueID
Left Join Table02 ON Room_Avail.UniqueID = Table02.UniqueID
Left Join Table03 ON Room_Avail.UniqueID = Table03.UniqueID
Left Join Table04 ON Room_Avail.UniqueID = Table04.UniqueID

WHERE Room_Avail.UniqueID = 'LONHA02341375437396 ' GetSQLValueString($colname_SeqOpenSave, "text"));
$SeqOpenSave = mysql_query($query_SeqOpenSave, $iMaint) or die(mysql_error());
$row_SeqOpenSave = mysql_fetch_assoc($SeqOpenSave);
$totalRows_SeqOpenSave = mysql_num_rows($SeqOpenSave);

Any ideas?

Regards,

Blackbox

Weedpacket

Well, you shouldn't be, because [man]mysql_fetch_assoc[/man] returns an array, not a resource - are you sure you're looking at [font=monospace]$row_SeqOpenSave[/font]?
Incidentally, [thread=10387467]the MySQL extension is deprecated[/thread], and shouldn't be used for new applications.