The more I get into php, the larger my databases get. I wonder why that is.... I'm working on a quick project for a Spanish class, and my database will end up having around 500-700 entries in it. each entry fills two varchar(100) fields, one varchar(3) field, and two int fields (one auto incrementing). I use the following code to build two arrays:
Code: Select all
$sql = buildsql();
$data = mysql_query($sql) or die(mysql_error());
while($result = mysql_fetch_array($data))
{
$spanray = array_merge($spanray, array($result[0]));
$englray = array_merge($englray, array($result[1]));
}Thanks.
Edit: Oh yeah, as a side note... is
Code: Select all
SELECT FROM table WHERE (something=1 OR something=2) AND (nothing=3 OR nothing=3)Code: Select all
SELECT FROM table WHERE something=1 OR something=2 AND nothing=3 OR nothing=3