Code: Select all
$sql = mysql_query($query) or die(mysql_error());
$categories = array();
$whatever = array();
while($row = mysql_fetch_assoc($sql))
{
$categories[] = $row['category'];
$whatever[] = $row['something else'];
}Moderator: General Moderators
Code: Select all
$sql = mysql_query($query) or die(mysql_error());
$categories = array();
$whatever = array();
while($row = mysql_fetch_assoc($sql))
{
$categories[] = $row['category'];
$whatever[] = $row['something else'];
}Code: Select all
select t1.thing1, t2.thing2 from table1 as t1, table2 as t2 where .....Code: Select all
<?php
include ("**");
$link = mysql_connect($host, $user, $password) or die ("Could not connect.");
$result = mysql_db_query($dbname,$sql,$link);
$sql = mysql_query("SELECT * FROM table ORDER BY keyindex desc limit 5") OR die(mysql_error());
while($row = mysql_fetch_array($sql, MYSQL_ASSOC))
{
$categories [] = $row['category'];
$articlenames [] = $row['articletitle'];
}
$sql = mysql_query("SELECT * FROM table2 ORDER BY keyindex desc limit 4") OR die(mysql_error());
while($row = mysql_fetch_array($sql, MYSQL_ASSOC))
{
$bname [] = $row['buildingname'];
$count [] = $row['county'];
}
$rows = mysql_num_rows($sql);
if($rows) {
$message = "$rows records found";
}
else{
echo "No records found";
}
mysql_close($link);
?>Code: Select all
<?php echo $bname[$indexcount]; ?>