MySQL help 3

[PhoenixDown]

Hi.

How do I get records from rows in a MySQL table into a scalar variable? I want to use them on my web site.

 

[sleipnir214]

Use mysql_fetch_array() to put the data into an arry, then use join() to join the array elements into a single scalar.

But it is not necessary to use join if your output is going to a web browser.

 

[PhoenixDown]

Sorry, but can you provide an example? I'm still new to PHP. :-(

 

[sonnysavage]

What is a scalar variable?

For data retrieval, I like to use the MYSQL_ASSOC option for

mysql_fetch_array

. It makes an associative array so you can refernce the value by using the column name.
Example:

$query = "SELECT * FROM table_name WHERE id='".$record_id."'";
$result = mysql_query ($query, $linkid);
$rowarray = mysql_fetch_array($result, MYSQL_ASSOC);
$record_data1 = $rowarray["data1"];

Documentation:

http://www.php.net/manual/en/function.mysql-fetch-array.php

 

[KarveR]

<?php


$db = mysql_connect(&quot;localhost&quot;, &quot;username&quot;, &quot;password&quot or die ('cannot connect to mysql server');

mysql_select_db(&quot;test&quot;,$db) or die ('Cannot select database');

$result = mysql_query(&quot;select * from table_name where stuff&quot;,$db);

$num_rows = mysql_num_rows($result);

echo &quot;<div align=center> Your search has found <b>$num_rows </b>rows \n&quot;;

printf(&quot;%s %s %s %s %s %s \n&quot;, $myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5]);

}
?>
***************************************
Party on, dudes!

 

[PhoenixDown]

Thanks!