peterbarone

I'm no pro by any means either. So I run into the same issues you do. First place to start echo $stock somewhere on the page make sure it is being set. I have also noticed that with some php vers. Select * from table1 where stock= '$stock'; If you need php for repeating table let me know Hope that helps a little one noob to another. Lol

Thanks a ton ! You got me thinking with your last post. I rethought the process of what I was tring to do. I had everything that I needed I was just making to complex. Being a noob the magic overwhelms the simplicity lol. Based on the first post to me I just changed the location of the information that I was looking to store and all fell into place. Again thanks so much for taken the time to look at this for me.

Thanks Keith for taken the time to look at this for me. I'm really new to inner join and MySql for that matter. "Better to have a table of workouts and a table of exercises, and then a link table with as many rows are required for for the number of exercises in any particular workout" I like that idea so much better but it is beyond my knowledge at this time.

I have two tables one that holds a list of exercises, and one that holds a list of workouts. My table structures Exercises table idexercises 1Bench Press 2Dips 3Pull Ups Workouts table idexercises1exercises2exercises3exercises4 12132 23221 So what i'm looking to render in my php file is a table that looks like this. idexercises1exercises2exercises3exercises4 1DipsBenchPull upDips 2Pull upDipsDipsBench Thanks for any help

THANKS ALOT. got the permission to change to 755. chmod($uploaddir.'/'.$_FILES['file']['name'],0777); Is there a better way to set the permission RE: 0777

if(is_uploaded_file($_FILES['file']['tmp_name'])){ move_uploaded_file($_FILES['file']['tmp_name'],$uploaddir.'/'.$_FILES['file']['name']); if(strtoupper(substr(PHP_OS,0,3))!="WIN") @chmod($_FILES['file']['name'],0777); } Thanks for that find, my typo. still loading the file to 640. Any other ideas ?

I'm having a problem setting file permissions. Can someone give a little guidance. if(is_uploaded_file($_FILES['file']['tmp_name'])){ move_uploaded_file($_FILES['file']['tmp_name'],$uploaddir.'/'.$_FILES['file']['name']); chmod($_FILES['file']['tmp_name'],0777); The permissions are not being set ? I made sure the dir was chmod correct. Thanks

my lack of experience is starting to shine. really sorry Let me ask the question a different way. How can I break results for a query into separate tables ? table1 displays all records with id of 1 table2 displays all records with id of 4 table3 displays all records with id of 55 ect... And I mean display tables not MySql tables Sorry if I make you feel like

do you mean like this <a href="EDIT.php?id=2">submit id 2</a> then get it from the url on the edit page $id = $_GET['id'];

Sorry I guess I was not clear. I need to do one query to get all id's from a table There maybe 3,5, 15, 60 ect... Then I want to take each ID returned from the first query and use it in NEW query's select id from sometable returns id = 3 id =10 id =23 select * from someothertable where id = 3 select * from someothertable where id = 10 select * from someothertable where id = 23 That is what i'm looking to do. Thanks for the time

Hello I have a question. I'm trying to perform multiple queries based off the results from a query. Is this possible ? $result = mysql_query("SELECT id FROM sometable"); for each id returned $result1 = mysql_query("SELECT * FROM someothertable WHERE id=result from $result query"); Any help would be GREAT

I'm new also, but I would use CSS first to layout your page make that your template. Then copy the template 3 more times and your on your way.

maybe this will help $whatever = mysql_query("SELECT something FROM sometable;"); // Then, where you want your drop down list echo "<FORM NAME=\"select\" ACTION=\"select.php\" METHOD=POST>\n"; echo "<font class=\"text1\">What to select:</font>&nbsp<SELECT CLASS = \"small\" NAME = selected>"; for ($j=0; $j<mysql_num_rows($whatever); $j++){ $list = mysql_fetch_array($whatever); echo "<OPTION VALUE=$list[somevalue]> $list[showsomename] \n";} echo "</SELECT>"; echo "<INPUT CLASS=\"button\" TYPE=submit VALUE='GO!'>\n"; echo "</form>\n"; Hope that can help

Try something like this <a href=\"youreditpage.php?id=$row[id]\">$row[pagecontent]</a>

ok due to my egnorance. let me try it this way for all of you that are nice enough to help me [td bgcolor=yellow]4[td bgcolor=red]3[/td][/tr][/table][td bgcolor=green]5[/td][/tr][/table][td bgcolor=blue]6[/td][/tr][/table] I need bgcolor to be set based on the value of the cell if cell = 4 bgcolor= yellow if cell = 5 bgcolor =green Sorry I can't explain it better. I'm new