61 Posted Topics
Re: [QUOTE=;][/QUOTE] Try this. <?PHP $query=mysql_query("SELECT * FROM call_details WHERE !ISNULL(call_project_name)"); echo "<select name='detailr'>"; while($row=mysql_fetch_array($query)) { echo "<option value='$row[call_id]'>".$row['call_project_name']."</option>"; } echo "</select>"; ?> | |
Re: [QUOTE=;][/QUOTE] I format your code. try this. $conn = mysql_connect ("localhost", "xxxx", "xxxx"); mysql_select_db ("wkho_TTX", $conn); $query = "SELECT * FROM venues"; $result = mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); //change this to $num=mysql_num_rows($result); $i=0; while ($i < $num) { $option = mysql_result($result,$i,'vname'); // i dont know waht is vname? echo "<option … | |
Re: Try this. Lets say we save this php as savedb.php <?php //database connection here echo "<form action='savedb.php' method='post'>"; echo "<input type='text' name='empid'>"."<br/>"; echo "<input type='text' name='password'>"."<br/>"; //or use <input type='password'> echo "<input type='text' name='address'>"."<br/>"; echo "<input type='text' name='first_name'>"."<br/>"; echo "<input type='text' name='last_name'>"."<br/>"; echo "<input type='submit' name='submit' value='Save'>"; echo "</form>"; if($_POST['submit']=="Save") … | |
Re: [QUOTE=;][/QUOTE] You must stored the path of the image file into mysql database. Then try to query the file path using PHP. | |
Re: Try this query $insert = mysql_query("INSERT INTO mystuff.pageser (name,content) VALUES('$content_name','$content') where user_id = '$colname_Recordset1'")); | |
Re: [QUOTE=;][/QUOTE] $query_Directory_update = "update directory set Sno=<?php $Directory_update['Sno']; ?>where Sno='$_GET[updateid]'"; try to modified the above code into this: $query_Directory_update = mysql_query("update directory set directory.Sno='$Directory_update[Sno]' where Sno='".$_GET[updateid]."'"); I think you don't have any PHP error with that query, but I'm not so sure if the query successfully update the record, since … | |
Re: [QUOTE=;][/QUOTE] Try to put the $subject['id'] into a variable. For example, $id=$subject['id']; then make a query like this: $page_set=mysql_query("SELECT * FROM pages WHERE subject_id='".$id."'"); just pay attention (') and ("). | |
Re: [QUOTE=;][/QUOTE] Try to analyze this example. $query = mysql_query("select * from tbl_name"); while($result=mysql_fetch_array($query)) { $name = $result['name']; $age = $result['age']; $address = $result['address']; $gender = $result['gander']; } // now display the result into textbox to allow the user to edit echo "<form action='save.php' method='post'>"; echo "<input type='text' name='name' value='$name'>"; echo … | |
Hi to all, Can anyone show me a sample php code on how to get the client's Mother Board Serial Number? Thanks. | |
Hi every one, Can anyone help me on the problem? The scenario goes like this. I have lots of files (.pdf, .doc, and .xls) stored on my sever. I want the user to access the files. I mean, they can open it for some review purposes but I don't want … | |
Re: [QUOTE=;][/QUOTE] I agree with borzoi. If you are lazy, then it is impossible for you to learn PHP and MySQL. PHP is not an easy programming language specially to the lazy person like you. Try to help your self first... You can search over the internet to have basic knowledge … |
The End.