ginginca

Yes this is exactly what I am confused about. Here are my fields in the links table: idnum name cat sub_cat url date status email other area_code (other is 0 in every record so I think this is not in use). I don't get how the field names relate to $other_info[x] The code says this: <?$sql="select * from links where other='1' order by date desc";$other_res=mysql_db_query("londonlink", $sql, $sql_conn)or die('Invalid query: ' . mysql_error());for($y=0; $y<mysql_num_rows($other_res); $y++){ $other_info=mysql_fetch_row($other_res); ?> <tr> <td> <?echo $other_info[1];?> </td> <td> <a href="<?echo $other_info[4];?>"> <?echo $other_info[4];?> </a> </td> <td> <? $sql="select * from category where idnum='$other_info[2]'"; $other1_res=mysql_db_query("londonlink", $sql, $sql_conn)or die('Invalid query: ' . mysql_error()); $cat_row=mysql_fetch_row($other1_res); print $cat_row[1]; ?> The table looks like this: Company Name URL Category Sub-Category Email Address (area code to be here) Company Name URL Category Sub-Category Email Address (area code to be here) Company Name URL Category Sub-Category Email Address (area code to be here) The most recent on the top of the list was the last one submitted. Then on the right side, there's a choice of two buttons - reject or approve.

That "somewhat" has been my question. I didn't understand what those numbers meant. But you have explained it a little. I'll play with that a bit and see if I get any result. Thanks. I'll let you know if it works or not.

I put it in the links table. The field is called area_code. And yes they appear in order in the web site. As for the admin panel, the most recent is listed first.

Can you explain what you mean by BUY links? -- never mind -- my browser didn't load the entire page. You can purchase links by submitting to paid directories. You can get free links by submitting to free directories. I have started a directory of these types of sites (hosted here). http://www.industry-online.com/ - I also list how long it takes for you to have your link reviewed. For example. DMOZ is the biggest but takes forever to be included. Jayde is another great one ... but you're up in about a day. There are lots of free directories that you can start with. When you submit, make sure you are following the guidelines of their submission requirements. (As a side note ... if any of you webmasters are running directories please feel free to submit to this site.)

I run a web site that is a directory of sites in my City. Since submissions are free, I continually receive submissions from webmasters that are NOT at all related. It is of course a waste of time for them ... and a waste of time for me. (Some people just don't take the 30 seconds to read.) I have decided to add a new field (area code) which will at least help me in quickly identifying the spammers. I was thinking I might even do the same thing with postal code. I have added a new field to the database, and it is now on my submit page for the "submitters" to fill in. However, in my admin panel, I need to view this information and that's where I'm running into my question. It's a very long page of code (which I didn't write myself) so I'm not quite sure how the programmer put it together. Here is the part of the code that includes the submit vs decline button: <?$sql="select * from links where other='1' order by date desc";$other_res=mysql_db_query("londonlink", $sql, $sql_conn)or die('Invalid query: ' . mysql_error());for($y=0; $y<mysql_num_rows($other_res); $y++){ $other_info=mysql_fetch_row($other_res); ?> <tr> <td> <?echo $other_info[1];?> </td> <td> <a href="<?echo $other_info[4];?>"> <?echo $other_info[4];?> </a> </td> <td> <? $sql="select * from category where idnum='$other_info[2]'"; $other1_res=mysql_db_query("londonlink", $sql, $sql_conn)or die('Invalid query: ' . mysql_error()); $cat_row=mysql_fetch_row($other1_res); print $cat_row[1]; ?> </td> <td> <? $sql="select * from sub_category where idnum='$other_info[3]'"; $other2_res=mysql_db_query("londonlink", $sql, $sql_conn)or die('Invalid query: ' . mysql_error()); $subcat_row=mysql_fetch_row($other2_res); print $subcat_row[2]; ?> </td> <td> <?echo $other_info[7];?> </td> <td> <input type="submit" name="<?echo "accept".$other_info[0];?>" value="Accept"> </td> <td> <input type="submit" name="<?echo "decline".$other_info[0];?>" value="Decline"> </td> </tr> <?}?> What I don't understand is how he is making each item in the list appear. There is a list of variables at the beginning of of the page ... but I don't think that is what I am looking for. /* VARIABLES*/$database['host']="****************";$database['name']="****************";$database['pass']="************";$table[1]="category";$table[2]="sub_category";$table[3]="links";$sql="select * from $table[$num]";$where_sql="select * from ".$table[$num]." where ".$field."='".$opt."'";$submit[1]="add_cat";$submit[2]="name_cat";$submit[3]="old_cat";$submit[4]="add_sub_cat";$submit[5]="name_sub_cat";$submit[6]="old_sub_cat";$submit[7]="add_link";$submit[8]="edit_link";$submit[9]="rem_link";$submit[10]="bansub";$today=date("Y-m-d"); But I think these are only for the various sections of my admin panel. Based on what you see here, what am I looking for? Or do I need to post the entire page?

Thanks for all the feedback!

Can anyone recommend any products that will generate an RSS feed from an HTML / PHP web site? Is there anything that would be automated?

I became an authorized reseller through tucows opensrs.So in effect I purchase them from myself.

I have a directory site that someone else programmed for me a couple of years ago. I have been making my own modifications to the script, and generally not running into many issues, since the changes are usually pretty basic. When a visitor clicks on a category, it takes them to a category page which lists all the sub categories, and under each category is a list of the links in it. When you click on one of the links, it takes you to a frame page. I have a tiny frame across the top which allows them to stay within the site. (Q) I would like to add a tiny link in my top frame that says "remove this frame" and it would dynamically link to their site, hence removing the frame. <HTML><HEAD> <TITLE><?echo $link_info[1];?> - London Ontario Canada Southwestern Ontario Business Directory</TITLE></HEAD><FRAMESET frameborder="0" ROWS="8%,92%"> <FRAME SCROLLING="No" NORESIZE SRC="header.php?cat=<? echo $cat;?>"> <FRAME SRC="<? echo $page; ?>"></FRAMESET><NOFRAMES><BODY><P></BODY></NOFRAMES></HTML> Here's an example of the page: http://forums.xisto.com/no_longer_exists/ I hope I have given you enough information to answer my question. Thanks in advance. Gin

I've been getting an error for the past hour or more "connection terminated suddenly"

Whatever was wrong is corrected. I was able to log-in.

Yes I set it up as the primary key in both. So it sounds like I'm on the right track here.

Thank you very much TavoxPeru. It worked. In the statement that has ORDER BY in it ... why is the there both a " (quotes) and a ' (apostrophe) ? Sorry my understanding of PHP is very new.

Thanks. I'll give that a try!

When I click on phpMyAdmin from the cpanel I'm am getting an error message:Wrong username/password. Access denied.

Thank you for your reply.This gave me a strange result of:7CIhAs for understanding the process, I have decided to go back to college and take PHP, starting next month. I am really enjoying what I am learning so far but feel like I'm at a loss since there is "so much" that PHP can do.

I have two tables in a database. userid and usercreditsIn userid I have all the fields that identify the user (name, address etc.)In my usercredits table I have the following fields:IDNUMProgramNameCamp#CompletionDateAmountDatePmtSentPmtMethodCommentscreditIDWhat I would like to understand about my table structure, is how do I associate my credits tothe correct user. If I have done this correctly, there is also a field in the first table that is called IDNUM where each user has a unique number to identify who they are.When someone is logged into the site I need to display the values from the usercredits table that are only THEIR credits.Am I starting this off correctly?

My query is returning a list of manufacturers with a hyperlink to their web site. I would like to LIST them alphabetically but can't seem to figure it out. Can someone lend me a hand? <?php // Query the Database $specific_value = 'Industrial';$query = "SELECT * FROM table_links WHERE cat = '" . mysql_real_escape_string($specific_value) . "' ORDER BY 'manufacturer' ASC";$query = "SELECT * FROM table_links WHERE cat = '" . mysql_real_escape_string($specific_value) . "'";$result = mysql_query($query);if(!$result) die("ERROR: " . mysql_error());while($row = mysql_fetch_array($result)) { echo '<a href="'.$row['mfr_url'].'">'.$row['manufacturer'].'</a><br>'; } ?>

The reason I'm having trouble in the first place *grin* The mfr_url is not q unique string believe it or not. I was surprised to see that on the list I was given I have various companies all using the same web site ... all divisions of the same company I guess. I'll look at your reply and see if it helps. Thank you very much!

Can you get through to them? Last time I tried (a decade ago) I couldn't get anyone on the phone.

I last installed November '05. It has been running well until about 2 weeks ago. And yes SP2 is obviously on there. When the problem surfaces, I have gone to Network Connections and I can see that my internet connection is "disabled". But re-enabling it makes no difference.

I have been working on this site for the past few months and I am very new to PHP. I have been doing HTML for 11+ years so it was time to dive in (long overdue I guess.) I have two very basic issues that I need some assistance with this review: (1) Is the concept of the site clearly explained? Have I worded things correctly that would make visitors want to join (it's free), and also once they join have I worded things correctly that they would want to follow through with earning money at the site. (2) The second is a back-end issue. The site is correctly tracking all data but I have one more thing to do in my programming. Users need to be able to view their credits. But in order for me to finish this part of the back-end I need some credits in the member's account. If you could complete an offer (which would cost you nothing except a few minutes of your time) it would help me with this part of it. (If you do ... credits earned are definately tracking ... just not yet displaying.) Thanks for your help! http://forums.xisto.com/no_longer_exists/ Gin

You have to be old enough to remember Abbott and Costello, and not too old to REALLY understand computers, to fully appreciate this. For those of us who sometimes get flustered by our computers, please read on... If Bud Abbott and Lou Costello were alive today, their infamous sketch, Who's on First?" might have turned out something like this:

I have recently been having a bizarre error and was wondering if anyone was familiar with this and could provide some insight. Most mornings when I get up my internet conenction is down on one PC. I can't seem to get it re-connected until I reboot. Once I reboot a window comes up that says that windows has recovered from a serious error. Here's the details: BCCode : 1000000a BCP1 : 00040000 BCP2 : 00000002 BCP3 : 00000000 BCP4 : 804DBC95 OSVer : 5_1_2600 SP : 2_0 Product : 256_1 Any thoughts on what is causing this?

I have a PHP query that produces a list: // Query the Database $specific_value = 'Industrial';$query = "SELECT * FROM table_links WHERE cat = '" . mysql_real_escape_string($specific_value) . "'";$result = mysql_query($query);if(!$result) die("ERROR: " . mysql_error());while($row = mysql_fetch_array($result)) { echo '<a href="'.$row['mfr_url'].'">'.$row['manufacturer'].'</a><br>'; } Can someone tell me how to sort the result alphabetically? Thanks!