recset

Anyone have any ideas???

Thanks for responding. However, that doesn't work, the following statement does work: [code]ALTER TABLE `wisdom_backup` ADD Cases2 varchar(30)[/code] However how do I get it to show a default value for the new column????

I have an existing table, and I want to create a new column (with a default value), and have all of the records already in the table, have the new default value and column .... what SQL statement would accomplish this?

How would I implement that into my current script? [code]mysql_select_db($database_vlot, $vlot); $query_ShowComments = "SELECT * FROM comments WHERE WISDOM_ID = (SELECT max(id) FROM wisdom)"; $ShowComments = mysql_query($query_ShowComments, $vlot) or die(mysql_error()); $row_ShowComments = mysql_fetch_assoc($ShowComments); $totalRows_ShowComments = mysql_num_rows($ShowComments);[/code] More or less, I do not need to code the 'show record count' in the above piece.

I have two tables. (lets refer them as [b]Table A[/b] and [b]Table B[/b]) I am trying to show how many records are in [b]Table B[/b], based off of the record ID of [b]Table A[/b] (the Record ID of Table B will sort Table A) All of this has to appear in a Repeated Region. Here is what I have so far, please help: [code]mysql_select_db($database_vlot, $vlot); $query_ShowComments = "SELECT * FROM comments WHERE WISDOM_ID = (SELECT max(id) FROM wisdom)"; $ShowComments = mysql_query($query_ShowComments, $vlot) or die(mysql_error()); $row_ShowComments = mysql_fetch_assoc($ShowComments); $totalRows_ShowComments = mysql_num_rows($ShowComments);[/code] Thanks

Wow, no comments huh?? I guess I must have a great site ... thanks  :o

I've noticed that a lot of people have some extensions problems, if anyone needs some assistance or wants to know where to find some good dreamweaver extensions, message me.

I have a new site, and I need some competent and helpful critiques. The site is on lyrics and quotes from pop/hip hop music artists. Also, any advice on how to generate traffic? exposure? [b][url=http://www.vacantlot.org]http://www.vacantlot.org[/url][/b] [img]http://www.vacantlot.org/elements/vlotlong.jpg[/img]

Mewhocorrupts, I am actually using Win XP, i haven't really ventured out into the BSD realm. However, I will start looking for some bluetooth daemons for windows, thanks for the lead.

[size=13pt]Does anyone know of any ideas of applying PHP scripts to utilize Bluetooth? Basically, I would like a script to call upon a Bluetooth Device, and transfer data from an SQL database to a Bluetooth device. I am lost, and do not know where to start. Thanks.[/size]

Thanks for the ref. links, as for the logo, its just a silhouette image of someone holding a microphone. The site is designed for 1024x768, not 800x600

I'd like some feedback on this site that I am about to revamp: [url=http://www.kingsofmusic.com]www.kingsofmusic.com[/url] The look I am going for is more of a magazine layout, does anyone have any ideas and/or reference sites.

Mainewoods, I found the line: [code] $query_quotes = sprintf("SELECT * FROM wisdom_backup WHERE MAXIMID = %s ORDER BY AUTHOR ASC", $colname_quotes); [/code] The whole reason for this is to clear a url parameter that is added to the URL in the browser everytime a user 'votes' on a record.  Thus, if the user doesn't vote, then this line is irrelevant. But, when the user 'votes' it adds a URL parameter to the browser, so that if the user decides to vote on another record, it will count 2 votes (1 for the new vote hit, and 1 for the previous vote hit, because each url parameter is now in the url shown in the browser).  So essentially, after the user votes, I just want to clear the URL parameter. Does this make sense? Or am I over-thinking this?

[b]Can anyone help out with this problem???? Please Help, thank you!!![/b]

Sorry, about that. Ok, in the db is: [code]'wisdom2.php?MAXIMID=<?php echo $row_menu['ID']; ?>[/code] What I want the final result is to change the url of the browser window (when clicked) to: [code]'wisdom2.php?MAXIMID=<?php echo $row_menu['ID']; ?>[/code] the php tag would actually be a number of a recordset (depending on the row menu). Thus, that output would be something like: [code]'wisdom2.php?MAXIMID=5[/code]