I think that the bitwise or was probably the cause of the problem. I actually didn't notice until you pointed it out. But I just ended up re-doing the database (basically copy and paste) so I could create this much nicer query:
$query = "select * from Artists"
$result = mysql_query($query)
if (mysql_num_rows($result) == 0){
echo 'nothing here...'
}
else{
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
echo "
$out = "
echo $out
echo $row['state']
echo "
$out = "
echo $out
echo $row['city']
echo "
$out = "
echo $out
echo $row['venue']
echo "
}
}
This was just to get it to work so I could display something. When I'n not working on my new project i will try to work out the original setup (which I still kept incase). As it is right now it is very difficult to update the database because the amount of data for each column is different so there are a lot of blank rows. This just makes messy MySQL updates when trying to find the first blank row which isn't very efficient since I want to be able to upload multiple rows at a time.
No comments:
Post a Comment