mysql datatypes issue

[irishgirl2004]

hi, i am using the following code

$db = mysql_connect("localhost", "xxx", "xxxxxxx");
mysql_select_db("acctest",$db);
$result = mysql_query("SELECT * FROM testtable",$db);
while ($myrow = mysql_fetch_row($result)) 
{
$premium = myrow[3];
}

but..... the $permium variable is never assigned??? its a double in my database, is this a problem? if ya can help please let me know, and points to tutorials about it would be great if ya dont know any answer......

many thanks in advance.......

[The_Chancer]

From

$db = mysql_connect("localhost", "xxx", "xxxxxxx");
mysql_select_db("acctest",$db);
$result = mysql_query("SELECT * FROM testtable",$db);
while ($myrow = mysql_fetch_row($result)) 
{
$premium = myrow[3];
}

WHy not refer to it as

$db = mysql_connect("localhost", "xxx", "xxxxxxx");
mysql_select_db("acctest",$db);
$result = mysql_query("SELECT * FROM testtable",$db);
while ($myrow = mysql_fetch_assoc($result)) 
{
echo $myrow['column_name']."<br />";
}

Using the assoc - you can use the column header - I personally find it much easier....

[pablodelapena]

Or even better:

$db = mysql_connect("localhost", "xxx", "xxxxxxx"); 
mysql_select_db("acctest",$db); 
$result = mysql_query("SELECT * FROM testtable",$db); 
while ($myrow = mysql_fetch_array($result))  

{ 
echo $myrow['column_name']."<br />"; 
}

using the mysql_fetch_array() you can refer to either the column header or its number!! whey! Everyones happy🙂