studioceasar

Hi All, I'm working on a website page that is displaying data from a SQL database. I have a series of echo statements display the data within a table: [CODE] echo "<table border '1' bordercolor='#333333' cellpadding='3' cellspacing='0' width='100%'> <tr> <th><span class='heading'>ID</span></th> <th><span class='heading'>Date Submitted</span></th><th><span class='heading'>Location</span></th><th><span class='heading'>Type</span></th><th><span class='heading'>Request</span></th> <th><span class='heading'>Start Date</span></th><th><span …

Hi All, I can't understand why I am getting The following error message: check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 I've poured through my code and I can't find a solution to the issue. Any suggestions …

Hi All, I'm having a problem connecting to my database because of a syntax error on the line: $result= mysql_query($sql,$link) or die(mysql_error()); Could you please let me know what the conflict and solution is?. I included the script below. Thanks in advance. C- [CODE]mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect …

Hi all, I have a column in my table that auto increments as a counter as new records are added. I would like to renumber the entire column and have it start at 6000. Can anyone suggest an sql line that would allow me to acomplish this? Thanks in advance …

Hello all, Is there an easy way to edit the order of my colums in a table? Presently, my colums are: cust_num, name, email, location, bday_day, bday_month, bday_year, state I would like to list the "location" column after "state". Can anyone offer a simple suggestion. Thanks in advance. C-

Hi All, I've been struggling with a number of different snippets of code to get the following script to force download. Everything I try won't connect. Unfortunately, because I'm such a novice, I can't find where the problem lies. Could anyone help me 'plug in" the right code to make …

Hi All, Can one of the gurus out there help me to convert a row variable to a link that will download an MP3 file? Using the code below: my $row['link'] displays the url in plain text. I would like to create a button to initiate an automatic download command …